Binding the database to the datagrid while loading the page

[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

 

[Guest]

Uggh.
http://www.microsoft.com/downloads/...0A-9877-4A7B-88EC-0426B48DF275&displaylang=en
Peter