我点击一个按钮,执行如下代码,为什么能点击多次,可以多次select into 临时表 吗?
在查询分析器里只能执行一次select into 临时表。为什么在这里能执行多次?SqlCommand cmd3 = new SqlCommand("select Field_Value from I_defaultvalue where Table_Name='SYSTEM' and Table_Field='CUT_CUSTOM_ORDER_RECORD'", con);
string Field_Value=cmd3.ExecuteScalar().ToString();
if (Field_Value=="0") {
SqlCommand cmd4 = new SqlCommand("select WRPROD,WRTOOL into tbb from I_CustomOrder group by WRPROD,WRTOOL", con);
cmd3.ExecuteReader();
}
else
{
SqlCommand cmd5 = new SqlCommand("select top Field_Value WRPROD,WRTOOL into tbb from I_CustomOrder group by WRPROD,WRTOOL", con);
cmd3.ExecuteReader();
}
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;namespace APS.tongbudata
{
/// <summary>
/// tongbu 的摘要描述。
/// </summary>
public class tongbu : System.Web.UI.Page
{
protected System.Web.UI.WebControls.ImageButton Tcustomer;
protected System.Web.UI.WebControls.ImageButton Tmujudunji;
protected System.Web.UI.WebControls.ImageButton Tzhipin;
protected System.Web.UI.WebControls.ImageButton Tzhipinzhicheng;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.ImageButton Tbaochan;
private void Page_Load(object sender, System.EventArgs e)
{
// 在這裡放置使用者程式碼以初始化網頁
} #region Web Form 設計工具產生的程式碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 此為 ASP.NET Web Form 設計工具所需的呼叫。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 此為設計工具支援所必須的方法 - 請勿使用程式碼編輯器修改
/// 這個方法的內容。
/// </summary>
private void InitializeComponent()
{
this.Tcustomer.Click += new System.Web.UI.ImageClickEventHandler(this.Tcustomer_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void Tcustomer_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
SqlConnection con=new SqlConnection(ConfigurationSettings.AppSettings["cnn"]);
con.Open();
string sq1l = "select count(Field_Value) from I_defaultvalue where Table_Name='SYSTEM' and Table_Field='SYSTEM_INIT_SETUP' and Field_Value='T' ";
SqlCommand cmd1 = new SqlCommand(sq1l, con); //檢測是否初始化 string sq12 = "select count(WRFAC) from I_CustomOrder where WRFAC in ( select WRFAC from I_defaultvalue where Table_Name='SYSTEM' and Table_Field='CUSTOMER_CODE') ";
SqlCommand cmd2 = new SqlCommand(sq12, con); //檢測是否有資料
if((int)cmd1.ExecuteScalar()<= 0)
{
Response.Write("<script language=javascript>alert('系統沒初始化,點此返回!')</script>"); return;
} if((int)cmd2.ExecuteScalar()<= 0)
{
Response.Write("<script language=javascript>alert('本廠ID沒有相關資料,點此返回')</script>"); return;
}
//取得唯一產品編號
SqlCommand cmd3 = new SqlCommand("select Field_Value from I_defaultvalue where Table_Name='SYSTEM' and Table_Field='CUT_CUSTOM_ORDER_RECORD'", con);
string Field_Value=cmd3.ExecuteScalar().ToString();
if (Field_Value=="0") {
SqlCommand cmd4 = new SqlCommand("select WRPROD,WRTOOL into tbb from I_CustomOrder group by WRPROD,WRTOOL", con);
cmd3.ExecuteReader();
}
else
{
SqlCommand cmd5 = new SqlCommand("select top Field_Value WRPROD,WRTOOL into tbb from I_CustomOrder group by WRPROD,WRTOOL", con);
cmd3.ExecuteReader();
}
con.Close();
} }
}