How to save multiple records in grid view using single click

Question

0.00/5 (No votes)

See more:

I have a webform and I am able to insert data into gridview using temporary table after adding Some records in grid_view from the webform i want to save all the data in database in a single click, Suppose i have 5 column in my table(Database) and only three column in Gridview and two column in webform, in single click all the rows and 5 column, 2 column with same record in the same column like date or ProductReceivedBy and three column from the grid. Can any body help me to find out the solution of this code. I am using VS2005 and SQLServer 2005. Can any body provide me code....

Posted 15-Mar-12 0:08am

Namit KB

Add a Solution

2 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)

Sarvesh Kumar Gupta · Answer 1 · 2012-03-15T00:19:00

Hi, There is many techniques for doing this. for this,

Method 1. You can use XML- Create a DataTable at front end and create xml from that data table and send this xml as a parameter to sp.

Method 2. take 5 parameters in sp, 2 for form values, and 3 for grid values. these 3 are varchar(max). at Front end, using foreach make a comma separated string for each column and send to each parameter then in sp, split 3 parameters into tables using split function.
then you can use loop in SP for inserting record in table. I am using 2nd method and works right if understood properly. :-)

Golois · Answer 2 · 2012-03-15T08:08:00

One way you can do that is by loading the gridview in edit mode.
Then you have a button on the page and set this method on click:

C#

protected void Button1_Click(object sender, EventArgs e)
  {
      for (int i = 0; i < GridView1.Rows.Count; i++)
      {
          GridView1.UpdateRow(i, false);    //save the row at index = i

      }
  }

How to save multiple records in grid view using single click

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0