display data to datagridview from database

Meena S

7y1.1kLearn iOS Programming

When am trying to display data to datagridview from database, only first row inserted properly

please find the below code. please correct the below code

public void filldata(String bno)
{
textBox1.Text = bno;
OleDbConnection con = new OleDbConnection(@"Provider=SQLOLEDB;Data Source=DESKTOP\SQLEXPRESS;User ID=sa; Password = REGENT; Initial Catalog=Meena; Integrated secutity=SSPI");
con.Open();
OleDbCommand cmd = new OleDbCommand(("Select * from data1 where Sno = '" +bno +"'"), con);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dt;
dataGridView1.Columns[1].DataPropertyName = "Itemcode";
dataGridView1.Columns[2].DataPropertyName = "Description";
dataGridView1.Columns[3].DataPropertyName = "Uom";
dataGridView1.Columns[4].DataPropertyName = "Qunatity";
dataGridView1.Columns[5].DataPropertyName = "Rate";
dataGridView1.Columns[6].DataPropertyName = "Amount";
con.Close();
}

In the above picture, three fields not filled in datagrid. How to resolve this issue.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty7y ago
Hii Meena,

Please check your dadabase table data1 first. I think the three fields value in table is blank.
Jignesh Kumar7y ago
Hi Meena,

Please find below link,

https://www.aspsnippets.com/Articles/Bind-Fill-DataGridView-in-Windows-Forms-WinForms-Application-in-C-and-VBNet.aspx

https://www.c-sharpcorner.com/UploadFile/deveshomar/ways-to-bind-datagridview-in-window-forms-C-Sharp/
Amit Gupta7y ago
@Meena If you had added any column manually then simply remove them as data fetched from the database will includes the respective columns to gridview.
Meena S7y ago
if autogenerate columns true means, am getting the below output
Meena S7y ago
there is no definition like databind, am getting error.
Jignesh Kumar7y ago
Hi Meenda,

Please use below code. I guess you are missing DataBind() method to bind data.
public void filldata(String bno)
{
textBox1.Text = bno;
OleDbConnection con = new OleDbConnection(@"Provider=SQLOLEDB;Data Source=DESKTOP\SQLEXPRESS;User ID=sa; Password = REGENT; Initial Catalog=Meena; Integrated secutity=SSPI");
con.Open();
OleDbCommand cmd = new OleDbCommand(("Select * from data1 where Sno = '" +bno +"'"), con);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dt;
dataGridView1.DataBind()
con.Close();
}
Gajendra Jangid7y ago
hello dear,

try as below:
using (SqlConnection con = new SqlConnection(constring))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM Customers", con))
            {
                cmd.CommandType = CommandType.Text;
                using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                {
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        dataGridView1.DataSource = dt;
                    }
                }
            }
        }
Meena S7y ago
I have predefined columns in my datagrid. if am using AutoGenerateColumns = true;

It will generate columns and fill data.
Amit Gupta7y ago
There is no need to use DataPropertyName when using DataSource and set the value of the line of AutoGenerateColumns = true;