How to add more than one row to gridview

Sirisha K

8y736Learn iOS Programming

How to add more than one row to gridview by using datatable, without using database

6 Replies

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

Sirisha K8y ago
This was not working still i can able to adding 1 row only
Sirisha K8y ago
Thank you very much
Kanimozhi Shivakumar8y ago
Hi Sirisha,

Code for adding rows to datagridview by click of ADD button:
private void btnADD_Click(object sender, EventArgs e)
{
    try
    {
        if (dtSuppDet.Rows.Count == 0)
        {
            //code ----> if any validations required for input feilds before adding values to datagrid
            //-----------------Adding Columns to data table-------------
            dtSuppDet.Columns.Add("CODE", typeof(string)); // Mention your data type here (typeof(string) or typeof(int) ,etc)
            dtSuppDet.Columns.Add("NAME", typeof(string));
            dtSuppDet.Columns.Add("AREA", typeof(string));
            dtSuppDet.Columns.Add("GSTNUM", typeof(string));
            //--------------Adding rows to data table ------------------
            dtSuppDet.Rows.Add(txtCode.Text, txtName.Text, txtArea.Text, txtGST.Text);
            //---------------Loading data table rows to datagridview ------------
            dataGridView1.DataSource = null;
            dataGridView1.Columns[0].DataPropertyName = "CODE";
            dataGridView1.Columns[1].DataPropertyName = "NAME";
            dataGridView1.Columns[2].DataPropertyName = "AREA";
            dataGridView1.Columns[3].DataPropertyName = "GSTNUM";
            dataGridView1.DataSource = dtSuppDet;
            dataGridView1.Refresh();
        }
        else
        {
            dtSuppDet.Rows.Add(txtCode.Text, txtName.Text, txtArea.Text, txtGST.Text);
            dataGridView1.DataSource = dtSuppDet;
            dataGridView1.Refresh();
        }
    }
    catch (Exception)
    {
    }
}
Note: While adding values to datatable rows take care of data types which you defined for respective columns.
Sirisha K8y ago
Dynamically i give data then it will add to gridview , i added 1 row successfully but facing issue with when adding more rows.
Kanimozhi Shivakumar8y ago
Hi Sirisha,

Please find below code :-
private void fillGrid()
        {
            try
            {
                DataTable dtSuppDet = new DataTable();

                //-----------------Adding Columns to data table-------------
                dtSuppDet.Columns.Add("CODE", typeof(string));
                dtSuppDet.Columns.Add("NAME", typeof(string));
                dtSuppDet.Columns.Add("AREA", typeof(string));
                dtSuppDet.Columns.Add("GSTNUM", typeof(string));
                //--------------Adding rows to data table ------------------
                dtSuppDet.Rows.Add("001", "Cradle Point", "Bangalore", "GSTIN456456546");
                dtSuppDet.Rows.Add("002", "Le-Meridian", "Bangalore", "GSTIt57656576");
                dtSuppDet.Rows.Add("003", "A2B", "Hosur", "GSTIN4567657657");
                dtSuppDet.Rows.Add("004", "Heritage", "Bangalore", "GSTIN324234234");
                dtSuppDet.Rows.Add("005", "Tree House", "Salem", "GSTIN6787669879");
                dtSuppDet.Rows.Add("006", "Dine Engine", "Delhi", "GSTIN0897897667");
                dtSuppDet.Rows.Add("007", "Amul", "Gujarat", "GSTIN3256787098");
                //---------------Loading data table rows to datagridview ------------
                dataGridView1.DataSource = null;
                dataGridView1.Columns[0].DataPropertyName = "CODE";
                dataGridView1.Columns[1].DataPropertyName = "NAME";
                dataGridView1.Columns[2].DataPropertyName = "AREA";
                dataGridView1.Columns[3].DataPropertyName = "GSTNUM";
                dataGridView1.DataSource = dtSuppDet;
                dataGridView1.Refresh();
            }
            catch (Exception ex)
            {
            }
        }
The Output of above code is:

Hope this will meet your requirements.
Yogesh Ghorpade8y ago
DataTable dtNew = new DataTable();
dtNew.Columns.Add(new DataColumn("Col1", typeof(string)));
dtNew.Columns.Add(new DataColumn("Col2", typeof(string)));
dtNew.Columns.Add(new DataColumn("Col3", typeof(string)));
for (int i = 0; i < 5; i++)
{
dr = dtNew.NewRow();
dr["Col1"] = "abc";
dr["Col2"] = "abc";
dr["Col3"] = "abc";
}

Gridview1.DataSource= dtNew;
Gridview1.DataBind();