Our Training Programs

All contents are copyright of their authors.

pass value to query

pass value to query

swami swami

13yAsked May 14, 2013, 1:24 PM1.6kVisual Basic .NET

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

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Vulpes13y ago
Accepted 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 swami13y ago
Thanks for helping me...
swami swami13y ago
Vulpes, Thank you so much.......
swami swami13y ago
i tried "_advis" and "ad1" both. But nothing is working...
swami swami13y ago
It is giving an error "The name ad1 does not exist in the current context"
Javeed M Shaikh13y ago
try this:

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

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