Hi all I am new to the Database World Here is my problem
I have A database with a table named ITEM which has 4 columns
1.Upc 2.Desc 3.Cost 4.Price
I have a datagrid and 4 textboxes and a button each textbox
represents 1 field on the button click event it should do the flowing 1 if the 4 textboxes is empty it should run the basic query and display all the data in the datagrid
if there is any textboxes not empty it should run a the select command like this WHERE UPC=(TextBoxUpc.TEXT)
how do gendered this kind of command?
Is it possible to have where upc=the containing characters or starts with these characters?
Please Help
Thank You
Chaim
I have A database with a table named ITEM which has 4 columns
1.Upc 2.Desc 3.Cost 4.Price
I have a datagrid and 4 textboxes and a button each textbox
represents 1 field on the button click event it should do the flowing 1 if the 4 textboxes is empty it should run the basic query and display all the data in the datagrid
if there is any textboxes not empty it should run a the select command like this WHERE UPC=(TextBoxUpc.TEXT)
how do gendered this kind of command?
Is it possible to have where upc=the containing characters or starts with these characters?
Please Help
Thank You
Chaim
