如何调用存储过程执行命令

用于调用数据库中的写好的存储过程，这里的例子没有带参数，如果要带参数也可以用于登录时与数据库互动性的登录窗口，这样安全性要好，下次再实验一下：

点击(此处)折叠或打开

1. app.config中定义连接字符串
   
2.    <!-- 数据库连接字符串-->
   
3. <configuration>
   
4.  <appSettings>
   
5.       <add key="Helpdeskstr" value="server=(local);User ID=sa;Password=;database=Test" />
   
6. </appSettings>
   
7.    
   
8. </configuration>
   
9. 
   
10. 
    
11. string con = ConfigurationManager.ConnectionStrings["Helpdeskstr"].ConnectionString;
    
12. 
    
13.             string sql = "del_uninst_softlist"; //要调用的存储过程名
    
14.             SqlConnection constr = new SqlConnection(con); //SQL数据库连接对象，以数据库链接字符串为参数
    
15.             DialogResult dr = MessageBox.Show("你确定删除残留软件吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
    
16.             try
    
17.             {
    
18.                 if (dr == DialogResult.OK)
    
19.                 {
    
20.                     SqlCommand comstr = new SqlCommand(sql, constr); //SQL语句执行对象，第一个参数是要执行的语句，第二个是数据库连接对象
    
21.                     comstr.CommandType = CommandType.StoredProcedure; //要使用的是存储过程，所以设置执行类型为存储过程
    
22.                     constr.Open(); //打开数据库连接
    
23.                     comstr.ExecuteNonQuery();//执行存储过程
    
24.                     MessageBox.Show("删除残留软件已经完成！");
    
25.                 }
    
26.                 else
    
27.                 {
    
28.                     return;
    
29.                 }
    
30.             }
    
31.             catch(Exception ex)
    
32.             {
    
33.                 MessageBox.Show(ex.Message);
    
34.             }
    
35.             finally
    
36.             {
    
37.                 constr.Close(); //关闭连接
    
38.             }

以下是写的与数据库调用存储过程的账号更新与建立：这里自己写的一个方法,好像没有校验登录方法

点击(此处)折叠或打开

1. public static int AccountRegister(string accountName, string password,string firstname,string position,string phone)
   
2.         {
   
3.             //string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
   
4.             string connstr = configxml.xmlconn.readxml();
   
5.             SqlConnection conn = new SqlConnection(connstr);
   
6.             string bytePassword = Encrypt.GetMD5_32(password);//使用32位MD5加密
   
7.             conn.Open();
   
8. 
   
9.             SqlCommand cmd = new SqlCommand("Account_Add", conn);
   
10.             cmd.CommandType = CommandType.StoredProcedure;
    
11.             SqlParameter prmAccountName = cmd.Parameters.Add(new SqlParameter("@accountName", SqlDbType.NVarChar, 50));
    
12.             prmAccountName.Value = accountName;
    
13.             SqlParameter prmPassword = cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar, 50));
    
14.             prmPassword.Value = bytePassword;
    
15.             SqlParameter prmFirstName = cmd.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.NVarChar, 50));
    
16.             prmFirstName.Value = firstname;
    
17.             SqlParameter prmPosition = cmd.Parameters.Add(new SqlParameter("@position", SqlDbType.NVarChar, 50));
    
18.             prmPosition.Value = position;
    
19.             SqlParameter prmPhone = cmd.Parameters.Add(new SqlParameter("@phone", SqlDbType.NVarChar, 50));
    
20.             prmPhone.Value = phone;
    
21.             int myInt = cmd.ExecuteNonQuery();
    
22.             cmd.Dispose();
    
23.             conn.Close();
    
24.             return myInt;
    
25.         }
    
26.         //更新账户信息
    
27.         public static int AccountUpdate(string accountName, string password)
    
28.         {
    
29.             //string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
    
30.             string connstr = configxml.xmlconn.readxml();
    
31.             string bytePassword = Encrypt.GetMD5_32(password);
    
32.             SqlConnection conn = new SqlConnection(connstr);
    
33.             conn.Open();
    
34.             SqlCommand cmd = new SqlCommand("Account_Update",conn);
    
35.             cmd.CommandType = CommandType.StoredProcedure;
    
36.             SqlParameter prmAccountName = cmd.Parameters.Add(new SqlParameter("@accountName", SqlDbType.NVarChar, 50));
    
37.             prmAccountName.Value = accountName;
    
38.             SqlParameter prmPassword = cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar, 50));
    
39.             prmPassword.Value = bytePassword;
    
40.             int myInt = cmd.ExecuteNonQuery();
    
41.             cmd.Dispose();
    
42.             conn.Close();
    
43.             return myInt;
    
44.         }