How to insert new user ? RRS feed

  • Question

  • I have database called Customers and i have button btnAddNewCustomer.I want to insert new customer into my database with new Name and tel_number, but i don't know how to check is there already customer with that name in my database?I think i must compare value of Name and values of Name column in db,but i can't.Can you help?
    Thursday, January 6, 2011 7:58 AM


  • Before you do the insert, do a select statement on the table with a where clause and check if you retrieve a record, maybe do a select count(*) and if you get a result of 1 then you know the customer exists.
    John F Lundy
    • Marked as answer by artxach Friday, January 7, 2011 10:35 AM
    Friday, January 7, 2011 10:33 AM