OleDbConnection con2 = new OleDbConnection("Provider=SQLOLEDB.1.Persist Security Info=False; integrated security=sspi;Initial Catalog=JK_DATA;Data Source=WWW-12E7BEEA209");
            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=D:\\配件格式(车).xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");//Oledb 连接字符串
            con2.Open();
            con.Open();
            OleDbCommand com = new OleDbCommand("select Code,名称,规格型号,计量单位,数量,含税总价 from [Sheet1$] where Code<>'#N/A'", con);
            OleDbDataReader der2 = com.ExecuteReader(CommandBehavior.CloseConnection);
            while (der2.Read())
            {
                OleDbCommand com_2 = new OleDbCommand("select count(*) from [Sheet1$] where Code='" + der2["Code"] + "'", con);
                OleDbDataReader O_der = com_2.ExecuteReader(CommandBehavior.CloseConnection);
                O_der.Read();
                int Count = O_der.GetInt32(0);
                if (Count > 8 || Count == 8)
                {
                    //MessageBox.Show(Count.ToString(),"1");
                    OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
                    com4.ExecuteNonQuery();
                    i++;                }
                else
                {
                    //MessageBox.Show(Count.ToString(), "2");
                    OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
                    com4.ExecuteNonQuery();
                    i++;
                }
            }
            MessageBox.Show("GOOD ok");
            con.Close();
            con2.Close();

解决方案 »

  1.   


        //using System .Data .OleDb ;
        public partial class Form1 : Form
        {
                  
        }
        class sqlconnect
        {
            
            private void opensql ()
            {
                OleDbConnection con2 = new OleDbConnection("Provider=SQLOLEDB.1.Persist Security Info=False; integrated security=sspi;Initial Catalog=JK_DATA;Data Source=WWW-12E7BEEA209"); 
                OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=D:\\配件格式(车).xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");//Oledb 连接字符串 
                con2.Open(); 
                con.Open(); 
                OleDbCommand com = new OleDbCommand("select Code,名称,规格型号,计量单位,数量,含税总价 from [Sheet1$] where Code <>'#N/A'", con); 
                OleDbDataReader der2 = com.ExecuteReader(CommandBehavior.CloseConnection); 
                while (der2.Read()) 
                { 
                    OleDbCommand com_2 = new OleDbCommand("select count(*) from [Sheet1$] where Code='" + der2["Code"] + "'", con); 
                    OleDbDataReader O_der = com_2.ExecuteReader(CommandBehavior.CloseConnection); 
                    O_der.Read(); 
                    int Count = O_der.GetInt32(0); 
                    if (Count > 8  || Count == 8) 
                    { 
                        //MessageBox.Show(Count.ToString(),"1"); 
                        OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2); 
                        com4.ExecuteNonQuery(); 
                        i++;                 } 
                    else 
                    { 
                        //MessageBox.Show(Count.ToString(), "2"); 
                        OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2); 
                        com4.ExecuteNonQuery(); 
                        i++; 
                    } 
                } 
                MessageBox.Show("GOOD ok"); 
                con.Close(); 
                con2.Close();
            }    }