Binding the database to the datagrid while loading the page

  • Thread starter Thread starter yasodhai
  • Start date Start date
Y

yasodhai

Hi,
I have to bind the database to the datagrid control.

string secid=Session["SID"].ToString();
int sid=Convert.ToInt32(secid);

//Adding the records in the Fielddet table to the datagrid
string Fld = "select * from fielddet where sectionID=@SecID";
SqlCommand FldCmd= new SqlCommand(Fld,myConnection);
SqlParameter secIDParameter= new
SqlParameter("@SecID",SqlDbType.Int,4);

secIDParameter.Value=sid;
FldCmd.Parameters.Add(secIDParameter);
DataSet Fldds=new DataSet();

Without using where clause it is possible for me to bind the database
with the grid. Kindly help me how to fill the datagrid using this
datasource.


Thanks & Regards,
Yasodhai
 
Back
Top