Our Training Programs

All contents are copyright of their authors.

Binding DataGridView usin DataReader

Binding DataGridView usin DataReader

sridhar reddy

20yAsked May 4, 2006, 2:39 AM12.4kLearn iOS Programming

Hi,

I am trying to populate a DataGridView using DataReader. But I am unable to bind it.

Cna I know, how do I do it? Can anyone please help?

Thanks,
Sridhar.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

vijay kumar18y ago
sqldatareader sqlreader = new sqldatareader();

sqlreader = commandobject.executereader()

while(sqlreader.read())

{

str = dr["FieldName"];

}

sqlreader.close()
Ajay Rohilla19y ago
try this :

SqlConnection con = new SqlConnection("Connection String");

con.Open();

SqlCommand com = new SqlCommand("SQL Query", con);

SqlDataReader read = com.ExecuteReader();

DataSet ds = new DataSet();

DataTable dt = new DataTable("Table1");

ds.Tables.Add(dt);

ds.Load(read, LoadOption.PreserveChanges, ds.Tables[0]);

gridControl1.DataSource = ds.Tables[0];
sridhar reddy20y ago
Thank you very much.
li yufeng20y ago
You can use bindingSource.First,you need to use the 'read()' method of DataReader,Store the records into a colleciton object,then you can set the data source of bindingSource with the colleciton,finally,bind the dataGridView with the bindingSource.