Datagridview control in .net

[siri11]

Hi..
Can anyone plzzz suggest me how to bind data to Datagridview control from database (Sql server 2000) in c#.net(windows Application).I have one single record in my table,this single record must be displayed in the grid in single column.Plzz provide the code.One row from table must be displayed as one column in the gird.

Thanks in advance,
siri

[dip_developer]

Hi..
Can anyone plzzz suggest me how to bind data to Datagridview control from database (Sql server 2000) in c#.net(windows Application).I have one single record in my table,this single record must be displayed in the grid in single column.Plzz provide the code.One row from table must be displayed as one column in the gird.

Thanks in advance,
siri

see here for process of Binding datagridview...

http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx

for your 2 nd query you need to create a temporary datatable with the table information by looping through the records....othe rwise a row cannot be displayed as a column in the gridview...I think