private
void
Save11()
{
SqlConnection connection = OpenSql();
connection.Open();
SqlTransaction tran = connection.BeginTransaction();
try
{
for
(
int
i = 0; i <= (dataGridView1.Rows.Count) - 2; i++)
{
string
sql1 =
string
.Format(
"insert into sqltest ( Name) values('{0}')"
, dataGridView1[1, i].Value);
SqlCommand command =
new
SqlCommand(sql1, connection);
command.Transaction = tran;
command.ExecuteNonQuery();
}
tran.Commit();
}
catch
(Exception ex)
{
MessageBox.Show(ex.Message,
"保存失败"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
tran.Rollback();
//有错就回滚
}
finally
{
connection.Close(); connection.Dispose();
}
}