Saturday, March 15, 2014

How to access cell value from DataTable in ASP.NET

11:05 PMSaturday, March 15, 2014


Suppose, i have Database table with some rows and columns. Look like given below

How to access cell value from DataTable in ASP.NET

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/>";  

Output of given mentioned code

How to access cell value from DataTable in ASP.NET

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();
                for (int i = 0; i < table .Rows .Count; i++)
              name1 +=  table.Rows[i].ItemArray[1].ToString() +"<br/>";  
                Label1.Text = name1;


Protected by Copyscape Online Copyright Protection Software


Post a Comment

Toggle Footer