SqlParameter的应用实例

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Text
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private string conStr = "database=trms;data source=.;uid=sa;pwd=sa";

        private void btnInsert_Click(object sender, EventArgs e)
        {
            using (SqlConnection con = new SqlConnection (conStr ))
            {
                SqlParameter[] parms = new SqlParameter[3];
                parms[0] = new SqlParameter("@UserID",SqlDbType.Int );
                parms[0].Value = txtUserID.Text.Trim();
                parms[1] = new SqlParameter("@UserName",SqlDbType .VarChar ,50);
                parms[1].Value = txtUserName.Text.Trim();
                parms[2] = new SqlParameter("@Password", SqlDbType.VarChar, 50);
                parms[2].Value = txtPassword.Text.Trim();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                cmd.CommandText = "testInsert";
                cmd.CommandType = CommandType.StoredProcedure;
                foreach (SqlParameter parm in parms)
                {
                    cmd.Parameters.Add(parm );
                }
                con.Open();
                cmd.ExecuteNonQuery();
            }
        }
    }
}