sub routien

[ahmedsoliman]

i need to add item in data base ,the sql statment have to be writine in function, and iwill call it via button how??????????

[whammy]

Can you explain in more detail where you're having problems? :(

[ReyN]

In ADO, you can use either Addnew or issue an Sql Insert statement to add a new record to a db.

Maybe this article can help. It's almost about what you said: add a record to a db, using a button, except that the code to execute the insert is not used in a function or sub routine, but rather as an inline code block. At least you can pick up from there . . . better than none ... :D

Letting Users Update Information (http://aspalliance.com/aspxtreme/ado/lettingusersupdateinformation.aspx?pageno=2)