How to add more than one row to gridview

Question

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

Kanimozhi Shivakumar · Answer

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 Ghorpade · Answer

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 { dr = dtNew.NewRow(); dr["Col1"] = "abc"; dr["Col2"] = "abc"; dr["Col3"] = "abc"; } Gridview1.DataSource= dtNew; Gridview1.DataBind();

Sirisha K · Answer

This was not working still i can able to adding 1 row only

Sirisha K · Answer

Thank you very much

Kanimozhi Shivakumar · Answer

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 K · Answer

Dynamically i give data then it will add to gridview , i added 1 row successfully but facing issue with when adding more rows.