这次与大家带来的是一个具有增删改查的一个全功能的例子也是最后一次讲WinForm,接下来我会与大家分享我在ASP.Net心得,使用13个控件。以下是13个控件列表(3个Label(lblUserName, lblNewUserName, lblNewUserPass)2个TextBox(txtNewUserName, txtNewUserPass)1个DataGrid(dgUserType)6个Button(btnTypeData, btnNewData, btnAdd, btnDelete, btnUpdate, btnSelect)1个ComboBox(cbUserName)),这个例子在很多地方都用的着。在以前我与大家都讲过了的知识点。
1
using
System;
2 using System.Drawing;
3 using System.Collections;
4 using System.ComponentModel;
5 using System.Windows.Forms;
6 using System.Data;
7 using System.Data.SqlClient;
8 {
9 /**//// <summary>
10 /// 打开数据库
11 /// </summary>
12 /// <returns></returns>
13 private SqlConnection Open()
14 {
15 string _strConn = "Server=.; uid=sa; pwd=sa; database=Test";
16 _myConn = new SqlConnection(_strConn);
17 if(_myConn.State == ConnectionState.Closed)
18 {
19 _myConn.Open();
20 return _myConn;
21 }
22 else
23 {
24 return _myConn;
25 }
26 }
27 /**//// <summary>
28 /// 关闭数据库
29 /// </summary>
30 private void Close()
31 {
32 if(_myConn.State == ConnectionState.Open)
33 {
34 _myConn.Close();
35 }
36 }
37
38 private void Form1_Load(object sender, System.EventArgs e)
39 {
40 string _strSql = "Select UserName from UserTest";
41 SqlConnection _cbConn = Open();
42 SqlDataAdapter _ad = new SqlDataAdapter(_strSql, _cbConn);
43 DataSet _ds = new DataSet();
44 _ad.Fill(_ds);
45 for(int i = 0; i < _ds.Tables[0].Rows.Count; i++)
46 {
47 DataRowCollection _drwc = _ds.Tables[0].Rows;
48 cbUserName.Items.Add(_drwc[i]["UserName"].ToString());
49 }
50 this.Close();
51 }
52
53 private void btnTypeData_Click(object sender, System.EventArgs e)
54 {
55 string _strUserName = cbUserName.SelectedItem.ToString();
56 string _strSql = "Select UserName, UserPass from UserTest where UserName='"+ _strUserName +"'";
57 SqlConnection _btnConn = Open();
58 SqlDataAdapter _ad = new SqlDataAdapter(_strSql, _btnConn);
59 DataSet _ds = new DataSet();
60 _ad.Fill(_ds);
61 this.dgUserType.DataSource = _ds.Tables[0];
62 }
63
64 private void btnAdd_Click(object sender, System.EventArgs e)
65 {
66 string _strUserName = this.txtNewUserName.Text.Trim();
67 string _strPassWord = this.txtNewUserPass.Text.Trim();
68 string _strSql = "Insert into UserTest values('"+ _strUserName +"', '"+ _strPassWord +"')";
69 SqlConnection _btnAddConn = Open();
70 SqlCommand _btnAddCmd = new SqlCommand(_strSql, _btnAddConn);
71 int _isAddInfo = _btnAddCmd.ExecuteNonQuery();
72 if(_isAddInfo != 0)
73 {
74 MessageBox.Show("添加成功");
75 }
76 this.Close();
77 }
78
79 private void btnDelete_Click(object sender, System.EventArgs e)
80 {
81 string _strUserName = this.txtNewUserName.Text.Trim();
82 string _strPassWord = this.txtNewUserPass.Text.Trim();
83 string _strSql = "Delete From UserTest where UserName='"+ _strUserName +"' and UserPass='"+ _strPassWord +"'";
84 SqlConnection _btnDeleteConn = Open();
85 SqlCommand _btnDeleteCmd = new SqlCommand(_strSql, _btnDeleteConn);
86 int _isAddInfo = _btnDeleteCmd.ExecuteNonQuery();
87 if(_isAddInfo != 0)
88 {
89 MessageBox.Show("删除成功");
90 }
91 this.Close();
92 }
93
94 private void btnUpdate_Click(object sender, System.EventArgs e)
95 {
96 string _strUserName = this.txtNewUserName.Text.Trim();
97 string _strPassWord = this.txtNewUserPass.Text.Trim();
98 string _strSql = "Update UserTest Set UserName='"+ _strUserName +"',UserPass='"+ _strPassWord +"' where UserName='"+ _strUserName +"'";;
99 SqlConnection _btnUpdateConn = Open();
100 SqlCommand _btnUpdateCmd = new SqlCommand(_strSql, _btnUpdateConn);
101 int _isUpdateInfo = _btnUpdateCmd.ExecuteNonQuery();
102 if(_isUpdateInfo != 0)
103 {
104 MessageBox.Show("修改成功");
105 }
106 this.Close();
107 }
108
109 private void btnSelect_Click(object sender, System.EventArgs e)
110 {
111 string _strUserName = this.txtNewUserName.Text.Trim();
112 string _strSql = "Select UserName, UserPass From UserTest where UserName='"+ _strUserName +"'";
113 SqlConnection _btnSelectConn = Open();
114 SqlCommand _btnUpdateCmd = new SqlCommand(_strSql, _btnSelectConn);
115 SqlDataReader _drSelect = _btnUpdateCmd.ExecuteReader(CommandBehavior.CloseConnection);
116 if(_drSelect.Read())
117 {
118 this.txtNewUserName.Text = _drSelect["UserName"].ToString();
119 this.txtNewUserPass.Text = _drSelect["UserPass"].ToString();
120 }
121 this.Close();
122 }
123
124 private void btnNewData_Click(object sender, System.EventArgs e)
125 {
126 string _strSql = "Select UserName from UserTest";
127 SqlConnection _NewConn = Open();
128 SqlDataAdapter _Newad = new SqlDataAdapter(_strSql, _NewConn);
129 DataSet _Newds = new DataSet();
130 _Newad.Fill(_Newds);
131 for(int i = 0; i < _Newds.Tables[0].Rows.Count; i++)
132 {
133 DataRowCollection _drwc = _Newds.Tables[0].Rows;
134 cbUserName.Items.Add(_drwc[i]["UserName"].ToString());
135 }
136 this.Close();
137 }
138}
2 using System.Drawing;
3 using System.Collections;
4 using System.ComponentModel;
5 using System.Windows.Forms;
6 using System.Data;
7 using System.Data.SqlClient;
8 {
9 /**//// <summary>
10 /// 打开数据库
11 /// </summary>
12 /// <returns></returns>
13 private SqlConnection Open()
14 {
15 string _strConn = "Server=.; uid=sa; pwd=sa; database=Test";
16 _myConn = new SqlConnection(_strConn);
17 if(_myConn.State == ConnectionState.Closed)
18 {
19 _myConn.Open();
20 return _myConn;
21 }
22 else
23 {
24 return _myConn;
25 }
26 }
27 /**//// <summary>
28 /// 关闭数据库
29 /// </summary>
30 private void Close()
31 {
32 if(_myConn.State == ConnectionState.Open)
33 {
34 _myConn.Close();
35 }
36 }
37
38 private void Form1_Load(object sender, System.EventArgs e)
39 {
40 string _strSql = "Select UserName from UserTest";
41 SqlConnection _cbConn = Open();
42 SqlDataAdapter _ad = new SqlDataAdapter(_strSql, _cbConn);
43 DataSet _ds = new DataSet();
44 _ad.Fill(_ds);
45 for(int i = 0; i < _ds.Tables[0].Rows.Count; i++)
46 {
47 DataRowCollection _drwc = _ds.Tables[0].Rows;
48 cbUserName.Items.Add(_drwc[i]["UserName"].ToString());
49 }
50 this.Close();
51 }
52
53 private void btnTypeData_Click(object sender, System.EventArgs e)
54 {
55 string _strUserName = cbUserName.SelectedItem.ToString();
56 string _strSql = "Select UserName, UserPass from UserTest where UserName='"+ _strUserName +"'";
57 SqlConnection _btnConn = Open();
58 SqlDataAdapter _ad = new SqlDataAdapter(_strSql, _btnConn);
59 DataSet _ds = new DataSet();
60 _ad.Fill(_ds);
61 this.dgUserType.DataSource = _ds.Tables[0];
62 }
63
64 private void btnAdd_Click(object sender, System.EventArgs e)
65 {
66 string _strUserName = this.txtNewUserName.Text.Trim();
67 string _strPassWord = this.txtNewUserPass.Text.Trim();
68 string _strSql = "Insert into UserTest values('"+ _strUserName +"', '"+ _strPassWord +"')";
69 SqlConnection _btnAddConn = Open();
70 SqlCommand _btnAddCmd = new SqlCommand(_strSql, _btnAddConn);
71 int _isAddInfo = _btnAddCmd.ExecuteNonQuery();
72 if(_isAddInfo != 0)
73 {
74 MessageBox.Show("添加成功");
75 }
76 this.Close();
77 }
78
79 private void btnDelete_Click(object sender, System.EventArgs e)
80 {
81 string _strUserName = this.txtNewUserName.Text.Trim();
82 string _strPassWord = this.txtNewUserPass.Text.Trim();
83 string _strSql = "Delete From UserTest where UserName='"+ _strUserName +"' and UserPass='"+ _strPassWord +"'";
84 SqlConnection _btnDeleteConn = Open();
85 SqlCommand _btnDeleteCmd = new SqlCommand(_strSql, _btnDeleteConn);
86 int _isAddInfo = _btnDeleteCmd.ExecuteNonQuery();
87 if(_isAddInfo != 0)
88 {
89 MessageBox.Show("删除成功");
90 }
91 this.Close();
92 }
93
94 private void btnUpdate_Click(object sender, System.EventArgs e)
95 {
96 string _strUserName = this.txtNewUserName.Text.Trim();
97 string _strPassWord = this.txtNewUserPass.Text.Trim();
98 string _strSql = "Update UserTest Set UserName='"+ _strUserName +"',UserPass='"+ _strPassWord +"' where UserName='"+ _strUserName +"'";;
99 SqlConnection _btnUpdateConn = Open();
100 SqlCommand _btnUpdateCmd = new SqlCommand(_strSql, _btnUpdateConn);
101 int _isUpdateInfo = _btnUpdateCmd.ExecuteNonQuery();
102 if(_isUpdateInfo != 0)
103 {
104 MessageBox.Show("修改成功");
105 }
106 this.Close();
107 }
108
109 private void btnSelect_Click(object sender, System.EventArgs e)
110 {
111 string _strUserName = this.txtNewUserName.Text.Trim();
112 string _strSql = "Select UserName, UserPass From UserTest where UserName='"+ _strUserName +"'";
113 SqlConnection _btnSelectConn = Open();
114 SqlCommand _btnUpdateCmd = new SqlCommand(_strSql, _btnSelectConn);
115 SqlDataReader _drSelect = _btnUpdateCmd.ExecuteReader(CommandBehavior.CloseConnection);
116 if(_drSelect.Read())
117 {
118 this.txtNewUserName.Text = _drSelect["UserName"].ToString();
119 this.txtNewUserPass.Text = _drSelect["UserPass"].ToString();
120 }
121 this.Close();
122 }
123
124 private void btnNewData_Click(object sender, System.EventArgs e)
125 {
126 string _strSql = "Select UserName from UserTest";
127 SqlConnection _NewConn = Open();
128 SqlDataAdapter _Newad = new SqlDataAdapter(_strSql, _NewConn);
129 DataSet _Newds = new DataSet();
130 _Newad.Fill(_Newds);
131 for(int i = 0; i < _Newds.Tables[0].Rows.Count; i++)
132 {
133 DataRowCollection _drwc = _Newds.Tables[0].Rows;
134 cbUserName.Items.Add(_drwc[i]["UserName"].ToString());
135 }
136 this.Close();
137 }
138}