7
Answers

datatable

Vivek Joy

Vivek Joy

9y
768
1
HI everyone
 
 
I need to upload datatable values in grid without using datasource.
 
I need to know how can we find the count value of datatable
 
My code is
 
SqlConnection con = new SqlConnection("server=QB_DT_2\\sqlexpress;database=QbAppDb1;user id=sa;password=admin123");
SqlCommand cmd = new SqlCommand("Select * from QbGroups where Groupname = 'primary'", con);
DataTable dt = new DataTable();
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
for (int i = 0; i < dt.Rows.Count; i++)
{
RadGrid.Rows.Add();
RadGrid.Rows[i].Cells[0].Value = rdr["QBGUID"].ToString();
RadGrid.Rows[i].Cells[1].Value = rdr["GroupName"].ToString();
}
 
Answers (7)