{"id":28903,"date":"2024-11-25T13:51:17","date_gmt":"2024-11-25T05:51:17","guid":{"rendered":"https:\/\/fwq.ai\/blog\/28903\/"},"modified":"2024-11-25T13:51:17","modified_gmt":"2024-11-25T05:51:17","slug":"%e5%9f%ba%e4%ba%8ec%e5%ae%9e%e7%8e%b0%e7%ae%80%e5%8d%95%e7%9a%84%e9%9a%8f%e6%9c%ba%e6%8a%bd%e5%a5%96%e5%b0%8f%e7%a8%8b%e5%ba%8f%e5%ae%9e%e4%be%8b%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/28903\/","title":{"rendered":"\u57fa\u4e8eC#\u5b9e\u73b0\u7b80\u5355\u7684\u968f\u673a\u62bd\u5956\u5c0f\u7a0b\u5e8f\u5b9e\u4f8b\u4ee3\u7801"},"content":{"rendered":"<p>\u57fa\u4e8e\u662f\u5982\u4f55\u5b9e\u73b0\u7b80\u5355\u7684\u62bd\u5956\u7a0b\u5e8f\uff0c\u4e0b\u9762\u5c0f\u7f16\u7ed9\u5927\u5bb6\u5206\u4eab\u4e86\u5177\u4f53\u4ee3\u7801\uff0c\u6709\u9700\u8981\u7684\u670b\u53cb\u53c2\u8003\u4e0b<\/p>\n<p>\u5e9f\u8bdd\u4e0d\u591a\u8bf4\u4e86\uff0c\u76f4\u63a5\u7ed9\u5927\u5bb6\u8d34\u4ee3\u7801\u4e86\u3002\u5177\u4f53\u4ee3\u7801\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n<p><\/p>\n<pre>using&nbsp;System;\r\nusing&nbsp;System.Collections.Generic;\r\nusing&nbsp;System.ComponentModel;\r\nusing&nbsp;System.Data;\r\nusing&nbsp;System.Drawing;\r\nusing&nbsp;System.Linq;\r\nusing&nbsp;System.Text;\r\nusing&nbsp;System.Threading.Tasks;\r\nusing&nbsp;System.Windows.Forms;\r\nusing&nbsp;System.Data.SqlClient;\r\nnamespace&nbsp;ChouJiang\r\n{\r\n&nbsp;public&nbsp;partial&nbsp;class&nbsp;Form1&nbsp;:&nbsp;Form\r\n&nbsp;{\r\n&nbsp;public&nbsp;Form1()\r\n&nbsp;{\r\n&nbsp;InitializeComponent();\r\n&nbsp;}\r\nprivate&nbsp;void&nbsp;button1_Click(object&nbsp;sender,&nbsp;EventArgs&nbsp;e)\r\n&nbsp;{\r\n&nbsp;int&nbsp;number&nbsp;=&nbsp;Convert.ToInt32(textBox1.Text.ToString());\r\n&nbsp;string&nbsp;prize=comboBox1.Text.ToString();\r\n&nbsp;string&nbsp;conn&nbsp;=&nbsp;\"\";\r\n&nbsp;string&nbsp;sql&nbsp;=&nbsp;\"\";\r\n&nbsp;string&nbsp;s&nbsp;=&nbsp;\"\";\r\n&nbsp;conn&nbsp;=&nbsp;\"server=XTFLZ-PC;database=Xtf;uid=sa;pwd=123456\";\r\n&nbsp;sql&nbsp;=&nbsp;\"select&nbsp;*from&nbsp;Ticket\";\r\n&nbsp;SqlConnection&nbsp;myconn&nbsp;=&nbsp;new&nbsp;SqlConnection(conn);\r\n&nbsp;myconn.Open();\r\n&nbsp;SqlDataAdapter&nbsp;sda&nbsp;=&nbsp;new&nbsp;SqlDataAdapter(sql,myconn);\r\n&nbsp;DataSet&nbsp;ds=new&nbsp;DataSet();\r\n&nbsp;sda.Fill(ds,\"Ticket\");\r\n&nbsp;dataGridView11.DataSource&nbsp;=&nbsp;ds;\r\n&nbsp;dataGridView11.DataMember&nbsp;=&nbsp;\"Ticket\";\r\n&nbsp;Random&nbsp;rd&nbsp;=&nbsp;new&nbsp;Random();\r\n&nbsp;for&nbsp;(int&nbsp;i&nbsp;=&nbsp;0;&nbsp;i&nbsp;<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u4ee5\u4e0a\u5c31\u662f\u57fa\u4e8eC#\u5b9e\u73b0\u7b80\u5355\u7684\u968f\u673a\u62bd\u5956\u5c0f\u7a0b\u5e8f\u5b9e\u4f8b\u4ee3\u7801\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u57fa\u4e8e\u662f\u5982\u4f55\u5b9e\u73b0\u7b80\u5355\u7684\u62bd\u5956\u7a0b\u5e8f\uff0c\u4e0b\u9762\u5c0f\u7f16\u7ed9\u5927\u5bb6\u5206\u4eab\u4e86\u5177\u4f53\u4ee3\u7801\uff0c\u6709\u9700\u8981\u7684\u670b\u53cb\u53c2\u8003\u4e0b \u5e9f\u8bdd\u4e0d\u591a\u8bf4\u4e86\uff0c\u76f4\u63a5\u7ed9\u5927\u5bb6\u8d34\u4ee3\u7801\u4e86\u3002\u5177\u4f53\u4ee3\u7801\u5982\u4e0b\u6240\u793a\uff1a using&nbsp;System; using&nbsp;System.Collections.Generic; using&nbsp;System.ComponentModel; using&nbsp;System.Data; using&nbsp;System.Drawing; using&nbsp;System.Linq; using&nbsp;System.Text; using&nbsp;System.Threading.Tasks; using&nbsp;System.Windows.Forms; using&nbsp;System.Data.SqlClient; namespace&nbsp;ChouJiang { &nbsp;public&nbsp;partial&nbsp;class&nbsp;Form1&nbsp;:&nbsp;Form &nbsp;{ &nbsp;public&nbsp;Form1() &nbsp;{ &nbsp;InitializeComponent(); &nbsp;} private&nbsp;void&nbsp;button1_Click(object&nbsp;sender,&nbsp;EventArgs&nbsp;e) &nbsp;{ &nbsp;int&nbsp;number&nbsp;=&nbsp;Convert.ToInt32(textBox1.Text.ToString()); &nbsp;string&nbsp;prize=comboBox1.Text.ToString(); &nbsp;string&nbsp;conn&nbsp;=&nbsp;&#8220;&#8221;; &nbsp;string&nbsp;sql&nbsp;=&nbsp;&#8220;&#8221;; &nbsp;string&nbsp;s&nbsp;=&nbsp;&#8220;&#8221;; &nbsp;conn&nbsp;=&nbsp;&#8220;server=XTFLZ-PC;database=Xtf;uid=sa;pwd=123456&#8221;; &nbsp;sql&nbsp;=&nbsp;&#8220;select&nbsp;*from&nbsp;Ticket&#8221;; &nbsp;SqlConnection&nbsp;myconn&nbsp;=&nbsp;new&nbsp;SqlConnection(conn); &nbsp;myconn.Open(); &nbsp;SqlDataAdapter&nbsp;sda&nbsp;=&nbsp;new&nbsp;SqlDataAdapter(sql,myconn); &nbsp;DataSet&nbsp;ds=new&nbsp;DataSet(); &nbsp;sda.Fill(ds,&#8221;Ticket&#8221;); &nbsp;dataGridView11.DataSource&nbsp;=&nbsp;ds; &nbsp;dataGridView11.DataMember&nbsp;=&nbsp;&#8220;Ticket&#8221;; &nbsp;Random&nbsp;rd&nbsp;=&nbsp;new&nbsp;Random(); &nbsp;for&nbsp;(int&nbsp;i&nbsp;=&nbsp;0;&nbsp;i&nbsp; \u767b\u5f55\u540e\u590d\u5236 \u4ee5\u4e0a\u5c31\u662f\u57fa\u4e8eC#\u5b9e\u73b0\u7b80\u5355\u7684\u968f\u673a\u62bd\u5956\u5c0f\u7a0b\u5e8f\u5b9e\u4f8b\u4ee3\u7801\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-28903","post","type-post","status-publish","format-standard","hentry","category-19"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=28903"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28903\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=28903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=28903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=28903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}