adding textbox values to gridview

Question

0.00/5 (No votes)

See more:

How to add text box values to grid view by clicking on a add button and after that if we click a save button then the values from grid view must store in sql server database

step1:text box values must go into grid view after clicking a add button
step2: there is another button save if we click on this the values from grid view should store in database

Posted 11-Mar-12 0:05am

manoj420

Updated 11-Mar-12 0:24am

v4

Add a Solution

1 solution

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)

kishore sharma · Answer 1 · 2012-03-11T02:30:00

Hello,
To Do this
1st:create datatable
2nd:add row to datatable
3rd: bind to gridview and store that talbe in viewsate and repeat from step 1(by converting viewstate value back to datatable)

1st step:
create data table following way...
DataTable table = new DataTable();
add columns how many you want and give the names which you are binding to the gridvieww

table.Columns.Add("Ename", typeof(int));
table.Columns.Add("Sname", typeof(string));
table.Columns.Add("Department", typeof(string));
table.Columns.Add("DateOfJoin", typeof(string));

2nd step:
onclick of the button take the values entered in the textbox and add to the columns of the datatable.

table.Rows.Add(txtname.text.trim(),txtsname.text.trim() ,txtDptName.text.trim(),txtdate.text.trim() );

at the end bind this table to the gridview
grdEmpdetails.datasource=table;

and store this table in the viewstate
viewstate["dtTable"]=talbe;
again
3rd:onlcick of the button you have to convert viewstate value back to datatable and add the new row and again bind that to gridview..

Its Done