CODEWITHSUNDEEP
c#winformsc#-4.0datagridview
pikk
pikk

Reputation: 855

DataGridView binding not working

I am working on a winforms project and i have this following code in the Form_Load method. But it doesnt work. Can anyone help me? 

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Sella.Properties.Settings.Database1ConnectionString1"].ConnectionString);
// A SqlCommand object is used to execute the SQL commands.
SqlCommand scmd = new SqlCommand("Select * From CustCalls", conn);
// A SqlDataAdapter uses the SqlCommand object to fill a DataSet.
SqlDataAdapter sda = new SqlDataAdapter(scmd);
// Create and Fill a new DataSet.
DataSet ds = new DataSet();
sda.Fill(ds);

dataGridView1.DataSource = ds;

Upvotes: 1

Views: 1112

Answers (2)

Sarvan
Sarvan

Reputation: 11

SqlDataAdapter sda = new SqlDataAdapter(scmd, conn);

dataTable dt = new DataTable();

sda.Fill(dt);

dataGridView1.DataSource = dt;

Upvotes: 0

LarsTech
LarsTech

Reputation: 81675

Try sourcing directly to the table in the dataset:

dataGridView1.DataSource = ds.Tables[0];

Upvotes: 2

Related Questions