473,379 Members | 1,190 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

Generic maintenance of tables

We have several tables that we want to maintain on our webpage. User
should just pick the tablename from drop down box, and then page
should then populate the grid with the data from that table along with
"Edit" button. If they click on Edit then they should be able to do
an in-line edit of that record in the grid.

They also should be able to add a record to the table. If they click
on add then we want to show edit boxes where they can enter field
values and click on save to save data to that table.

Since every table has differnet fields but same behavior, I was
wondering if there is any generic code that I can borrow to add/edit
data to/from these tables instead of writing custom code for all of
these tables.

Thanks

Oct 30 '07 #1
1 2499
If it's suitable, you could use the DynamicDataControls on the ASP.NET Ajax
Futures (see ajax.asp.net). This automatically generates data editing pages
without you having to write code.

Dave

"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@v3g2000hsg.googlegro ups.com...
We have several tables that we want to maintain on our webpage. User
should just pick the tablename from drop down box, and then page
should then populate the grid with the data from that table along with
"Edit" button. If they click on Edit then they should be able to do
an in-line edit of that record in the grid.

They also should be able to add a record to the table. If they click
on add then we want to show edit boxes where they can enter field
values and click on save to save data to that table.

Since every table has differnet fields but same behavior, I was
wondering if there is any generic code that I can borrow to add/edit
data to/from these tables instead of writing custom code for all of
these tables.

Thanks
Oct 31 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Larry Maturo | last post by:
I noticed that in SQL Server Management Studio, under Management, there is a Legacy folder with maintenace plans created by adding entries to the system tables dbo.sysmaintplan_* tables (i.e. all...
4
by: derekbarrett | last post by:
Hi all, Our business is in manufacturing, and we are running SAP on DB2 8.1, planning on upgrading to 8.2.2 within a couple of months. We are running operations 24/7, so are looking for ways to...
1
by: Jani Tamminen | last post by:
We run DB2 UDB v8.1 on Windows. How do I find the list of all users that have the following privileges: 1. User Data Maintenance 2. System Tabale Maintenance
4
by: db2group88 | last post by:
Hello, we are using db2 udb v8.2 on windows. if we need to run a reorg and runstats monthly, i think the best way to do them is via the tool "Configure Automatic Maintainance". I find out that...
3
by: .Net Newbie | last post by:
I'm new to .Net and need to create a generic (free) way to update lookup tables in SQL Server (using C#) in ASP.Net pages. I found an article at:...
1
by: Michel Esber | last post by:
Hello, Linux RedHat AS4 running DB2 V8 FP11. I have followed the docs at http://tinyurl.com/qckrn and enabled automatic statistics collection. It has been 2 days since I updated my DB cfg and...
11
by: redefined.horizons | last post by:
First, I would thank all of those that took the time to answer my question about creating an array based on a numeric value stored in a variable. I realize after reading the responses and doing...
1
by: jimenezkrause | last post by:
Hello, I administrate a large number of Oracle databases for my company. Some DBs are easily structured and the staff responsible for keeping them updated are able to use an Oracle client...
5
by: Anders Borum | last post by:
Hi! While implementing a property manager (that supports key / value pairs), I was wondering how to constrain T to a struct or string type. Basically, I guess what I'm looking for is the common...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.