client side add to a table

John Smith · Sep 30, 2004

ASP.NET SQL C#
I would like to get data from sql server and display it in a web page table
and be able to edit add delete rows without having to do server pulls.
When the user is finished the user pushes commit button and the data is
transferred back to the sql server.
I would appreciate being pointed at an example of how to do this.
thank you
mark

Guest · Sep 30, 2004

Well Datagrid has the Edit,Delete,Add capabilities..
Look for examples on the Net to get started!

Anonieko Ramos · Sep 30, 2004

Are you referring to disconnected model
where Datasets are stored locally via
write xml and later updates the database
in 1 shot?

John Smith · Sep 30, 2004

yes,

I do not want to do server trips for edit update add rows to the dataset.

mark

John Smith · Sep 30, 2004

Datagrid is a server component from what I read. If you know how to do these
things on the client with no server trips I would appreciate being shown
how.

Mark

Ken Dopierala Jr. · Sep 30, 2004

Hi Mark,

This is how I do it, it is a little complicated but once you get used it
you'll have no problems:

var tblMyTable = document.getElementById('tblNames');
var Rows = tblMyTable.getElementsByTagName('tr');
var NewRow;
var NewCell;

NewRow = tblMyTable.insertRow(Rows.length);
NewCell = NewRow.insertCell(0);
NewCell.innerHTML = "John";
NewCell = NewRow.insertCell(1);
NewCell.innerHTML = "Smith";

Now you have a table with 1 row and 2 columns. I recommend putting:
debugger; after the NewCell = NewRow.insertCell(0) line. Then looking at
NewCell in the watch pane. There you will see the huge number of properties
(i.e. NewCell.bgColor, NewCell.width, and etc.) that you can manipulate.
You can do the same for NewRow and tblMyTable and you'll get a feel for
everything you can do. Good luck! Ken.

Patrice · Sep 30, 2004

Then you'll have to do that client side using JavaScript and handling the
whole "table" model. Weight carefully first if it's worth...

Patrice

--

John Smith · Oct 1, 2004

How do you get the table data back into an sql server?

thank you
mark

Ken Dopierala Jr. · Oct 1, 2004

Hi Mark,

If you are putting input controls (i.e. <input type='text' ....>) in your
table, then create a global variable in the <head> section of your page. I
use Counter. Every time I add a row I use the same ID for the controls but
append an incremented Counter (txtName1, txtName2). Then when you submit
your form assign Counter to a hidden input field that you have set to
runat="server":

<input id="hidNumberOfLines" type="hidden" name="hidNumberOfLines"
runat="server">

In your server side code check the value of this hidden control. If it is
greater than 0 then loop and get all your values:

intNumberOfLineItems = CInt(hidNumberOfLines.Value)

For intCounter = 1 To intNumberOfLineItems
strFirstName = CStr(Request("txtFirstName" + CStr(intCounter)))
strLastName = CStr(Request("txtLastName" + CStr(intCounter)))
strAge = CInt(Request("txtAge" + CStr(intCounter)))

How to add dropdown selected data to table using jquery	2	Jul 2, 2022
datagrid and client side scripts to add row	0	Sep 30, 2004
How can I find occurrences of a column name FPPaymentID in the entire database (e.g table, stored procedure etc) in SSMS?	2	Jun 20, 2023
Add Rows to Table through Client-Side	2	Apr 3, 2007
Add the value taken from the user to my range for ActiveX ComboBox	0	Aug 27, 2022
Add a list of videos each one in a different button in a web page	1	Dec 10, 2022
Unable to add task to todo list	1	Sep 25, 2021
Dynamically add row to a table	3	Aug 16, 2007

client side add to a table

John Smith

Guest

Anonieko Ramos

John Smith

John Smith

Ken Dopierala Jr.

Patrice

John Smith

Ken Dopierala Jr.

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads