Introduction
Suppose, i have Database table with some rows and columns. Look like given below
And i want to access cell value of it. Now, first discuss about DataTable, It is container, It Contains multiple Data Columns and multiple Data Rows. It is Main part of ADO.NET library. In this program, we will retrieve cell value of DataTable. Now, first load DataTable with any datasource using load( ) method. After that you can retrieve cell value of it easily.
Now Let's go for an example
Above mentioned snapshot, If we want to access jacob text from given table then consider this table as 2D array. Now, you can access this text from table using itemArray property of DataRow class. Like
string name = instance of DataTable.Rows[0].ItemArray[1].ToString();
Similarly, if want to access whole data of single column then must use loop, such as
for (int i = 0; i < table .Rows .Count; i++)
{
string name1 = instance of DataTable.Rows[i].ItemArray[1].ToString(); +"<br/>";
}
for (int i = 0; i < table .Rows .Count; i++)
{
string name1 = instance of DataTable.Rows[i].ItemArray[1].ToString(); +"<br/>";
}
Output of given mentioned code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class Default5 : System.Web.UI.Page
{
string name1=string.Empty ;
protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString =ConfigurationManager.ConnectionStrings ["ConnectionString"].ToString ();
con.Open ();
using(SqlCommand cmd = new SqlCommand ())
{
cmd.CommandText = "select * from Register";
cmd.Connection =con;
SqlDataReader rd=cmd.ExecuteReader ();
DataTable table;
table = new DataTable();
table.Load(rd);
for (int i = 0; i < table .Rows .Count; i++)
{
name1 += table.Rows[i].ItemArray[1].ToString() +"<br/>";
}
Label1.Text = name1;
}
}
}
}