帮忙翻译一段C#代码

Question

求各位大侠帮帮忙给注释一下~~貌似不难，但是不太懂！回答的好有加分哦~~
protected void Button1_Click(object sender, EventArgs e)
{
String settings = ConfigurationManager.ConnectionStrings["DB_tpjConnectionString"].ToString();
SqlConnection conn = new SqlConnection(settings);

intID = int.Parse(this.txtID.Text);
chrPWD = this.txtPwd.Text;
chrRole = this.DropDownList1.SelectedValue;

if (chrRole.CompareTo("专家") == 0)
{
string sql = "select ID_E,pwd_E from Einformation where ID_E=" + intID + " and pwd_E='" + chrPWD.ToString() + "'";

SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();

da.Fill(ds);

if (ds.Tables[0].Rows.Count == 0)
{
Response.Write("<script>alert('您不是专家或者用户名和密码错误');location='Login.aspx'</script>");
}
else
{
Session["ID"] = txtID.Text;
Response.Write("<script>location='zlogin.aspx'</script>");
}

}

Answer 1

protected void Button1_Click(object sender, EventArgs e)
{
// 获得在web.config里设置的连接字符串”DB_tpjConnectionString“
String settings = ConfigurationManager.ConnectionStrings["DB_tpjConnectionString"].ToString();
// 创建数据连接conn
SqlConnection conn = new SqlConnection(settings);

// 这很简单吧，获值
intID = int.Parse(this.txtID.Text);
chrPWD = this.txtPwd.Text;
chrRole = this.DropDownList1.SelectedValue;

// 如果DropDownList1选择的是”专家“
if (chrRole.CompareTo("专家") == 0)
{
string sql = "select ID_E,pwd_E from Einformation where ID_E=" + intID + " and pwd_E='" + chrPWD.ToString() + "'";

// 创建适配器da
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
// 创建数据集ds
DataSet ds = new DataSet();
// 填充适配器da
da.Fill(ds);
// 如果没有数据
if (ds.Tables[0].Rows.Count == 0)
{
Response.Write("<script>alert('您不是专家或者用户名和密码错误');location='Login.aspx'</script>");
}
else
{
// 创建Session
Session["ID"] = txtID.Text;
Response.Write("<script>location='zlogin.aspx'</script>");
}

Answer 2

//button1的click事件：
protected void Button1_Click(object sender, EventArgs e)
{
//获取数据库连接字符串
String settings = ConfigurationManager.ConnectionStrings["DB_tpjConnectionString"].ToString();
//创建数据库连接实例
SqlConnection conn = new SqlConnection(settings);

//页面输入的id，pwd，role(角色)的值赋给三个相应的变量
intID = int.Parse(this.txtID.Text);
chrPWD = this.txtPwd.Text;
chrRole = this.DropDownList1.SelectedValue;

//如果角色是“专家”
if (chrRole.CompareTo("专家") == 0)
{
//要执行的sql语句
string sql = "select ID_E,pwd_E from Einformation where ID_E=" + intID + " and pwd_E='" + chrPWD.ToString() + "'";

//根据上面那个语句把数据填充到ds里(就是读取这个专家的信息)
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();

da.Fill(ds);
//如果sql语句查询到的行数是0，提示用户名密码错误，然后转向login.aspx
//如果行数>0，把id赋给一个Session，并且转到页面'zlogin.aspx'
if (ds.Tables[0].Rows.Count == 0)
{
Response.Write("<script>alert('您不是专家或者用户名和密码错误');location='Login.aspx'</script>");
}
else
{
Session["ID"] = txtID.Text;
Response.Write("<script>location='zlogin.aspx'</script>");
}

}

Answer 3

//获取连接字符串
String settings = ConfigurationManager.ConnectionStrings["DB_tpjConnectionString"].ToString();
SqlConnection conn = new SqlConnection(settings);
//没啥说的
intID = int.Parse(this.txtID.Text);
chrPWD = this.txtPwd.Text;
chrRole = this.DropDownList1.SelectedValue;
//如果不等 一个数据库操作 得到DATASET

if (chrRole.CompareTo("专家") == 0)
{
string sql = "select ID_E,pwd_E from Einformation where ID_E=" + intID + " and pwd_E='" + chrPWD.ToString() + "'";

SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();

da.Fill(ds);
//如果得到个DATASET里为空 提示‘您不是专家或者用户名和密码错误' 然后跳转
if (ds.Tables[0].Rows.Count == 0)
{
Response.Write("<script>alert('您不是专家或者用户名和密码错误');location='Login.aspx'</script>");
}
//不为空 记录session 然后跳转
else
{
Session["ID"] = txtID.Text;
Response.Write("<script>location='zlogin.aspx'</script>");
}