C#连接SQLServer数据库操作教程

 public void CreatSQL()
        {
            SqlConnection conn = new SqlConnection(@"server=.;database=AccurePro;uid=sa;pwd=123");
            String tableNameStr = "select count(1) from sysobjects  where name = 'Production' ";
            conn.Open();
            SqlCommand cmd1 = new SqlCommand(tableNameStr, conn);
            int result = Convert.ToInt32(cmd1.ExecuteScalar());
            if (result == 0)
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
                string ConnectionString = "server=.;database=AccurePro;uid=sa;pwd=123";
                conn.ConnectionString = ConnectionString;
                conn.Open();
                string sql = "CREATE TABLE Production" + "(工号 INTEGER CONSTRAINT PKeyMyId PRIMARY KEY," + "生产单号 INT, 客户名 CHAR(20), 门幅 CHAR(20),材质 CHAR(20),楞型 CHAR(20),订单数 INT,长度 FLOAT,剖宽 FLOAT,压线1 CHAR(20),压线2 CHAR(20),压线3 CHAR(20),压线4 CHAR(20),压线5 CHAR(20),剖数 FLOAT,备注 CHAR(20),订单总长 FLOAT,线型 CHAR(20),修边 CHAR(20),修边类型 CHAR(20),捆张 FLOAT,最高限速 CHAR(20),预计耗时 CHAR(20),完成时间 CHAR(20))";
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
            }
        }

        public void Initialize()
        {
            string connstr = @"server=.;database=AccurePro;integrated security=true;";
            SqlConnection conn = new SqlConnection(connstr);
            try
            {
                conn.Open();
            }
            catch
            {

                MessageBox.Show("数据库连接异常！");
                return;
            }
        }

        public void AddSQL()
        {
            SqlConnection conn = new SqlConnection(@"server=.;database=AccurePro;uid=sa;pwd=123");
            string s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16, s17, s18, s19, s20, s21, s22, s23, s24;
            SqlCommand insertcmd = new SqlCommand("insert into Production(工号, 生产单号, 客户名, 门幅, 材质, 楞型, 订单数, 长度, 剖宽, 压线1, 压线2, 压线3, 压线4, 压线5, 剖数, 备注, 订单总长, 线型, 修边, 修边类型, 捆张, 最高限速, 预计耗时, 完成时间) values (@s1,@s2,@s3,@s4,@s5,@s6,@s7,@s8,@s9,@s10,@s11,@s12,@s13,@s14,@s15,@s16,@s17,@s18,@s19,@s20,@s21,@s22,@s23,@s24 )", conn);
            insertcmd.Parameters.Add("@s1", SqlDbType.Int, 20);//工号
            insertcmd.Parameters.Add("@s2", SqlDbType.Int, 20);//生产单号
            insertcmd.Parameters.Add("@s3", SqlDbType.Char, 20);//客户名
            insertcmd.Parameters.Add("@s4", SqlDbType.Char, 20);//门幅
            insertcmd.Parameters.Add("@s5", SqlDbType.Char, 20);//材质
            insertcmd.Parameters.Add("@s6", SqlDbType.Char, 20);//楞型
            insertcmd.Parameters.Add("@s7", SqlDbType.Int, 20);//订单数
            insertcmd.Parameters.Add("@s8", SqlDbType.Float, 20);//长度
            insertcmd.Parameters.Add("@s9", SqlDbType.Float, 20);//剖宽
            insertcmd.Parameters.Add("@s10", SqlDbType.Char, 20);//压线1
            insertcmd.Parameters.Add("@s11", SqlDbType.Char, 20);//压线2
            insertcmd.Parameters.Add("@s12", SqlDbType.Char, 20);//压线3
            insertcmd.Parameters.Add("@s13", SqlDbType.Char, 20);//压线4
            insertcmd.Parameters.Add("@s14", SqlDbType.Char, 20);//压线5
            insertcmd.Parameters.Add("@s15", SqlDbType.Float, 20);//剖数
            insertcmd.Parameters.Add("@s16", SqlDbType.Char, 20);//备注
            insertcmd.Parameters.Add("@s17", SqlDbType.Float, 20);//订单总长
            insertcmd.Parameters.Add("@s18", SqlDbType.Char, 20);//线型
            insertcmd.Parameters.Add("@s19", SqlDbType.Char, 20);//修边
            insertcmd.Parameters.Add("@s20", SqlDbType.Char, 20);//修边类型