need to search mysql for something and return the value in the next colum

steve potts

Hi all,

i have a very simple table in mysql, i can connect etc fine, and i think i have the query i need, but how do i get this working in c#?

what it will basically do is find a username based on the windows username.

sUserName = Environment.UserName;

"'select sms_un from smsusers where domain_un = ' + sUserName;";

sorry its quite hard to describe :) does this make sense?

4 Replies

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

Vulpes14y ago
Accepted answer
Try:

string query = "select sms_un from smsusers where domain_un = '" + sUserName + "'";
0
steve potts14y ago
thankyou, you are amazing :D
0
Vulpes14y ago
If you're expecting a single result, then I'd use the ExecuteScalar method:

string result = Convert.ToString(command.ExecuteScalar());
0
steve potts14y ago
cant get it working, heres my code, can anyone help? :) 2bh im very new to this , and somehow when things started to work i got deeper in, and now im stuck on the last piece!

at the moment, the messagebox is just a temp thing to see if it works, and i get a messagebox just saying "-1"

string MyConString = "SERVER=192.168.0.89;" +
"DATABASE=domtosms;" +
"UID=root;" +
"PASSWORD=password;";

MySqlConnection connection = new MySqlConnection(MyConString);
string query = "select sms_un from smsusers where domain_un = '" + sUserName + "'";
MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand(query);

try
{
connection.Open();
command.Connection = connection;
string result = Convert.ToString(command.ExecuteNonQuery());
MessageBox.Show(result, "test");
}

catch (MySqlException ex)
{
MessageBox.Show(ex.ToString(), "Error");
}



connection.Close();
0