sub routien

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

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

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)