将数据集值插入sql表 [英] inserting dataset value to sql table

问题描述

嗨..
我有一个DataSet ds，我正在使用此数据集的值插入另一个sql表....

Hi..
i have a DataSet ds, i am inserting values of dataset to another sql table using this....

foreach (DataRow dr in ds.Tables[0].Rows)
       {
cmdSql = new SqlCommand();
cmdSql.CommandText = "insert into Test(Country,Capital,Currency) Values('" + dr.ItemArray[0].ToString() + "','" + dr.ItemArray[1].ToString() + "','" + dr.ItemArray[2].ToString() + "')";
            cmdSql.Connection = con;
            cmdSql.ExecuteNonQuery();

}
我不能按如下所示编写此代码....???它给我错误

}
cant i write this code as shown below....???it gives me error

DataTable dt = new DataTable();
       dt = ds.Tables[0];
       cmdSql = new SqlCommand();
       cmdSql.CommandText = "insert into Test(Country,Capital,Currency) select Country,Capital,Currency from dt ";
       cmdSql.Connection = con;
       cmdSql.ExecuteNonQuery();

推荐答案

不能按如下所示编写此代码.... ???

不，您不能这样写.

如果dt是DB中的物理表，则可以编写.

但是它是数据表，并且已与数据库断开连接，因此您不能这样写.

cant i write this code as shown below....???

No- You can not write like that.

If dt is a physical table inside DB then you can write.

But it is datatable and disconnected from DB, So you cant write like that.

这篇关于将数据集值插入sql表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！