sql statement
-
i have made this statement "select distinct fatrname from reglz where fatrname LIKE '%" & TextBox1.Text & "%' " then he has display all the results in datagride in this datagride there is some names "mark" and there is some names "marko" what i need is to select all these records to edit them and from textbox we can write marko for all current records to edit all these names how can i do that this is very very urgent plzz
-
i have made this statement "select distinct fatrname from reglz where fatrname LIKE '%" & TextBox1.Text & "%' " then he has display all the results in datagride in this datagride there is some names "mark" and there is some names "marko" what i need is to select all these records to edit them and from textbox we can write marko for all current records to edit all these names how can i do that this is very very urgent plzz
try to check the value of your txtbox... maybe it is getting a null string or space that is why your database is returning all the data...