How to dynamically add rows to a gridview through a datatable without affecting any table?

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

I have to show a gridview in my page which doesn't concerns any table to be bound with it. Still it should store one Tax detail per row, as entered by user.

1. The gridview shown above should not show any records at first except the footer template of two textboxes and an Add New Record Button, when you are upto add any record.
2. Once clicked on Add New Record button it should show a row without action column.
3. (I'm having quite a hard time here)Once clicked on Add/Insert Button(separate from the gridview) store the entered record somehow.
4. Then I have to show the record in ***Another*** concrete GridView with Edit Button.
5. Once I click on edit button, control should return to my dynamic gridview page. Here, my dynamic gridview will show previously entered record with action column containing a delete button.

Can you Help Me? I don't want help with the code. Just point me in the right direction(s), please.

What I have tried:

I've tried binding it taxes table in my database, but it showed each and every entry in taxes.

Posted 20-Jul-17 21:12pm

sam_matte

Updated 21-Jul-17 1:24am

Add a Solution

Comments

Atlapure Ambrish 21-Jul-17 7:27am

You can use two different datatables. One to work with dynamic grid, which will be created every time and bound to this grid so it does not show any data. When you hit Add/Insert button just copy the data from this datatable to the datatable which is bound to other other grid using built-in method.

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)

omerkamran · Accepted Answer · 2017-07-21T01:24:00

Answers:

1. To display only the footer template when grid is empty you have to enter an empty row in Gridview and hide that row.
You should follow these steps:

Dim dt as DataTable
dt.Cols.add("column1")
dt.Cols.add("column2")
dt.Cols.add("column3")

dt.rows.Add("","","")

ViewState("table") = dt

Gridview.DataSource() = TryCast(ViewState("table"),DataTable)
DataBind()
GridView.Rows(0).Visible = False

2. When you click on Add new button. Bind a method on the button click and
do following in your method:

Dim dt AS DataTable = TryCast(ViewState("table"),DataTable)
//Add your new data inserted in your footed row in the below row
dt.Rows.Add(YourData1,YourData2,....,YourDataN)

//After inserting the row

ViewState("table") = dt

GridView.DataSource = TryCast(ViewState("table"),DataTable)
DataBind()