Oh nevermind. I figured out my problem...I forgot
another SP.
Thanks anyways!!!
--- Dean Fiala <[EMAIL PROTECTED]> wrote:
> Where's your code to create the cmd object?
>
> It should add a parameter named @CustomerID and set
> the appropriate value.
>
>
> On Mon, 28 Mar 2005 21:08:57 -0000, sas0riza
> <[EMAIL PROTECTED]> wrote:
> >
> >
> > I have the following error:
> >
> > ==========================
> > Procedure 'GetCustomer' expects parameter
> '@CustomerId', which was
> > not supplied.
> > Description: An unhandled exception occurred
> during the execution of
> > the current web request. Please review the stack
> trace for more
> > information about the error and where it
> originated in the code.
> >
> > Exception Details:
> System.Data.SqlClient.SqlException:
> > Procedure 'GetCustomer' expects parameter
> '@CustomerId', which was
> > not supplied.
> >
> > Source Error:
> >
> > Line 19: cmd.CommandType =
> CommandType.StoredProcedure
> > Line 20: adpt = New SqlDataAdapter(cmd)
> > Line 21: adpt.Fill(ds, "Customers")
> > Line 22: Session("Customers") = ds.Tables
> > ("Customers").DefaultView
> > Line 23:
> >
> > Source File: F:\3-28-05\Data11A.aspx Line: 21
> >
> > Stack Trace:
> >
> > [SqlException: Procedure 'GetCustomer' expects
> > parameter '@CustomerId', which was not supplied.]
> >
>
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> > cmdBehavior, RunBehavior runBehavior, Boolean
> returnStream) +635
> >
> >
>
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader
> > (CommandBehavior behavior) +9
> > System.Data.Common.DbDataAdapter.Fill(Object
> data, Int32
> > startRecord, Int32 maxRecords, String srcTable,
> IDbCommand command,
> > CommandBehavior behavior) +121
> > System.Data.Common.DbDataAdapter.Fill(DataSet
> dataSet, Int32
> > startRecord, Int32 maxRecords, String srcTable,
> IDbCommand command,
> > CommandBehavior behavior) +77
> > System.Data.Common.DbDataAdapter.Fill(DataSet
> dataSet, String
> > srcTable) +36
> > ASP.Data11A_aspx.Page_Load(Object sender,
> EventArgs e) in F:\3-28-
> > 05\Data11A.aspx:21
> > System.Web.UI.Control.OnLoad(EventArgs e) +55
> > System.Web.UI.Control.LoadRecursive() +21
> > System.Web.UI.Page.ProcessRequestMain() +718
> >
> > ======================================
> >
> > Am I missing a line??
> >
> > Thank you!
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
> --
> Dean Fiala
> Very Practical Software, Inc
> http://www.vpsw.com
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
