数据存储过程问题求教啊

string cmdtxt1 = "Server=60.23.186.166,1433;Database=DB;Integrated Security=SSPI";
        SqlConnection Con = new SqlConnection(cmdtxt1);
        Con.Open();
        SqlCommand com=new SqlCommand();
        com.Connection=Con;
        com.CommandText= "insert into Account(login_account,login_password,login_password_md5) values('"+user+"','"+pwd+"','"+pwd+"')";
        com.ExecuteNonQuery();
       Con.Close();

        Response.Write("<script>alert('恭喜账号注册成功');</script>");
上面的数据存储过程怎么样修改成下面这样的。string conn = System.Configuration.ConfigurationManager.AppSettings["dns"];
            SqlConnection con = new SqlConnection(conn);
            con.Open();
            SqlCommand cmd = new SqlCommand("_UserRegister", con);             cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter account = cmd.Parameters.Add("@account", SqlDbType.NVarChar, 32);              account.Value = UserName.Text.Trim();
            SqlParameter sqlPassword = cmd.Parameters.Add("@password", SqlDbType.NVarChar, 32);
            sqlPassword.Value = Password.Text.Trim();
            SqlParameter ret = cmd.Parameters.Add("@ret", SqlDbType.Int);
            ret.Direction = ParameterDirection.Output;
            cmd.ExecuteNonQuery();              int nRet = (int)ret.Value;
            if (nRet==1)
            {
                Alert("注册成功");
            }
            else
            {
                Alert("注册失败，用户名已被使用！");
            }
            con.Close(); --------------------编程问答-------------------- 自己写个存储过程不就完事了 --------------------编程问答-------------------- 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;
using System.IO;
using System.Collections;
using System.Security.Cryptography;
using System.Text.RegularExpressions;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
   /* private string MD5Encrypt(string str)
    {
        System.Security.Cryptography.MD5 hashmd5;
        hashmd5 = new System.Security.Cryptography.MD5CryptoServiceProvider();
        byte[]byte1;
        byte1 = hashmd5.ComputeHash(Encoding.Default.GetBytes(str));
        hashmd5.Clear();
        return Converter.ToBase64String(byte1);
    }*/
    protected void check_Click(object sender, EventArgs e)
    {

        Regex myRex = new Regex(@"(([0-9]+[a-zA-Z]+)|([a-zA-Z]+[0-9]+))");
        string s = LoginT.Text;
        //IsMatch m = myRex.IsMatch(s);
        if (!myRex.IsMatch(LoginT.Text))
        {
            Response.Write("<script>alert('你输入的游戏账号非法');</script>");

        return;
        }
        string usename = Request["LoginT"];
        string cmdtxt1 = "Server=119.52.199.130,1433;Database=DB;Integrated

Security=SSPI";
        SqlConnection Con = new SqlConnection(cmdtxt1);
       Con.Open();
       SqlCommand scom = new SqlCommand("Select count(*)  from Account where

login_account='" + usename + "'", Con);
        int count = Convert.ToInt32(scom.ExecuteScalar());
        if (count > 0)
        {
            Response.Write("<script>alert('该账号已经被注册,请重心注册账号！');</script>");


        }
        else
        {
            Response.Write("<script>alert('该账号可以注册');</script>");
        }
       Con.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {


        string user = this.LoginT.Text.Trim().ToString();
        string pwd=this.PWT.Text.Trim().ToString();
        if (PWT.Text.ToString() != TextBox2.Text.ToString())
        {
           Response.Write("<script>alert('密码不一致，请重新输入');</script>");

           return;
        }
        }
       }

        if
         }(PWT.Text.Length < 5)

            Response.Write("<script>alert('请输入大于五位的密码');</script>");
            return;
        }

        private static string strCon = ConfigurationManager.ConnectionStrings

["constr"].ConnectionString;
public static object ExecuteScalar(string strSql,string CommandType , SqlParameter[]

parameters)
           {
            SqlCommand cmdSql =  conn.CreateCommand();

            try
                {
                    conn.Open();
                    cmdSql.CommandText = strSql;
                    if(cmdsql.CommandType=="_UserRegister")
                {
                cmdsql.CommandType = CommandType.StoredProcedure;
                }
                if(this.bInTrans)
                {

                cmdSql.Transaction = this.trans;
                }
                foreach(SqlParameter SqlParm in parameters)
                {
                SqlParameter account = cmdsql.Parameters.Add("@account", SqlDbType.NVarChar,

32);
            account.Value = UserName.Text.Trim();
            SqlParameter sqlPassword = cmdsql.Parameters.Add("@password",

SqlDbType.NVarChar, 32);
            sqlPassword.Value = Password.Text.Trim();
            SqlParameter ret = cmdsql.Parameters.Add("@ret", SqlDbType.Int);
            ret.Direction = ParameterDirection.Output;
            }
            }
          catch(Exception ex)
   {
    throw ex;
   }
   finally
   {
   }
   return cmdSql;
  {
}
我这么写行吗

补充：.NET技术 ,  ASP.NET