cdefgabc811的博客

使用ADO.NET编写的手机销售系统 private void Order_Load(object sender, EventArgs e) { this.BackgroundImage = Image.FromFile("4.jpg"); SqlConnection cn = DBHelp.conn;//得到连接字符串 string sql = "select * from MobilePhone";//要执行的SQL语句 SqlCommand cmd = new SqlCommand(sql, cn); SqlDataReader sdr = null; try { cn.Open(); sdr = cmd.ExecuteReader();//得到sdr对象 while (sdr.Read()) { this.cboPhoneType.Items.Add(sdr["MobileModel"]);//将读取到的内容添加到手机型号下拉框中 } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sdr.Close(); cn.Close(); } string sql1 = "select * from Saler"; cmd = new SqlCommand(sql1, cn); try { cn.Open(); sdr = cmd.ExecuteReader(); while (sdr.Read()) { this.cboSaler.Items.Add(sdr["SaleName"]);//将读取到的内容添加到销售人员下拉框中 } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sdr.Close(); cn.Close(); } }

Using c # write typing games