ADO.Net数据库连接串的 参数传递

 1using System;
 2using System.Collections.Generic;
 3using System.ComponentModel;
 4using System.Data;
 5using System.Drawing;
 6using System.Linq;
 7using System.Text;
 8using System.Windows.Forms;
 9using System.Data.SqlClient;
10
11namespace 参数
12{
13    public partial class Form1 : Form
14    {
15        public Form1()
16        {
17            InitializeComponent();
18        }
19
20        private void button1_Click(object sender, EventArgs e)
21        {
22            string sqlconn = @"server =TTC-A6C4B2BF957\MSSQLSERVER1; database = test_c; integrated security = true";
23            SqlConnection conn = new SqlConnection(sqlconn);
24            conn.Open();
25            string sqlstr = " update emp set ENAME =@ename where eno = @eno";
26            SqlCommand cmd = new SqlCommand(sqlstr, conn);
27
28
29            //传递参数方法一#region//传递参数方法一
30            SqlParameter farm1 = new SqlParameter("@ename", SqlDbType.NChar);
31            SqlParameter farm2 = new SqlParameter("@eno", SqlDbType.NChar);
32            cmd.Parameters.Add(farm1);
33            cmd.Parameters["@ename"].Value = textBox1.Text;
34            cmd.Parameters.Add(farm2);
35            cmd.Parameters["@eno"].Value = textBox2.Text;
36            # endregion
37
38
39            //传递参数方法二#region//传递参数方法二
40            cmd.Parameters.Add("ename", SqlDbType.NChar);
41            cmd.Parameters["@ename"].Value = textBox1.Text;
42            cmd.Parameters.Add("eno", SqlDbType.NChar);
43            cmd.Parameters["@eno"].Value = textBox2.Text;
44            #endregion
45
46
47            //传递参数方法三#region//传递参数方法三
48            cmd.Parameters.AddWithValue("ename", textBox1.Text);
49            cmd.Parameters.AddWithValue("eno", textBox2.Text);
50            #endregion
51
52
53            int i = cmd.ExecuteNonQuery();
54            MessageBox.Show(i.ToString());
55            
56            
57        }
58    }
59}
60
61