check for duplicate data

Question

Greeting from Malaysia hi, i am a beginner in VB.NET. How do I check the duplicate records in the database? For example, I have a table called category in SQL server. This table contains with CategoryID and Category. In the front end I created a form that contains only 2 textbox. One is for the category ID that the ID is auto generated and the other textbox is for the user to enter the categoris(ed. adult, kids, comedy,.......) . So, how do I check if the user enters the category that already exists in the table. Please help! Have a nice day! Thanks and regards, Vivian

Answer 1

Check this..It might be helpful.

http://humrahimcs.wordpress.com/2010/09/21/how-to-add-currency-symbol-in-gridview-priceamount-column/

Answer 2

thankx for reply but will it be work in case if i will display the total price....
because i think it will display an error during addition of price like "usd 1231 + usd 2465"

what will i do to resolve this problem.?

Answer 3

try this

before binding the datatable to gridview.
foreach(DataRow dr in datatable1)
{
dr["price"]=ConfigurationSettings.AppSettings["Currency"] + dr["Price"].ToString();
}

and in web.config.

<AppSettings>
<add key="Currency" value ="USD"/>
</AppSettings>