怎么连续执行SQL语句
string ConnStr;
ConnStr = PortalSettings.ConnectionString+Server.MapPath(PortalSettings.DataPath);
string sql;
OleDbConnection conn = new OleDbConnection(ConnStr);
conn.Open();
sql = "select caption from CateList where caption ='" + OfficeName.Text + "'";
OleDbCommand cmd = new OleDbCommand(sql,conn);
OleDbDataReader reader = cmd.ExecuteReader();
if(reader.Read())
{
conn.Dispose();
cmd.Dispose();
reader.Close();
Msg.Visible = true;
//Msg.Text = OfficeName.Text;
Msg.Text = "该科室已存在";
}
else
{
sql = "insert into CateList caption Values ('" + OfficeName.Text + "')";
//执行到这句出错了,怎么办啊
cmd.ExecuteNonQuery();
Msg.Visible = true;
Msg.Text = "添加科室成功";
conn.Dispose();
cmd.Dispose();
reader.Close();
}