Datagridview data binding from database error

Question

I have a datagridview in my Windows C# application. I am binding some data from my SQL server 2005 database into it. The datagridview already has a fixed number of columns and rows with their indivdual names. The problem is the data is displayed after the columns where i wish to get my data. The code is as following

SqlCommand cmd = new SqlCommand("Select * from INV_details_1 where i_n = '" + textBox3.Text + "'", sconn);

            SqlDataAdapter da2 = new SqlDataAdapter();

            da2.SelectCommand = cmd;

            DataSet ds2 = new DataSet();

           da2.Fill(ds2);

            dgv_details.DataSource = ds2.Tables[0].DefaultView;

The issue is that the data is getting displayed after my desired column headers. I wish to get the data in these specified columns.

Please help

Doan Cuong · Accepted Answer · 2013-04-02 08:48:52Z

1

You must map each column of the datagridview with the corresponding column in database using DataPropertyName property of Datagridview's column. EX:

dgv_details.Columns[0].DataPropertyName = "Name"

This will map column 0 in datagridview with column "Name" in datatable

answered Apr 2, 2013 at 8:48

Doan Cuong

2,6244 gold badges26 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Datagridview data binding from database error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related