how to fill textbox from dataset?
<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>
