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

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

Uggh.
http://www.microsoft.com/downloads/d...displaylang=en
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"ya******@gmail.com" wrote:

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