.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             //连接字符串
10             SACommand cmd_client = new SACommand("SELECT Password,name,[user] FROM client where [User] = " + UserName.Text, _conn);
11 
12             SADataReader dr = cmd_client.ExecuteReader();
13             //注意下面这么写法是通不过的!SYBASE 之变态,帮助之烂,方法也不写清楚,示例也没有,只有参考的程序
14             //string users = dr.GetChar(2).ToString();
15             //循环读出
16             while (dr.Read())
17             {
18                 psword = dr.GetString(0);
19                 namer = dr.GetString(1);
20                 users = dr.GetString(2);
21             }
22             string Url;
23             dr.Close();
24             if (users == null || users == String.Empty)
25             {
26 
27                 //提示错误("无此用户或者密码错误！");
28 
29 
30             }
31             else
32             {
33                 if (psword != Password.Text)
34                 {
35                     //提示错误("用户或者密码错误！");
36                 }
37                 else
38                 {
39                     //保存登陆信息
40                     FormsAuthentication.SetAuthCookie(users, false);
41                     HttpContext.Current.Session["loginuser"] = users;
42                     HttpContext.Current.Session["loginname"] = namer;
43                     if (Request.QueryString["ReturnUrl"] != null)
44                     {
45                         Url = Request.QueryString["ReturnUrl"];
46                         HttpContext.Current.Response.Redirect(Url);
47                     }
48                     else
49                     {
50                         //内部的一个方法
51                         Url = WuLiu.BLL.Globals.ApplicationVRoot + "/Index/Index.htm";
52                         OpenWindow(Url);
53                     }
54 
55                 }
56             }
57         }
58         catch (SAException ex)
59         {
60             //提示错误("连接失败")
61         }
62 
63