2017-04-25数据库编程截图
时间：2021-07-01 10:21:17
帮助过：14人阅读
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数据库编程截图
标签：信息 XML [] box cmd div sql generic txt
