textbox value read from sql table name coloum

Try this    

  SqlDataAdapter da;
        DataSet ds;
         da = new SqlDataAdapter("Select name from Tablename ", con);
                da.SelectCommand.CommandType = CommandType.StoredProcedure;
                ds = new DataSet();
                da.Fill(ds);
               textbox1 . Text = ds.Tables[0].Rows[0]["Name"].ToString();
                textbox2 . Text = ds.Tables[0].Rows[1]["Name"].ToString();