Re: Now: @Original_parameters not set.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 06/01/04

Next message: JJKane: "Re: Search a DataTable on a byte[] field"

Previous message: Ginny Caughey [MVP]: "Re: Books reviewed"
In reply to: Kevin Hodgson: "Re: Now: @Original_parameters not set."
Messages sorted by: [ date ] [ thread ]

Date: Tue, 1 Jun 2004 15:16:49 -0400

Hmm, almost looks like a column mapping is missing... Here's typically what
it will look like
"@Original_EmplNum", System.Data.SqlDbType.Int, 4,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte),
"EmplNum", System.Data.DataRowVersion.Original, Nothing))

Where "EmplNum" is the colummapping and the DataRowVersion.Original maps
back to the original value of the row for the concurrency test. It looks
like it was reconfigured and the mapping were left out. It should have
warned you though. Run back through the wizard, choose existing stored
procedures, and make sure all the fields are mapped for you Insert Command.
If not it should throw up a warning..

I can recreate this exactly if i reconfigure and don't specify the
columnMappings, but if I do, all is well. The First pass through the Wizard
takes care of it for you, but I'm guessing this was done more than once.

Let me know.

Bill

-- 
W.G. Ryan, eMVP
http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp
"Kevin Hodgson" <kevin@caseware.com> wrote in message
news:ubJLXx$REHA.624@TK2MSFTNGP11.phx.gbl...
> Here's my error and the definition for the Stored Procedure.
>
> System.Data.SqlClient.SqlException: Procedure 'cw_customerupdate' expects
> parameter'@Original_EndUserID', which was not supplied.
> at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
> DataTableMapping tableMapping)
> at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
> at MyApp.Form.btnUpdateClient_Click(Object sender, EventArgs e) in
> \path\form.vb: line 1154
>
> This is my call to do the update:
>
> Me.BindingContext(Me.DsCustomerInfo1.CW_customerinfo).EndCurrentEdit()
> Me.daCustomerInfo.Update(Me.DsCustomerInfo1, "CW_customerinfo")
>
> This is my declaration for the Stored Procedure, which was setup by the
> Designer when I added the SqlDataAdapter to my Form.
>         Me.SqlUpdateCommand1.CommandText = "[cw_customerupdate]"
>         Me.SqlUpdateCommand1.CommandType =
> System.Data.CommandType.StoredProcedure
>         Me.SqlUpdateCommand1.Connection = Me.connExpress
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@RETURN_VALUE",
> System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue,
> False, CType(0, Byte), CType(0, Byte), "",
> System.Data.DataRowVersion.Current, Nothing))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@EndUserID",
System.Data.SqlDbType.Int,
> 4, "EndUserID"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@ClientNumber",
> System.Data.SqlDbType.VarChar, 50, "ClientNumber"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CompanyName",
> System.Data.SqlDbType.VarChar, 50, "CompanyName"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@ShortName",
> System.Data.SqlDbType.VarChar, 10, "ShortName"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Address",
> System.Data.SqlDbType.VarChar, 255, "Address"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.VarChar,
> 50, "City"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@ProvinceOrState",
> System.Data.SqlDbType.VarChar, 20, "ProvinceOrState"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Country",
> System.Data.SqlDbType.VarChar, 50, "Country"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@PostalCode",
> System.Data.SqlDbType.VarChar, 20, "PostalCode"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Phone1",
System.Data.SqlDbType.VarChar,
> 40, "Phone1"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Phone2",
System.Data.SqlDbType.VarChar,
> 40, "Phone2"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@FaxNumber",
> System.Data.SqlDbType.VarChar, 40, "FaxNumber"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@FirstName",
> System.Data.SqlDbType.VarChar, 30, "FirstName"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@LastName",
> System.Data.SqlDbType.VarChar, 30, "LastName"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@EmailAddress",
> System.Data.SqlDbType.VarChar, 50, "EmailAddress"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Active", System.Data.SqlDbType.Int,
4,
> "Active"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@DistributorID",
> System.Data.SqlDbType.Int, 4, "DistributorID"))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_EndUserID",
> System.Data.SqlDbType.Int, 4))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_Active",
> System.Data.SqlDbType.Int, 4))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_DistributorID",
> System.Data.SqlDbType.Int, 4))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_Address",
> System.Data.SqlDbType.VarChar, 255))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_City",
> System.Data.SqlDbType.VarChar, 50))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_ClientNumber",
> System.Data.SqlDbType.VarChar, 50))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_CompanyName",
> System.Data.SqlDbType.VarChar, 50))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_Country",
> System.Data.SqlDbType.VarChar, 50))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_EmailAddress",
> System.Data.SqlDbType.VarChar, 50))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_FaxNumber",
> System.Data.SqlDbType.VarChar, 40))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_FirstName",
> System.Data.SqlDbType.VarChar, 30))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_LastName",
> System.Data.SqlDbType.VarChar, 30))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_Phone1",
> System.Data.SqlDbType.VarChar, 40))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_Phone2",
> System.Data.SqlDbType.VarChar, 40))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_PostalCode",
> System.Data.SqlDbType.VarChar, 20))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_ProvinceOrState",
> System.Data.SqlDbType.VarChar, 20))
>         Me.SqlUpdateCommand1.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Original_ShortName",
> System.Data.SqlDbType.VarChar, 10))
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:OwBCIg$REHA.3572@TK2MSFTNGP11.phx.gbl...
> > If a parameter is missing then you need to look to the stored proc or
your
> > update command and see what its expecting.  What is the exact error you
> are
> > getting?
> >
> > -- 
> >
> > W.G. Ryan, eMVP
> >
> > "Kevin Hodgson" <kevin@caseware.com> wrote in message
> > news:eMFAiG$REHA.3476@tk2msftngp13.phx.gbl...
> > > Now I'm getting an error on the Update for each of the
> > > @Original_<Parameters>. in my query.  Aren't these values set/tracked
by
> > the
> > > data binding, or do I need to set each of these Parameters when I do
my
> > > update?  Am I going to need to set all the new parameters manually as
> > well?
>
>

Next message: JJKane: "Re: Search a DataTable on a byte[] field"

Previous message: Ginny Caughey [MVP]: "Re: Books reviewed"
In reply to: Kevin Hodgson: "Re: Now: @Original_parameters not set."
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Limit of 150 rows in a combobox?
... I can't find an answer to this in the newgroup postings, ... datasource is a SQL Server stored procedure. ... 200 rows when executed on SQL Server. ... Any advice on finding these missing rows would be most ...
(microsoft.public.access.forms)
Re: SQLServer dosnt throw warning message !
... I believe it only throws that error for a missing stored procedure. ... SQL Server MVP ... > Is there any witch to turn ON in order to have this message, I'm pretty sure> I didn't change any setting in my server> ...
(microsoft.public.sqlserver.programming)
SA connection problems.
... I've got problems with a SQL 7.0 server. ... It's most likely after a hacker attack. ... indicates that the stored procedure sp_password is ... IS missing. ...
(microsoft.public.sqlserver.security)
Re: when posting page is there a way to make it post without waiting?
... Basically it works exactly the same as the darkfalz one, but missing ... >> my second page gets the values and passes them to a stored procedure ...
(microsoft.public.inetserver.asp.general)