How to add muliple rows to Datatable using looping

Question

Hi, I want to add rows to the datatable .. I may have to add one row or multiple rows.. No of rows to be added to the Datatable may vary.. How to do this?

B M Suchitra · Answer

Actually i am adding a row to DATATABLE at linkbutton click.. This DATATABLE i am binding it to Gridview. After binding if user adds one more row to DATATABLE(TELL ME HOW TO ADD THAT ALSO) Then the DATATBLE should display both the rows ie also the previously added row also.. in my case datatable is displaying only currently added row and not the previous row,.. How to show all the rows.. Point to note: i am not saving the row to database

Rajkumar R · Answer

final is no. of pages in the gridview

B M Suchitra · Answer

@Rajkumar, What is that final in the for loop?

Rajkumar R · Answer

DataRow dr; for (int i = GridView1.Rows.Count; i { dr = dtable.NewRow(); dtable.Rows.Add(dr); } dtable.AcceptChanges(); GridView1.DataSource = dtable; GridView1.DataBind(); Try this in your gridbind function it may help u

Alok Pandey · Answer

Hi, I hope following code will help you.. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } DataTable dt = new DataTable (); private void Form1_Load( object sender, EventArgs e) { DataColumn dcname = new DataColumn ( "NAME" ); DataColumn dccity = new DataColumn ( "CITY" ); dt.Columns.Add(dcname); dt.Columns.Add(dccity); dataGridView1.DataSource = dt; } private void btnAddToGridview_Click( object sender, EventArgs e) { DataRow dr = dt.NewRow(); dr[0] = txtname.Text; dr[1] = txtcity.Text; dt.Rows.Add(dr); dataGridView1.DataSource = dt; } SqlConnection conn; SqlCommand comm; string constring = @"Data Source=server_name;Initial Catalog=DATABASE_NAME;Integrated Security=True" ; private void btnSaveToDatabase_Click( object sender, EventArgs e) { conn = new SqlConnection (constring); conn.Open(); for ( int a=0;a { comm = new SqlCommand ( "insert into TABLE_NAME values ('" + dataGridView1.Rows[a].Cells[0].Value + "','" + dataGridView1.Rows[a] .Cells[1].Value + "')" , conn); comm.ExecuteNonQuery(); } conn.Close(); MessageBox .Show( "Saved" ); } } }

B M Suchitra · Answer

Let me explain what i need to do: I have a gridview with empty data template which has a row after adding data to this row i need to add this row to datatable and bind this table to gridview. Again i want to add one more rows data to the datatable and display this row along with the previously added row so now i have to display 2 rows ... My problem is i have added one row and it displays fine later when i add one more row i am losing the previous rows data.and only currently added row is displayed.. Please suggest how to overcome this problem

dev 0 · Answer

Hi B M Suchitra, If you want to add rows from database using table/stored procedure into the Datatable , then you can try this.. SqlConnection sqlcon = new SqlConnection (System.Configuration. ConfigurationManager .ConnectionStrings[ "Connection" ].ToString(); SqlCommand cmd = new SqlCommand (SprocName, sqlcon); cmd.CommandType = CommandType .StoredProcedure; SqlDataAdapter da1 = new SqlDataAdapter (cmd); DataTable dt = new DataTable (); sqlcon.Open(); da1.Fill(dt); da1.Dispose(); sqlcon.Close(); Hope this will help you. Thanks.

Datta Kharad · Answer

Hi Suchitra Where is stored your rows either datatable or any other (it means source of getting rows)...which you want to insert?

B M Suchitra · Answer

Hi Datta, I may add one row or multiple. I do not know how many rows i will add.. Then how to count the rows and then add to the datatable?

Datta Kharad · Answer

Hi dtData = new DataTable(); dtData.Columns.Add("Name"); dtData.Columns.Add("Address"); dtData.Columns.Add("Mark"); DataRow dr = dtData.NewRow(); dr[0] = "Datta"; dr[1] = "Mumbai"; dr[2] ="500"; dtData.Rows.Add(dr); dr = dtData.NewRow(); dr[0] = "DK"; dr[1] = "Pune"; dr[2] = "8000"; dtData.Rows.Add(dr); dr = dtData.NewRow(); dr[0] = "Kharad"; dr[1] = "Hyderbad"; dr[2] = "45000"; dtData.Rows.Add(dr); //OR....If you want to copy rows of datatable1 to datatable2 foreach (DataRow dr in datatable1.Rows) { object[] row = dr.ItemArray; datatable2.Rows.Add(row); }

How to add muliple rows to Datatable using looping

Answers (10)