i m using text box to save data in table of sql server 2000 ...when the data is getting save it is also adding to the list box......i want the data not to be saved again at the back end in sql server 2000 if it is present in list box once
The easisest way is to make that field a unique identifier or primary key, that way when you try to save to SQL it will raise an error. Otherwise you will have to add code to check your listbox before sending the insert query to SQL.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!