Code
1 public bool login(string uname, string upass)
2 {
3 SqlConnection con = new SqlConnection(constring);
4 con.Open();
5 SqlCommand cmd = new SqlCommand("login", con);
6 cmd.CommandType = CommandType.StoredProcedure;
7 cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = uname;
8 cmd.Parameters.Add("@pass", SqlDbType.VarChar, 50).Value = upass;
9 try
10 {
11 string checklogin = cmd.ExecuteScalar().ToString();
12 if (checklogin != null)
13 {
14 //登入成功
15 return true;
16 }
17 else
18 {
19 return false;
20 }
21 }
22 catch
23 {
24 return false;
25 }
26 con.Close();
27 }
28
29 public DataRow personinformation(string name)
30 {
31 SqlConnection con = new SqlConnection(constring);
32 con.Open();
33 SqlDataAdapter sda = new SqlDataAdapter("userinformation",con);
34 sda.SelectCommand.CommandType = CommandType.StoredProcedure;
35 sda.SelectCommand.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = name;
36 DataSet ds = new DataSet();
37 try
38 {
39 //SqlDataReader dr = cmd.ExecuteReader();
40 sda.Fill(ds);
41 return ds.Tables[0].Rows[0];
42 con.Close();
43 }
44 catch(Exception error)
45 {
46 throw new System.Exception(error.Message);
47 }
48 }
49
50 public void updateinformation(ArrayList arr)
51 {
52
53 SqlConnection con = new SqlConnection(constring);
54 con.Open();
55 SqlCommand cmd = new SqlCommand("updateperson", con);
56 cmd.CommandType = CommandType.StoredProcedure;
57 cmd.Parameters.Add("@sex", SqlDbType.VarChar, 10).Value = arr[0];
58 cmd.Parameters.Add("@age", SqlDbType.Int).Value = arr[1];
59 cmd.Parameters.Add("@mail", SqlDbType.VarChar, 20).Value = arr[2];
60 cmd.Parameters.Add("@add", SqlDbType.VarChar, 100).Value = arr[3];
61 cmd.Parameters.Add("@phone", SqlDbType.VarChar, 12).Value = arr[4];
62 cmd.Parameters.Add("@proplem", SqlDbType.VarChar, 50).Value = arr[5];
63 cmd.Parameters.Add("@key", SqlDbType.VarChar, 50).Value = arr[6];
64 cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = arr[7];
65 try
66 {
67 cmd.ExecuteNonQuery();
68 }
69 catch (Exception err)
70 {
71 throw new System.Exception(err.Message);
72 }
73 finally
74 {
75 con.Close();
76 }
77 }