How to add muliple rows to Datatable using looping

@Rajkumar,

What is that final in the for loop?

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");
        }              
    }

}

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

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.

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

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?

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);
}