pass value to query

Question

How to pass value of string to a query?

Following is the code -

public string _advis

{

set { string ad1 = value; }

}

MySqlCommand com1 = new MySqlCommand("Select ID from swapnali.login where Advisor_Name='"_advis "'", conn);

How to pass value of _advis to mysql query. Here I have passed _advis, but it is giving error.

Thanks

Vulpes · Answer

Just noticed that the property code is faulty. If you change it to this then both mine and Javeed's suggestions should work: private string ad1; public string _advis { get { return ad1; } set { ad1 = value; } }

swami swami · Answer

Thanks for helping me...

swami swami · Answer

Vulpes Thank you so much.......

swami swami · Answer

i tried _advis and ad1 both. But nothing is working...

swami swami · Answer

It is giving an error The name ad1 does not exist in the current context

Javeed M Shaikh · Answer

try this: MySqlCommand com1 = new MySqlCommand(Select ID from swapnali.login where Advisor_Name=' + yourstringvalue + ' conn);

Vulpes · Answer

Try changing it to this: MySqlCommand com1 = new MySqlCommand(Select ID from swapnali.login where Advisor_Name=' + ad1 + ' conn);