药品管理系统 sql2008

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace WindowsFormsApp1
{
    public partial class adddrug : Form
    {
        public adddrug（）
        {
            InitializeComponent（）;
        }

        private void label1_Click（object sender EventArgs e）
        {

        }

        private void label4_Click（object sender EventArgs e）
        {

        }

        private void textBox1_TextChanged（object sender EventArgs e）
        {

        }

        private void button5_Click（object sender EventArgs e）
        {
            string a = textBox1.Text;
            string b = textBox2.Text;
            string c = textBox3.Text;
            string d = textBox4.Text;

            string coonString = “server =LENOVO-PC\SQLEXPRESS;database=denglu;uid=sa;pwd=123456“;
            //string coonString = “server=home-pc\SQLEXPRESS;Initial Catalog=System;Integrated Security=SSPI“;
            SqlConnection coon = new SqlConnection（coonString）;
            coon.Open（）;//打开连接   
            SqlCommand cmd = coon.CreateCommand（）;
            cmd.CommandText = “insert into medicine values （‘“+a+“‘‘“+b+“‘‘“+c+“‘‘“+d+“‘）“;
            cmd.ExecuteNonQuery（）;//执行sql   
            MessageBox.Show（“添加成功“）;
        }

        private void button1_Click（object sender EventArgs e）
        {
            this.Hide（）;
            Form3 form = new Form3（）;
            form.Show（）;
        }

        private void button2_Click（object sender EventArgs e）
        {
            
        }

        private void button3_Click（object sender EventArgs e）
        {
            this.Hide（）;
            deletedrug form = new deletedrug（）;
            form.Show（）;
        }

        private void button4_Click（object sender EventArgs e）
        {
            this.Hide（）;
            Form1 form = new Form1（）;
            form.Show（）;
        }

        private void button6_Click（object sender EventArgs e）
        {
            this.Hide（）;
            sale form = new sale（）;
            form.Show（）;
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件    3145728  2019-01-23 15:09  drugmanagedenglu.mdf

     文件    1048576  2019-01-23 15:09  drugmanagedenglu_log.ldf

     文件         40  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitCOMMIT_EDITMSG

     文件        770  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitconfig

     文件         73  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitdescription

     文件         23  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitHEAD

     文件        478  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githooksapplypatch-msg.sample

     文件        896  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githookscommit-msg.sample

     文件        189  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githookspost-update.sample

     文件        424  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githookspre-applypatch.sample

     文件       1642  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githookspre-commit.sample

     文件       1348  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githookspre-push.sample

     文件       4951  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githookspre-rebase.sample

     文件        544  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githookspre-receive.sample

     文件       1239  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githooksprepare-commit-msg.sample

     文件       3610  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.githooksupdate.sample

     文件        225  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitindex

     文件        240  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitinfoexclude

     文件        181  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitlogsHEAD

     文件        181  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitlogs
efsheadsmaster

     文件        751  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitobjects1ff0c423042b46cb1d617b81efb715defbe8054d

     文件       2112  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitobjects3c4efe206bd0e7230ad0ae8396a3c883c8207906

     文件        156  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitobjects5a3627e4aac1c6e15887b8fa4dcd42cfba08cd33

     文件         89  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitobjects91e3470e1645e6e8d0de6fe9f6b242f366e9a393

     文件         41  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.git
efsheadsmaster

     文件       2581  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitattributes

     文件       4565  2019-01-18 10:41  drugmanagemanageWindowsFormsApp1.gitignore

     文件      85645  2017-09-16 14:22  drugmanagemanageWindowsFormsApp1.vsconfigapplicationhost.config

    ..A..H.    133120  2019-01-23 15:11  drugmanagemanageWindowsFormsApp1.vsWindowsFormsApp1v15.suo

     文件     856064  2019-01-23 14:25  drugmanagemanageWindowsFormsApp1.vsWindowsFormsApp1v15sqlite3storage.ide

............此处省略202个文件信息