Bind the Data to DataGridView in C#

Question

I have a table with ID and a Name column i want to show the one ID and Name in a DataGridView For Example in Textbox when i enter ID and click search button the datagridview shows the specifc record. In Search Button I have following Code but it gives error

con.Open();
Sqlcommand cmd = new Sqlcommand("Select * from Registration where ID = '"+textBox1.Text+"'")
sqldatareader reader = cmd.Executereader();
if (reader.HasRows)
{
          datagridview1.DataSource = reader.GetSqlValues()
 }

How can i bind the data to datagridview?

what is the error and if you are inserting a integer value to search and your id is also numeric then why there is need of single quotes?..please your code it is more helpful — NetStarter, Feb 21 '13 at 11:31
Like @NetStarter said you don't need quotes in a integer field, also you need to perform datagridview1.DataBind(); after filling the datasource — EProgrammerNotFound, Feb 21 '13 at 11:36

score 1 · Answer 1 · edited Feb 21 '13 at 11:49

1

Instead of data reader use dataSet:

con.Open();

Sqlcommand cmd = new Sqlcommand("Select * from Registration where ID = '"+textBox1.Text+"'");

sqlDataAdapter1 = new SqlDataAdapter();

sqlDataAdapter1.SelectCommand = cmd;

DataSet ds = new DataSet();

sqlDataAdapter1.Fill(ds);

datagridview1.DataSource = ds.table(0);

This will help you

edited Feb 21 '13 at 11:49

spajce

7,044
5
29
44

answered Feb 21 '13 at 11:47

NiteshG86

85
1
8

score 0 · Answer 2 · answered Oct 29 '13 at 11:00

0

con.Open();
Sqlcommand cmd = new Sqlcommand("Select * from Registration where ID= '"+textBox1.Text+"'",con);
sqldatareader reader = cmd.Executereader();
if (reader.HasRows)
{
          datagridview1.DataSource = reader.GetSqlValues();
 }

answered Oct 29 '13 at 11:00

Crismil XI

1

Bind the Data to DataGridView in C#

2 Answers2