当前位置：Gxlcms > 数据库问题 > 传智播客数据绑定和数据库开发基础(第四季)-杨中科

传智播客数据绑定和数据库开发基础(第四季)-杨中科

时间：2021-07-01 10:21:17 帮助过：1人阅读

using System; 2 using System.Collections.Generic; 3 using System.ComponentModel; 4 using System.Data; 5 using System.Drawing; 6 using System.Linq; 7 using System.Text; 8 using System.Windows.Forms; 9 using System.Data.SqlClient; 10 11 namespace adonet 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 SqlHelper.ExecuteNonQuery("insert into T_Student(Name,Age) values(‘a‘,33)"); 23 DataTable table = SqlHelper.ExecuteDataTable("select * from T_Student where Age=@Age or Name=@Name", 24 new SqlParameter("@Age", 26), new SqlParameter("name", "刘洋")); 25 foreach (DataRow row in table.Rows) 26 { 27 string name = (string)row["name"]; 28 MessageBox.Show(name); 29 } 30 } 31 } 32 } View Code 技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> adonet
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #000000;">{
  3. </span><span style="color: #008080;"> 3</span>     <span style="color: #0000ff;">partial</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> Form1
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #000000;">    {
  5. </span><span style="color: #008080;"> 5</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  6. <span style="color: #008080;"> 6</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 必需的设计器变量。
  7. </span><span style="color: #008080;"> 7</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  8. <span style="color: #008080;"> 8</span>         <span style="color: #0000ff;">private</span> System.ComponentModel.IContainer components = <span style="color: #0000ff;">null</span><span style="color: #000000;">;
  9. </span><span style="color: #008080;"> 9</span> 
  10. <span style="color: #008080;">10</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  11. <span style="color: #008080;">11</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 清理所有正在使用的资源。
  12. </span><span style="color: #008080;">12</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  13. <span style="color: #008080;">13</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="disposing"></span><span style="color: #008000;">如果应释放托管资源，为 true；否则为 false。</span><span style="color: #808080;"></param></span>
  14. <span style="color: #008080;">14</span>         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">override</span> <span style="color: #0000ff;">void</span> Dispose(<span style="color: #0000ff;">bool</span><span style="color: #000000;"> disposing)
  15. </span><span style="color: #008080;">15</span> <span style="color: #000000;">        {
  16. </span><span style="color: #008080;">16</span>             <span style="color: #0000ff;">if</span> (disposing && (components != <span style="color: #0000ff;">null</span><span style="color: #000000;">))
  17. </span><span style="color: #008080;">17</span> <span style="color: #000000;">            {
  18. </span><span style="color: #008080;">18</span> <span style="color: #000000;">                components.Dispose();
  19. </span><span style="color: #008080;">19</span> <span style="color: #000000;">            }
  20. </span><span style="color: #008080;">20</span>             <span style="color: #0000ff;">base</span><span style="color: #000000;">.Dispose(disposing);
  21. </span><span style="color: #008080;">21</span> <span style="color: #000000;">        }
  22. </span><span style="color: #008080;">22</span> 
  23. <span style="color: #008080;">23</span>         <span style="color: #0000ff;">#region</span> Windows 窗体设计器生成的代码
  24. <span style="color: #008080;">24</span> 
  25. <span style="color: #008080;">25</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  26. <span style="color: #008080;">26</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 设计器支持所需的方法 - 不要
  27. </span><span style="color: #008080;">27</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 使用代码编辑器修改此方法的内容。
  28. </span><span style="color: #008080;">28</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  29. <span style="color: #008080;">29</span>         <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> InitializeComponent()
  30. </span><span style="color: #008080;">30</span> <span style="color: #000000;">        {
  31. </span><span style="color: #008080;">31</span>             <span style="color: #0000ff;">this</span>.button1 = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Windows.Forms.Button();
  32. </span><span style="color: #008080;">32</span>             <span style="color: #0000ff;">this</span><span style="color: #000000;">.SuspendLayout();
  33. </span><span style="color: #008080;">33</span>             <span style="color: #008000;">//</span> 
  34. <span style="color: #008080;">34</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> button1
  35. </span><span style="color: #008080;">35</span>             <span style="color: #008000;">//</span> 
  36. <span style="color: #008080;">36</span>             <span style="color: #0000ff;">this</span>.button1.Location = <span style="color: #0000ff;">new</span> System.Drawing.Point(<span style="color: #800080;">88</span>, <span style="color: #800080;">78</span><span style="color: #000000;">);
  37. </span><span style="color: #008080;">37</span>             <span style="color: #0000ff;">this</span>.button1.Name = <span style="color: #800000;">"</span><span style="color: #800000;">button1</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  38. </span><span style="color: #008080;">38</span>             <span style="color: #0000ff;">this</span>.button1.Size = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">75</span>, <span style="color: #800080;">23</span><span style="color: #000000;">);
  39. </span><span style="color: #008080;">39</span>             <span style="color: #0000ff;">this</span>.button1.TabIndex = <span style="color: #800080;">0</span><span style="color: #000000;">;
  40. </span><span style="color: #008080;">40</span>             <span style="color: #0000ff;">this</span>.button1.Text = <span style="color: #800000;">"</span><span style="color: #800000;">button1</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  41. </span><span style="color: #008080;">41</span>             <span style="color: #0000ff;">this</span>.button1.UseVisualStyleBackColor = <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  42. </span><span style="color: #008080;">42</span>             <span style="color: #0000ff;">this</span>.button1.Click += <span style="color: #0000ff;">new</span> System.EventHandler(<span style="color: #0000ff;">this</span><span style="color: #000000;">.button1_Click);
  43. </span><span style="color: #008080;">43</span>             <span style="color: #008000;">//</span> 
  44. <span style="color: #008080;">44</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> Form1
  45. </span><span style="color: #008080;">45</span>             <span style="color: #008000;">//</span> 
  46. <span style="color: #008080;">46</span>             <span style="color: #0000ff;">this</span>.AutoScaleDimensions = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Drawing.SizeF(6F, 12F);
  47. </span><span style="color: #008080;">47</span>             <span style="color: #0000ff;">this</span>.AutoScaleMode =<span style="color: #000000;"> System.Windows.Forms.AutoScaleMode.Font;
  48. </span><span style="color: #008080;">48</span>             <span style="color: #0000ff;">this</span>.ClientSize = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">284</span>, <span style="color: #800080;">261</span><span style="color: #000000;">);
  49. </span><span style="color: #008080;">49</span>             <span style="color: #0000ff;">this</span>.Controls.Add(<span style="color: #0000ff;">this</span><span style="color: #000000;">.button1);
  50. </span><span style="color: #008080;">50</span>             <span style="color: #0000ff;">this</span>.Name = <span style="color: #800000;">"</span><span style="color: #800000;">Form1</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  51. </span><span style="color: #008080;">51</span>             <span style="color: #0000ff;">this</span>.Text = <span style="color: #800000;">"</span><span style="color: #800000;">Form1</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  52. </span><span style="color: #008080;">52</span>             <span style="color: #0000ff;">this</span>.ResumeLayout(<span style="color: #0000ff;">false</span><span style="color: #000000;">);
  53. </span><span style="color: #008080;">53</span> 
  54. <span style="color: #008080;">54</span> <span style="color: #000000;">        }
  55. </span><span style="color: #008080;">55</span> 
  56. <span style="color: #008080;">56</span>         <span style="color: #0000ff;">#endregion</span>
  57. <span style="color: #008080;">57</span> 
  58. <span style="color: #008080;">58</span>         <span style="color: #0000ff;">private</span><span style="color: #000000;"> System.Windows.Forms.Button button1;
  59. </span><span style="color: #008080;">59</span> <span style="color: #000000;">    }
  60. </span><span style="color: #008080;">60</span> }
View Code 技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Windows.Forms;
  5. </span><span style="color: #008080;"> 5</span> 
  6. <span style="color: #008080;"> 6</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> adonet
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #000000;">{
  8. </span><span style="color: #008080;"> 8</span>     <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> Program
  9. </span><span style="color: #008080;"> 9</span> <span style="color: #000000;">    {
  10. </span><span style="color: #008080;">10</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  11. <span style="color: #008080;">11</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 应用程序的主入口点。
  12. </span><span style="color: #008080;">12</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  13. <span style="color: #008080;">13</span> <span style="color: #000000;">        [STAThread]
  14. </span><span style="color: #008080;">14</span>         <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> Main()
  15. </span><span style="color: #008080;">15</span> <span style="color: #000000;">        {
  16. </span><span style="color: #008080;">16</span> <span style="color: #000000;">            Application.EnableVisualStyles();
  17. </span><span style="color: #008080;">17</span>             Application.SetCompatibleTextRenderingDefault(<span style="color: #0000ff;">false</span><span style="color: #000000;">);
  18. </span><span style="color: #008080;">18</span>             Application.Run(<span style="color: #0000ff;">new</span><span style="color: #000000;"> Form1());
  19. </span><span style="color: #008080;">19</span> <span style="color: #000000;">        }
  20. </span><span style="color: #008080;">20</span> <span style="color: #000000;">    }
  21. </span><span style="color: #008080;">21</span> }
View Code

sqlhelper

技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Text;
  5. </span><span style="color: #008080;"> 5</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data.SqlClient;
  6. </span><span style="color: #008080;"> 6</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Configuration;
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data;
  8. </span><span style="color: #008080;"> 8</span> 
  9. <span style="color: #008080;"> 9</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> adonet
  10. </span><span style="color: #008080;">10</span> <span style="color: #000000;">{
  11. </span><span style="color: #008080;">11</span>     <span style="color: #0000ff;">class</span><span style="color: #000000;"> SqlHelper
  12. </span><span style="color: #008080;">12</span> <span style="color: #000000;">    {
  13. </span><span style="color: #008080;">13</span>         <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">string</span> connStr = ConfigurationManager.ConnectionStrings[<span style="color: #800000;">"</span><span style="color: #800000;">dbConnStr</span><span style="color: #800000;">"</span><span style="color: #000000;">].ConnectionString;
  14. </span><span style="color: #008080;">14</span> 
  15. <span style="color: #008080;">15</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">int</span> ExecuteNonQuery(<span style="color: #0000ff;">string</span> sql, <span style="color: #0000ff;">params</span><span style="color: #000000;"> SqlParameter[] parameters)
  16. </span><span style="color: #008080;">16</span> <span style="color: #000000;">        {
  17. </span><span style="color: #008080;">17</span>             <span style="color: #0000ff;">using</span> (SqlConnection conn = <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlConnection(connStr))
  18. </span><span style="color: #008080;">18</span> <span style="color: #000000;">            {
  19. </span><span style="color: #008080;">19</span> <span style="color: #000000;">                conn.Open();
  20. </span><span style="color: #008080;">20</span>                 <span style="color: #0000ff;">using</span> (SqlCommand cmd =<span style="color: #000000;"> conn.CreateCommand())
  21. </span><span style="color: #008080;">21</span> <span style="color: #000000;">                {
  22. </span><span style="color: #008080;">22</span>                     cmd.CommandText =<span style="color: #000000;"> sql;
  23. </span><span style="color: #008080;">23</span> <span style="color: #000000;">                    cmd.Parameters.AddRange(parameters);
  24. </span><span style="color: #008080;">24</span>                     <span style="color: #0000ff;">return</span><span style="color: #000000;"> cmd.ExecuteNonQuery();
  25. </span><span style="color: #008080;">25</span> <span style="color: #000000;">                }
  26. </span><span style="color: #008080;">26</span> <span style="color: #000000;">            }
  27. </span><span style="color: #008080;">27</span> <span style="color: #000000;">        }
  28. </span><span style="color: #008080;">28</span> 
  29. <span style="color: #008080;">29</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">object</span> ExecuteScalar(<span style="color: #0000ff;">string</span> sql, <span style="color: #0000ff;">params</span><span style="color: #000000;"> SqlParameter[] parameters)
  30. </span><span style="color: #008080;">30</span> <span style="color: #000000;">        {
  31. </span><span style="color: #008080;">31</span>             <span style="color: #0000ff;">using</span> (SqlConnection conn = <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlConnection(connStr))
  32. </span><span style="color: #008080;">32</span> <span style="color: #000000;">            {
  33. </span><span style="color: #008080;">33</span> <span style="color: #000000;">                conn.Open();
  34. </span><span style="color: #008080;">34</span>                 <span style="color: #0000ff;">using</span> (SqlCommand cmd =<span style="color: #000000;"> conn.CreateCommand())
  35. </span><span style="color: #008080;">35</span> <span style="color: #000000;">                {
  36. </span><span style="color: #008080;">36</span>                     cmd.CommandText =<span style="color: #000000;"> sql;
  37. </span><span style="color: #008080;">37</span> <span style="color: #000000;">                    cmd.Parameters.AddRange(parameters);
  38. </span><span style="color: #008080;">38</span>                     <span style="color: #0000ff;">return</span><span style="color: #000000;"> cmd.ExecuteScalar();
  39. </span><span style="color: #008080;">39</span> <span style="color: #000000;">                }
  40. </span><span style="color: #008080;">40</span> <span style="color: #000000;">            }
  41. </span><span style="color: #008080;">41</span> <span style="color: #000000;">        }
  42. </span><span style="color: #008080;">42</span> 
  43. <span style="color: #008080;">43</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> DataTable ExecuteDataTable(<span style="color: #0000ff;">string</span> sql, <span style="color: #0000ff;">params</span><span style="color: #000000;"> SqlParameter[] parameters)
  44. </span><span style="color: #008080;">44</span> <span style="color: #000000;">        {
  45. </span><span style="color: #008080;">45</span>             <span style="color: #0000ff;">using</span> (SqlConnection conn = <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlConnection(connStr))
  46. </span><span style="color: #008080;">46</span> <span style="color: #000000;">            {
  47. </span><span style="color: #008080;">47</span> <span style="color: #000000;">                conn.Open();
  48. </span><span style="color: #008080;">48</span>                 <span style="color: #0000ff;">using</span> (SqlCommand cmd =<span style="color: #000000;"> conn.CreateCommand())
  49. </span><span style="color: #008080;">49</span> <span style="color: #000000;">                {
  50. </span><span style="color: #008080;">50</span>                     cmd.CommandText =<span style="color: #000000;"> sql;
  51. </span><span style="color: #008080;">51</span> <span style="color: #000000;">                    cmd.Parameters.AddRange(parameters);
  52. </span><span style="color: #008080;">52</span> 
  53. <span style="color: #008080;">53</span>                     SqlDataAdapter adapter = <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlDataAdapter(cmd);
  54. </span><span style="color: #008080;">54</span>                     DataSet dataset=<span style="color: #0000ff;">new</span><span style="color: #000000;"> DataSet();
  55. </span><span style="color: #008080;">55</span> <span style="color: #000000;">                    adapter.Fill(dataset);
  56. </span><span style="color: #008080;">56</span>                     <span style="color: #0000ff;">return</span> dataset.Tables[<span style="color: #800080;">0</span><span style="color: #000000;">];
  57. </span><span style="color: #008080;">57</span> <span style="color: #000000;">                }
  58. </span><span style="color: #008080;">58</span> <span style="color: #000000;">            }
  59. </span><span style="color: #008080;">59</span> <span style="color: #000000;">        }
  60. </span><span style="color: #008080;">60</span> <span style="color: #000000;">    }
  61. </span><span style="color: #008080;">61</span> }
View Code

 

(三)ADO.Net案例：登陆、数据导入导出、省市联动选择

技术分享 
  1. <span style="color: #008080;">1</span> <?xml version=<span style="color: #800000;">"</span><span style="color: #800000;">1.0</span><span style="color: #800000;">"</span> encoding=<span style="color: #800000;">"</span><span style="color: #800000;">utf-8</span><span style="color: #800000;">"</span> ?>
  2. <span style="color: #008080;">2</span> <configuration>
  3. <span style="color: #008080;">3</span>   <connectionStrings>
  4. <span style="color: #008080;">4</span>     <add name=<span style="color: #800000;">"</span><span style="color: #800000;">dbConnStr</span><span style="color: #800000;">"</span> connectionString=<span style="color: #800000;">"</span><span style="color: #800000;">data source=.;initial catalog=Scott;user id=sa;password=222222</span><span style="color: #800000;">"</span>/>
  5. <span style="color: #008080;">5</span>   </connectionStrings>
  6. <span style="color: #008080;">6</span> </configuration>
View Code

 

技术分享 
  1. <span style="color: #008080;">1</span> <?xml version=<span style="color: #800000;">"</span><span style="color: #800000;">1.0</span><span style="color: #800000;">"</span> encoding=<span style="color: #800000;">"</span><span style="color: #800000;">utf-8</span><span style="color: #800000;">"</span> ?>
  2. <span style="color: #008080;">2</span> <configuration>
  3. <span style="color: #008080;">3</span>   <connectionStrings>
  4. <span style="color: #008080;">4</span>     <add name=<span style="color: #800000;">"</span><span style="color: #800000;">myconnStr</span><span style="color: #800000;">"</span> connectionString =<span style="color: #800000;">"</span><span style="color: #800000;">data source=.;initial catalog=Scott;user id=sa;password=222222</span><span style="color: #800000;">"</span>/>
  5. <span style="color: #008080;">5</span>   </connectionStrings>
  6. <span style="color: #008080;">6</span> </configuration>
View Code 技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Text;
  5. </span><span style="color: #008080;"> 5</span> 
  6. <span style="color: #008080;"> 6</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> Adonet
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #000000;">{
  8. </span><span style="color: #008080;"> 8</span>     <span style="color: #0000ff;">class</span><span style="color: #000000;"> Area
  9. </span><span style="color: #008080;"> 9</span> <span style="color: #000000;">    {
  10. </span><span style="color: #008080;">10</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">int</span><span style="color: #000000;"> AreaId
  11. </span><span style="color: #008080;">11</span>         { <span style="color: #0000ff;">get</span>; <span style="color: #0000ff;">set</span><span style="color: #000000;">; }
  12. </span><span style="color: #008080;">12</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">string</span><span style="color: #000000;"> AreaName
  13. </span><span style="color: #008080;">13</span>         { <span style="color: #0000ff;">get</span>; <span style="color: #0000ff;">set</span><span style="color: #000000;">; }
  14. </span><span style="color: #008080;">14</span> <span style="color: #000000;">    }
  15. </span><span style="color: #008080;">15</span> }
View Code 技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.ComponentModel;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data;
  5. </span><span style="color: #008080;"> 5</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Drawing;
  6. </span><span style="color: #008080;"> 6</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Text;
  8. </span><span style="color: #008080;"> 8</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Windows.Forms;
  9. </span><span style="color: #008080;"> 9</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data.SqlClient;
  10. </span><span style="color: #008080;">10</span> 
  11. <span style="color: #008080;">11</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> Adonet
  12. </span><span style="color: #008080;">12</span> <span style="color: #000000;">{
  13. </span><span style="color: #008080;">13</span>     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">partial</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> LoginWindow : Form
  14. </span><span style="color: #008080;">14</span> <span style="color: #000000;">    {
  15. </span><span style="color: #008080;">15</span>         <span style="color: #0000ff;">public</span><span style="color: #000000;"> LoginWindow()
  16. </span><span style="color: #008080;">16</span> <span style="color: #000000;">        {
  17. </span><span style="color: #008080;">17</span> <span style="color: #000000;">            InitializeComponent();
  18. </span><span style="color: #008080;">18</span> <span style="color: #000000;">        }
  19. </span><span style="color: #008080;">19</span> 
  20. <span style="color: #008080;">20</span>         <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> btnLogin_Click(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e)
  21. </span><span style="color: #008080;">21</span> <span style="color: #000000;">        {
  22. </span><span style="color: #008080;">22</span>             <span style="color: #0000ff;">if</span> (userName.Text.Length <= <span style="color: #800080;">0</span><span style="color: #000000;">)
  23. </span><span style="color: #008080;">23</span> <span style="color: #000000;">            {
  24. </span><span style="color: #008080;">24</span>                 MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">请输入用户名</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  25. </span><span style="color: #008080;">25</span>                 <span style="color: #0000ff;">return</span><span style="color: #000000;">;
  26. </span><span style="color: #008080;">26</span> <span style="color: #000000;">            }
  27. </span><span style="color: #008080;">27</span>             <span style="color: #0000ff;">if</span> (passWord.Text.Length <= <span style="color: #800080;">0</span><span style="color: #000000;">)
  28. </span><span style="color: #008080;">28</span> <span style="color: #000000;">            {
  29. </span><span style="color: #008080;">29</span>                 MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">请输入密码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  30. </span><span style="color: #008080;">30</span>                 <span style="color: #0000ff;">return</span><span style="color: #000000;">;
  31. </span><span style="color: #008080;">31</span> <span style="color: #000000;">            }
  32. </span><span style="color: #008080;">32</span> 
  33. <span style="color: #008080;">33</span>             DataTable table = SqlHelper.ExecuteDataTable(<span style="color: #800000;">"</span><span style="color: #800000;">select * from T_User where username=@username;</span><span style="color: #800000;">"</span><span style="color: #000000;">, 
  34. </span><span style="color: #008080;">34</span>                 <span style="color: #0000ff;">new</span> SqlParameter(<span style="color: #800000;">"</span><span style="color: #800000;">@username</span><span style="color: #800000;">"</span><span style="color: #000000;">, userName.Text));
  35. </span><span style="color: #008080;">35</span>             <span style="color: #0000ff;">if</span> (table.Rows.Count <= <span style="color: #800080;">0</span><span style="color: #000000;">)
  36. </span><span style="color: #008080;">36</span> <span style="color: #000000;">            {
  37. </span><span style="color: #008080;">37</span>                 MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">用户名不存在</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  38. </span><span style="color: #008080;">38</span>                 <span style="color: #0000ff;">return</span><span style="color: #000000;">;
  39. </span><span style="color: #008080;">39</span> <span style="color: #000000;">            }
  40. </span><span style="color: #008080;">40</span>             <span style="color: #0000ff;">if</span> (table.Rows.Count > <span style="color: #800080;">1</span><span style="color: #000000;">)
  41. </span><span style="color: #008080;">41</span> <span style="color: #000000;">            {
  42. </span><span style="color: #008080;">42</span>                 MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">不好啦，用户名重复</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  43. </span><span style="color: #008080;">43</span>                 <span style="color: #0000ff;">return</span><span style="color: #000000;">;
  44. </span><span style="color: #008080;">44</span> <span style="color: #000000;">            }
  45. </span><span style="color: #008080;">45</span>             DataRow row = table.Rows[<span style="color: #800080;">0</span><span style="color: #000000;">];
  46. </span><span style="color: #008080;">46</span>             <span style="color: #0000ff;">string</span> dbPassword = (<span style="color: #0000ff;">string</span>)row[<span style="color: #800000;">"</span><span style="color: #800000;">Password</span><span style="color: #800000;">"</span><span style="color: #000000;">];
  47. </span><span style="color: #008080;">47</span>             <span style="color: #0000ff;">long</span> id = (<span style="color: #0000ff;">long</span>)row[<span style="color: #800000;">"</span><span style="color: #800000;">Id</span><span style="color: #800000;">"</span><span style="color: #000000;">];
  48. </span><span style="color: #008080;">48</span>             <span style="color: #0000ff;">int</span> errorTimes = (<span style="color: #0000ff;">int</span>)row[<span style="color: #800000;">"</span><span style="color: #800000;">ErrorTimes</span><span style="color: #800000;">"</span><span style="color: #000000;">];
  49. </span><span style="color: #008080;">49</span>             <span style="color: #0000ff;">if</span> (errorTimes >= <span style="color: #800080;">3</span><span style="color: #000000;">)
  50. </span><span style="color: #008080;">50</span> <span style="color: #000000;">            {
  51. </span><span style="color: #008080;">51</span>                 MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">输入次数过多，用户已经锁定</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  52. </span><span style="color: #008080;">52</span>                 <span style="color: #0000ff;">return</span><span style="color: #000000;">;
  53. </span><span style="color: #008080;">53</span> <span style="color: #000000;">            }
  54. </span><span style="color: #008080;">54</span>             <span style="color: #0000ff;">if</span> (passWord.Text !=<span style="color: #000000;"> dbPassword)
  55. </span><span style="color: #008080;">55</span> <span style="color: #000000;">            {
  56. </span><span style="color: #008080;">56</span>                 SqlHelper.ExecuteNonQuery(<span style="color: #800000;">"</span><span style="color: #800000;">update T_User set ErrorTimes=ErrorTimes+1 where Id=@Id</span><span style="color: #800000;">"</span><span style="color: #000000;">,
  57. </span><span style="color: #008080;">57</span>                     <span style="color: #0000ff;">new</span> SqlParameter(<span style="color: #800000;">"</span><span style="color: #800000;">@Id</span><span style="color: #800000;">"</span><span style="color: #000000;">, id));
  58. </span><span style="color: #008080;">58</span>                 MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">密码错误</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  59. </span><span style="color: #008080;">59</span> <span style="color: #000000;">            }
  60. </span><span style="color: #008080;">60</span>             <span style="color: #0000ff;">else</span>
  61. <span style="color: #008080;">61</span> <span style="color: #000000;">            {
  62. </span><span style="color: #008080;">62</span>                 MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">登陆成功</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  63. </span><span style="color: #008080;">63</span> <span style="color: #000000;">            }
  64. </span><span style="color: #008080;">64</span> <span style="color: #000000;">        }
  65. </span><span style="color: #008080;">65</span> <span style="color: #000000;">    }
  66. </span><span style="color: #008080;">66</span> }
View Code 技术分享 
  1. <span style="color: #008080;">  1</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> Adonet
  2. </span><span style="color: #008080;">  2</span> <span style="color: #000000;">{
  3. </span><span style="color: #008080;">  3</span>     <span style="color: #0000ff;">partial</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> LoginWindow
  4. </span><span style="color: #008080;">  4</span> <span style="color: #000000;">    {
  5. </span><span style="color: #008080;">  5</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  6. <span style="color: #008080;">  6</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 必需的设计器变量。
  7. </span><span style="color: #008080;">  7</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  8. <span style="color: #008080;">  8</span>         <span style="color: #0000ff;">private</span> System.ComponentModel.IContainer components = <span style="color: #0000ff;">null</span><span style="color: #000000;">;
  9. </span><span style="color: #008080;">  9</span> 
  10. <span style="color: #008080;"> 10</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  11. <span style="color: #008080;"> 11</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 清理所有正在使用的资源。
  12. </span><span style="color: #008080;"> 12</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  13. <span style="color: #008080;"> 13</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="disposing"></span><span style="color: #008000;">如果应释放托管资源，为 true；否则为 false。</span><span style="color: #808080;"></param></span>
  14. <span style="color: #008080;"> 14</span>         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">override</span> <span style="color: #0000ff;">void</span> Dispose(<span style="color: #0000ff;">bool</span><span style="color: #000000;"> disposing)
  15. </span><span style="color: #008080;"> 15</span> <span style="color: #000000;">        {
  16. </span><span style="color: #008080;"> 16</span>             <span style="color: #0000ff;">if</span> (disposing && (components != <span style="color: #0000ff;">null</span><span style="color: #000000;">))
  17. </span><span style="color: #008080;"> 17</span> <span style="color: #000000;">            {
  18. </span><span style="color: #008080;"> 18</span> <span style="color: #000000;">                components.Dispose();
  19. </span><span style="color: #008080;"> 19</span> <span style="color: #000000;">            }
  20. </span><span style="color: #008080;"> 20</span>             <span style="color: #0000ff;">base</span><span style="color: #000000;">.Dispose(disposing);
  21. </span><span style="color: #008080;"> 21</span> <span style="color: #000000;">        }
  22. </span><span style="color: #008080;"> 22</span> 
  23. <span style="color: #008080;"> 23</span>         <span style="color: #0000ff;">#region</span> Windows 窗体设计器生成的代码
  24. <span style="color: #008080;"> 24</span> 
  25. <span style="color: #008080;"> 25</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  26. <span style="color: #008080;"> 26</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 设计器支持所需的方法 - 不要
  27. </span><span style="color: #008080;"> 27</span>         <span style="color: #808080;">///</span><span style="color: #008000;"> 使用代码编辑器修改此方法的内容。
  28. </span><span style="color: #008080;"> 28</span>         <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  29. <span style="color: #008080;"> 29</span>         <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> InitializeComponent()
  30. </span><span style="color: #008080;"> 30</span> <span style="color: #000000;">        {
  31. </span><span style="color: #008080;"> 31</span>             <span style="color: #0000ff;">this</span>.userName = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Windows.Forms.TextBox();
  32. </span><span style="color: #008080;"> 32</span>             <span style="color: #0000ff;">this</span>.label1 = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Windows.Forms.Label();
  33. </span><span style="color: #008080;"> 33</span>             <span style="color: #0000ff;">this</span>.label2 = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Windows.Forms.Label();
  34. </span><span style="color: #008080;"> 34</span>             <span style="color: #0000ff;">this</span>.passWord = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Windows.Forms.TextBox();
  35. </span><span style="color: #008080;"> 35</span>             <span style="color: #0000ff;">this</span>.btnLogin = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Windows.Forms.Button();
  36. </span><span style="color: #008080;"> 36</span>             <span style="color: #0000ff;">this</span><span style="color: #000000;">.SuspendLayout();
  37. </span><span style="color: #008080;"> 37</span>             <span style="color: #008000;">//</span> 
  38. <span style="color: #008080;"> 38</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> userName
  39. </span><span style="color: #008080;"> 39</span>             <span style="color: #008000;">//</span> 
  40. <span style="color: #008080;"> 40</span>             <span style="color: #0000ff;">this</span>.userName.Location = <span style="color: #0000ff;">new</span> System.Drawing.Point(<span style="color: #800080;">135</span>, <span style="color: #800080;">34</span><span style="color: #000000;">);
  41. </span><span style="color: #008080;"> 41</span>             <span style="color: #0000ff;">this</span>.userName.Name = <span style="color: #800000;">"</span><span style="color: #800000;">userName</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  42. </span><span style="color: #008080;"> 42</span>             <span style="color: #0000ff;">this</span>.userName.Size = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">100</span>, <span style="color: #800080;">21</span><span style="color: #000000;">);
  43. </span><span style="color: #008080;"> 43</span>             <span style="color: #0000ff;">this</span>.userName.TabIndex = <span style="color: #800080;">0</span><span style="color: #000000;">;
  44. </span><span style="color: #008080;"> 44</span>             <span style="color: #008000;">//</span> 
  45. <span style="color: #008080;"> 45</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> label1
  46. </span><span style="color: #008080;"> 46</span>             <span style="color: #008000;">//</span> 
  47. <span style="color: #008080;"> 47</span>             <span style="color: #0000ff;">this</span>.label1.AutoSize = <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  48. </span><span style="color: #008080;"> 48</span>             <span style="color: #0000ff;">this</span>.label1.Location = <span style="color: #0000ff;">new</span> System.Drawing.Point(<span style="color: #800080;">46</span>, <span style="color: #800080;">37</span><span style="color: #000000;">);
  49. </span><span style="color: #008080;"> 49</span>             <span style="color: #0000ff;">this</span>.label1.Name = <span style="color: #800000;">"</span><span style="color: #800000;">label1</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  50. </span><span style="color: #008080;"> 50</span>             <span style="color: #0000ff;">this</span>.label1.Size = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">41</span>, <span style="color: #800080;">12</span><span style="color: #000000;">);
  51. </span><span style="color: #008080;"> 51</span>             <span style="color: #0000ff;">this</span>.label1.TabIndex = <span style="color: #800080;">1</span><span style="color: #000000;">;
  52. </span><span style="color: #008080;"> 52</span>             <span style="color: #0000ff;">this</span>.label1.Text = <span style="color: #800000;">"</span><span style="color: #800000;">用户名</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  53. </span><span style="color: #008080;"> 53</span>             <span style="color: #008000;">//</span> 
  54. <span style="color: #008080;"> 54</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> label2
  55. </span><span style="color: #008080;"> 55</span>             <span style="color: #008000;">//</span> 
  56. <span style="color: #008080;"> 56</span>             <span style="color: #0000ff;">this</span>.label2.AutoSize = <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  57. </span><span style="color: #008080;"> 57</span>             <span style="color: #0000ff;">this</span>.label2.Location = <span style="color: #0000ff;">new</span> System.Drawing.Point(<span style="color: #800080;">58</span>, <span style="color: #800080;">104</span><span style="color: #000000;">);
  58. </span><span style="color: #008080;"> 58</span>             <span style="color: #0000ff;">this</span>.label2.Name = <span style="color: #800000;">"</span><span style="color: #800000;">label2</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  59. </span><span style="color: #008080;"> 59</span>             <span style="color: #0000ff;">this</span>.label2.Size = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">29</span>, <span style="color: #800080;">12</span><span style="color: #000000;">);
  60. </span><span style="color: #008080;"> 60</span>             <span style="color: #0000ff;">this</span>.label2.TabIndex = <span style="color: #800080;">2</span><span style="color: #000000;">;
  61. </span><span style="color: #008080;"> 61</span>             <span style="color: #0000ff;">this</span>.label2.Text = <span style="color: #800000;">"</span><span style="color: #800000;">密码</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  62. </span><span style="color: #008080;"> 62</span>             <span style="color: #008000;">//</span> 
  63. <span style="color: #008080;"> 63</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> passWord
  64. </span><span style="color: #008080;"> 64</span>             <span style="color: #008000;">//</span> 
  65. <span style="color: #008080;"> 65</span>             <span style="color: #0000ff;">this</span>.passWord.Location = <span style="color: #0000ff;">new</span> System.Drawing.Point(<span style="color: #800080;">135</span>, <span style="color: #800080;">101</span><span style="color: #000000;">);
  66. </span><span style="color: #008080;"> 66</span>             <span style="color: #0000ff;">this</span>.passWord.Name = <span style="color: #800000;">"</span><span style="color: #800000;">passWord</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  67. </span><span style="color: #008080;"> 67</span>             <span style="color: #0000ff;">this</span>.passWord.Size = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">100</span>, <span style="color: #800080;">21</span><span style="color: #000000;">);
  68. </span><span style="color: #008080;"> 68</span>             <span style="color: #0000ff;">this</span>.passWord.TabIndex = <span style="color: #800080;">3</span><span style="color: #000000;">;
  69. </span><span style="color: #008080;"> 69</span>             <span style="color: #008000;">//</span> 
  70. <span style="color: #008080;"> 70</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> btnLogin
  71. </span><span style="color: #008080;"> 71</span>             <span style="color: #008000;">//</span> 
  72. <span style="color: #008080;"> 72</span>             <span style="color: #0000ff;">this</span>.btnLogin.Location = <span style="color: #0000ff;">new</span> System.Drawing.Point(<span style="color: #800080;">88</span>, <span style="color: #800080;">161</span><span style="color: #000000;">);
  73. </span><span style="color: #008080;"> 73</span>             <span style="color: #0000ff;">this</span>.btnLogin.Name = <span style="color: #800000;">"</span><span style="color: #800000;">btnLogin</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  74. </span><span style="color: #008080;"> 74</span>             <span style="color: #0000ff;">this</span>.btnLogin.Size = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">75</span>, <span style="color: #800080;">23</span><span style="color: #000000;">);
  75. </span><span style="color: #008080;"> 75</span>             <span style="color: #0000ff;">this</span>.btnLogin.TabIndex = <span style="color: #800080;">4</span><span style="color: #000000;">;
  76. </span><span style="color: #008080;"> 76</span>             <span style="color: #0000ff;">this</span>.btnLogin.Text = <span style="color: #800000;">"</span><span style="color: #800000;">登录</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  77. </span><span style="color: #008080;"> 77</span>             <span style="color: #0000ff;">this</span>.btnLogin.UseVisualStyleBackColor = <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  78. </span><span style="color: #008080;"> 78</span>             <span style="color: #0000ff;">this</span>.btnLogin.Click += <span style="color: #0000ff;">new</span> System.EventHandler(<span style="color: #0000ff;">this</span><span style="color: #000000;">.btnLogin_Click);
  79. </span><span style="color: #008080;"> 79</span>             <span style="color: #008000;">//</span> 
  80. <span style="color: #008080;"> 80</span>             <span style="color: #008000;">//</span><span style="color: #008000;"> LoginWindow
  81. </span><span style="color: #008080;"> 81</span>             <span style="color: #008000;">//</span> 
  82. <span style="color: #008080;"> 82</span>             <span style="color: #0000ff;">this</span>.AutoScaleDimensions = <span style="color: #0000ff;">new</span><span style="color: #000000;"> System.Drawing.SizeF(6F, 12F);
  83. </span><span style="color: #008080;"> 83</span>             <span style="color: #0000ff;">this</span>.AutoScaleMode =<span style="color: #000000;"> System.Windows.Forms.AutoScaleMode.Font;
  84. </span><span style="color: #008080;"> 84</span>             <span style="color: #0000ff;">this</span>.ClientSize = <span style="color: #0000ff;">new</span> System.Drawing.Size(<span style="color: #800080;">284</span>, <span style="color: #800080;">261</span><span style="color: #000000;">);
  85. </span><span style="color: #008080;"> 85</span>             <span style="color: #0000ff;">this</span>.Controls.Add(<span style="color: #0000ff;">this</span><span style="color: #000000;">.btnLogin);
  86. </span><span style="color: #008080;"> 86</span>             <span style="color: #0000ff;">this</span>.Controls.Add(<span style="color: #0000ff;">this</span><span style="color: #000000;">.passWord);
  87. </span><span style="color: #008080;"> 87</span>             <span style="color: #0000ff;">this</span>.Controls.Add(<span style="color: #0000ff;">this</span><span style="color: #000000;">.label2);
  88. </span><span style="color: #008080;"> 88</span>             <span style="color: #0000ff;">this</span>.Controls.Add(<span style="color: #0000ff;">this</span><span style="color: #000000;">.label1);
  89. </span><span style="color: #008080;"> 89</span>             <span style="color: #0000ff;">this</span>.Controls.Add(<span style="color: #0000ff;">this</span><span style="color: #000000;">.userName);
  90. </span><span style="color: #008080;"> 90</span>             <span style="color: #0000ff;">this</span>.Name = <span style="color: #800000;">"</span><span style="color: #800000;">LoginWindow</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  91. </span><span style="color: #008080;"> 91</span>             <span style="color: #0000ff;">this</span>.Text = <span style="color: #800000;">"</span><span style="color: #800000;">LoginWindow</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  92. </span><span style="color: #008080;"> 92</span>             <span style="color: #0000ff;">this</span>.ResumeLayout(<span style="color: #0000ff;">false</span><span style="color: #000000;">);
  93. </span><span style="color: #008080;"> 93</span>             <span style="color: #0000ff;">this</span><span style="color: #000000;">.PerformLayout();
  94. </span><span style="color: #008080;"> 94</span> 
  95. <span style="color: #008080;"> 95</span> <span style="color: #000000;">        }
  96. </span><span style="color: #008080;"> 96</span> 
  97. <span style="color: #008080;"> 97</span>         <span style="color: #0000ff;">#endregion</span>
  98. <span style="color: #008080;"> 98</span> 
  99. <span style="color: #008080;"> 99</span>         <span style="color: #0000ff;">private</span><span style="color: #000000;"> System.Windows.Forms.TextBox userName;
  100. </span><span style="color: #008080;">100</span>         <span style="color: #0000ff;">private</span><span style="color: #000000;"> System.Windows.Forms.Label label1;
  101. </span><span style="color: #008080;">101</span>         <span style="color: #0000ff;">private</span><span style="color: #000000;"> System.Windows.Forms.Label label2;
  102. </span><span style="color: #008080;">102</span>         <span style="color: #0000ff;">private</span><span style="color: #000000;"> System.Windows.Forms.TextBox passWord;
  103. </span><span style="color: #008080;">103</span>         <span style="color: #0000ff;">private</span><span style="color: #000000;"> System.Windows.Forms.Button btnLogin;
  104. </span><span style="color: #008080;">104</span> <span style="color: #000000;">    }
  105. </span><span style="color: #008080;">105</span> }
View Code 技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.ComponentModel;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data;
  5. </span><span style="color: #008080;"> 5</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Drawing;
  6. </span><span style="color: #008080;"> 6</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Text;
  8. </span><span style="color: #008080;"> 8</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Windows.Forms;
  9. </span><span style="color: #008080;"> 9</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data.SqlClient;
  10. </span><span style="color: #008080;">10</span> 
  11. <span style="color: #008080;">11</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> Adonet
  12. </span><span style="color: #008080;">12</span> <span style="color: #000000;">{
  13. </span><span style="color: #008080;">13</span>     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">partial</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> CitySelectWindow : Form
  14. </span><span style="color: #008080;">14</span> <span style="color: #000000;">    {
  15. </span><span style="color: #008080;">15</span>         <span style="color: #0000ff;">public</span><span style="color: #000000;"> CitySelectWindow()
  16. </span><span style="color: #008080;">16</span> <span style="color: #000000;">        {
  17. </span><span style="color: #008080;">17</span> <span style="color: #000000;">            InitializeComponent();
  18. </span><span style="color: #008080;">18</span> <span style="color: #000000;">        }
  19. </span><span style="color: #008080;">19</span> 
  20. <span style="color: #008080;">20</span>         Dictionary<<span style="color: #0000ff;">string</span>, <span style="color: #0000ff;">int</span>> dictProv = <span style="color: #0000ff;">new</span> Dictionary<<span style="color: #0000ff;">string</span>, <span style="color: #0000ff;">int</span>><span style="color: #000000;">();
  21. </span><span style="color: #008080;">21</span>         <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> CitySelectWindow_Load(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e)
  22. </span><span style="color: #008080;">22</span> <span style="color: #000000;">        {
  23. </span><span style="color: #008080;">23</span>             DataTable dtProv = SqlHelper.ExecuteDataTable(<span style="color: #800000;">"</span><span style="color: #800000;">select * from AreaFull where AreaPid=0</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  24. </span><span style="color: #008080;">24</span>             <span style="color: #008000;">//</span><span style="color: #008000;">List<Area> listProv = new List<Area>();
  25. </span><span style="color: #008080;">25</span>             <span style="color: #008000;">//</span><span style="color: #008000;">Area area = new Area();</span>
  26. <span style="color: #008080;">26</span>             <span style="color: #0000ff;">foreach</span> (DataRow row <span style="color: #0000ff;">in</span><span style="color: #000000;"> dtProv.Rows)
  27. </span><span style="color: #008080;">27</span> <span style="color: #000000;">            {
  28. </span><span style="color: #008080;">28</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">area.AreaId = (int)row["AreaId"];
  29. </span><span style="color: #008080;">29</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">area.AreaName = (string)row["AreaName"];
  30. </span><span style="color:                    </div>
  31.                   
  32.  
  33.                     <div class=" "="">
  34.                         <ul class="m-news-opt fix">
  35.                             <li class="opt-item">
  36.                                 <a href="/sql_question-454054.html" target="_blank"><p>< 上一篇</p><p class="ellipsis">Sql Server 删除所有表</p></a>
  37.                             </li>
  38.                             <li class="opt-item ta-r">
  39.                                  <a href="/sql_question-454056.html" target="_blank"><p>下一篇 ></p><p class="ellipsis">Oracle11g安装详细步骤</p></a>
  40.                             </li>
  41.                         </ul>
  42.                     </span>

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！