Dim TaskInfoConn As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("TaskInfo_Database"))
Dim TaskComm As New SqlCommand("P_Task_Insert", TaskInfoConn)
TaskComm.CommandType = CommandType.StoredProcedure
Dim para As SqlParameter '传回参数
para = TaskComm.Parameters.Add("@_SerialNo", SqlDbType.Int)
para.Direction = ParameterDirection.ReturnValue
para = TaskComm.Parameters.Add("@_ID", SqlDbType.VarChar)
para.Value = pub.IsNull(Me.Taskid.Text.Trim.ToString)
'
para = TaskComm.Parameters.Add("@_StartTime", SqlDbType.DateTime)
para.Value = System.Convert.ToDateTime(CDate(Me.TaskStartTime.Text.Trim.ToString).ToShortDateString)
'执行存储过程
Dim TaskReader As SqlDataReader
Try
If TaskInfoConn.State = ConnectionState.Closed Then TaskInfoConn.Open()
TaskReader = TaskComm.ExecuteReader
Session("_SerialNo") = TaskComm.Parameters("@_SerialNo").Value //得到 '传回参数
TaskReader.Close()
TaskInfoConn.Close()
Catch err As Exception
Session("Case_Error") = err.Message
Response.Redirect("../ErrorTimeOut.aspx")
End Try
Dim TaskComm As New SqlCommand("P_Task_Insert", TaskInfoConn)
TaskComm.CommandType = CommandType.StoredProcedure
Dim para As SqlParameter '传回参数
para = TaskComm.Parameters.Add("@_SerialNo", SqlDbType.Int)
para.Direction = ParameterDirection.ReturnValue
para = TaskComm.Parameters.Add("@_ID", SqlDbType.VarChar)
para.Value = pub.IsNull(Me.Taskid.Text.Trim.ToString)
'
para = TaskComm.Parameters.Add("@_StartTime", SqlDbType.DateTime)
para.Value = System.Convert.ToDateTime(CDate(Me.TaskStartTime.Text.Trim.ToString).ToShortDateString)
'执行存储过程
Dim TaskReader As SqlDataReader
Try
If TaskInfoConn.State = ConnectionState.Closed Then TaskInfoConn.Open()
TaskReader = TaskComm.ExecuteReader
Session("_SerialNo") = TaskComm.Parameters("@_SerialNo").Value //得到 '传回参数
TaskReader.Close()
TaskInfoConn.Close()
Catch err As Exception
Session("Case_Error") = err.Message
Response.Redirect("../ErrorTimeOut.aspx")
End Try
我的代码:
string conn=@"Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=..\db\txl.mdb;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
OleDbConnection cnn_txl=new OleDbConnection(conn);
int p_ssdd;
int p_zt;
OleDbCommand Command_firstshow=new OleDbCommand ("que_basepolice",cnn_txl);
Command_firstshow.CommandType=CommandType.StoredProcedure ;
p_ssdd=int.Parse(Request.QueryString["p_ssdd"]);
p_zt=int.Parse(Request.QueryString["p_zt"]);
Command_firstshow.Parameters.Add("@p_ssdd",p_ssdd) ;
Command_firstshow.Parameters.Add("@p_zt",p_zt) ;
OleDbDataAdapter Adapter_firstshow=new OleDbDataAdapter(Command_firstshow);
DataSet dataSet_txl=new DataSet ();
Adapter_firstshow.Fill(dataSet_txl,"base");
DataGrid_txl.DataSource=dataSet_txl.Tables["base"].DefaultView;
DataGrid_txl.DataMember ="base";
DataGrid_txl.DataBind();
Label_title.Text ="eee";
Label_title.Text =Request.QueryString["p_ssdd"];
}
配置文件
<configuration>
<system.web> <!-- 鍔ㄦ€佽皟璇曠紪璇?
璁剧疆 compilation debug="true" 浠ュ惎鐢?ASPX 璋冭瘯銆傚惁鍒欙紝灏嗘鍊艰缃负
false 灏嗘彁楂樻搴旂敤绋嬪簭鐨勮繍琛屾椂鎬ц兘銆?
璁剧疆 compilation debug="true" 浠ュ皢璋冭瘯绗﹀彿(.pdb 淇℃伅)
鎻掑叆鍒扮紪璇戦〉涓€傚洜涓鸿繖灏嗗垱寤烘墽琛岃捣鏉?
杈冩參鐨勫ぇ鏂囦欢锛屾墍浠ュ簲璇ュ彧鍦ㄨ皟璇曟椂灏嗘鍊艰缃负 true锛岃€屽湪鎵€鏈夊叾浠栨椂鍊欓兘璁剧疆涓?
false銆傛湁鍏虫洿澶氫俊鎭紝璇峰弬鑰冩湁鍏?
璋冭瘯 ASP.NET 鏂囦欢鐨勬枃妗c€?
-->
<compilation
defaultLanguage="c#"
debug="true"
/> <!-- 鑷畾涔夐敊璇俊鎭?
璁剧疆 customErrors mode="On" 鎴?"RemoteOnly" 浠ュ惎鐢ㄨ嚜瀹氫箟閿欒淇℃伅锛屾垨璁剧疆涓?"Off" 浠ョ鐢ㄨ嚜瀹氫箟閿欒淇℃伅銆?
涓烘瘡涓澶勭悊鐨勯敊璇坊鍔?<error> 鏍囪銆? "On" 濮嬬粓鏄剧ず鑷畾涔?鍙嬪ソ鐨?淇℃伅銆?
"Off" 濮嬬粓鏄剧ず璇︾粏鐨?ASP.NET 閿欒淇℃伅銆?
"RemoteOnly" 鍙涓嶅湪鏈湴 Web 鏈嶅姟鍣ㄤ笂杩愯鐨?
鐢ㄦ埛鏄剧ず鑷畾涔?鍙嬪ソ鐨?淇℃伅銆傚嚭浜庡畨鍏ㄧ洰鐨勶紝寤鸿浣跨敤姝よ缃紝浠ヤ究
涓嶅悜杩滅▼瀹㈡埛绔樉绀哄簲鐢ㄧ▼搴忕殑璇︾粏淇℃伅銆?
-->
<customErrors
mode="RemoteOnly"
/> <!-- 韬唤楠岃瘉
姝よ妭璁剧疆搴旂敤绋嬪簭鐨勮韩浠介獙璇佺瓥鐣ャ€傚彲鑳界殑妯″紡鏄?"Windows"銆?
"Forms"銆?"Passport" 鍜?"None" "None" 涓嶆墽琛岃韩浠介獙璇併€?
"Windows" IIS 鏍规嵁搴旂敤绋嬪簭鐨勮缃墽琛岃韩浠介獙璇?
(鍩烘湰銆佺畝瑕佹垨闆嗘垚 Windows)銆傚湪 IIS 涓繀椤荤鐢ㄥ尶鍚嶈闂€?
"Forms" 鎮ㄤ负鐢ㄦ埛鎻愪緵涓€涓緭鍏ュ嚟鎹殑鑷畾涔夌獥浣?Web 椤?锛岀劧鍚?
鍦ㄦ偍鐨勫簲鐢ㄧ▼搴忎腑楠岃瘉浠栦滑鐨勮韩浠姐€傜敤鎴峰嚟鎹爣璁板瓨鍌ㄥ湪 Cookie 涓€?
"Passport" 韬唤楠岃瘉鏄€氳繃 Microsoft 鐨勯泦涓韩浠介獙璇佹湇鍔℃墽琛岀殑锛?
瀹冧负鎴愬憳绔欑偣鎻愪緵鍗曠嫭鐧诲綍鍜屾牳蹇冮厤缃枃浠舵湇鍔°€?
-->
<authentication mode="None" /> <!-- 鎺堟潈
姝よ妭璁剧疆搴旂敤绋嬪簭鐨勬巿鏉冪瓥鐣ャ€傚彲浠ュ厑璁告垨鎷掔粷涓嶅悓鐨勭敤鎴锋垨瑙掕壊璁块棶
搴旂敤绋嬪簭璧勬簮銆傞€氶厤绗? "*" 琛ㄧず浠讳綍浜猴紝"?" 琛ㄧず鍖垮悕
(鏈粡韬唤楠岃瘉鐨?鐢ㄦ埛銆?
--> <authorization>
<allow users="*" /> <!-- 鍏佽鎵€鏈夌敤鎴?-->
<!-- <allow users="[閫楀彿鍒嗛殧鐨勭敤鎴峰垪琛╙"
roles="[閫楀彿鍒嗛殧鐨勮鑹插垪琛╙"/>
<deny users="[閫楀彿鍒嗛殧鐨勭敤鎴峰垪琛╙"
roles="[閫楀彿鍒嗛殧鐨勮鑹插垪琛╙"/>
-->
</authorization> <!-- 搴旂敤绋嬪簭绾у埆璺熻釜璁板綍
搴旂敤绋嬪簭绾у埆璺熻釜涓哄簲鐢ㄧ▼搴忎腑鐨勬瘡涓€椤靛惎鐢ㄨ窡韪棩蹇楄緭鍑恒€?
璁剧疆 trace enabled="true" 鍙互鍚敤搴旂敤绋嬪簭璺熻釜璁板綍銆傚鏋?pageOutput="true"锛屽垯
鍦ㄦ瘡涓€椤电殑搴曢儴鏄剧ず璺熻釜淇℃伅銆傚惁鍒欙紝鍙互閫氳繃娴忚 Web 搴旂敤绋嬪簭
鏍圭洰褰曚腑鐨?"trace.axd" 椤垫潵鏌ョ湅
搴旂敤绋嬪簭璺熻釜鏃ュ織銆?
-->
<trace
enabled="false"
requestLimit="10"
pageOutput="false"
traceMode="SortByTime"
localOnly="true"
/> <!-- 浼氳瘽鐘舵€佽缃?
榛樿鎯呭喌涓嬶紝ASP.NET 浣跨敤 Cookie 鏉ユ爣璇嗗摢浜涜姹傚睘浜庣壒瀹氱殑浼氳瘽銆?
濡傛灉 Cookie 涓嶅彲鐢紝鍒欏彲浠ラ€氳繃灏嗕細璇濇爣璇嗙娣诲姞鍒?URL 鏉ヨ窡韪細璇濄€?
鑻ヨ绂佺敤 Cookie锛岃璁剧疆 sessionState cookieless="true"銆?
-->
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
cookieless="false"
timeout="20"
/> <!-- 鍏ㄧ悆鍖?
姝よ妭璁剧疆搴旂敤绋嬪簭鐨勫叏鐞冨寲璁剧疆銆?
-->
<globalization
requestEncoding="utf-8"
responseEncoding="utf-8"
/> </system.web>
<appSettings>
<add key="TaskInfo_Database" value= "User ID=sa;Initial Catalog=MobileRepire;Data Source=BLUE;password=whn801213" />
</appSettings>
</configuration>
酱紫!
Command_firstshow.Parameters.Add("@p_ssdd",p_ssdd) ;
Command_firstshow.Parameters.Add("@p_zt",p_zt) ;把"@"去掉看行不行,不行的话把上面两句写全了。
Command_firstshow.Parameters.Add(new OleDbParameter("@p_ssdd", ..., p_ssdd)) ;
Command_firstshow.Parameters.Add(new OleDbParameter("@p_zt", ..., p_zt)) ;