怎样用ado.net（C#）调用带参数的access2000数据库的查询（存储过程）？

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

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

sorry .写错了。我用vb的..不过差不多..
System.Configuration.ConfigurationSettings.AppSettings("TaskInfo_Database"))  是什么意思？
我的代码如下，需输入两个参数p_ssdd、p_zt，access中的类型是short,可是系统总报错，说“初始化字符串的格式不符合规范”，请各位帮帮忙：
我的代码：
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"];
}
和asp中的global差不多
配置文件
<?xml version="1.0" encoding="utf-8" ?>
<configuration>

  <system.web>    
    <compilation
         defaultLanguage="c#"
         debug="true"
    />    
    <customErrors
    mode="RemoteOnly"
    />     
    <authentication mode="None"  />     <authorization>
        <allow users="*" /> 
            
    </authorization>    
    <trace
        enabled="false"
        requestLimit="10"
        pageOutput="false"
        traceMode="SortByTime"
localOnly="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>
酱紫！
access2000没有存储过程的吧？那下面这些参数不能带前缀"@"
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)) ;