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

Question

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?

Vulpes · Answer

Try: string query = select sms_un from smsusers where domain_un = ' + sUserName + ';

steve potts · Answer

thankyou you are amazing :D

Vulpes · Answer

If you're expecting a single result then I'd use the ExecuteScalar method: string result = Convert.ToString( command.ExecuteScalar() );

steve potts · Answer

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();