Datagridview does not show data

Question

I have created a simple table inside Nortwind db.I am trying to retrieve all data using datagridview .I think missed out something because nothing displays in datagridview.There is no exception and error massages just doesnt work

public void getData() 
{
    SqlConnection con = new SqlConnection(cnn);
    DataSet ds = new DataSet();
    cmd = new SqlCommand("Select * from info",con);
    SqlDataAdapter adp = new SqlDataAdapter(cmd);
    adp.Fill(ds);
    dataGridView1.DataSource = ds;
}

@dumass The DataAdapter will open and close the connection itself. — LarsTech, Aug 08 '13 at 18:24
just a tought : You shoudl wrap your `SqlConnection` and your `SqlDataAdapter` in using block. You should also (IMHO) add a try/catch block around your statement — Rémi, Aug 08 '13 at 18:25
@LarsTech - thank you for the info.I didn't know it.I deleted my answer as its misleading.. — Venkata Krishna, Aug 08 '13 at 18:30
Thank you i found a solution dataGridView1.DataSource = ds.Tables[0]; — user2583511, Aug 08 '13 at 18:38

score 3 · Answer 1 · answered Aug 08 '13 at 18:40

3

Use a DataTable instead of a DataSet

Otherwise, you need to specify which table the DataGridView should show.

answered Aug 08 '13 at 18:40

banging

2,540
1
22
26

santosh singh · Answer 2 · 2017-12-24T18:21:56.073

3

You need to specify which table the DataGridView should show. Try following code snippet.

dataGridView1.DataSource = ds.Tables[0];

edited Dec 24 '17 at 18:21

answered Aug 08 '13 at 18:42

santosh singh

27,666
26
83
129

Datagridview does not show data

2 Answers2