编程序

     后面的分别改为txtname spec price

  双击保存 

    

    

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+"','"+txtSpec.Text+"',"+txtPrice.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 (txtPrice.Text == "" &&
                int.TryParse(txtPrice.Text, out price))
                status = 2;
            return status;

        }
    }
}