redkyna

With Dreamweaver we can create a page to show records from a database, a page to insert records, a page to update records and a page to delete records... is it possible to combine all these within 1 page?

My idea is that user can view and manipulate the database from the web just like how he can manipulate a database in Access (my database is in Access).

I know we can't add more than 1 behavior in a page, but anyone has any idea that may bring me closer to wht i want it to be?

Thanksss...

Smokie

If you can use ASP.NET, look into an editable datagrid, or maybe search google for a normal ASP version of a datagrid.

courtjester

You could put them all in a text box and line them up something similar to a Spreadsheet layout. Then Let them Change them to whatever they would like. And when they hit Submit let it Just edit the file itself. As for adding new row's you'd have to make that a seperate file. If you don't know any server side scripting languages (which I presume you don't) This might be a pretty hefty task. But if you know them it should be fairly easy for you.

Deleting records and such could be on the same page.. You can put check boxes in front of every line and let them mark which one's they want to delete, and then when they submit the form it takes them to the page that actually deletes it. But you can put all of these options on the same page, you'd just have to understand the code mainly.

redkyna

I'm trying on ASP.Net editable datagrid, it is one of the behavior in Dreamweaver, but it seems that when i update a record, there is an error:
System.Data.OleDb.OleDbException: Syntax error in UPDATE statement.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.OnDataGridUpdate(Object Src, DataGridCommandEventArgs E)

Anyone knows wht's the possible cause of this?

Smokie

post ALL of the error message...

redkyna

I'm glad u replied, but it's all.
It shows the error at the upper part of that same page.

redkyna

Thank u guys for ur time, I know wht's the reason now, the fieldname in my Access database, the datagrid works after i deleted all the spaces and special characters from the fieldnames. Yeah...

Webforumz Staff

Yup! That would be a problem...