Datagrid

Question

SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=StudentRegistration;Integrated Security=True");

con.Open();

SqlCommand cmd = new SqlCommand("select * from StudentInfo",con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

dataGridView1.DataSource = ds;

dataGridView1.DataMember = "Student";
why i am getting Object reference not set to an instance of an object in this the code is correct i think.

pls reply guys

Lakshmanan Sethu Sankaranarayan · Answer

Yeah Agree.If the DataSet or DataViewManager contains only one DataTable, you should set the DataMember to the TableName of that DataTable.

Brijendra Gautam · Answer

@Lakshmanan: DataTable will not be created with name StudentInfo . So don't pass StudentInfo as DataMember. DataTable inside DataSet will created with the name Table,Table1, Table2 and so on... when we use SqlDataAdapter to fill the dataset. Unless we specify the names of table.

Lakshmanan Sethu Sankaranarayan · Answer

yes I agree with Brijendra. Remove the Datamember or provide the value as the StudentInfo.

Brijendra Gautam · Answer

The problem is in using DataMember . Since you have used sql query to fill dataset so the genereted dataset will contains tables with the name Tabel1 and not as Student. Just remove the last line and it will work. dataGridView1.DataMember = "Student"; //Remove it.

Munesh Sharma · Answer

You use this method for showing data in datagrid view from database. public void displayDataGridView() { SqlConnection con = new SqlConnection ( "server MUNESH\SQL2008R2;Database=data;UID=sa;Password=123;" ); SqlCommand cmd = new SqlCommand ( "Select * from data1" , con); try { con.Open(); SqlDataAdapter da = new SqlDataAdapter (); da.SelectCommand = cmd; DataTable dt = new DataTable (); da.Fill(dt); dataGridView1.DataSource = dt; con.Close(); } catch ( Exception ec) { MessageBox.Show(ec.Message); } }

Abhay Shanker · Answer

Modify your code as below string connectionString = "Data Source=(local);Initial Catalog=StudentRegistration;Integrated Security=True"; string sql = "SELECT * FROM StudentInfo"; SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection); DataSet ds = new DataSet(); connection.Open(); dataadapter.Fill(ds, "Student"); connection.Close(); dataGridView1.DataSource = ds; dataGridView1.DataMember = "Student";