how to insert all rows data from a gridview to a table

Question

0.00/5 (No votes)

See more:

ASP.NET

I want to develope an app where i can insert the gridview data in to a table .

please give me some suggestions please.

Posted 18-Mar-12 2:32am

ashu1810

Add a Solution

Comments

Varun Sareen 19-Mar-12 0:04am

have you tried something? what table; a DATATABLE or dB Table

ashu1810 19-Mar-12 5:11am

Its a database table

i used this insert statement

string statment = string.Format("insert into PROD_INVENTORY ( PROD_GRP_ID, PRODUCT_ID, IMEI_NO,INV_CAT_ID,QTY,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE, VALID,WAREHOUSE_ID) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}' )", item.Cells[1].Text, item.Cells[2].Text," null", '1',item.Cells[3].Text,"xyz",DateTime.Now.ToString(),"xyz",DateTime.Now.ToString(),'y',ddlwarehouseid.SelectedItem.ToString());

here in place of gridview values i.e, item.cells[i].text, it is inserting 0's in these cells PROD_GRP_ID,PRODUCT_ID,QTY of PROD_INVENTORY Table.
please give me some suggestions

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohamed Mitwalli · Answer 1 · 2012-03-19T22:17:00

hi ,

C#

protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
           con.Open();
           SqlCommand cmd = new SqlCommand("select * from TestTb", con);
           cmd.CommandType = CommandType.Text;
           SqlDataAdapter adpt = new SqlDataAdapter(cmd);
           DataTable dt = new DataTable();
           adpt.Fill(dt);
           GridView1.DataSource = dt;
           GridView1.DataBind();
       }
   }

C#

private void button1_Click(object sender, EventArgs e)
       {
           foreach (DataGridViewRow item in dataGridView1.Rows)
           {


               SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
               con.Open();
               string statment = string.Format("insert into  test1 ( [name], [address], gender ) values ('{0}','{1}','{2}' )", item.Cells[1].Value.ToString(), item.Cells[2].Value.ToString(), item.Cells[3].Value.ToString());
               SqlCommand cmd = new SqlCommand(statment, con);

               cmd.CommandType = CommandType.Text;
               cmd.ExecuteNonQuery();
               con.Close();
               cmd.Dispose();

           }
       }

Mohamed Mitwalli · Answer 2 · 2012-03-20T09:37:00

sry for being late and if this didn't work with u give me script of the table i tried this time to simulate your table hopes it help u :)

C#

protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          binding();
      }
  }

C#

void binding()
  {
      SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=TestDB;Integrated Security=True");
      con.Open();
      SqlCommand cmd = new SqlCommand("select * from PROD_INVENTORY", con);
      cmd.CommandType = CommandType.Text;
      SqlDataAdapter adpt = new SqlDataAdapter(cmd);
      DataTable dt = new DataTable();
      adpt.Fill(dt);
      GridView1.DataSource = null;
      GridView1.DataSource = dt;
      GridView1.DataBind();
      con.Close();
      cmd.Dispose();

  }

C#

protected void Button1_Click(object sender, EventArgs e)
  {
      SqlConnection cn = new SqlConnection(@"Data Source=MOHAMED-PC\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True");
      SqlCommand cmd = new SqlCommand();
     cn.Open();
      string statment ="";
      foreach (GridViewRow item in GridView1.Rows)
      {

       statment   = string.Format("insert into PROD_INVENTORY ( PROD_GRP_ID, PRODUCT_ID, IMEI_NO,INV_CAT_ID,QTY,CREATED_BY) values ('{0}','{1}','{2}','{3}','{4}','{5}' )", item.Cells[2].Text, item.Cells[3].Text, null, '1',
              item.Cells[4].Text.ToString(), "ashu1810");
         //  cmd = new SqlCommand(statment, cn);


      }
      cmd.CommandText = statment;
      cmd.Connection = cn;
      cmd.CommandType = CommandType.Text;
      cmd.ExecuteNonQuery();
      cn.Close();
      cmd.Dispose();
      binding();

  }

ashu1810 · Answer 3 · 2012-03-26T21:13:00

I did it something like this, and its working now.

C#

protected void Btnrecv_Click(object sender, EventArgs e)
  {

      callgrid();
      for (int i = 0; i < GridView1.Rows.Count; i++)
      {

          int PGID = Convert.ToInt32( ds.Tables["T"].Rows[i][1].ToString());
          int PID = Convert.ToInt32(ds.Tables["T"].Rows[i][2].ToString());
          int qty = Convert.ToInt32(ds.Tables["T"].Rows[i][3].ToString());
          int wrid = Convert.ToInt32(ddlwarehouseid.SelectedItem.ToString());
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.Clear();
          cmd.CommandText = "insert_update";
          cmd.Parameters.AddWithValue("@PGID", PGID);
          cmd.Parameters.AddWithValue("@PID", PID);
          cmd.Parameters.AddWithValue("@IMEINO", "NULL");
          cmd.Parameters.AddWithValue("@INVCAT", 1);
          cmd.Parameters.AddWithValue("@QTY", qty);
          cmd.Parameters.AddWithValue("@CDB", " LOGGEDIN USER");
          cmd.Parameters.AddWithValue("@CD", DateTime.Now.ToString());
          cmd.Parameters.AddWithValue("@LUB", "LOGGEDIN USER");
          cmd.Parameters.AddWithValue("@LUD", DateTime.Now.ToString());
          cmd.Parameters.AddWithValue("@VALID", "Y");
          cmd.Parameters.AddWithValue("@WRID", wrid);

          cmd.Connection = cn;
          cn.Open();
          cmd.ExecuteNonQuery();
          cn.Close();

and I used stored Procedure

SQL

ALTER procedure [dbo].[insert_update] (@PGID int ,@PID int,@IMEINO VARCHAR(30),@INVCAT INT,@QTY int,@CDB VARCHAR(20) ,@CD DATE,@LUB VARCHAR(20),@LUD DATE,@VALID CHAR(1),@WRID int)
AS
BEGIN
IF NOT EXISTS (SELECT * FROM PROD_INVENTORY WHERE PROD_GRP_ID=@PGID AND PRODUCT_ID=@PID AND WAREHOUSE_ID=@WRID )
INSERT INTO PROD_INVENTORY(PROD_GRP_ID,PRODUCT_ID,IMEI_NO,INV_CAT_ID,QTY,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,VALID,WAREHOUSE_ID)
VALUES (@PGID, @PID,@IMEINO,@INVCAT,@QTY,@CDB,@CD,@LUB,@LUD,@VALID,@WRID)

ELSE
UPDATE PROD_INVENTORY SET
QTY=QTY+@QTY,CREATED_BY=@CDB,CREATION_DATE=@CD,LAST_UPDATED_BY=@LUB,LAST_UPDATE_DATE=@LUD,VALID=@VALID WHERE PROD_GRP_ID=@PGID AND PRODUCT_ID=@PID AND WAREHOUSE_ID=@WRID
END

how to insert all rows data from a gridview to a table

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0