add.cs

一个较小的采购系统,一些比较实际的代码,可以用来参考

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;



/// <summary>
/// add 的摘要说明
/// </summary>
public class add
{
    public void insert(string strUID,string strPWD,string strArea,string strXZ,string strname)
    { 
        //添加帐号
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("Register", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlParameter paraUID = new SqlParameter("@user_UID", SqlDbType.NVarChar, 50);
        paraUID.Value = strUID;
        cmd.Parameters.Add(paraUID);

        SqlParameter paraPWD = new SqlParameter("@user_PWD",SqlDbType.NVarChar,50);
        string str = FormsAuthentication.HashPasswordForStoringInConfigFile(strPWD, "md5");
        paraPWD.Value = str;
        cmd.Parameters.Add(paraPWD);

        SqlParameter paraArea = new SqlParameter("@user_area", SqlDbType.NVarChar, 50);
        paraArea.Value = strArea;
        cmd.Parameters.Add(paraArea);

        SqlParameter paraXZ = new SqlParameter("@user_type", SqlDbType.NVarChar, 50);
        paraXZ.Value = strXZ;
        cmd.Parameters.Add(paraXZ);

        SqlParameter paraname = new SqlParameter("@user_name", SqlDbType.NVarChar, 50);
        paraname.Value = strname;
        cmd.Parameters.Add(paraname);

        //SqlParameter paraid = new SqlParameter("@user_ID", SqlDbType.Int, 50);
        //paraid.Direction = ParameterDirection.InputOutput;
        //cmd.Parameters.Add(paraid);

      
            cmd.ExecuteNonQuery();
            conn.Close();
            conn.Dispose();
      



    }
}