Could anyone help me in the select statement. I created small form to search in the database, it gaves me an error Missing Expression. The combox has the attributes of the table because I want restrict the search to only on specfic columns.
commandString = "Select * from tableadd where " + this.comboBox1.SelectedText + "like '%" + textBox1.Text + "%'" ;
Actually the statement that you gave it to me I know about it. But what I want to do is I want to select one attribut, for example
If I have this table,
create table CUSTOMER(
If put these 4 attributes in combobox I can put for example in the textbox= paris
So I know that PARIS is a city, I'll select from combobox CITY. but I use your statement and imagine that I want to search by CITY not by Customer Name it will be easy for me everytime I select different attribute depend on the search.
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...