data from HTML grid to database

riru · October 10th, 2006, 10:51 AM

Hi all,
I'm a very beginner and I've the problem I describe below:
I've to insert data from editable grid HTML(dinamically created by a search) to another SQL table.
Do you have idea how to do it? I'm using ASP 3.0 and SQL Server 2000.

Thank you in advanced

Rita

riru · October 11th, 2006, 09:39 AM

:)I thak you for your suggestion, but could you plase send me the link where to find information?

Thank you
Rita

dparsons · October 11th, 2006, 09:42 AM

What do you mean by an editable grid? You create an HTML table on the fly and display the data? I don't understand what you mean.

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

riru · October 11th, 2006, 10:50 AM

Hi all,
I didn't ask you to do it for me, but only to say if it's possible in ASP 3.0.
I've to realize an editable grid (where the number of the fields can change because it's a result of a search) and based these editable values I've to update some fields in table.
I'm answering if it's possible to realize it.
I hope it's clear.

Thank you

riru

Quote:

quote:Originally posted by dparsons
What do you mean by an editable grid? You create an HTML table on the fly and display the data? I don't understand what you mean.

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

dparsons · October 11th, 2006, 10:56 AM

So what you are doing is creating a field dynamically based on the result set of a search query. Yes it is easy to do, all you would have to do is use a Request.Form(<dyanmic textbox>) to work with the data.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

riru · October 13th, 2006, 08:23 AM

Thank you for your suggestion

I'll try

Rita

rstelma · October 13th, 2006, 10:09 AM

Hi,

I have done what you're looking for many times. Depending on exactly how you are generating your fields there are a few different ways to do it. Could you explain a little more about what is the data in the search, how you're hitting the database and depending on what you find in your search, how you will be saving the data, in one column, several columns, etc.

Whatever you're doing though, you will have to loop through your search results and use some kind of key to identify each text box that you generate dynamically. I'm assuming you're generating text boxes in the "HTML grid". But I can't tell for sure from your post.

Thanks,
Richard