Displaying the database record using datatbale in c#

narasiman rao

i am displaying the database record using datatable
In LatestNewsMaster table record as follows

id Subject Link Active
1 Defect Mail defectmail.aspx A
2 Accounts Fee accountsfee.aspx A
3 Latestenews page Latestnews.aspx A

My code as follows

string constr = ConfigurationManager.ConnectionStrings["Reception2_DB"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("select Link from LatestNewsMaster where active <> 'd'"))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
label1.Text = dt.Rows[0][0].ToString().Trim();
return dt;
}
}
}

But when i run in label dsiplaying only firt recrod defectmail.aspx in the label1. not displaying all the three link records from the database.

from my above code what is the mistake i made.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Purushottam Rathore10y ago
Hi Narasiman

As you know label contains string. You should use any data control for display records from datatable like repeater, datalist, gridview etc.
Ravi Patel10y ago
Hi ,

try this

string constr = ConfigurationManager.ConnectionStrings["Reception2_DB"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("select Link from LatestNewsMaster where active <> 'd'"))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
label1.Text = dt.Rows[0][0].ToString().Trim() + dt.Rows[0][1].ToString().Trim() + dt.Rows[0][2].ToString().Trim()
// this is the case if you are Datatable have one row and three column if more than one row then then you have to use for loop.
return dt;
}
}
}