Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chrispy
Posting Yak Master
107 Posts |
 Posted - 2003-03-26 : 21:43:12
|
| Hi all, Short of creating a new Datagrid that I can edit can anyone recommend a tool that I can edit tables with dynamically.What I have is a shopping cart that has it's own editing web page.I have created some customization to it through tables, other than the table that it uses.I am looking for a tool that will allow me to say; join two tables and be able to edit the data that way. Speed is an issue as well.Any thoughts?Thanks in advance,Chris |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-26 : 21:50:33
|
| What platform ? ASP / ASP.NET / VB / PHP / Perl ?In any case, writing your own is a great learning experience.Damian |
 |
|
|
chrispy
Posting Yak Master
107 Posts |
Posted - 2003-03-26 : 21:55:58
|
| Merlin, Either ASP or ASP.NET to MSSQL 2000.I am assuming that creating a Datagrid in ASP.NET would be the way to go?Just looking for something user friendly that was out of the box. Maybe a little more on the client side (adjust the width of field, etc). We might have some non-technical people doing it. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-03-26 : 22:08:50
|
| Either way, don't count on having an easy time updating a recordset that is a two-table join.It's far better to run separate update statements on each table.I should repeat what nr told me: Avoid editing recordsets directly, open forward-only, read only cursors, and use stored procedures to add, edit, and update data. Its longer in the short run, but saves debugging time in the long run. Speed will definitely be much improved, and you will not be dependent on flukes between releases of ADO.Sarah Berger MCSD |
|
|
|
chrispy
Posting Yak Master
107 Posts |
Posted - 2003-03-28 : 18:18:23
|
| Thanks all,Decided to go the route of writing my own. Found a nice add on datagrid called SQLSuperGrid at www.superexpert.com (I only plug it because it is free).It takes the overhead out of the sorting and editing that is required in .net.Makes it real easy.Question I have no is with datgrids in general.There is no way to edit data in a datagrid, if the query is a join.There is one case were I do not need to join the data, but only check to see if the relationship is active in another table.The table that I need to edit has the productid on each row, which corresponds to the UID of the product in another table. In the same table that has the UID, I need to check if IsActive is set to 1 ; if so that I want to bring it up in the datagrid to edit. So I do not want to actually edit it in the datagrid.Make sense?????Does anyone know if this is possible to query the DB as such in a datagrid to allow it to be editiable?Thanks in advance,Chris |
|
|
|
|
|
|
|
|
Recommendation on a DB editing tool??