用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();
};