insert dynamically created gridview data into database

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

C#

ASP.NET

, +

Hi,

I want to insert a dynamically created gridview data into database.

Please help me friends.

Posted 4-Jul-11 20:08pm

nithibs

Updated 4-Jul-11 20:53pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 5-Jul-11 2:53am

Edited for Clarity.

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)

SanjeevSingh · Answer 1 · 2011-07-04T20:24:00

Solution 2

Hello,

take a blank row and bind the row as datasource. by this you will get the one blank row in grid afterwords you can add data to them. but yes for this you need have knowledge of view state.

hoping it will help you.. right comments if you need any furthur help

thanks

sanjeev

Posted 4-Jul-11 20:24pm

SanjeevSingh

Comments

nithibs 5-Jul-11 2:31am

hi..
i bind the datas already but now i want to insert the grid rows into database....
here i am giving the code for dynamically created grid datas...

protected void addprobtn_Click(object sender, EventArgs e)
{
if (addprobtn.Text == "Add")
{
if ((txtpid.Text.Length > 0) && (txtpname.Text.Length > 0))
{
string pid = txtpid.Text.Trim();
string pname = txtpname.Text.Trim();
AddDataToTable(pid, pname, (DataTable)Session["myDatatable"]);
addpro_Grid2.Visible = true;
addpro_Grid2.DataSource = ((DataTable)Session["myDatatable"]).DefaultView;
addpro_Grid2.DataBind();

}
}

else
{
lblmsg.Visible = true;
lblmsg.Text = "Enter Product ID & Product Name";
}
}

private void AddDataToTable(string pid, string pname, DataTable myTable)
{
DataRow row;
row = myTable.NewRow();
row["pid"] = pid;
row["pname"] = pname;
myTable.Rows.Add(row);
}

private DataTable BuildTable()
{
DataTable myDataTable = new DataTable();
myDataTable.Columns.Add("pid").DataType = Type.GetType("System.String");
myDataTable.Columns.Add("pname").DataType = Type.GetType("System.String");
return myDataTable;
}

if i use this above code and enter the data in textboxes and click the add button it will dynamically create the gridview....

now, i want to know how to insert that into database

Christian Graus 5-Jul-11 2:58am

You can add anything you like in the DB, it's all the same. What you can't do, is use dynamically created stuff that was added in an event, as it's added too late to have viewstate. Just like I said.

Christian Graus · Answer 2 · 2011-07-04T20:09:00

Solution 1

The fact it's dynamically created means you won't be able to find it's data unless you insert it before page_load, otherwise, it's viewstate is lost. Once you can get it's data, you insert it like any other.

Posted 4-Jul-11 20:09pm

Christian Graus

SanjeevSingh · Answer 3 · 2011-07-04T20:36:00

Hello,

Now you know your Gridview and their respective rows right. take a button and on click event initialilze the connection for DB. Using a loop create a string that has insertion data from grid and finaly execute that command.

it will insert the data into respecetive DB.

for example point google for How to insert data from gridview to DB. it will give you lots of link.

thanks
Sanjeev