datagridview control

[purnimakhamri]

hello..!!! can any bodt tell me how to bind datagridview in winform this is my code but gridview is not displaying the data, i dont know where i did the mistake

SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\simullat ion\\simullation\\simullation.mdf;Integrated Security=True;User Instance=True");
con.Open();
DataSet ds = new DataSet();
//DataTable table = new DataTable("Unit_Master");
SqlDataAdapter da = new SqlDataAdapter("insert into Unit_Master(UnitValues) values('" + txtUnitValues.Text.Trim() + "')", con);
da.Fill(ds, "Unit_Master");
dataGridView1.DataSource = ds.Tables["Unit_Master"].DefaultView;
dataGridView1.DataMember = "Unit_Master";
dataGridView1.AutoResizeRows(DataGridViewAutoSizeR owsMode.AllCells);
dataGridView1.Refresh();
da.Update(ds);
//dataGridView1.DataSource = table;

[Frinavale]

First check that your connection string is correct and then please step through your application using the debugger.

Check to see if your DataSet is getting filled and un-comment the line where you are setting the DataGridView's DataSource. If you don't set the DataGridView's DataSource then it will not display.

Why are you updating the DataSet?

[mldisibio]

The DataAdapter command is an Insert statement, not a Select statement, so there are no rows being placed into the the DataTable.

[DevGeek]

change your query from insert to select.
like
Select * from Unit_Master