用C#读取XML文件，并导入到SqlServer

用C#读取XML文件，并导入到SqlServer

将用C#读取XML文件，并导入到SqlServer

private void btnInsert_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            ds.ReadXml(textBox1.Text);
             // dv.DataSource = ds.Tables[0];
            for(int i =0;i< ds.Tables[0].Rows.Count; i++)
            {
                string productId =  ds.Tables[0].Rows[i][0].ToString();
                string productName = ds.Tables[0].Rows[i][1].ToString();
                string supplierName = ds.Tables[0].Rows[i][2].ToString();
                string sql = @"INSERT INTO [dbo].[Products]
                                           ([ProductID]
                                           ,[ProductName]
                                           ,[SupplierName])
                                     VALUES
                                           (@ProductID,@ProductName,@SupplierName)";
                SqlParameter[] para = { new SqlParameter("@ProductID", productId),
                                        new SqlParameter("@ProductName", productName),
                                        new SqlParameter("@SupplierName",  supplierName)};
                DBHelperSQL.TableChange(sql, para);
            }
            myShow();
        };