.net2.0 +asa 10 连接程序

.net2.0 +asa 10

用的实在是少!
网上找了一大圈都没有!
只有自己看帮助

 

 1 Code
 2         string psword = "", namer = "", users = "";
 3 
 4         try
 5 
 6        {
 7             _conn = new SAConnection("DBN=asa;UID=DBA;PWD=sql");
 8             _conn.Open();
 9             //连接字符串
             SACommand cmd_client = new SACommand("SELECT Password,name,[user] FROM client where [User] = " + UserName.Text, _conn);
 
             SADataReader dr = cmd_client.ExecuteReader();
             //注意下面这么写法是通不过的!SYBASE 之变态,帮助之烂,方法也不写清楚,示例也没有,只有参考的程序
             //string users = dr.GetChar(2).ToString();
             //循环读出
             while (dr.Read())
             {
                 psword = dr.GetString(0);
                 namer = dr.GetString(1);
                 users = dr.GetString(2);
             }
             string Url;
             dr.Close();
             if (users == null || users == String.Empty)
             {
 
                 //提示错误("无此用户或者密码错误！");
 
 
             }
             else
             {
                 if (psword != Password.Text)
                 {
                     //提示错误("用户或者密码错误！");
                 }
                 else
                 {
                     //保存登陆信息
                     FormsAuthentication.SetAuthCookie(users, false);
                     HttpContext.Current.Session["loginuser"] = users;
                     HttpContext.Current.Session["loginname"] = namer;
                     if (Request.QueryString["ReturnUrl"] != null)
                     {
                         Url = Request.QueryString["ReturnUrl"];
                         HttpContext.Current.Response.Redirect(Url);
                     }
                     else
                     {
                         //内部的一个方法
                         Url = WuLiu.BLL.Globals.ApplicationVRoot + "/Index/Index.htm";
                         OpenWindow(Url);
                     }
 
                 }
             }
         }
         catch (SAException ex)
         {
             //提示错误("连接失败")
         }