新手的问题

Question

下面的代码是我在本机系统成功连接的例子，希望对你有帮助！<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<Script RunAt="Server" language="c#">
protected void Page_Load(Object Src, EventArgs E)
{
HttpCookie objCookie=Request.Cookies["GDEEUID"];
if(objCookie==null)
{
objCookie=new HttpCookie("GDEEUID","");
}
String uname=Request.Form["uname"].ToString();
String passwd=Request.Form["passwd"].ToString();
SqlConnection conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=GDEESystem");
conn.Open();
SqlCommand SC=new SqlCommand("Update GDEE_User Set 登陆状态=0 where 用户ID='"+objCookie.Value+"'",conn);
SC.ExecuteNonQuery();
DataSet DS=new DataSet();
SqlDataAdapter DA=new SqlDataAdapter("select * from GDEE_User where 用户ID='"+uname+"' and 用户密码='"+passwd+"'",conn);
DA.Fill(DS,"GDEE_User");
if(DS.Tables[0].Rows.Count!=0)
{
SC.CommandText="Update GDEE_User Set 登陆状态=1 where 用户ID='"+uname+"' and 用户密码='"+passwd+"'";
SC.ExecuteNonQuery();
objCookie.Name="GDEEUname";
objCookie.Value=(String)DS.Tables["GDEE_User"].Rows[0]["用户名称"];
//HttpCookie objCookie=new HttpCookie("GDEEUname",(String)DS.Tables["GDEE_User"].Rows[0]["用户名称"]);
Response.AppendCookie(objCookie);
objCookie.Name="GDEEUID";
objCookie.Value=(String)DS.Tables["GDEE_User"].Rows[0]["用户ID"];
Response.AppendCookie(objCookie);
}
else
{
Response.Write("<script language=javascript>");
Response.Write("alert('错误的用户名或密码！');");
Response.Write("window.history.go(-1);");
Response.Write("<");
Response.Write("/");
Response.Write("script>");
Response.End();
}
conn.Close();
}
</Script>