dr[2] = tb.Rows[i][1];
dr[3] = tb.Rows[i][2];
dr[4] = tb.Rows[i][3];
ds.Tables[0].Rows.Add(dr);
}
try
{
da.Update(ds);//执行插入操作
tran.Commit();//事务提交
Label1.Visible = true;
Label1.Text = "<script language=javascript>alert('数据导入成功！');location='Default.aspx';</script>";
}
catch
{
tran.Rollback();//事务回滚
Label1.Visible = true;
Label1.Text = "<script language=javascript>alert('数据导入失败！');location='Default.aspx';</script>";
}
finally
{
con.Close();//关闭数据库连接
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string sqlstr = "select * from Score";
OleDbConnection conn = CreateCon();
conn.Open();
OleDbCommand mycom = new OleDbCommand(sqlstr, conn);
OleDbDataReader dr = mycom.ExecuteReader();
dr.Read();
if (dr.HasRows)
