110,534
社区成员
发帖
与我相关
我的任务
分享
sqlconn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from TEMP_FLIGHT ", sqlconn);
object obj = cmd.ExecuteScalar();
if (Convert.ToInt32(obj) > 0)
{
DataSet ds = new DataSet();
SqlDataAdapter oda = new SqlDataAdapter("select * from TEMP_FLIGHT", sqlconn);
ds.Clear();
oda.Fill(ds, "TEMP_FLIGHT");
sqlconn1.Open();
SqlCommand mcmd = sqlconn1.CreateCommand();
mcmd.CommandText = "delete from A_FLIGHT where ( select * from A_FLIGHT join "
+ ds.Tables["TEMP_FLIGHT"] + " on A_FLIGHT.FLIGHTID = " + ds.Tables["TEMP_FLIGHT"].Columns["FLIGHTID"].ToString() + ")" + " ";
mcmd.CommandText += "insert into A_FLIGHT select * from " + ds.Tables["TEMP_FLIGHT"];
mcmd.ExecuteNonQuery();
SqlDataAdapter mda = new SqlDataAdapter("select * from A_FLIGHT", sqlconn);
ds.Clear();
mda.Fill(ds, "A_FLIGHT");
SqlCommand ocmd = sqlconn.CreateCommand();
ocmd.CommandText = "drop table TEMP_FLIGHT_OLD" + " ";
ocmd.CommandText += "sp_ReName TEMP_FLIGHT , TEMP_FLIGHT_OLD" + " ";
ocmd.CommandText += "create table TEMP_FLIGHT select * from " + ds.Tables["A_FLIGHT"];
ocmd.ExecuteNonQuery();
MessageBox.Show("成功");