Select statement with substring function

o abuzaid

i have textbox for my user to type first 3 or 4 or any number of characters to seach for full name of drug from sql table named grugs

i used Lenght function to find no of characters typed so i can use this number with substring function to display all drug names started with enterd characthers

int i = textBox1.Text.Lenght;

select * from drugs where Substring(drg_name,0, i ) = textBox1.Text

but this gives me Error says Invalid Column name i

any Idea smart pepole ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Hi,

SQL server has like operater which will meet your requirement. First of all you need to pass textbox values based on like query will return result for you,

If you are using web application then please refer this thread,
https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/jquery-auto-complete-text-box-in-Asp-Net-C-Sharp/

if You are using windows application then
https://www.c-sharpcorner.com/UploadFile/33b051/autocomplete-textbox-in-windows-form/#:~:text=AutoComplete%20textbox%20is%20used%20for,autocomplete%20textbox%20in%20windows%20form.
Amit Gupta5y ago
Select * from drugs where drugname like '%textbox1.Text%' ;