初學者做網站

失敗了 :(

/* SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=mydata;User Id=sa;Password=1234");
conn.Open();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("Select Account_Name,Name,NickName,Sex,Birthday,CellPhone From Member_Detail Where Account_Name='" + Session["Account_Name"] + "'", conn);
SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read ())
{
// Label2.Text = Convert.ToString(dr.GetSqlInt16(0));
Label3.Text = Convert.ToString(dr.GetString(1));
Label4.Text = Convert.ToString(dr.GetString(2));
Label5.Text = Convert.ToString(dr.GetString(3));
Label6.Text = Convert.ToString(dr.GetString(4));
Label7.Text = Convert.ToString(dr.GetString(5));
Label8.Text = Convert.ToString(dr.GetSqlChars(6));
// Label9.Text = Convert.ToString(dr.GetString(7));
}
else
{
Label2.Text = "";

}*/

成功了:)

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=mydata;User Id=sa;Password=1234");
conn.Open();
DataTable dt = new DataTable();

SqlDataAdapter cmd = new SqlDataAdapter("Select Account_ID,Account_Name,Name,NickName,Sex,Birthday,CellPhone,[E-mail] From Member_Detail Where Account_Name='" + Session["Account_Name"] + "'", conn);
cmd.Fill(dt);

if (dt.Rows.Count >= 0)
{
Label2.Text = Convert.ToString(dt.Rows[0]["Account_ID"]);
Label3.Text = Convert.ToString(dt.Rows[0]["Account_Name"]);
Label4.Text = Convert.ToString(dt.Rows[0]["Name"]);
Label5.Text = Convert.ToString(dt.Rows[0]["NickName"]);
Label6.Text = Convert.ToString(dt.Rows[0]["Sex"]);
Label7.Text = Convert.ToString(dt.Rows[0]["Birthday"]);
Label8.Text = Convert.ToString(dt.Rows[0]["CellPhone"]);
Label9.Text = Convert.ToString(dt.Rows[0]["E-mail"]);
}
else
{
Label2.Text = "";
}
conn.Close();
cmd.Dispose();