Hi all

iam using ASP.NET

i connected the database to SQL through codings without using Wizards ... i need to insert , update,delete the data from the textbox through Coding....

hope all can understand.

advance thanks

violet

Check this out if it helps.. http://aspnet.4guysfromrolla.com/articles/072705-1.aspx

____________________________
Im JAMES  

hi

thanks a lot..

now adding, deleteing..is  working but edit.not working...

let me see..

violet

Hi

To update a table , you have to pass the commandtext and then use ExecuteNonQuery().

Here is the sample piece of code.


commandobject.CommandText = "update mShipper set cnno = cnno+1 where shippercode = '2005'"
adapterobject.UpdateCommand = dbconn.VBC_comm
commandobject.ExecuteNonQuery()

Note : You mush create connection object , command and adapter object.

Regards
Chris