database to textbox

• • Reply

  12 years ago

  by Black Hero

  Mya New

  , Czech Republic

  Joined 14 years ago

  Hi, I use this code to update my database,
  
       conn.Open()
          cmd.CommandText = "Update [aa] Set [aa] = @confirmed Where [aa] = @aa"
          cmd.CommandType = CommandType.Text
          cmd.Parameters.Add("@a, SqlDbType.VarChar).Value = "aa"
          cmd.Parameters.Add("@aa", SqlDbType.NChar).Value = aa.Text
       
          '  cmd.ExecuteNonQuery()
        
  
   What I want now is to retrieve data from the database, and show it on a textbox, how can i do that?
  
  ex. if i want the value of a , b,c ,d (in a text box )from users and where f = funny
   
  
  Thanks
  

  Report abuse