title: how to fill textbox from dataset?
body: <p>i run this and i want to fill textbox txtFname with data - but it dont do nothing</p>
  
  <pre><code> using (Conn = new SqlConnection(Conect))
                  {
                      Conn.Open();
  
                      SQL = "SELECT * FROM MEN where id = '" + txtBAR.Text.Trim() + "'";
                      dsView = new DataSet();
                      adp = new SqlDataAdapter(SQL, Conn);
                      adp.Fill(dsView, "MEN");
                      adp.Dispose();
                      txtFname.Text = dsView.Tables[0].Rows[3][0].ToString();
                      txtFname.DataBind();
                      Conn.Close();
                  }
  </code></pre>
  
  <p>how to do it ?</p>
  
  <p>thank's in advance</p>