62,050
社区成员
发帖
与我相关
我的任务
分享
SqlConnection con = new SqlConnection(connectionString);//连接数据库
con.Open();
SqlTransaction trans = con.BeginTransaction();//事物对象
try
{
SqlCommand com = new SqlCommand();//数据操作对象
com.Connection = con;//指定连接
com.Transaction = trans;//指定事物
string sql = "";
for (int ii = 1; ii < table.Rows.Count; ii++)
{ //对datatable循环
sql = "INSERT INTO [users]([usersID],[usersName],[usersAddress],[usersBirthdate],[usersGender])values ('" + table.Rows[ii]["编号"].ToString() + "','" + table.Rows[ii]["姓名"].ToString() + "','" + table.Rows[ii]["家庭住址"].ToString() + "','" + table.Rows[ii]["生日"].ToString() + "','" + table.Rows[ii]["性别"].ToString() + "')";//某一行的数据
com.CommandText = sql;
com.ExecuteNonQuery();//执行该行
}
trans.Commit();//如果全部执行完毕.提交
}
catch
{
trans.Rollback();//如果有异常.回滚.
}
finally
{ con.Close();//关闭连接
}
[/quote]正解。
SqlConnection con = new SqlConnection(connectionString);//连接数据库
con.Open();
SqlTransaction trans = con.BeginTransaction();//事物对象
try
{
SqlCommand com = new SqlCommand();//数据操作对象
com.Connection = con;//指定连接
com.Transaction = trans;//指定事物
string sql = "";
for (int ii = 1; ii < table.Rows.Count; ii++)
{ //对datatable循环
sql = "INSERT INTO [users]([usersID],[usersName],[usersAddress],[usersBirthdate],[usersGender])values ('" + table.Rows[ii]["编号"].ToString() + "','" + table.Rows[ii]["姓名"].ToString() + "','" + table.Rows[ii]["家庭住址"].ToString() + "','" + table.Rows[ii]["生日"].ToString() + "','" + table.Rows[ii]["性别"].ToString() + "')";//某一行的数据
com.CommandText = sql;
com.ExecuteNonQuery();//执行该行
}
trans.Commit();//如果全部执行完毕.提交
}
catch
{
trans.Rollback();//如果有异常.回滚.
}
finally
{ con.Close();//关闭连接
}
select * from tablename
var dt=new DataTable();
for int i=0 i<dt.rows.count i++
{
string sql="insert into xxoo values('"+dt.rows[i][0].tostring()+"','')"
exec(sql)
}
这是常规方法.还有一种SqlBulkCopy
http://technet.microsoft.com/zh-cn/magazine/09esk03d(VS.100).aspx