Need help understanding?
Server Error in '/solo' Application.
----------------------------------------------------------------------------
----
Object must implement IConvertible.
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.InvalidC astException: Object must implement
IConvertible.
Source Error:
Line 509: Me.cmdAddMember .Parameters(30) .Value =
Me.txtCurrentDa te.Text
Line 510: Me.cmdAddMember .Connection.Ope n()
Line 511: Me.cmdAddMember .ExecuteNonQuer y()
Line 512: Me.cmdAddMember .Connection.Clo se()
Line 513: Me.txtMemberId. Visible = True
Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 511
Stack Trace:
[InvalidCastExce ption: Object must implement IConvertible.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o
stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277
----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET
Version:1.1.432 2.573
7  1670 
Leon,
It looks as if you need to convert the text into an actual date object.
Me.cmdAddMember .Parameters(30) .Value = CType(Me.txtCur rentDate.Text,
DateTime)
--
S. Justin Gengo, MCP
Web Developer
Free code library at: www.aboutfortunate.com
"Out of chaos comes order."
Nietzche
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:ug******** ******@TK2MSFTN GP11.phx.gbl... Need help understanding?
Server Error in '/solo' Application.
--------------------------------------------------------------------------
-- ----
Object must implement IConvertible.
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.InvalidC astException: Object must implement
IConvertible.
Source Error:
Line 509: Me.cmdAddMember .Parameters(30) .Value =
Me.txtCurrentDa te.Text
Line 510: Me.cmdAddMember .Connection.Ope n()
Line 511: Me.cmdAddMember .ExecuteNonQuer y()
Line 512: Me.cmdAddMember .Connection.Clo se()
Line 513: Me.txtMemberId. Visible = True
Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 511
Stack Trace:
[InvalidCastExce ption: Object must implement IConvertible.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277
--------------------------------------------------------------------------
-- ----
Version Information: Microsoft .NET Framework Version:1.1.432 2.573;
ASP.NET Version:1.1.432 2.573
This might have already been covered, but, Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
I know in C# the Parameters collection is 0 based, so I am making the same
assumption for vb
Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text.
This is the second parameter you have and is the first parameter expected by
the stored procedure, so it seems you are adding more parameters that the SP
knows what to do with.
You also can't grab the memberID until AFTER the query is run. You can
either run the ExecuteScalar() to get the ID of the recently added and you
will have to assign it after the query. Before the record is inserted, the
ID is not know.
You might want to get the @@Identity ( or rather the Scope_Identity( ) <do a
google search> ) as an output parameter.
HTH
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:uf******** ******@TK2MSFTN GP11.phx.gbl... (Do You See A Problem!) This is the Store Proceduce and code I'm using.
REATE PROCEDURE [Add_Member]
(@Username [varchar](20),
@Password [varchar](16),
@SecretQuestion [varchar](50),
@SecretAnswer [varchar](64),
@FirstName [varchar](64),
@LastName [varchar](64),
@BirthMonth [varchar](10),
@BirthDay [tinyint],
@BirthYear [smallint],
@Gender [varchar](6),
@SchoolState [varchar](50),
@SchoolName [varchar](200),
@Classification [varchar](50),
@Major [varchar](120),
@CreditCardName [varchar](120),
@CreditCardType [varchar](20),
@CreditCardNumb er [varchar](16),
@CreditCardExpM onth [varchar](10),
@CreditCardExpY ear [smallint],
@BillingAddress 1 [varchar](200),
@BillingAddress 2 [varchar](200),
@BillingCity [varchar](200),
@BillingState [varchar](50),
@BillingPostalC ode [varchar](10),
@EmailAddress [varchar](64),
@PhoneAreaCode [char](3),
@PhoneNumber [varchar](8),
@ActivationDate [smalldatetime],
@RenewalDate [smalldatetime],
@LastUpdate [smalldatetime])
AS INSERT INTO [Stunation].[dbo].[TAB_Member]
( [Username],
[Password],
[SecretQuestion],
[SecretAnswer],
[FirstName],
[LastName],
[BirthMonth],
[BirthDay],
[BirthYear],
[Gender],
[SchoolState],
[SchoolName],
[Classification],
[Major],
[CreditCardName],
[CreditCardType],
[CreditCardNumbe r],
[CreditCardExpMo nth],
[CreditCardExpYe ar],
[BillingAddress1],
[BillingAddress2],
[BillingCity],
[BillingState],
[BillingPostalCo de],
[EmailAddress],
[PhoneAreaCode],
[PhoneNumber],
[ActivationDate],
[RenewalDate],
[LastUpdate])
VALUES
( @Username,
@Password,
@SecretQuestion ,
@SecretAnswer,
@FirstName,
@LastName,
@BirthMonth,
@BirthDay,
@BirthYear,
@Gender,
@SchoolState,
@SchoolName,
@Classification ,
@Major,
@CreditCardName ,
@CreditCardType ,
@CreditCardNumb er,
@CreditCardExpM onth,
@CreditCardExpY ear,
@BillingAddress 1,
@BillingAddress 2,
@BillingCity,
@BillingState,
@BillingPostalC ode,
@EmailAddress,
@PhoneAreaCode,
@PhoneNumber,
@ActivationDate ,
@RenewalDate,
@LastUpdate)
SELECT MemberID = @@IDENTITY
GO
This is the code inside of vs.net
If Me.IsValid = True Then
Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text
Me.cmdAddMember .Parameters(2). Value = Me.txtPassword. Text
Me.cmdAddMember .Parameters(3). Value = Me.ddlSecretQue stion.SelectedI tem
Me.cmdAddMember .Parameters(4). Value = Me.txtSecretAns wer.Text
Me.cmdAddMember .Parameters(5). Value = Me.txtFirstName .Text
Me.cmdAddMember .Parameters(6). Value = Me.txtLastName. Text
Me.cmdAddMember .Parameters(7). Value = Me.ddlBirthMont h.SelectedItem
Me.cmdAddMember .Parameters(8). Value = Me.ddlBirthDay. SelectedItem
Me.cmdAddMember .Parameters(9). Value = Me.txtBirthYear .Text
Me.cmdAddMember .Parameters(10) .Value = Me.rbtGender.Se lectedItem
Me.cmdAddMember .Parameters(11) .Value = Me.ddlSchoolSta te.SelectedItem
Me.cmdAddMember .Parameters(12) .Value = Me.ddlSchoolNam e.SelectedItem
Me.cmdAddMember .Parameters(13) .Value = Me.ddlClassific ation.SelectedI tem
Me.cmdAddMember .Parameters(14) .Value = Me.ddlSchoolMaj or.SelectedItem
Me.cmdAddMember .Parameters(15) .Value = Me.txtCreditCar dName.Text
Me.cmdAddMember .Parameters(16) .Value = Me.ddlCreditCar dType.SelectedI tem
Me.cmdAddMember .Parameters(17) .Value = Me.txtCreditCar dNumber.Text
Me.cmdAddMember .Parameters(18) .Value = Me.ddlExpMonth. SelectedItem
Me.cmdAddMember .Parameters(19) .Value = Me.ddlExpYear.S electedItem
Me.cmdAddMember .Parameters(20) .Value = Me.txtBillingAd dress1.Text
Me.cmdAddMember .Parameters(21) .Value = Me.txtBillingAd dress2.Text
Me.cmdAddMember .Parameters(22) .Value = Me.txtBillingCi ty.Text
Me.cmdAddMember .Parameters(23) .Value = Me.ddlBillingSt ate.SelectedIte m
Me.cmdAddMember .Parameters(24) .Value = Me.txtBillingZi pCode.Text
Me.cmdAddMember .Parameters(25) .Value = Me.txtEmail.Tex t
Me.cmdAddMember .Parameters(26) .Value = Me.txtPhonerAre aCode.Text
Me.cmdAddMember .Parameters(27) .Value = Me.txtPhone.Tex t
Me.cmdAddMember .Parameters(28) .Value = Me.txtCurrentDa te.Text
Me.cmdAddMember .Parameters(29) .Value = (Me.txtFutureDa te.Text)
Me.cmdAddMember .Parameters(30) .Value = (Me.txtCurrentD ate.Text)
Me.cmdAddMember .Connection.Ope n()
Me.cmdAddMember .ExecuteNonQuer y()
Me.cmdAddMember .Connection.Clo se()
Me.txtMemberId. Visible = True
End If
"S. Justin Gengo" <sj*****@aboutf ortunate.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. Leon,
It looks as if you need to convert the text into an actual date object.
Me.cmdAddMember .Parameters(30) .Value = CType(Me.txtCur rentDate.Text,
DateTime)
--
S. Justin Gengo, MCP
Web Developer
Free code library at:
www.aboutfortun ate.com
"Out of chaos comes order."
Nietzche
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:ug******** ******@TK2MSFTN GP11.phx.gbl... Need help understanding?
Server Error in '/solo' Application.
-------------------------------------------------------------------------- -- ----
Object must implement IConvertible.
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.InvalidC astException: Object must implement
IConvertible.
Source Error:
Line 509: Me.cmdAddMember .Parameters(30) .Value =
Me.txtCurrentDa te.Text
Line 510: Me.cmdAddMember .Connection.Ope n()
Line 511: Me.cmdAddMember .ExecuteNonQuer y()
Line 512: Me.cmdAddMember .Connection.Clo se()
Line 513: Me.txtMemberId. Visible = True
Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 511
Stack Trace:
[InvalidCastExce ption: Object must implement IConvertible.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33 System.Web.UI.P age.ProcessRequ estMain() +1277
-------------------------------------------------------------------------- -- ----
Version Information: Microsoft .NET Framework Version:1.1.432 2.573;
ASP.NET Version:1.1.432 2.573
My Code is page is still giving me the same error, and can't figure-out what
I'm doing wrong!
any suggestion?
Server Error in '/solo' Application.
----------------------------------------------------------------------------
----
Object must implement IConvertible.
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.InvalidC astException: Object must implement
IConvertible.
Source Error:
Line 508: Me.cmdAddMember .Parameters(30) .Value =
Me.txtCurrentDa te.Text
Line 509: Me.cmdAddMember .Connection.Ope n()
Line 510: Me.cmdAddMember .ExecuteNonQuer y()
Line 511: Me.cmdAddMember .Connection.Clo se()
Line 512: Me.txtMemberId. Visible = True
Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 510
Stack Trace:
[InvalidCastExce ption: Object must implement IConvertible.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:510
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o
stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277
----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET
Version:1.1.432 2.573
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:uR******** ******@TK2MSFTN GP11.phx.gbl... This might have already been covered, but,
Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
I know in C# the Parameters collection is 0 based, so I am making the same
assumption for vb
Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text.
This is the second parameter you have and is the first parameter expected
by the stored procedure, so it seems you are adding more parameters that the
SP knows what to do with.
You also can't grab the memberID until AFTER the query is run. You can
either run the ExecuteScalar() to get the ID of the recently added and you
will have to assign it after the query. Before the record is inserted,
the ID is not know.
You might want to get the @@Identity ( or rather the Scope_Identity( ) <do
a google search> ) as an output parameter.
HTH
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:uf******** ******@TK2MSFTN GP11.phx.gbl... (Do You See A Problem!) This is the Store Proceduce and code I'm using.
REATE PROCEDURE [Add_Member]
(@Username [varchar](20),
@Password [varchar](16),
@SecretQuestion [varchar](50),
@SecretAnswer [varchar](64),
@FirstName [varchar](64),
@LastName [varchar](64),
@BirthMonth [varchar](10),
@BirthDay [tinyint],
@BirthYear [smallint],
@Gender [varchar](6),
@SchoolState [varchar](50),
@SchoolName [varchar](200),
@Classification [varchar](50),
@Major [varchar](120),
@CreditCardName [varchar](120),
@CreditCardType [varchar](20),
@CreditCardNumb er [varchar](16),
@CreditCardExpM onth [varchar](10),
@CreditCardExpY ear [smallint],
@BillingAddress 1 [varchar](200),
@BillingAddress 2 [varchar](200),
@BillingCity [varchar](200),
@BillingState [varchar](50),
@BillingPostalC ode [varchar](10),
@EmailAddress [varchar](64),
@PhoneAreaCode [char](3),
@PhoneNumber [varchar](8),
@ActivationDate [smalldatetime],
@RenewalDate [smalldatetime],
@LastUpdate [smalldatetime])
AS INSERT INTO [Stunation].[dbo].[TAB_Member]
( [Username],
[Password],
[SecretQuestion],
[SecretAnswer],
[FirstName],
[LastName],
[BirthMonth],
[BirthDay],
[BirthYear],
[Gender],
[SchoolState],
[SchoolName],
[Classification],
[Major],
[CreditCardName],
[CreditCardType],
[CreditCardNumbe r],
[CreditCardExpMo nth],
[CreditCardExpYe ar],
[BillingAddress1],
[BillingAddress2],
[BillingCity],
[BillingState],
[BillingPostalCo de],
[EmailAddress],
[PhoneAreaCode],
[PhoneNumber],
[ActivationDate],
[RenewalDate],
[LastUpdate])
VALUES
( @Username,
@Password,
@SecretQuestion ,
@SecretAnswer,
@FirstName,
@LastName,
@BirthMonth,
@BirthDay,
@BirthYear,
@Gender,
@SchoolState,
@SchoolName,
@Classification ,
@Major,
@CreditCardName ,
@CreditCardType ,
@CreditCardNumb er,
@CreditCardExpM onth,
@CreditCardExpY ear,
@BillingAddress 1,
@BillingAddress 2,
@BillingCity,
@BillingState,
@BillingPostalC ode,
@EmailAddress,
@PhoneAreaCode,
@PhoneNumber,
@ActivationDate ,
@RenewalDate,
@LastUpdate)
SELECT MemberID = @@IDENTITY
GO
This is the code inside of vs.net
If Me.IsValid = True Then
Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text
Me.cmdAddMember .Parameters(2). Value = Me.txtPassword. Text
Me.cmdAddMember .Parameters(3). Value = Me.ddlSecretQue stion.SelectedI tem
Me.cmdAddMember .Parameters(4). Value = Me.txtSecretAns wer.Text
Me.cmdAddMember .Parameters(5). Value = Me.txtFirstName .Text
Me.cmdAddMember .Parameters(6). Value = Me.txtLastName. Text
Me.cmdAddMember .Parameters(7). Value = Me.ddlBirthMont h.SelectedItem
Me.cmdAddMember .Parameters(8). Value = Me.ddlBirthDay. SelectedItem
Me.cmdAddMember .Parameters(9). Value = Me.txtBirthYear .Text
Me.cmdAddMember .Parameters(10) .Value = Me.rbtGender.Se lectedItem
Me.cmdAddMember .Parameters(11) .Value = Me.ddlSchoolSta te.SelectedItem
Me.cmdAddMember .Parameters(12) .Value = Me.ddlSchoolNam e.SelectedItem
Me.cmdAddMember .Parameters(13) .Value = Me.ddlClassific ation.SelectedI tem
Me.cmdAddMember .Parameters(14) .Value = Me.ddlSchoolMaj or.SelectedItem
Me.cmdAddMember .Parameters(15) .Value = Me.txtCreditCar dName.Text
Me.cmdAddMember .Parameters(16) .Value = Me.ddlCreditCar dType.SelectedI tem
Me.cmdAddMember .Parameters(17) .Value = Me.txtCreditCar dNumber.Text
Me.cmdAddMember .Parameters(18) .Value = Me.ddlExpMonth. SelectedItem
Me.cmdAddMember .Parameters(19) .Value = Me.ddlExpYear.S electedItem
Me.cmdAddMember .Parameters(20) .Value = Me.txtBillingAd dress1.Text
Me.cmdAddMember .Parameters(21) .Value = Me.txtBillingAd dress2.Text
Me.cmdAddMember .Parameters(22) .Value = Me.txtBillingCi ty.Text
Me.cmdAddMember .Parameters(23) .Value = Me.ddlBillingSt ate.SelectedIte m
Me.cmdAddMember .Parameters(24) .Value = Me.txtBillingZi pCode.Text
Me.cmdAddMember .Parameters(25) .Value = Me.txtEmail.Tex t
Me.cmdAddMember .Parameters(26) .Value = Me.txtPhonerAre aCode.Text
Me.cmdAddMember .Parameters(27) .Value = Me.txtPhone.Tex t
Me.cmdAddMember .Parameters(28) .Value = Me.txtCurrentDa te.Text
Me.cmdAddMember .Parameters(29) .Value = (Me.txtFutureDa te.Text)
Me.cmdAddMember .Parameters(30) .Value = (Me.txtCurrentD ate.Text)
Me.cmdAddMember .Connection.Ope n()
Me.cmdAddMember .ExecuteNonQuer y()
Me.cmdAddMember .Connection.Clo se()
Me.txtMemberId. Visible = True
End If
"S. Justin Gengo" <sj*****@aboutf ortunate.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. Leon,
It looks as if you need to convert the text into an actual date
object.
Me.cmdAddMember .Parameters(30) .Value = CType(Me.txtCur rentDate.Text,
DateTime)
--
S. Justin Gengo, MCP
Web Developer
Free code library at:
www.aboutfortun ate.com
"Out of chaos comes order."
Nietzche
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:ug******** ******@TK2MSFTN GP11.phx.gbl...
> Need help understanding?
>
> Server Error in '/solo' Application.
-------------------------------------------------------------------------- --
> ----
>
> Object must implement IConvertible.
> 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.InvalidC astException: Object must
implement > IConvertible.
>
> Source Error:
>
> Line 509: Me.cmdAddMember .Parameters(30) .Value =
> Me.txtCurrentDa te.Text
> Line 510: Me.cmdAddMember .Connection.Ope n()
> Line 511: Me.cmdAddMember .ExecuteNonQuer y()
> Line 512: Me.cmdAddMember .Connection.Clo se()
> Line 513: Me.txtMemberId. Visible = True
>
> Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 511
>
> Stack Trace:
>
> [InvalidCastExce ption: Object must implement IConvertible.]
> System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
> System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
> solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
> c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
> System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
>
>
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o > stBackEvent(Str ing eventArgument) +57
> System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
> sourceControl, String eventArgument) +18
> System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection
postData) +33 > System.Web.UI.P age.ProcessRequ estMain() +1277
>
>
>
-------------------------------------------------------------------------- --
> ----
> Version Information: Microsoft .NET Framework Version:1.1.432 2.573;
ASP.NET
> Version:1.1.432 2.573
>
>
Have you changed any of your code or is it still the same?
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OZ******** ******@TK2MSFTN GP12.phx.gbl... My Code is page is still giving me the same error, and can't figure-out
what I'm doing wrong!
any suggestion?
Server Error in '/solo' Application.
--------------------------------------------------------------------------
-- ----
Object must implement IConvertible.
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.InvalidC astException: Object must implement
IConvertible.
Source Error:
Line 508: Me.cmdAddMember .Parameters(30) .Value =
Me.txtCurrentDa te.Text
Line 509: Me.cmdAddMember .Connection.Ope n()
Line 510: Me.cmdAddMember .ExecuteNonQuer y()
Line 511: Me.cmdAddMember .Connection.Clo se()
Line 512: Me.txtMemberId. Visible = True
Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 510
Stack Trace:
[InvalidCastExce ption: Object must implement IConvertible.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:510
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277
--------------------------------------------------------------------------
-- ----
Version Information: Microsoft .NET Framework Version:1.1.432 2.573;
ASP.NET Version:1.1.432 2.573
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:uR******** ******@TK2MSFTN GP11.phx.gbl... This might have already been covered, but,
Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
I know in C# the Parameters collection is 0 based, so I am making the
same assumption for vb
Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text.
This is the second parameter you have and is the first parameter
expected by the stored procedure, so it seems you are adding more parameters that
the SP knows what to do with.
You also can't grab the memberID until AFTER the query is run. You can
either run the ExecuteScalar() to get the ID of the recently added and
you will have to assign it after the query. Before the record is inserted,
the ID is not know.
You might want to get the @@Identity ( or rather the Scope_Identity( )
<do a google search> ) as an output parameter.
HTH
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:uf******** ******@TK2MSFTN GP11.phx.gbl... (Do You See A Problem!) This is the Store Proceduce and code I'm
using.
REATE PROCEDURE [Add_Member]
(@Username [varchar](20),
@Password [varchar](16),
@SecretQuestion [varchar](50),
@SecretAnswer [varchar](64),
@FirstName [varchar](64),
@LastName [varchar](64),
@BirthMonth [varchar](10),
@BirthDay [tinyint],
@BirthYear [smallint],
@Gender [varchar](6),
@SchoolState [varchar](50),
@SchoolName [varchar](200),
@Classification [varchar](50),
@Major [varchar](120),
@CreditCardName [varchar](120),
@CreditCardType [varchar](20),
@CreditCardNumb er [varchar](16),
@CreditCardExpM onth [varchar](10),
@CreditCardExpY ear [smallint],
@BillingAddress 1 [varchar](200),
@BillingAddress 2 [varchar](200),
@BillingCity [varchar](200),
@BillingState [varchar](50),
@BillingPostalC ode [varchar](10),
@EmailAddress [varchar](64),
@PhoneAreaCode [char](3),
@PhoneNumber [varchar](8),
@ActivationDate [smalldatetime],
@RenewalDate [smalldatetime],
@LastUpdate [smalldatetime])
AS INSERT INTO [Stunation].[dbo].[TAB_Member]
( [Username],
[Password],
[SecretQuestion],
[SecretAnswer],
[FirstName],
[LastName],
[BirthMonth],
[BirthDay],
[BirthYear],
[Gender],
[SchoolState],
[SchoolName],
[Classification],
[Major],
[CreditCardName],
[CreditCardType],
[CreditCardNumbe r],
[CreditCardExpMo nth],
[CreditCardExpYe ar],
[BillingAddress1],
[BillingAddress2],
[BillingCity],
[BillingState],
[BillingPostalCo de],
[EmailAddress],
[PhoneAreaCode],
[PhoneNumber],
[ActivationDate],
[RenewalDate],
[LastUpdate])
VALUES
( @Username,
@Password,
@SecretQuestion ,
@SecretAnswer,
@FirstName,
@LastName,
@BirthMonth,
@BirthDay,
@BirthYear,
@Gender,
@SchoolState,
@SchoolName,
@Classification ,
@Major,
@CreditCardName ,
@CreditCardType ,
@CreditCardNumb er,
@CreditCardExpM onth,
@CreditCardExpY ear,
@BillingAddress 1,
@BillingAddress 2,
@BillingCity,
@BillingState,
@BillingPostalC ode,
@EmailAddress,
@PhoneAreaCode,
@PhoneNumber,
@ActivationDate ,
@RenewalDate,
@LastUpdate)
SELECT MemberID = @@IDENTITY
GO
This is the code inside of vs.net
If Me.IsValid = True Then
Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text
Me.cmdAddMember .Parameters(2). Value = Me.txtPassword. Text
Me.cmdAddMember .Parameters(3). Value =
Me.ddlSecretQue stion.SelectedI tem
Me.cmdAddMember .Parameters(4). Value = Me.txtSecretAns wer.Text
Me.cmdAddMember .Parameters(5). Value = Me.txtFirstName .Text
Me.cmdAddMember .Parameters(6). Value = Me.txtLastName. Text
Me.cmdAddMember .Parameters(7). Value = Me.ddlBirthMont h.SelectedItem
Me.cmdAddMember .Parameters(8). Value = Me.ddlBirthDay. SelectedItem
Me.cmdAddMember .Parameters(9). Value = Me.txtBirthYear .Text
Me.cmdAddMember .Parameters(10) .Value = Me.rbtGender.Se lectedItem
Me.cmdAddMember .Parameters(11) .Value = Me.ddlSchoolSta te.SelectedItem
Me.cmdAddMember .Parameters(12) .Value = Me.ddlSchoolNam e.SelectedItem
Me.cmdAddMember .Parameters(13) .Value =
Me.ddlClassific ation.SelectedI tem
Me.cmdAddMember .Parameters(14) .Value = Me.ddlSchoolMaj or.SelectedItem
Me.cmdAddMember .Parameters(15) .Value = Me.txtCreditCar dName.Text
Me.cmdAddMember .Parameters(16) .Value =
Me.ddlCreditCar dType.SelectedI tem
Me.cmdAddMember .Parameters(17) .Value = Me.txtCreditCar dNumber.Text
Me.cmdAddMember .Parameters(18) .Value = Me.ddlExpMonth. SelectedItem
Me.cmdAddMember .Parameters(19) .Value = Me.ddlExpYear.S electedItem
Me.cmdAddMember .Parameters(20) .Value = Me.txtBillingAd dress1.Text
Me.cmdAddMember .Parameters(21) .Value = Me.txtBillingAd dress2.Text
Me.cmdAddMember .Parameters(22) .Value = Me.txtBillingCi ty.Text
Me.cmdAddMember .Parameters(23) .Value = Me.ddlBillingSt ate.SelectedIte m
Me.cmdAddMember .Parameters(24) .Value = Me.txtBillingZi pCode.Text
Me.cmdAddMember .Parameters(25) .Value = Me.txtEmail.Tex t
Me.cmdAddMember .Parameters(26) .Value = Me.txtPhonerAre aCode.Text
Me.cmdAddMember .Parameters(27) .Value = Me.txtPhone.Tex t
Me.cmdAddMember .Parameters(28) .Value = Me.txtCurrentDa te.Text
Me.cmdAddMember .Parameters(29) .Value = (Me.txtFutureDa te.Text)
Me.cmdAddMember .Parameters(30) .Value = (Me.txtCurrentD ate.Text)
Me.cmdAddMember .Connection.Ope n()
Me.cmdAddMember .ExecuteNonQuer y()
Me.cmdAddMember .Connection.Clo se()
Me.txtMemberId. Visible = True
End If
"S. Justin Gengo" <sj*****@aboutf ortunate.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
> Leon,
>
> It looks as if you need to convert the text into an actual date
object. >
> Me.cmdAddMember .Parameters(30) .Value = CType(Me.txtCur rentDate.Text,
> DateTime)
>
>
> --
> S. Justin Gengo, MCP
> Web Developer
>
> Free code library at:
> www.aboutfortun ate.com
>
> "Out of chaos comes order."
> Nietzche
> "Leon Shaw" <vn*****@msn.co m> wrote in message
> news:ug******** ******@TK2MSFTN GP11.phx.gbl...
> > Need help understanding?
> >
> > Server Error in '/solo' Application.
>
-------------------------------------------------------------------------- > --
> > ----
> >
> > Object must implement IConvertible.
> > 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.InvalidC astException: Object must implement > > IConvertible.
> >
> > Source Error:
> >
> > Line 509: Me.cmdAddMember .Parameters(30) .Value =
> > Me.txtCurrentDa te.Text
> > Line 510: Me.cmdAddMember .Connection.Ope n()
> > Line 511: Me.cmdAddMember .ExecuteNonQuer y()
> > Line 512: Me.cmdAddMember .Connection.Clo se()
> > Line 513: Me.txtMemberId. Visible = True
> >
> > Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line:
511 > >
> > Stack Trace:
> >
> > [InvalidCastExce ption: Object must implement IConvertible.]
> > System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
> > System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
> > solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
> > c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
> > System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
> >
> >
>
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o > > stBackEvent(Str ing eventArgument) +57
> > System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
> > sourceControl, String eventArgument) +18
> > System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
> > System.Web.UI.P age.ProcessRequ estMain() +1277
> >
> >
> >
>
-------------------------------------------------------------------------- > --
> > ----
> > Version Information: Microsoft .NET Framework
Version:1.1.432 2.573; > ASP.NET
> > Version:1.1.432 2.573
> >
> >
>
>
I Change my code, but I think something os wrong with my store procedure
because every where I test (query analyer, browers, vs.net server explorer)
it the following error show up:
Procedure 'Add_Member' expects parameter '@Username', which was not
supplied.
Do You see anything wrong?
CREATE PROCEDURE [Add_Member]
(@Username [varchar](20),
@Password [varchar](16),
@SecretQuestion [varchar](50),
@SecretAnswer [varchar](64),
@FirstName [varchar](64),
@LastName [varchar](64),
@BirthMonth [varchar](10),
@BirthDay [tinyint],
@BirthYear [smallint],
@Gender [varchar](6),
@SchoolState [varchar](50),
@SchoolName [varchar](200),
@Classification [varchar](50),
@Major [varchar](120),
@CreditCardName [varchar](120),
@CreditCardType [varchar](20),
@CreditCardNumb er [varchar](16),
@CreditCardExpM onth [varchar](10),
@CreditCardExpY ear [smallint],
@BillingAddress 1 [varchar](200),
@BillingAddress 2 [varchar](200),
@BillingCity [varchar](200),
@BillingState [varchar](50),
@BillingPostalC ode [varchar](10),
@EmailAddress [varchar](64),
@PhoneAreaCode [char](3),
@PhoneNumber [varchar](8),
@ActivationDate [smalldatetime],
@RenewalDate [smalldatetime],
@LastUpdate [smalldatetime])
AS INSERT INTO [Stunation].[dbo].[TAB_Member]
( [Username],
[Password],
[SecretQuestion],
[SecretAnswer],
[FirstName],
[LastName],
[BirthMonth],
[BirthDay],
[BirthYear],
[Gender],
[SchoolState],
[SchoolName],
[Classification],
[Major],
[CreditCardName],
[CreditCardType],
[CreditCardNumbe r],
[CreditCardExpMo nth],
[CreditCardExpYe ar],
[BillingAddress1],
[BillingAddress2],
[BillingCity],
[BillingState],
[BillingPostalCo de],
[EmailAddress],
[PhoneAreaCode],
[PhoneNumber],
[ActivationDate],
[RenewalDate],
[LastUpdate])
VALUES
( @Username,
@Password,
@SecretQuestion ,
@SecretAnswer,
@FirstName,
@LastName,
@BirthMonth,
@BirthDay,
@BirthYear,
@Gender,
@SchoolState,
@SchoolName,
@Classification ,
@Major,
@CreditCardName ,
@CreditCardType ,
@CreditCardNumb er,
@CreditCardExpM onth,
@CreditCardExpY ear,
@BillingAddress 1,
@BillingAddress 2,
@BillingCity,
@BillingState,
@BillingPostalC ode,
@EmailAddress,
@PhoneAreaCode,
@PhoneNumber,
@ActivationDate ,
@RenewalDate,
@LastUpdate)
SELECT
MemberID = @@IDENTITY
GO
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. . Have you changed any of your code or is it still the same?
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OZ******** ******@TK2MSFTN GP12.phx.gbl... My Code is page is still giving me the same error, and can't figure-out what I'm doing wrong!
any suggestion?
Server Error in '/solo' Application.
--------------------------------------------------------------------------
-- ----
Object must implement IConvertible.
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.InvalidC astException: Object must implement
IConvertible.
Source Error:
Line 508: Me.cmdAddMember .Parameters(30) .Value =
Me.txtCurrentDa te.Text
Line 509: Me.cmdAddMember .Connection.Ope n()
Line 510: Me.cmdAddMember .ExecuteNonQuer y()
Line 511: Me.cmdAddMember .Connection.Clo se()
Line 512: Me.txtMemberId. Visible = True
Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 510
Stack Trace:
[InvalidCastExce ption: Object must implement IConvertible.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:510
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
+33 System.Web.UI.P age.ProcessRequ estMain() +1277
--------------------------------------------------------------------------
-- ----
Version Information: Microsoft .NET Framework Version:1.1.432 2.573;
ASP.NET Version:1.1.432 2.573
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:uR******** ******@TK2MSFTN GP11.phx.gbl... This might have already been covered, but,
> Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
I know in C# the Parameters collection is 0 based, so I am making the same assumption for vb
> Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text.
This is the second parameter you have and is the first parameter expected by the stored procedure, so it seems you are adding more parameters that
the SP knows what to do with.
You also can't grab the memberID until AFTER the query is run. You
can either run the ExecuteScalar() to get the ID of the recently added and
you will have to assign it after the query. Before the record is
inserted, the ID is not know.
You might want to get the @@Identity ( or rather the Scope_Identity( ) <do a google search> ) as an output parameter.
HTH
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:uf******** ******@TK2MSFTN GP11.phx.gbl...
> (Do You See A Problem!) This is the Store Proceduce and code I'm
using. >
> REATE PROCEDURE [Add_Member]
> (@Username [varchar](20),
> @Password [varchar](16),
> @SecretQuestion [varchar](50),
> @SecretAnswer [varchar](64),
> @FirstName [varchar](64),
> @LastName [varchar](64),
> @BirthMonth [varchar](10),
> @BirthDay [tinyint],
> @BirthYear [smallint],
> @Gender [varchar](6),
> @SchoolState [varchar](50),
> @SchoolName [varchar](200),
> @Classification [varchar](50),
> @Major [varchar](120),
> @CreditCardName [varchar](120),
> @CreditCardType [varchar](20),
> @CreditCardNumb er [varchar](16),
> @CreditCardExpM onth [varchar](10),
> @CreditCardExpY ear [smallint],
> @BillingAddress 1 [varchar](200),
> @BillingAddress 2 [varchar](200),
> @BillingCity [varchar](200),
> @BillingState [varchar](50),
> @BillingPostalC ode [varchar](10),
> @EmailAddress [varchar](64),
> @PhoneAreaCode [char](3),
> @PhoneNumber [varchar](8),
> @ActivationDate [smalldatetime],
> @RenewalDate [smalldatetime],
> @LastUpdate [smalldatetime])
>
> AS INSERT INTO [Stunation].[dbo].[TAB_Member]
> ( [Username],
> [Password],
> [SecretQuestion],
> [SecretAnswer],
> [FirstName],
> [LastName],
> [BirthMonth],
> [BirthDay],
> [BirthYear],
> [Gender],
> [SchoolState],
> [SchoolName],
> [Classification],
> [Major],
> [CreditCardName],
> [CreditCardType],
> [CreditCardNumbe r],
> [CreditCardExpMo nth],
> [CreditCardExpYe ar],
> [BillingAddress1],
> [BillingAddress2],
> [BillingCity],
> [BillingState],
> [BillingPostalCo de],
> [EmailAddress],
> [PhoneAreaCode],
> [PhoneNumber],
> [ActivationDate],
> [RenewalDate],
> [LastUpdate])
>
> VALUES
> ( @Username,
> @Password,
> @SecretQuestion ,
> @SecretAnswer,
> @FirstName,
> @LastName,
> @BirthMonth,
> @BirthDay,
> @BirthYear,
> @Gender,
> @SchoolState,
> @SchoolName,
> @Classification ,
> @Major,
> @CreditCardName ,
> @CreditCardType ,
> @CreditCardNumb er,
> @CreditCardExpM onth,
> @CreditCardExpY ear,
> @BillingAddress 1,
> @BillingAddress 2,
> @BillingCity,
> @BillingState,
> @BillingPostalC ode,
> @EmailAddress,
> @PhoneAreaCode,
> @PhoneNumber,
> @ActivationDate ,
> @RenewalDate,
> @LastUpdate)
>
> SELECT MemberID = @@IDENTITY
> GO
> This is the code inside of vs.net
> If Me.IsValid = True Then
>
> Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
>
> Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text
>
> Me.cmdAddMember .Parameters(2). Value = Me.txtPassword. Text
>
> Me.cmdAddMember .Parameters(3). Value = Me.ddlSecretQue stion.SelectedI tem >
> Me.cmdAddMember .Parameters(4). Value = Me.txtSecretAns wer.Text
>
> Me.cmdAddMember .Parameters(5). Value = Me.txtFirstName .Text
>
> Me.cmdAddMember .Parameters(6). Value = Me.txtLastName. Text
>
> Me.cmdAddMember .Parameters(7). Value = Me.ddlBirthMont h.SelectedItem
>
> Me.cmdAddMember .Parameters(8). Value = Me.ddlBirthDay. SelectedItem
>
> Me.cmdAddMember .Parameters(9). Value = Me.txtBirthYear .Text
>
> Me.cmdAddMember .Parameters(10) .Value = Me.rbtGender.Se lectedItem
>
> Me.cmdAddMember .Parameters(11) .Value =
Me.ddlSchoolSta te.SelectedItem >
> Me.cmdAddMember .Parameters(12) .Value = Me.ddlSchoolNam e.SelectedItem
>
> Me.cmdAddMember .Parameters(13) .Value =
Me.ddlClassific ation.SelectedI tem >
> Me.cmdAddMember .Parameters(14) .Value =
Me.ddlSchoolMaj or.SelectedItem >
> Me.cmdAddMember .Parameters(15) .Value = Me.txtCreditCar dName.Text
>
> Me.cmdAddMember .Parameters(16) .Value = Me.ddlCreditCar dType.SelectedI tem >
> Me.cmdAddMember .Parameters(17) .Value = Me.txtCreditCar dNumber.Text
>
> Me.cmdAddMember .Parameters(18) .Value = Me.ddlExpMonth. SelectedItem
>
> Me.cmdAddMember .Parameters(19) .Value = Me.ddlExpYear.S electedItem
>
> Me.cmdAddMember .Parameters(20) .Value = Me.txtBillingAd dress1.Text
>
> Me.cmdAddMember .Parameters(21) .Value = Me.txtBillingAd dress2.Text
>
> Me.cmdAddMember .Parameters(22) .Value = Me.txtBillingCi ty.Text
>
> Me.cmdAddMember .Parameters(23) .Value =
Me.ddlBillingSt ate.SelectedIte m >
> Me.cmdAddMember .Parameters(24) .Value = Me.txtBillingZi pCode.Text
>
> Me.cmdAddMember .Parameters(25) .Value = Me.txtEmail.Tex t
>
> Me.cmdAddMember .Parameters(26) .Value = Me.txtPhonerAre aCode.Text
>
> Me.cmdAddMember .Parameters(27) .Value = Me.txtPhone.Tex t
>
> Me.cmdAddMember .Parameters(28) .Value = Me.txtCurrentDa te.Text
>
> Me.cmdAddMember .Parameters(29) .Value = (Me.txtFutureDa te.Text)
>
> Me.cmdAddMember .Parameters(30) .Value = (Me.txtCurrentD ate.Text)
>
> Me.cmdAddMember .Connection.Ope n()
>
> Me.cmdAddMember .ExecuteNonQuer y()
>
> Me.cmdAddMember .Connection.Clo se()
>
> Me.txtMemberId. Visible = True
>
> End If
>
> "S. Justin Gengo" <sj*****@aboutf ortunate.com> wrote in message
> news:%2******** ********@tk2msf tngp13.phx.gbl. ..
> > Leon,
> >
> > It looks as if you need to convert the text into an actual date
object. > >
> > Me.cmdAddMember .Parameters(30) .Value =
CType(Me.txtCur rentDate.Text, > > DateTime)
> >
> >
> > --
> > S. Justin Gengo, MCP
> > Web Developer
> >
> > Free code library at:
> > www.aboutfortun ate.com
> >
> > "Out of chaos comes order."
> > Nietzche
> > "Leon Shaw" <vn*****@msn.co m> wrote in message
> > news:ug******** ******@TK2MSFTN GP11.phx.gbl...
> > > Need help understanding?
> > >
> > > Server Error in '/solo' Application.
> >
>
-------------------------------------------------------------------------- > > --
> > > ----
> > >
> > > Object must implement IConvertible.
> > > 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.InvalidC astException: Object must
implement > > > IConvertible.
> > >
> > > Source Error:
> > >
> > > Line 509: Me.cmdAddMember .Parameters(30) .Value =
> > > Me.txtCurrentDa te.Text
> > > Line 510: Me.cmdAddMember .Connection.Ope n()
> > > Line 511: Me.cmdAddMember .ExecuteNonQuer y()
> > > Line 512: Me.cmdAddMember .Connection.Clo se()
> > > Line 513: Me.txtMemberId. Visible = True
> > >
> > > Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 511 > > >
> > > Stack Trace:
> > >
> > > [InvalidCastExce ption: Object must implement IConvertible.]
> > >
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or > > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
> > > System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
> > > solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
> > > c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
> > > System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
> > >
> > >
> >
>
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o > > > stBackEvent(Str ing eventArgument) +57
> > > System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
> > > sourceControl, String eventArgument) +18
> > > System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection
postData) > +33
> > > System.Web.UI.P age.ProcessRequ estMain() +1277
> > >
> > >
> > >
> >
>
-------------------------------------------------------------------------- > > --
> > > ----
> > > Version Information: Microsoft .NET Framework Version:1.1.432 2.573; > > ASP.NET
> > > Version:1.1.432 2.573
> > >
> > >
> >
> >
>
>
I see the Problem (really I do!), but I cannot seem to fix it. I know there
is not a value assign to username, but I don't know why. I change the code
like you said, I even explicitly set the (@Username) one time and still got
the same error. Take a deeper look Please! And Take for all the help!
'
'adptAddMember
'
Me.adptAddMembe r.InsertCommand = Me.SqlInsertCom mand1
Me.adptAddMembe r.SelectCommand = Me.SqlSelectCom mand1
Me.adptAddMembe r.TableMappings .AddRange(New
System.Data.Com mon.DataTableMa pping() {New
System.Data.Com mon.DataTableMa pping("Table", "Add_Member ", New
System.Data.Com mon.DataColumnM apping() {New
System.Data.Com mon.DataColumnM apping("MemberI D", "MemberID") })})
'
'SqlSelectComma nd1
'
Me.SqlSelectCom mand1.CommandTe xt = "[Add_Member]"
Me.SqlSelectCom mand1.CommandTy pe = System.Data.Com mandType.Stored Procedure
Me.SqlSelectCom mand1.Connectio n = Me.connReg
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RETURN_V ALUE",
System.Data.Sql DbType.Int, 4, System.Data.Par ameterDirection .ReturnValue,
False, CType(10, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Username ",
System.Data.Sql DbType.VarChar, 20))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Password ",
System.Data.Sql DbType.VarChar, 16))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretQu estion",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretAn swer",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@FirstNam e",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastName ",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthMon th",
System.Data.Sql DbType.VarChar, 10))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthDay ",
System.Data.Sql DbType.TinyInt, 1, System.Data.Par ameterDirection .Input,
False, CType(3, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthYea r",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Gender", System.Data.Sql DbType.VarChar,
6))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolSt ate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolNa me",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Classifi cation",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Major", System.Data.Sql DbType.VarChar,
120))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdName",
System.Data.Sql DbType.VarChar, 120))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdType",
System.Data.Sql DbType.VarChar, 20))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdNumber",
System.Data.Sql DbType.VarChar, 16))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpMonth",
System.Data.Sql DbType.VarChar, 10))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpYear",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress1",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress2",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingC ity",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingS tate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingP ostalCode",
System.Data.Sql DbType.VarChar, 10))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@EmailAdd ress",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneAre aCode",
System.Data.Sql DbType.VarChar, 3))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneNum ber",
System.Data.Sql DbType.VarChar, 8))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Activati onDate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RenewalD ate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastUpda te",
System.Data.Sql DbType.DateTime , 8))
'
'SqlInsertComma nd1
'
Me.SqlInsertCom mand1.CommandTe xt = "[Add_Member]"
Me.SqlInsertCom mand1.CommandTy pe = System.Data.Com mandType.Stored Procedure
Me.SqlInsertCom mand1.Connectio n = Me.connReg
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RETURN_V ALUE",
System.Data.Sql DbType.Int, 4, System.Data.Par ameterDirection .ReturnValue,
False, CType(10, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Username ",
System.Data.Sql DbType.VarChar, 20))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Password ",
System.Data.Sql DbType.VarChar, 16))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretQu estion",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretAn swer",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@FirstNam e",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastName ",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthMon th",
System.Data.Sql DbType.VarChar, 10))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthDay ",
System.Data.Sql DbType.TinyInt, 1, System.Data.Par ameterDirection .Input,
False, CType(3, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthYea r",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Gender", System.Data.Sql DbType.VarChar,
6))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolSt ate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolNa me",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Classifi cation",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Major", System.Data.Sql DbType.VarChar,
120))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdName",
System.Data.Sql DbType.VarChar, 120))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdType",
System.Data.Sql DbType.VarChar, 20))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdNumber",
System.Data.Sql DbType.VarChar, 16))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpMonth",
System.Data.Sql DbType.VarChar, 10))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpYear",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress1",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress2",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingC ity",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingS tate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingP ostalCode",
System.Data.Sql DbType.VarChar, 10))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@EmailAdd ress",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneAre aCode",
System.Data.Sql DbType.VarChar, 3))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneNum ber",
System.Data.Sql DbType.VarChar, 8))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Activati onDate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RenewalD ate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastUpda te",
System.Data.Sql DbType.DateTime , 8))
'
'dsAddMember
'
Me.dsAddMember. DataSetName = "dsAddMembe r"
Me.dsAddMember. Locale = New System.Globaliz ation.CultureIn fo("en-US")
Me.dsAddMember. Namespace = "http://www.tempuri.org/dsAddMember.xsd "
CType(Me.dsClas sification,
System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsCred itCard, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsDay, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsGend er, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsMajo r, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsMont h, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsMySc hool, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsSecr etQuestion,
System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsStat e, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsYear , System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsAddM ember, System.Componen tModel.ISupport Initialize).End Init()
If Me.IsValid = True Then
Me.adptAddMembe r.InsertCommand .Parameters(0). Value = Me.txtUsername. Text
Me.adptAddMembe r.InsertCommand .Parameters(1). Value = Me.txtPassword. Text
Me.adptAddMembe r.InsertCommand .Parameters(2). Value =
Me.ddlSecretQue stion.SelectedI tem
Me.adptAddMembe r.InsertCommand .Parameters(3). Value = Me.txtSecretAns wer.Text
Me.adptAddMembe r.InsertCommand .Parameters(4). Value = Me.txtFirstName .Text
Me.adptAddMembe r.InsertCommand .Parameters(5). Value = Me.txtLastName. Text
Me.adptAddMembe r.InsertCommand .Parameters(6). Value =
Me.ddlBirthMont h.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(7). Value =
Me.ddlBirthDay. SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(8). Value = Me.txtBirthYear .Text
Me.adptAddMembe r.InsertCommand .Parameters(9). Value =
Me.rbtGender.Se lectedItem
Me.adptAddMembe r.InsertCommand .Parameters(10) .Value =
Me.ddlSchoolSta te.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(11) .Value =
Me.ddlSchoolNam e.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(12) .Value =
Me.ddlClassific ation.SelectedI tem
Me.adptAddMembe r.InsertCommand .Parameters(13) .Value =
Me.ddlSchoolMaj or.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(14) .Value =
Me.txtCreditCar dName.Text
Me.adptAddMembe r.InsertCommand .Parameters(15) .Value =
Me.ddlCreditCar dType.SelectedI tem
Me.adptAddMembe r.InsertCommand .Parameters(16) .Value =
Me.txtCreditCar dNumber.Text
Me.adptAddMembe r.InsertCommand .Parameters(17) .Value =
Me.ddlExpMonth. SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(18) .Value =
Me.ddlExpYear.S electedItem
Me.adptAddMembe r.InsertCommand .Parameters(19) .Value =
Me.txtBillingAd dress1.Text
Me.adptAddMembe r.InsertCommand .Parameters(20) .Value =
Me.txtBillingAd dress2.Text
Me.adptAddMembe r.InsertCommand .Parameters(21) .Value = Me.txtBillingCi ty.Text
Me.adptAddMembe r.InsertCommand .Parameters(22) .Value =
Me.ddlBillingSt ate.SelectedIte m
Me.adptAddMembe r.InsertCommand .Parameters(23) .Value =
Me.txtBillingZi pCode.Text
Me.adptAddMembe r.InsertCommand .Parameters(24) .Value = Me.txtEmail.Tex t
Me.adptAddMembe r.InsertCommand .Parameters(25) .Value =
Me.txtPhonerAre aCode.Text
Me.adptAddMembe r.InsertCommand .Parameters(26) .Value = Me.txtPhone.Tex t
Me.adptAddMembe r.InsertCommand .Parameters(27) .Value = Me.txtCurrentDa te.Text
Me.adptAddMembe r.InsertCommand .Parameters(28) .Value = Me.txtFutureDat e.Text
Me.adptAddMembe r.InsertCommand .Parameters(29) .Value = Me.txtCurrentDa te.Text
Me.adptAddMembe r.Fill(Me.dsAdd Member)
Me.adptAddMembe r.Update(Me.dsA ddMember)
End If
End Sub
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:e2******** ******@TK2MSFTN GP09.phx.gbl... The procedure looks good, but on your code ( codebehind) you were never
assigning anything to the username parameter that was being passed in.
Is that still the case?
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:ez******** *****@tk2msftng p13.phx.gbl... I Change my code, but I think something os wrong with my store procedure
because every where I test (query analyer, browers, vs.net server
explorer) it the following error show up:
Procedure 'Add_Member' expects parameter '@Username', which was not
supplied.
Do You see anything wrong?
CREATE PROCEDURE [Add_Member]
(@Username [varchar](20),
@Password [varchar](16),
@SecretQuestion [varchar](50),
@SecretAnswer [varchar](64),
@FirstName [varchar](64),
@LastName [varchar](64),
@BirthMonth [varchar](10),
@BirthDay [tinyint],
@BirthYear [smallint],
@Gender [varchar](6),
@SchoolState [varchar](50),
@SchoolName [varchar](200),
@Classification [varchar](50),
@Major [varchar](120),
@CreditCardName [varchar](120),
@CreditCardType [varchar](20),
@CreditCardNumb er [varchar](16),
@CreditCardExpM onth [varchar](10),
@CreditCardExpY ear [smallint],
@BillingAddress 1 [varchar](200),
@BillingAddress 2 [varchar](200),
@BillingCity [varchar](200),
@BillingState [varchar](50),
@BillingPostalC ode [varchar](10),
@EmailAddress [varchar](64),
@PhoneAreaCode [char](3),
@PhoneNumber [varchar](8),
@ActivationDate [smalldatetime],
@RenewalDate [smalldatetime],
@LastUpdate [smalldatetime])
AS INSERT INTO [Stunation].[dbo].[TAB_Member]
( [Username],
[Password],
[SecretQuestion],
[SecretAnswer],
[FirstName],
[LastName],
[BirthMonth],
[BirthDay],
[BirthYear],
[Gender],
[SchoolState],
[SchoolName],
[Classification],
[Major],
[CreditCardName],
[CreditCardType],
[CreditCardNumbe r],
[CreditCardExpMo nth],
[CreditCardExpYe ar],
[BillingAddress1],
[BillingAddress2],
[BillingCity],
[BillingState],
[BillingPostalCo de],
[EmailAddress],
[PhoneAreaCode],
[PhoneNumber],
[ActivationDate],
[RenewalDate],
[LastUpdate])
VALUES
( @Username,
@Password,
@SecretQuestion ,
@SecretAnswer,
@FirstName,
@LastName,
@BirthMonth,
@BirthDay,
@BirthYear,
@Gender,
@SchoolState,
@SchoolName,
@Classification ,
@Major,
@CreditCardName ,
@CreditCardType ,
@CreditCardNumb er,
@CreditCardExpM onth,
@CreditCardExpY ear,
@BillingAddress 1,
@BillingAddress 2,
@BillingCity,
@BillingState,
@BillingPostalC ode,
@EmailAddress,
@PhoneAreaCode,
@PhoneNumber,
@ActivationDate ,
@RenewalDate,
@LastUpdate)
SELECT
MemberID = @@IDENTITY
GO
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. . Have you changed any of your code or is it still the same?
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OZ******** ******@TK2MSFTN GP12.phx.gbl...
> My Code is page is still giving me the same error, and can't figure-out what
> I'm doing wrong!
> any suggestion?
> Server Error in '/solo' Application.
-------------------------------------------------------------------------- --
> ----
>
> Object must implement IConvertible.
> 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.InvalidC astException: Object must
implement > IConvertible.
>
> Source Error:
>
> Line 508: Me.cmdAddMember .Parameters(30) .Value =
> Me.txtCurrentDa te.Text
> Line 509: Me.cmdAddMember .Connection.Ope n()
> Line 510: Me.cmdAddMember .ExecuteNonQuer y()
> Line 511: Me.cmdAddMember .Connection.Clo se()
> Line 512: Me.txtMemberId. Visible = True
>
> Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 510
>
> Stack Trace:
>
> [InvalidCastExce ption: Object must implement IConvertible.]
> System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
> System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
> solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
> c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:510
> System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
>
>
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o > stBackEvent(Str ing eventArgument) +57
> System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
> sourceControl, String eventArgument) +18
> System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection
postData) +33 > System.Web.UI.P age.ProcessRequ estMain() +1277
>
>
>
-------------------------------------------------------------------------- --
> ----
> Version Information: Microsoft .NET Framework Version:1.1.432 2.573;
ASP.NET
> Version:1.1.432 2.573
> "William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
> news:uR******** ******@TK2MSFTN GP11.phx.gbl...
> > This might have already been covered, but,
> >
> > > Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
> >
> > I know in C# the Parameters collection is 0 based, so I am making the same
> > assumption for vb
> >
> > > Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text.
> >
> > This is the second parameter you have and is the first parameter
expected
> by
> > the stored procedure, so it seems you are adding more parameters that the
> SP
> > knows what to do with.
> >
> > You also can't grab the memberID until AFTER the query is run.
You can > > either run the ExecuteScalar() to get the ID of the recently added
and you
> > will have to assign it after the query. Before the record is
inserted, > the
> > ID is not know.
> >
> > You might want to get the @@Identity ( or rather the Scope_Identity( ) <do
> a
> > google search> ) as an output parameter.
> >
> > HTH
> >
> > bill
> >
> >
> >
> > "Leon Shaw" <vn*****@msn.co m> wrote in message
> > news:uf******** ******@TK2MSFTN GP11.phx.gbl...
> > > (Do You See A Problem!) This is the Store Proceduce and code I'm
using.
> > >
> > > REATE PROCEDURE [Add_Member]
> > > (@Username [varchar](20),
> > > @Password [varchar](16),
> > > @SecretQuestion [varchar](50),
> > > @SecretAnswer [varchar](64),
> > > @FirstName [varchar](64),
> > > @LastName [varchar](64),
> > > @BirthMonth [varchar](10),
> > > @BirthDay [tinyint],
> > > @BirthYear [smallint],
> > > @Gender [varchar](6),
> > > @SchoolState [varchar](50),
> > > @SchoolName [varchar](200),
> > > @Classification [varchar](50),
> > > @Major [varchar](120),
> > > @CreditCardName [varchar](120),
> > > @CreditCardType [varchar](20),
> > > @CreditCardNumb er [varchar](16),
> > > @CreditCardExpM onth [varchar](10),
> > > @CreditCardExpY ear [smallint],
> > > @BillingAddress 1 [varchar](200),
> > > @BillingAddress 2 [varchar](200),
> > > @BillingCity [varchar](200),
> > > @BillingState [varchar](50),
> > > @BillingPostalC ode [varchar](10),
> > > @EmailAddress [varchar](64),
> > > @PhoneAreaCode [char](3),
> > > @PhoneNumber [varchar](8),
> > > @ActivationDate [smalldatetime],
> > > @RenewalDate [smalldatetime],
> > > @LastUpdate [smalldatetime])
> > >
> > > AS INSERT INTO [Stunation].[dbo].[TAB_Member]
> > > ( [Username],
> > > [Password],
> > > [SecretQuestion],
> > > [SecretAnswer],
> > > [FirstName],
> > > [LastName],
> > > [BirthMonth],
> > > [BirthDay],
> > > [BirthYear],
> > > [Gender],
> > > [SchoolState],
> > > [SchoolName],
> > > [Classification],
> > > [Major],
> > > [CreditCardName],
> > > [CreditCardType],
> > > [CreditCardNumbe r],
> > > [CreditCardExpMo nth],
> > > [CreditCardExpYe ar],
> > > [BillingAddress1],
> > > [BillingAddress2],
> > > [BillingCity],
> > > [BillingState],
> > > [BillingPostalCo de],
> > > [EmailAddress],
> > > [PhoneAreaCode],
> > > [PhoneNumber],
> > > [ActivationDate],
> > > [RenewalDate],
> > > [LastUpdate])
> > >
> > > VALUES
> > > ( @Username,
> > > @Password,
> > > @SecretQuestion ,
> > > @SecretAnswer,
> > > @FirstName,
> > > @LastName,
> > > @BirthMonth,
> > > @BirthDay,
> > > @BirthYear,
> > > @Gender,
> > > @SchoolState,
> > > @SchoolName,
> > > @Classification ,
> > > @Major,
> > > @CreditCardName ,
> > > @CreditCardType ,
> > > @CreditCardNumb er,
> > > @CreditCardExpM onth,
> > > @CreditCardExpY ear,
> > > @BillingAddress 1,
> > > @BillingAddress 2,
> > > @BillingCity,
> > > @BillingState,
> > > @BillingPostalC ode,
> > > @EmailAddress,
> > > @PhoneAreaCode,
> > > @PhoneNumber,
> > > @ActivationDate ,
> > > @RenewalDate,
> > > @LastUpdate)
> > >
> > > SELECT MemberID = @@IDENTITY
> > > GO
> > > This is the code inside of vs.net
> > > If Me.IsValid = True Then
> > >
> > > Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
> > >
> > > Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text
> > >
> > > Me.cmdAddMember .Parameters(2). Value = Me.txtPassword. Text
> > >
> > > Me.cmdAddMember .Parameters(3). Value =
Me.ddlSecretQue stion.SelectedI tem
> > >
> > > Me.cmdAddMember .Parameters(4). Value = Me.txtSecretAns wer.Text
> > >
> > > Me.cmdAddMember .Parameters(5). Value = Me.txtFirstName .Text
> > >
> > > Me.cmdAddMember .Parameters(6). Value = Me.txtLastName. Text
> > >
> > > Me.cmdAddMember .Parameters(7). Value = Me.ddlBirthMont h.SelectedItem > > >
> > > Me.cmdAddMember .Parameters(8). Value =
Me.ddlBirthDay. SelectedItem > > >
> > > Me.cmdAddMember .Parameters(9). Value = Me.txtBirthYear .Text
> > >
> > > Me.cmdAddMember .Parameters(10) .Value = Me.rbtGender.Se lectedItem
> > >
> > > Me.cmdAddMember .Parameters(11) .Value =
Me.ddlSchoolSta te.SelectedItem > > >
> > > Me.cmdAddMember .Parameters(12) .Value =
Me.ddlSchoolNam e.SelectedItem > > >
> > > Me.cmdAddMember .Parameters(13) .Value =
Me.ddlClassific ation.SelectedI tem
> > >
> > > Me.cmdAddMember .Parameters(14) .Value =
Me.ddlSchoolMaj or.SelectedItem > > >
> > > Me.cmdAddMember .Parameters(15) .Value = Me.txtCreditCar dName.Text
> > >
> > > Me.cmdAddMember .Parameters(16) .Value =
Me.ddlCreditCar dType.SelectedI tem
> > >
> > > Me.cmdAddMember .Parameters(17) .Value =
Me.txtCreditCar dNumber.Text > > >
> > > Me.cmdAddMember .Parameters(18) .Value =
Me.ddlExpMonth. SelectedItem > > >
> > > Me.cmdAddMember .Parameters(19) .Value =
Me.ddlExpYear.S electedItem > > >
> > > Me.cmdAddMember .Parameters(20) .Value =
Me.txtBillingAd dress1.Text > > >
> > > Me.cmdAddMember .Parameters(21) .Value =
Me.txtBillingAd dress2.Text > > >
> > > Me.cmdAddMember .Parameters(22) .Value = Me.txtBillingCi ty.Text
> > >
> > > Me.cmdAddMember .Parameters(23) .Value =
Me.ddlBillingSt ate.SelectedIte m > > >
> > > Me.cmdAddMember .Parameters(24) .Value = Me.txtBillingZi pCode.Text
> > >
> > > Me.cmdAddMember .Parameters(25) .Value = Me.txtEmail.Tex t
> > >
> > > Me.cmdAddMember .Parameters(26) .Value = Me.txtPhonerAre aCode.Text
> > >
> > > Me.cmdAddMember .Parameters(27) .Value = Me.txtPhone.Tex t
> > >
> > > Me.cmdAddMember .Parameters(28) .Value = Me.txtCurrentDa te.Text
> > >
> > > Me.cmdAddMember .Parameters(29) .Value = (Me.txtFutureDa te.Text)
> > >
> > > Me.cmdAddMember .Parameters(30) .Value = (Me.txtCurrentD ate.Text)
> > >
> > > Me.cmdAddMember .Connection.Ope n()
> > >
> > > Me.cmdAddMember .ExecuteNonQuer y()
> > >
> > > Me.cmdAddMember .Connection.Clo se()
> > >
> > > Me.txtMemberId. Visible = True
> > >
> > > End If
> > >
> > > "S. Justin Gengo" <sj*****@aboutf ortunate.com> wrote in message
> > > news:%2******** ********@tk2msf tngp13.phx.gbl. ..
> > > > Leon,
> > > >
> > > > It looks as if you need to convert the text into an actual
date > object.
> > > >
> > > > Me.cmdAddMember .Parameters(30) .Value =
CType(Me.txtCur rentDate.Text, > > > > DateTime)
> > > >
> > > >
> > > > --
> > > > S. Justin Gengo, MCP
> > > > Web Developer
> > > >
> > > > Free code library at:
> > > > www.aboutfortun ate.com
> > > >
> > > > "Out of chaos comes order."
> > > > Nietzche
> > > > "Leon Shaw" <vn*****@msn.co m> wrote in message
> > > > news:ug******** ******@TK2MSFTN GP11.phx.gbl...
> > > > > Need help understanding?
> > > > >
> > > > > Server Error in '/solo' Application.
> > > >
> > >
> >
>
-------------------------------------------------------------------------- > > > > --
> > > > > ----
> > > > >
> > > > > Object must implement IConvertible.
> > > > > 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.InvalidC astException: Object must
> implement
> > > > > IConvertible.
> > > > >
> > > > > Source Error:
> > > > >
> > > > > Line 509: Me.cmdAddMember .Parameters(30) .Value =
> > > > > Me.txtCurrentDa te.Text
> > > > > Line 510: Me.cmdAddMember .Connection.Ope n()
> > > > > Line 511: Me.cmdAddMember .ExecuteNonQuer y()
> > > > > Line 512: Me.cmdAddMember .Connection.Clo se()
> > > > > Line 513: Me.txtMemberId. Visible = True
> > > > >
> > > > > Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line: 511
> > > > >
> > > > > Stack Trace:
> > > > >
> > > > > [InvalidCastExce ption: Object must implement IConvertible.]
> > > > >
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or > > > > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 > > > > > System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
> > > > > solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
> > > > > c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
> > > > > System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)
+108 > > > > >
> > > > >
> > > >
> > >
> >
>
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o > > > > > stBackEvent(Str ing eventArgument) +57
> > > > >
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler > > > > > sourceControl, String eventArgument) +18
> > > > > System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection
> postData)
> > > +33
> > > > > System.Web.UI.P age.ProcessRequ estMain() +1277
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
-------------------------------------------------------------------------- > > > > --
> > > > > ----
> > > > > Version Information: Microsoft .NET Framework
Version:1.1.432 2.573;
> > > > ASP.NET
> > > > > Version:1.1.432 2.573
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
reply to my email for continuing this...
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:OA******** ******@TK2MSFTN GP11.phx.gbl... I see the Problem (really I do!), but I cannot seem to fix it. I know
there is not a value assign to username, but I don't know why. I change the code
like you said, I even explicitly set the (@Username) one time and still
got the same error. Take a deeper look Please! And Take for all the help!
'
'adptAddMember
'
Me.adptAddMembe r.InsertCommand = Me.SqlInsertCom mand1
Me.adptAddMembe r.SelectCommand = Me.SqlSelectCom mand1
Me.adptAddMembe r.TableMappings .AddRange(New
System.Data.Com mon.DataTableMa pping() {New
System.Data.Com mon.DataTableMa pping("Table", "Add_Member ", New
System.Data.Com mon.DataColumnM apping() {New
System.Data.Com mon.DataColumnM apping("MemberI D", "MemberID") })})
'
'SqlSelectComma nd1
'
Me.SqlSelectCom mand1.CommandTe xt = "[Add_Member]"
Me.SqlSelectCom mand1.CommandTy pe = System.Data.Com mandType.Stored Procedure
Me.SqlSelectCom mand1.Connectio n = Me.connReg
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RETURN_V ALUE",
System.Data.Sql DbType.Int, 4, System.Data.Par ameterDirection .ReturnValue,
False, CType(10, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Username ",
System.Data.Sql DbType.VarChar, 20))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Password ",
System.Data.Sql DbType.VarChar, 16))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretQu estion",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretAn swer",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@FirstNam e",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastName ",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthMon th",
System.Data.Sql DbType.VarChar, 10))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthDay ",
System.Data.Sql DbType.TinyInt, 1, System.Data.Par ameterDirection .Input,
False, CType(3, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthYea r",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Gender",
System.Data.Sql DbType.VarChar, 6))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolSt ate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolNa me",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Classifi cation",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Major",
System.Data.Sql DbType.VarChar, 120))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdName",
System.Data.Sql DbType.VarChar, 120))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdType",
System.Data.Sql DbType.VarChar, 20))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdNumber",
System.Data.Sql DbType.VarChar, 16))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpMonth",
System.Data.Sql DbType.VarChar, 10))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpYear",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress1",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress2",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingC ity",
System.Data.Sql DbType.VarChar, 200))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingS tate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingP ostalCode",
System.Data.Sql DbType.VarChar, 10))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@EmailAdd ress",
System.Data.Sql DbType.VarChar, 64))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneAre aCode",
System.Data.Sql DbType.VarChar, 3))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneNum ber",
System.Data.Sql DbType.VarChar, 8))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Activati onDate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RenewalD ate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastUpda te",
System.Data.Sql DbType.DateTime , 8))
'
'SqlInsertComma nd1
'
Me.SqlInsertCom mand1.CommandTe xt = "[Add_Member]"
Me.SqlInsertCom mand1.CommandTy pe = System.Data.Com mandType.Stored Procedure
Me.SqlInsertCom mand1.Connectio n = Me.connReg
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RETURN_V ALUE",
System.Data.Sql DbType.Int, 4, System.Data.Par ameterDirection .ReturnValue,
False, CType(10, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Username ",
System.Data.Sql DbType.VarChar, 20))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Password ",
System.Data.Sql DbType.VarChar, 16))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretQu estion",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SecretAn swer",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@FirstNam e",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastName ",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthMon th",
System.Data.Sql DbType.VarChar, 10))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthDay ",
System.Data.Sql DbType.TinyInt, 1, System.Data.Par ameterDirection .Input,
False, CType(3, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BirthYea r",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Gender",
System.Data.Sql DbType.VarChar, 6))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolSt ate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@SchoolNa me",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Classifi cation",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Major",
System.Data.Sql DbType.VarChar, 120))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdName",
System.Data.Sql DbType.VarChar, 120))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdType",
System.Data.Sql DbType.VarChar, 20))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdNumber",
System.Data.Sql DbType.VarChar, 16))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpMonth",
System.Data.Sql DbType.VarChar, 10))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@CreditCa rdExpYear",
System.Data.Sql DbType.SmallInt , 2, System.Data.Par ameterDirection .Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress1",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingA ddress2",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingC ity",
System.Data.Sql DbType.VarChar, 200))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingS tate",
System.Data.Sql DbType.VarChar, 50))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@BillingP ostalCode",
System.Data.Sql DbType.VarChar, 10))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@EmailAdd ress",
System.Data.Sql DbType.VarChar, 64))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneAre aCode",
System.Data.Sql DbType.VarChar, 3))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@PhoneNum ber",
System.Data.Sql DbType.VarChar, 8))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Activati onDate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RenewalD ate",
System.Data.Sql DbType.DateTime , 8))
Me.SqlInsertCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@LastUpda te",
System.Data.Sql DbType.DateTime , 8))
'
'dsAddMember
'
Me.dsAddMember. DataSetName = "dsAddMembe r"
Me.dsAddMember. Locale = New System.Globaliz ation.CultureIn fo("en-US")
Me.dsAddMember. Namespace = "http://www.tempuri.org/dsAddMember.xsd "
CType(Me.dsClas sification,
System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsCred itCard, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsDay, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsGend er, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsMajo r, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsMont h, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsMySc hool, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsSecr etQuestion,
System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsStat e, System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsYear , System.Componen tModel.ISupport Initialize).End Init()
CType(Me.dsAddM ember, System.Componen tModel.ISupport Initialize).End Init()
If Me.IsValid = True Then
Me.adptAddMembe r.InsertCommand .Parameters(0). Value = Me.txtUsername. Text
Me.adptAddMembe r.InsertCommand .Parameters(1). Value = Me.txtPassword. Text
Me.adptAddMembe r.InsertCommand .Parameters(2). Value =
Me.ddlSecretQue stion.SelectedI tem
Me.adptAddMembe r.InsertCommand .Parameters(3). Value =
Me.txtSecretAns wer.Text
Me.adptAddMembe r.InsertCommand .Parameters(4). Value = Me.txtFirstName .Text
Me.adptAddMembe r.InsertCommand .Parameters(5). Value = Me.txtLastName. Text
Me.adptAddMembe r.InsertCommand .Parameters(6). Value =
Me.ddlBirthMont h.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(7). Value =
Me.ddlBirthDay. SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(8). Value = Me.txtBirthYear .Text
Me.adptAddMembe r.InsertCommand .Parameters(9). Value =
Me.rbtGender.Se lectedItem
Me.adptAddMembe r.InsertCommand .Parameters(10) .Value =
Me.ddlSchoolSta te.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(11) .Value =
Me.ddlSchoolNam e.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(12) .Value =
Me.ddlClassific ation.SelectedI tem
Me.adptAddMembe r.InsertCommand .Parameters(13) .Value =
Me.ddlSchoolMaj or.SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(14) .Value =
Me.txtCreditCar dName.Text
Me.adptAddMembe r.InsertCommand .Parameters(15) .Value =
Me.ddlCreditCar dType.SelectedI tem
Me.adptAddMembe r.InsertCommand .Parameters(16) .Value =
Me.txtCreditCar dNumber.Text
Me.adptAddMembe r.InsertCommand .Parameters(17) .Value =
Me.ddlExpMonth. SelectedItem
Me.adptAddMembe r.InsertCommand .Parameters(18) .Value =
Me.ddlExpYear.S electedItem
Me.adptAddMembe r.InsertCommand .Parameters(19) .Value =
Me.txtBillingAd dress1.Text
Me.adptAddMembe r.InsertCommand .Parameters(20) .Value =
Me.txtBillingAd dress2.Text
Me.adptAddMembe r.InsertCommand .Parameters(21) .Value =
Me.txtBillingCi ty.Text
Me.adptAddMembe r.InsertCommand .Parameters(22) .Value =
Me.ddlBillingSt ate.SelectedIte m
Me.adptAddMembe r.InsertCommand .Parameters(23) .Value =
Me.txtBillingZi pCode.Text
Me.adptAddMembe r.InsertCommand .Parameters(24) .Value = Me.txtEmail.Tex t
Me.adptAddMembe r.InsertCommand .Parameters(25) .Value =
Me.txtPhonerAre aCode.Text
Me.adptAddMembe r.InsertCommand .Parameters(26) .Value = Me.txtPhone.Tex t
Me.adptAddMembe r.InsertCommand .Parameters(27) .Value =
Me.txtCurrentDa te.Text
Me.adptAddMembe r.InsertCommand .Parameters(28) .Value =
Me.txtFutureDat e.Text
Me.adptAddMembe r.InsertCommand .Parameters(29) .Value =
Me.txtCurrentDa te.Text
Me.adptAddMembe r.Fill(Me.dsAdd Member)
Me.adptAddMembe r.Update(Me.dsA ddMember)
End If
End Sub
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:e2******** ******@TK2MSFTN GP09.phx.gbl... The procedure looks good, but on your code ( codebehind) you were never
assigning anything to the username parameter that was being passed in.
Is that still the case?
bill
"Leon Shaw" <vn*****@msn.co m> wrote in message
news:ez******** *****@tk2msftng p13.phx.gbl... I Change my code, but I think something os wrong with my store
procedure because every where I test (query analyer, browers, vs.net server
explorer) it the following error show up:
Procedure 'Add_Member' expects parameter '@Username', which was not
supplied.
Do You see anything wrong?
CREATE PROCEDURE [Add_Member]
(@Username [varchar](20),
@Password [varchar](16),
@SecretQuestion [varchar](50),
@SecretAnswer [varchar](64),
@FirstName [varchar](64),
@LastName [varchar](64),
@BirthMonth [varchar](10),
@BirthDay [tinyint],
@BirthYear [smallint],
@Gender [varchar](6),
@SchoolState [varchar](50),
@SchoolName [varchar](200),
@Classification [varchar](50),
@Major [varchar](120),
@CreditCardName [varchar](120),
@CreditCardType [varchar](20),
@CreditCardNumb er [varchar](16),
@CreditCardExpM onth [varchar](10),
@CreditCardExpY ear [smallint],
@BillingAddress 1 [varchar](200),
@BillingAddress 2 [varchar](200),
@BillingCity [varchar](200),
@BillingState [varchar](50),
@BillingPostalC ode [varchar](10),
@EmailAddress [varchar](64),
@PhoneAreaCode [char](3),
@PhoneNumber [varchar](8),
@ActivationDate [smalldatetime],
@RenewalDate [smalldatetime],
@LastUpdate [smalldatetime])
AS INSERT INTO [Stunation].[dbo].[TAB_Member]
( [Username],
[Password],
[SecretQuestion],
[SecretAnswer],
[FirstName],
[LastName],
[BirthMonth],
[BirthDay],
[BirthYear],
[Gender],
[SchoolState],
[SchoolName],
[Classification],
[Major],
[CreditCardName],
[CreditCardType],
[CreditCardNumbe r],
[CreditCardExpMo nth],
[CreditCardExpYe ar],
[BillingAddress1],
[BillingAddress2],
[BillingCity],
[BillingState],
[BillingPostalCo de],
[EmailAddress],
[PhoneAreaCode],
[PhoneNumber],
[ActivationDate],
[RenewalDate],
[LastUpdate])
VALUES
( @Username,
@Password,
@SecretQuestion ,
@SecretAnswer,
@FirstName,
@LastName,
@BirthMonth,
@BirthDay,
@BirthYear,
@Gender,
@SchoolState,
@SchoolName,
@Classification ,
@Major,
@CreditCardName ,
@CreditCardType ,
@CreditCardNumb er,
@CreditCardExpM onth,
@CreditCardExpY ear,
@BillingAddress 1,
@BillingAddress 2,
@BillingCity,
@BillingState,
@BillingPostalC ode,
@EmailAddress,
@PhoneAreaCode,
@PhoneNumber,
@ActivationDate ,
@RenewalDate,
@LastUpdate)
SELECT
MemberID = @@IDENTITY
GO
"William F. Robertson, Jr." <wf*********@kp mg.com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .
> Have you changed any of your code or is it still the same?
>
> bill
>
>
> "Leon Shaw" <vn*****@msn.co m> wrote in message
> news:OZ******** ******@TK2MSFTN GP12.phx.gbl...
> > My Code is page is still giving me the same error, and can't
figure-out > what
> > I'm doing wrong!
> > any suggestion?
> > Server Error in '/solo' Application.
>
-------------------------------------------------------------------------- > --
> > ----
> >
> > Object must implement IConvertible.
> > 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.InvalidC astException: Object must implement > > IConvertible.
> >
> > Source Error:
> >
> > Line 508: Me.cmdAddMember .Parameters(30) .Value =
> > Me.txtCurrentDa te.Text
> > Line 509: Me.cmdAddMember .Connection.Ope n()
> > Line 510: Me.cmdAddMember .ExecuteNonQuer y()
> > Line 511: Me.cmdAddMember .Connection.Clo se()
> > Line 512: Me.txtMemberId. Visible = True
> >
> > Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb Line:
510 > >
> > Stack Trace:
> >
> > [InvalidCastExce ption: Object must implement IConvertible.]
> > System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
> > System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
> > solo.index.btSu bmit_Click(Obje ct sender, EventArgs e) in
> > c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:510
> > System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
> >
> >
>
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o > > stBackEvent(Str ing eventArgument) +57
> > System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
> > sourceControl, String eventArgument) +18
> > System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
> > System.Web.UI.P age.ProcessRequ estMain() +1277
> >
> >
> >
>
-------------------------------------------------------------------------- > --
> > ----
> > Version Information: Microsoft .NET Framework
Version:1.1.432 2.573; > ASP.NET
> > Version:1.1.432 2.573
> > "William F. Robertson, Jr." <wf*********@kp mg.com> wrote in
message > > news:uR******** ******@TK2MSFTN GP11.phx.gbl...
> > > This might have already been covered, but,
> > >
> > > > Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
> > >
> > > I know in C# the Parameters collection is 0 based, so I am
making the > same
> > > assumption for vb
> > >
> > > > Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text.
> > >
> > > This is the second parameter you have and is the first parameter
> expected
> > by
> > > the stored procedure, so it seems you are adding more parameters
that > the
> > SP
> > > knows what to do with.
> > >
> > > You also can't grab the memberID until AFTER the query is run. You can
> > > either run the ExecuteScalar() to get the ID of the recently
added and > you
> > > will have to assign it after the query. Before the record is
inserted,
> > the
> > > ID is not know.
> > >
> > > You might want to get the @@Identity ( or rather the
Scope_Identity( ) > <do
> > a
> > > google search> ) as an output parameter.
> > >
> > > HTH
> > >
> > > bill
> > >
> > >
> > >
> > > "Leon Shaw" <vn*****@msn.co m> wrote in message
> > > news:uf******** ******@TK2MSFTN GP11.phx.gbl...
> > > > (Do You See A Problem!) This is the Store Proceduce and code
I'm > using.
> > > >
> > > > REATE PROCEDURE [Add_Member]
> > > > (@Username [varchar](20),
> > > > @Password [varchar](16),
> > > > @SecretQuestion [varchar](50),
> > > > @SecretAnswer [varchar](64),
> > > > @FirstName [varchar](64),
> > > > @LastName [varchar](64),
> > > > @BirthMonth [varchar](10),
> > > > @BirthDay [tinyint],
> > > > @BirthYear [smallint],
> > > > @Gender [varchar](6),
> > > > @SchoolState [varchar](50),
> > > > @SchoolName [varchar](200),
> > > > @Classification [varchar](50),
> > > > @Major [varchar](120),
> > > > @CreditCardName [varchar](120),
> > > > @CreditCardType [varchar](20),
> > > > @CreditCardNumb er [varchar](16),
> > > > @CreditCardExpM onth [varchar](10),
> > > > @CreditCardExpY ear [smallint],
> > > > @BillingAddress 1 [varchar](200),
> > > > @BillingAddress 2 [varchar](200),
> > > > @BillingCity [varchar](200),
> > > > @BillingState [varchar](50),
> > > > @BillingPostalC ode [varchar](10),
> > > > @EmailAddress [varchar](64),
> > > > @PhoneAreaCode [char](3),
> > > > @PhoneNumber [varchar](8),
> > > > @ActivationDate [smalldatetime],
> > > > @RenewalDate [smalldatetime],
> > > > @LastUpdate [smalldatetime])
> > > >
> > > > AS INSERT INTO [Stunation].[dbo].[TAB_Member]
> > > > ( [Username],
> > > > [Password],
> > > > [SecretQuestion],
> > > > [SecretAnswer],
> > > > [FirstName],
> > > > [LastName],
> > > > [BirthMonth],
> > > > [BirthDay],
> > > > [BirthYear],
> > > > [Gender],
> > > > [SchoolState],
> > > > [SchoolName],
> > > > [Classification],
> > > > [Major],
> > > > [CreditCardName],
> > > > [CreditCardType],
> > > > [CreditCardNumbe r],
> > > > [CreditCardExpMo nth],
> > > > [CreditCardExpYe ar],
> > > > [BillingAddress1],
> > > > [BillingAddress2],
> > > > [BillingCity],
> > > > [BillingState],
> > > > [BillingPostalCo de],
> > > > [EmailAddress],
> > > > [PhoneAreaCode],
> > > > [PhoneNumber],
> > > > [ActivationDate],
> > > > [RenewalDate],
> > > > [LastUpdate])
> > > >
> > > > VALUES
> > > > ( @Username,
> > > > @Password,
> > > > @SecretQuestion ,
> > > > @SecretAnswer,
> > > > @FirstName,
> > > > @LastName,
> > > > @BirthMonth,
> > > > @BirthDay,
> > > > @BirthYear,
> > > > @Gender,
> > > > @SchoolState,
> > > > @SchoolName,
> > > > @Classification ,
> > > > @Major,
> > > > @CreditCardName ,
> > > > @CreditCardType ,
> > > > @CreditCardNumb er,
> > > > @CreditCardExpM onth,
> > > > @CreditCardExpY ear,
> > > > @BillingAddress 1,
> > > > @BillingAddress 2,
> > > > @BillingCity,
> > > > @BillingState,
> > > > @BillingPostalC ode,
> > > > @EmailAddress,
> > > > @PhoneAreaCode,
> > > > @PhoneNumber,
> > > > @ActivationDate ,
> > > > @RenewalDate,
> > > > @LastUpdate)
> > > >
> > > > SELECT MemberID = @@IDENTITY
> > > > GO
> > > > This is the code inside of vs.net
> > > > If Me.IsValid = True Then
> > > >
> > > > Me.txtMemberId. Text = Me.cmdAddMember .Parameters(0). Value
> > > >
> > > > Me.cmdAddMember .Parameters(1). Value = Me.txtUsername. Text
> > > >
> > > > Me.cmdAddMember .Parameters(2). Value = Me.txtPassword. Text
> > > >
> > > > Me.cmdAddMember .Parameters(3). Value =
> Me.ddlSecretQue stion.SelectedI tem
> > > >
> > > > Me.cmdAddMember .Parameters(4). Value = Me.txtSecretAns wer.Text
> > > >
> > > > Me.cmdAddMember .Parameters(5). Value = Me.txtFirstName .Text
> > > >
> > > > Me.cmdAddMember .Parameters(6). Value = Me.txtLastName. Text
> > > >
> > > > Me.cmdAddMember .Parameters(7). Value =
Me.ddlBirthMont h.SelectedItem > > > >
> > > > Me.cmdAddMember .Parameters(8). Value =
Me.ddlBirthDay. SelectedItem > > > >
> > > > Me.cmdAddMember .Parameters(9). Value = Me.txtBirthYear .Text
> > > >
> > > > Me.cmdAddMember .Parameters(10) .Value =
Me.rbtGender.Se lectedItem > > > >
> > > > Me.cmdAddMember .Parameters(11) .Value =
Me.ddlSchoolSta te.SelectedItem
> > > >
> > > > Me.cmdAddMember .Parameters(12) .Value =
Me.ddlSchoolNam e.SelectedItem > > > >
> > > > Me.cmdAddMember .Parameters(13) .Value =
> Me.ddlClassific ation.SelectedI tem
> > > >
> > > > Me.cmdAddMember .Parameters(14) .Value =
Me.ddlSchoolMaj or.SelectedItem
> > > >
> > > > Me.cmdAddMember .Parameters(15) .Value =
Me.txtCreditCar dName.Text > > > >
> > > > Me.cmdAddMember .Parameters(16) .Value =
> Me.ddlCreditCar dType.SelectedI tem
> > > >
> > > > Me.cmdAddMember .Parameters(17) .Value = Me.txtCreditCar dNumber.Text > > > >
> > > > Me.cmdAddMember .Parameters(18) .Value = Me.ddlExpMonth. SelectedItem > > > >
> > > > Me.cmdAddMember .Parameters(19) .Value = Me.ddlExpYear.S electedItem > > > >
> > > > Me.cmdAddMember .Parameters(20) .Value = Me.txtBillingAd dress1.Text > > > >
> > > > Me.cmdAddMember .Parameters(21) .Value = Me.txtBillingAd dress2.Text > > > >
> > > > Me.cmdAddMember .Parameters(22) .Value = Me.txtBillingCi ty.Text
> > > >
> > > > Me.cmdAddMember .Parameters(23) .Value =
Me.ddlBillingSt ate.SelectedIte m
> > > >
> > > > Me.cmdAddMember .Parameters(24) .Value =
Me.txtBillingZi pCode.Text > > > >
> > > > Me.cmdAddMember .Parameters(25) .Value = Me.txtEmail.Tex t
> > > >
> > > > Me.cmdAddMember .Parameters(26) .Value =
Me.txtPhonerAre aCode.Text > > > >
> > > > Me.cmdAddMember .Parameters(27) .Value = Me.txtPhone.Tex t
> > > >
> > > > Me.cmdAddMember .Parameters(28) .Value = Me.txtCurrentDa te.Text
> > > >
> > > > Me.cmdAddMember .Parameters(29) .Value = (Me.txtFutureDa te.Text)
> > > >
> > > > Me.cmdAddMember .Parameters(30) .Value =
(Me.txtCurrentD ate.Text) > > > >
> > > > Me.cmdAddMember .Connection.Ope n()
> > > >
> > > > Me.cmdAddMember .ExecuteNonQuer y()
> > > >
> > > > Me.cmdAddMember .Connection.Clo se()
> > > >
> > > > Me.txtMemberId. Visible = True
> > > >
> > > > End If
> > > >
> > > > "S. Justin Gengo" <sj*****@aboutf ortunate.com> wrote in
message > > > > news:%2******** ********@tk2msf tngp13.phx.gbl. ..
> > > > > Leon,
> > > > >
> > > > > It looks as if you need to convert the text into an actual date > > object.
> > > > >
> > > > > Me.cmdAddMember .Parameters(30) .Value =
CType(Me.txtCur rentDate.Text,
> > > > > DateTime)
> > > > >
> > > > >
> > > > > --
> > > > > S. Justin Gengo, MCP
> > > > > Web Developer
> > > > >
> > > > > Free code library at:
> > > > > www.aboutfortun ate.com
> > > > >
> > > > > "Out of chaos comes order."
> > > > > Nietzche
> > > > > "Leon Shaw" <vn*****@msn.co m> wrote in message
> > > > > news:ug******** ******@TK2MSFTN GP11.phx.gbl...
> > > > > > Need help understanding?
> > > > > >
> > > > > > Server Error in '/solo' Application.
> > > > >
> > > >
> > >
> >
>
-------------------------------------------------------------------------- > > > > > --
> > > > > > ----
> > > > > >
> > > > > > Object must implement IConvertible.
> > > > > > 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.InvalidC astException: Object
must > > implement
> > > > > > IConvertible.
> > > > > >
> > > > > > Source Error:
> > > > > >
> > > > > > Line 509: Me.cmdAddMember .Parameters(30) .Value
= > > > > > > Me.txtCurrentDa te.Text
> > > > > > Line 510: Me.cmdAddMember .Connection.Ope n()
> > > > > > Line 511: Me.cmdAddMember .ExecuteNonQuer y()
> > > > > > Line 512: Me.cmdAddMember .Connection.Clo se()
> > > > > > Line 513: Me.txtMemberId. Visible = True
> > > > > >
> > > > > > Source File: c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb
Line: > 511
> > > > > >
> > > > > > Stack Trace:
> > > > > >
> > > > > > [InvalidCastExce ption: Object must implement
IConvertible.] > > > > > >
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
> > > > > > cmdBehavior, RunBehavior runBehavior, Boolean
returnStream) +723 > > > > > > System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
> > > > > > solo.index.btSu bmit_Click(Obje ct sender, EventArgs e)
in > > > > > > c:\inetpub\wwwr oot\solo\reg\in dex.aspx.vb:511
> > > > > > System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)
+108 > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o > > > > > > stBackEvent(Str ing eventArgument) +57
> > > > > > System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler > > > > > > sourceControl, String eventArgument) +18
> > > > > >
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection > > postData)
> > > > +33
> > > > > > System.Web.UI.P age.ProcessRequ estMain() +1277
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
-------------------------------------------------------------------------- > > > > > --
> > > > > > ----
> > > > > > Version Information: Microsoft .NET Framework
> Version:1.1.432 2.573;
> > > > > ASP.NET
> > > > > > Version:1.1.432 2.573
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: AIM |
last post by:
Error in msvc in building inheritance.obj to build hello.pyd
Hello,
I am trying to build the boost 1.31.0 sample extension hello.cpp.
I can not compile the file inheritance.cpp because the two
files containing some templates: adjacency_list.hpp and mem_fn.hpp can
not compile.
Does anyone have any solutions?
|
by: Gregory |
last post by:
Hi,
One of the disadvantages of using error handling with error codes
instead of exception handling is that error codes retuned from a
function can be forgotten to check thus leading to
unexpected run-time problems. Exceptions on the other hand can not be
simply ignored.
In order to solve this error codes problem I suggest using error object
instead of error codes.
Each function has to return an error object that stores an error
|
by: deko |
last post by:
I use this convention frequently:
Exit_Here:
Exit Sub
HandleErr:
Select Case Err.Number
Case 3163
Resume Next
Case 3376
Resume Next
|
by: p |
last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also
have Crystal 9 pro on my development machine. The web app runs fine on my
dev machine but am having problems deploying. I created the websetup and
built the MSI, have the bundled version. Copied to webserver and ran
Websetup.msi. Said I had to remove old version, which I did, then reran
WebSetup.msi and keeps giving me this error. "The installer was interrupted...
|
by: Manuel |
last post by:
I'm trying to compile glut 3.7.6 (dowbloaded from official site)using
devc++.
So I've imported the glut32.dsp into devc++, included manually some
headers, and start to compile.
It return a very strange error. In your experience, where I should
looking to find the real error? Surely the sintax of glut is correct...
gcc.exe -c glut_bitmap.c -o glut_bitmap.o -I"C:/Dev-Cpp/include"
-I"../../include" -D__GNUWIN32__ -W -DWIN32 -DNDEBUG...
| | |
by: bazzer |
last post by:
hey,
im trying to access a microsoft access database from an ASP.NET web
application in visual basic 2003.NET. i get the following error when i
try running it:
Server Error in '/CinemaBookingSystem' Application.
--------------------------------------------------------------------------------
ERROR General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process
|
by: developer |
last post by:
Hi All
I have made a .NET project.
the files included are borland c++ files that i am migrate to VC++ .NET
I am using Microsoft Visual C++ .NET 2003.
the compilation goes through properly, but throws a load of linker
errors
|
by: mchuc7719 |
last post by:
Hello,
I have a Vb.Net 2005 ClassLibrary, when I try to compile using MSBee, only
get errors.
Before I to run the command line, I open in notepad the .vbproj and I was
add the next line:
Target CoreCompile:
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Vbc.exe
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
