title: How to update MySql table row through C# console application?
body: <p>I am writing a console application and fetch data from MySql table . 
  Code : </p>
  
  <pre><code> string connection = "Server=localhoht;Database=data;Uid=root;Pwd=root123";
          MySqlConnection dbcon = new MySqlConnection(connection);
          MySqlCommand selectData;
          dbcon.Open();
          selectData = dbcon.CreateCommand();
  selectData.CommandText = "SELECT user_id, user_name,user_type FROM win_user WHERE user_type=1 ORDER BY user_id ASC ";
          MySqlDataReader juh = selectData.ExecuteReader();
  </code></pre>
  
  <p>And its working fine. Now I want to update a row with the code below :</p>
  
  <pre><code>string updatedata = "UPDATE win_user SET user_type='1' WHERE user_id= '1'";
          MySqlDataAdapter MyData = new MySqlDataAdapter();
          MyData.UpdateCommand = new MySqlCommand(updatedata, dbcon);  
  </code></pre>
  
  <p>But its not working.</p>