首页 > 代码库 > 2017-04-25数据库编程截图
2017-04-25数据库编程截图
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient;//连接数据 using System.Configuration; namespace ERPforms { public partial class Form1 : Form { //定义错误信息 string[] strMessage = new string[]{ "编号不能为空!","物料不能为空!","价格或输入格式不对!" }; public Form1() { InitializeComponent(); } private void textBox4_TextChanged(object sender, EventArgs e) { } private void label1_Click(object sender, EventArgs e) { } private void btnSave_Click(object sender, EventArgs e) { } private void textBox3_TextChanged(object sender, EventArgs e) { } private void textBox2_TextChanged(object sender, EventArgs e) { } private void textBox1_TextChanged(object sender, EventArgs e) { } //保存数据(新增物料) private void btmsave_Click(object sender, EventArgs e) { if (Validation() != -1) MessageBox.Show(strMessage[Validation()]); else { AddItems(); } } //添加物料信息 private void AddItems() { //连接数据库 string connString = ConfigurationManager.ConnectionStrings["connString"].ToString(); SqlConnection conn = new SqlConnection(connString);//实例化连接对象 string sql = "insert into Items values(‘" + txtNo.Text + "‘," + "‘" + txtName.Text + "‘,‘" + txtAge.Text + "‘," + txtPlace.Text + ")"; //数据库操作 conn.Open();//打开连接 try { SqlCommand cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { conn.Close(); } } //数据验证 private int Validation() { int price = 0; int status = -1; if (txtNo.Text == "")//验证编号 status = 0; else if (txtName.Text == "") status = 1; else if (txtAge.Text == "" && int.TryParse(txtAge.Text, out price)) status = 2; return status; } } }
全选在粘贴代码进去
<?xml version="1.0" encoding="utf-8" ?> <configuration> <connectionStrings> <add name="connString" connectionString="Data Source=.; Initial Catalog=ErpDb;Integrated Security=True"/> </connectionStrings> </configuration>
2017-04-25数据库编程截图
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。