how to bind row value to datarow class from sql server database using sqldatareader

Question

Hello friends i have table name called branch which has branchidbrachname columns. i want to retrieve branchname value to the datarow class using sqldatareader.and then this value is need to bind with combobox text . please help me.

Atul Kumar · Answer

What is problem???

Atul Kumar · Answer

SqlDataReader reader; List branchNames = new List (); if (reader.HasRows) { while(reader.Read()) { branchNames.Add(reader[branchName].ToString()); } } dataGrid.DataSource = branchNames;