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.InvalidCastException: Object must implement
IConvertible.
Source Error:
Line 509: Me.cmdAddMember.Parameters(30).Value =
Me.txtCurrentDate.Text
Line 510: Me.cmdAddMember.Connection.Open()
Line 511: Me.cmdAddMember.ExecuteNonQuery()
Line 512: Me.cmdAddMember.Connection.Close()
Line 513: Me.txtMemberId.Visible = True
Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 511
Stack Trace:
[InvalidCastException: Object must implement IConvertible.]
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195
solo.index.btSubmit_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573 7 1647
Leon,
It looks as if you need to convert the text into an actual date object.
Me.cmdAddMember.Parameters(30).Value = CType(Me.txtCurrentDate.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.com> wrote in message
news:ug**************@TK2MSFTNGP11.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.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 509: Me.cmdAddMember.Parameters(30).Value = Me.txtCurrentDate.Text Line 510: Me.cmdAddMember.Connection.Open() Line 511: Me.cmdAddMember.ExecuteNonQuery() Line 512: Me.cmdAddMember.Connection.Close() Line 513: Me.txtMemberId.Visible = True
Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 511
Stack Trace:
[InvalidCastException: Object must implement IConvertible.] System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 solo.index.btSubmit_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 --------------------------------------------------------------------------
-- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET Version:1.1.4322.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.com> wrote in message
news:uf**************@TK2MSFTNGP11.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), @CreditCardNumber [varchar](16), @CreditCardExpMonth [varchar](10), @CreditCardExpYear [smallint], @BillingAddress1 [varchar](200), @BillingAddress2 [varchar](200), @BillingCity [varchar](200), @BillingState [varchar](50), @BillingPostalCode [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], [CreditCardNumber], [CreditCardExpMonth], [CreditCardExpYear], [BillingAddress1], [BillingAddress2], [BillingCity], [BillingState], [BillingPostalCode], [EmailAddress], [PhoneAreaCode], [PhoneNumber], [ActivationDate], [RenewalDate], [LastUpdate])
VALUES ( @Username, @Password, @SecretQuestion, @SecretAnswer, @FirstName, @LastName, @BirthMonth, @BirthDay, @BirthYear, @Gender, @SchoolState, @SchoolName, @Classification, @Major, @CreditCardName, @CreditCardType, @CreditCardNumber, @CreditCardExpMonth, @CreditCardExpYear, @BillingAddress1, @BillingAddress2, @BillingCity, @BillingState, @BillingPostalCode, @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.ddlSecretQuestion.SelectedItem
Me.cmdAddMember.Parameters(4).Value = Me.txtSecretAnswer.Text
Me.cmdAddMember.Parameters(5).Value = Me.txtFirstName.Text
Me.cmdAddMember.Parameters(6).Value = Me.txtLastName.Text
Me.cmdAddMember.Parameters(7).Value = Me.ddlBirthMonth.SelectedItem
Me.cmdAddMember.Parameters(8).Value = Me.ddlBirthDay.SelectedItem
Me.cmdAddMember.Parameters(9).Value = Me.txtBirthYear.Text
Me.cmdAddMember.Parameters(10).Value = Me.rbtGender.SelectedItem
Me.cmdAddMember.Parameters(11).Value = Me.ddlSchoolState.SelectedItem
Me.cmdAddMember.Parameters(12).Value = Me.ddlSchoolName.SelectedItem
Me.cmdAddMember.Parameters(13).Value = Me.ddlClassification.SelectedItem
Me.cmdAddMember.Parameters(14).Value = Me.ddlSchoolMajor.SelectedItem
Me.cmdAddMember.Parameters(15).Value = Me.txtCreditCardName.Text
Me.cmdAddMember.Parameters(16).Value = Me.ddlCreditCardType.SelectedItem
Me.cmdAddMember.Parameters(17).Value = Me.txtCreditCardNumber.Text
Me.cmdAddMember.Parameters(18).Value = Me.ddlExpMonth.SelectedItem
Me.cmdAddMember.Parameters(19).Value = Me.ddlExpYear.SelectedItem
Me.cmdAddMember.Parameters(20).Value = Me.txtBillingAddress1.Text
Me.cmdAddMember.Parameters(21).Value = Me.txtBillingAddress2.Text
Me.cmdAddMember.Parameters(22).Value = Me.txtBillingCity.Text
Me.cmdAddMember.Parameters(23).Value = Me.ddlBillingState.SelectedItem
Me.cmdAddMember.Parameters(24).Value = Me.txtBillingZipCode.Text
Me.cmdAddMember.Parameters(25).Value = Me.txtEmail.Text
Me.cmdAddMember.Parameters(26).Value = Me.txtPhonerAreaCode.Text
Me.cmdAddMember.Parameters(27).Value = Me.txtPhone.Text
Me.cmdAddMember.Parameters(28).Value = Me.txtCurrentDate.Text
Me.cmdAddMember.Parameters(29).Value = (Me.txtFutureDate.Text)
Me.cmdAddMember.Parameters(30).Value = (Me.txtCurrentDate.Text)
Me.cmdAddMember.Connection.Open()
Me.cmdAddMember.ExecuteNonQuery()
Me.cmdAddMember.Connection.Close()
Me.txtMemberId.Visible = True
End If
"S. Justin Gengo" <sj*****@aboutfortunate.com> wrote in message news:%2****************@tk2msftngp13.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.txtCurrentDate.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.com> wrote in message news:ug**************@TK2MSFTNGP11.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.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 509: Me.cmdAddMember.Parameters(30).Value = Me.txtCurrentDate.Text Line 510: Me.cmdAddMember.Connection.Open() Line 511: Me.cmdAddMember.ExecuteNonQuery() Line 512: Me.cmdAddMember.Connection.Close() Line 513: Me.txtMemberId.Visible = True
Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 511
Stack Trace:
[InvalidCastException: Object must implement IConvertible.] System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 solo.index.btSubmit_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277
-------------------------------------------------------------------------- -- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.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.InvalidCastException: Object must implement
IConvertible.
Source Error:
Line 508: Me.cmdAddMember.Parameters(30).Value =
Me.txtCurrentDate.Text
Line 509: Me.cmdAddMember.Connection.Open()
Line 510: Me.cmdAddMember.ExecuteNonQuery()
Line 511: Me.cmdAddMember.Connection.Close()
Line 512: Me.txtMemberId.Visible = True
Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 510
Stack Trace:
[InvalidCastException: Object must implement IConvertible.]
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195
solo.index.btSubmit_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\solo\reg\index.aspx.vb:510
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
"William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message
news:uR**************@TK2MSFTNGP11.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.com> wrote in message news:uf**************@TK2MSFTNGP11.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), @CreditCardNumber [varchar](16), @CreditCardExpMonth [varchar](10), @CreditCardExpYear [smallint], @BillingAddress1 [varchar](200), @BillingAddress2 [varchar](200), @BillingCity [varchar](200), @BillingState [varchar](50), @BillingPostalCode [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], [CreditCardNumber], [CreditCardExpMonth], [CreditCardExpYear], [BillingAddress1], [BillingAddress2], [BillingCity], [BillingState], [BillingPostalCode], [EmailAddress], [PhoneAreaCode], [PhoneNumber], [ActivationDate], [RenewalDate], [LastUpdate])
VALUES ( @Username, @Password, @SecretQuestion, @SecretAnswer, @FirstName, @LastName, @BirthMonth, @BirthDay, @BirthYear, @Gender, @SchoolState, @SchoolName, @Classification, @Major, @CreditCardName, @CreditCardType, @CreditCardNumber, @CreditCardExpMonth, @CreditCardExpYear, @BillingAddress1, @BillingAddress2, @BillingCity, @BillingState, @BillingPostalCode, @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.ddlSecretQuestion.SelectedItem
Me.cmdAddMember.Parameters(4).Value = Me.txtSecretAnswer.Text
Me.cmdAddMember.Parameters(5).Value = Me.txtFirstName.Text
Me.cmdAddMember.Parameters(6).Value = Me.txtLastName.Text
Me.cmdAddMember.Parameters(7).Value = Me.ddlBirthMonth.SelectedItem
Me.cmdAddMember.Parameters(8).Value = Me.ddlBirthDay.SelectedItem
Me.cmdAddMember.Parameters(9).Value = Me.txtBirthYear.Text
Me.cmdAddMember.Parameters(10).Value = Me.rbtGender.SelectedItem
Me.cmdAddMember.Parameters(11).Value = Me.ddlSchoolState.SelectedItem
Me.cmdAddMember.Parameters(12).Value = Me.ddlSchoolName.SelectedItem
Me.cmdAddMember.Parameters(13).Value = Me.ddlClassification.SelectedItem
Me.cmdAddMember.Parameters(14).Value = Me.ddlSchoolMajor.SelectedItem
Me.cmdAddMember.Parameters(15).Value = Me.txtCreditCardName.Text
Me.cmdAddMember.Parameters(16).Value = Me.ddlCreditCardType.SelectedItem
Me.cmdAddMember.Parameters(17).Value = Me.txtCreditCardNumber.Text
Me.cmdAddMember.Parameters(18).Value = Me.ddlExpMonth.SelectedItem
Me.cmdAddMember.Parameters(19).Value = Me.ddlExpYear.SelectedItem
Me.cmdAddMember.Parameters(20).Value = Me.txtBillingAddress1.Text
Me.cmdAddMember.Parameters(21).Value = Me.txtBillingAddress2.Text
Me.cmdAddMember.Parameters(22).Value = Me.txtBillingCity.Text
Me.cmdAddMember.Parameters(23).Value = Me.ddlBillingState.SelectedItem
Me.cmdAddMember.Parameters(24).Value = Me.txtBillingZipCode.Text
Me.cmdAddMember.Parameters(25).Value = Me.txtEmail.Text
Me.cmdAddMember.Parameters(26).Value = Me.txtPhonerAreaCode.Text
Me.cmdAddMember.Parameters(27).Value = Me.txtPhone.Text
Me.cmdAddMember.Parameters(28).Value = Me.txtCurrentDate.Text
Me.cmdAddMember.Parameters(29).Value = (Me.txtFutureDate.Text)
Me.cmdAddMember.Parameters(30).Value = (Me.txtCurrentDate.Text)
Me.cmdAddMember.Connection.Open()
Me.cmdAddMember.ExecuteNonQuery()
Me.cmdAddMember.Connection.Close()
Me.txtMemberId.Visible = True
End If
"S. Justin Gengo" <sj*****@aboutfortunate.com> wrote in message news:%2****************@tk2msftngp13.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.txtCurrentDate.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.com> wrote in message news:ug**************@TK2MSFTNGP11.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.InvalidCastException: Object must
implement > IConvertible. > > Source Error: > > Line 509: Me.cmdAddMember.Parameters(30).Value = > Me.txtCurrentDate.Text > Line 510: Me.cmdAddMember.Connection.Open() > Line 511: Me.cmdAddMember.ExecuteNonQuery() > Line 512: Me.cmdAddMember.Connection.Close() > Line 513: Me.txtMemberId.Visible = True > > Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 511 > > Stack Trace: > > [InvalidCastException: Object must implement IConvertible.] > System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 > System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 > solo.index.btSubmit_Click(Object sender, EventArgs e) in > c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511 > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 > >
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo > stBackEvent(String eventArgument) +57 > System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler > sourceControl, String eventArgument) +18 > System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection
postData) +33 > System.Web.UI.Page.ProcessRequestMain() +1277 > > >
-------------------------------------------------------------------------- -- > ---- > Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET > Version:1.1.4322.573 > >
Have you changed any of your code or is it still the same?
bill
"Leon Shaw" <vn*****@msn.com> wrote in message
news:OZ**************@TK2MSFTNGP12.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.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 508: Me.cmdAddMember.Parameters(30).Value = Me.txtCurrentDate.Text Line 509: Me.cmdAddMember.Connection.Open() Line 510: Me.cmdAddMember.ExecuteNonQuery() Line 511: Me.cmdAddMember.Connection.Close() Line 512: Me.txtMemberId.Visible = True
Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 510
Stack Trace:
[InvalidCastException: Object must implement IConvertible.] System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 solo.index.btSubmit_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\solo\reg\index.aspx.vb:510 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 --------------------------------------------------------------------------
-- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET Version:1.1.4322.573 "William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message news:uR**************@TK2MSFTNGP11.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.com> wrote in message news:uf**************@TK2MSFTNGP11.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), @CreditCardNumber [varchar](16), @CreditCardExpMonth [varchar](10), @CreditCardExpYear [smallint], @BillingAddress1 [varchar](200), @BillingAddress2 [varchar](200), @BillingCity [varchar](200), @BillingState [varchar](50), @BillingPostalCode [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], [CreditCardNumber], [CreditCardExpMonth], [CreditCardExpYear], [BillingAddress1], [BillingAddress2], [BillingCity], [BillingState], [BillingPostalCode], [EmailAddress], [PhoneAreaCode], [PhoneNumber], [ActivationDate], [RenewalDate], [LastUpdate])
VALUES ( @Username, @Password, @SecretQuestion, @SecretAnswer, @FirstName, @LastName, @BirthMonth, @BirthDay, @BirthYear, @Gender, @SchoolState, @SchoolName, @Classification, @Major, @CreditCardName, @CreditCardType, @CreditCardNumber, @CreditCardExpMonth, @CreditCardExpYear, @BillingAddress1, @BillingAddress2, @BillingCity, @BillingState, @BillingPostalCode, @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.ddlSecretQuestion.SelectedItem Me.cmdAddMember.Parameters(4).Value = Me.txtSecretAnswer.Text
Me.cmdAddMember.Parameters(5).Value = Me.txtFirstName.Text
Me.cmdAddMember.Parameters(6).Value = Me.txtLastName.Text
Me.cmdAddMember.Parameters(7).Value = Me.ddlBirthMonth.SelectedItem
Me.cmdAddMember.Parameters(8).Value = Me.ddlBirthDay.SelectedItem
Me.cmdAddMember.Parameters(9).Value = Me.txtBirthYear.Text
Me.cmdAddMember.Parameters(10).Value = Me.rbtGender.SelectedItem
Me.cmdAddMember.Parameters(11).Value = Me.ddlSchoolState.SelectedItem
Me.cmdAddMember.Parameters(12).Value = Me.ddlSchoolName.SelectedItem
Me.cmdAddMember.Parameters(13).Value =
Me.ddlClassification.SelectedItem Me.cmdAddMember.Parameters(14).Value = Me.ddlSchoolMajor.SelectedItem
Me.cmdAddMember.Parameters(15).Value = Me.txtCreditCardName.Text
Me.cmdAddMember.Parameters(16).Value =
Me.ddlCreditCardType.SelectedItem Me.cmdAddMember.Parameters(17).Value = Me.txtCreditCardNumber.Text
Me.cmdAddMember.Parameters(18).Value = Me.ddlExpMonth.SelectedItem
Me.cmdAddMember.Parameters(19).Value = Me.ddlExpYear.SelectedItem
Me.cmdAddMember.Parameters(20).Value = Me.txtBillingAddress1.Text
Me.cmdAddMember.Parameters(21).Value = Me.txtBillingAddress2.Text
Me.cmdAddMember.Parameters(22).Value = Me.txtBillingCity.Text
Me.cmdAddMember.Parameters(23).Value = Me.ddlBillingState.SelectedItem
Me.cmdAddMember.Parameters(24).Value = Me.txtBillingZipCode.Text
Me.cmdAddMember.Parameters(25).Value = Me.txtEmail.Text
Me.cmdAddMember.Parameters(26).Value = Me.txtPhonerAreaCode.Text
Me.cmdAddMember.Parameters(27).Value = Me.txtPhone.Text
Me.cmdAddMember.Parameters(28).Value = Me.txtCurrentDate.Text
Me.cmdAddMember.Parameters(29).Value = (Me.txtFutureDate.Text)
Me.cmdAddMember.Parameters(30).Value = (Me.txtCurrentDate.Text)
Me.cmdAddMember.Connection.Open()
Me.cmdAddMember.ExecuteNonQuery()
Me.cmdAddMember.Connection.Close()
Me.txtMemberId.Visible = True
End If
"S. Justin Gengo" <sj*****@aboutfortunate.com> wrote in message news:%2****************@tk2msftngp13.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.txtCurrentDate.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.com> wrote in message > news:ug**************@TK2MSFTNGP11.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.InvalidCastException: Object must implement > > IConvertible. > > > > Source Error: > > > > Line 509: Me.cmdAddMember.Parameters(30).Value = > > Me.txtCurrentDate.Text > > Line 510: Me.cmdAddMember.Connection.Open() > > Line 511: Me.cmdAddMember.ExecuteNonQuery() > > Line 512: Me.cmdAddMember.Connection.Close() > > Line 513: Me.txtMemberId.Visible = True > > > > Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line:
511 > > > > Stack Trace: > > > > [InvalidCastException: Object must implement IConvertible.] > > System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 > > System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 > > solo.index.btSubmit_Click(Object sender, EventArgs e) in > > c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511 > > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 > > > > >
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo > > stBackEvent(String eventArgument) +57 > > System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler > > sourceControl, String eventArgument) +18 > > System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 > > System.Web.UI.Page.ProcessRequestMain() +1277 > > > > > > >
-------------------------------------------------------------------------- > -- > > ---- > > Version Information: Microsoft .NET Framework
Version:1.1.4322.573; > ASP.NET > > Version:1.1.4322.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),
@CreditCardNumber [varchar](16),
@CreditCardExpMonth [varchar](10),
@CreditCardExpYear [smallint],
@BillingAddress1 [varchar](200),
@BillingAddress2 [varchar](200),
@BillingCity [varchar](200),
@BillingState [varchar](50),
@BillingPostalCode [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],
[CreditCardNumber],
[CreditCardExpMonth],
[CreditCardExpYear],
[BillingAddress1],
[BillingAddress2],
[BillingCity],
[BillingState],
[BillingPostalCode],
[EmailAddress],
[PhoneAreaCode],
[PhoneNumber],
[ActivationDate],
[RenewalDate],
[LastUpdate])
VALUES
( @Username,
@Password,
@SecretQuestion,
@SecretAnswer,
@FirstName,
@LastName,
@BirthMonth,
@BirthDay,
@BirthYear,
@Gender,
@SchoolState,
@SchoolName,
@Classification,
@Major,
@CreditCardName,
@CreditCardType,
@CreditCardNumber,
@CreditCardExpMonth,
@CreditCardExpYear,
@BillingAddress1,
@BillingAddress2,
@BillingCity,
@BillingState,
@BillingPostalCode,
@EmailAddress,
@PhoneAreaCode,
@PhoneNumber,
@ActivationDate,
@RenewalDate,
@LastUpdate)
SELECT
MemberID = @@IDENTITY
GO
"William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message
news:%2***************@tk2msftngp13.phx.gbl... Have you changed any of your code or is it still the same?
bill
"Leon Shaw" <vn*****@msn.com> wrote in message news:OZ**************@TK2MSFTNGP12.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.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 508: Me.cmdAddMember.Parameters(30).Value = Me.txtCurrentDate.Text Line 509: Me.cmdAddMember.Connection.Open() Line 510: Me.cmdAddMember.ExecuteNonQuery() Line 511: Me.cmdAddMember.Connection.Close() Line 512: Me.txtMemberId.Visible = True
Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 510
Stack Trace:
[InvalidCastException: Object must implement IConvertible.] System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 solo.index.btSubmit_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\solo\reg\index.aspx.vb:510 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
+33 System.Web.UI.Page.ProcessRequestMain() +1277
-------------------------------------------------------------------------- -- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 "William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message news:uR**************@TK2MSFTNGP11.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.com> wrote in message news:uf**************@TK2MSFTNGP11.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), > @CreditCardNumber [varchar](16), > @CreditCardExpMonth [varchar](10), > @CreditCardExpYear [smallint], > @BillingAddress1 [varchar](200), > @BillingAddress2 [varchar](200), > @BillingCity [varchar](200), > @BillingState [varchar](50), > @BillingPostalCode [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], > [CreditCardNumber], > [CreditCardExpMonth], > [CreditCardExpYear], > [BillingAddress1], > [BillingAddress2], > [BillingCity], > [BillingState], > [BillingPostalCode], > [EmailAddress], > [PhoneAreaCode], > [PhoneNumber], > [ActivationDate], > [RenewalDate], > [LastUpdate]) > > VALUES > ( @Username, > @Password, > @SecretQuestion, > @SecretAnswer, > @FirstName, > @LastName, > @BirthMonth, > @BirthDay, > @BirthYear, > @Gender, > @SchoolState, > @SchoolName, > @Classification, > @Major, > @CreditCardName, > @CreditCardType, > @CreditCardNumber, > @CreditCardExpMonth, > @CreditCardExpYear, > @BillingAddress1, > @BillingAddress2, > @BillingCity, > @BillingState, > @BillingPostalCode, > @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.ddlSecretQuestion.SelectedItem > > Me.cmdAddMember.Parameters(4).Value = Me.txtSecretAnswer.Text > > Me.cmdAddMember.Parameters(5).Value = Me.txtFirstName.Text > > Me.cmdAddMember.Parameters(6).Value = Me.txtLastName.Text > > Me.cmdAddMember.Parameters(7).Value = Me.ddlBirthMonth.SelectedItem > > Me.cmdAddMember.Parameters(8).Value = Me.ddlBirthDay.SelectedItem > > Me.cmdAddMember.Parameters(9).Value = Me.txtBirthYear.Text > > Me.cmdAddMember.Parameters(10).Value = Me.rbtGender.SelectedItem > > Me.cmdAddMember.Parameters(11).Value =
Me.ddlSchoolState.SelectedItem > > Me.cmdAddMember.Parameters(12).Value = Me.ddlSchoolName.SelectedItem > > Me.cmdAddMember.Parameters(13).Value = Me.ddlClassification.SelectedItem > > Me.cmdAddMember.Parameters(14).Value =
Me.ddlSchoolMajor.SelectedItem > > Me.cmdAddMember.Parameters(15).Value = Me.txtCreditCardName.Text > > Me.cmdAddMember.Parameters(16).Value = Me.ddlCreditCardType.SelectedItem > > Me.cmdAddMember.Parameters(17).Value = Me.txtCreditCardNumber.Text > > Me.cmdAddMember.Parameters(18).Value = Me.ddlExpMonth.SelectedItem > > Me.cmdAddMember.Parameters(19).Value = Me.ddlExpYear.SelectedItem > > Me.cmdAddMember.Parameters(20).Value = Me.txtBillingAddress1.Text > > Me.cmdAddMember.Parameters(21).Value = Me.txtBillingAddress2.Text > > Me.cmdAddMember.Parameters(22).Value = Me.txtBillingCity.Text > > Me.cmdAddMember.Parameters(23).Value =
Me.ddlBillingState.SelectedItem > > Me.cmdAddMember.Parameters(24).Value = Me.txtBillingZipCode.Text > > Me.cmdAddMember.Parameters(25).Value = Me.txtEmail.Text > > Me.cmdAddMember.Parameters(26).Value = Me.txtPhonerAreaCode.Text > > Me.cmdAddMember.Parameters(27).Value = Me.txtPhone.Text > > Me.cmdAddMember.Parameters(28).Value = Me.txtCurrentDate.Text > > Me.cmdAddMember.Parameters(29).Value = (Me.txtFutureDate.Text) > > Me.cmdAddMember.Parameters(30).Value = (Me.txtCurrentDate.Text) > > Me.cmdAddMember.Connection.Open() > > Me.cmdAddMember.ExecuteNonQuery() > > Me.cmdAddMember.Connection.Close() > > Me.txtMemberId.Visible = True > > End If > > "S. Justin Gengo" <sj*****@aboutfortunate.com> wrote in message > news:%2****************@tk2msftngp13.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.txtCurrentDate.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.com> wrote in message > > news:ug**************@TK2MSFTNGP11.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.InvalidCastException: Object must implement > > > IConvertible. > > > > > > Source Error: > > > > > > Line 509: Me.cmdAddMember.Parameters(30).Value = > > > Me.txtCurrentDate.Text > > > Line 510: Me.cmdAddMember.Connection.Open() > > > Line 511: Me.cmdAddMember.ExecuteNonQuery() > > > Line 512: Me.cmdAddMember.Connection.Close() > > > Line 513: Me.txtMemberId.Visible = True > > > > > > Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 511 > > > > > > Stack Trace: > > > > > > [InvalidCastException: Object must implement IConvertible.] > > >
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior > > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 > > > System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 > > > solo.index.btSubmit_Click(Object sender, EventArgs e) in > > > c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511 > > > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 > > > > > > > > >
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo > > > stBackEvent(String eventArgument) +57 > > > System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler > > > sourceControl, String eventArgument) +18 > > > System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) > +33 > > > System.Web.UI.Page.ProcessRequestMain() +1277 > > > > > > > > > > > >
-------------------------------------------------------------------------- > > -- > > > ---- > > > Version Information: Microsoft .NET Framework Version:1.1.4322.573; > > ASP.NET > > > Version:1.1.4322.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.adptAddMember.InsertCommand = Me.SqlInsertCommand1
Me.adptAddMember.SelectCommand = Me.SqlSelectCommand1
Me.adptAddMember.TableMappings.AddRange(New
System.Data.Common.DataTableMapping() {New
System.Data.Common.DataTableMapping("Table", "Add_Member", New
System.Data.Common.DataColumnMapping() {New
System.Data.Common.DataColumnMapping("MemberID", "MemberID")})})
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "[Add_Member]"
Me.SqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure
Me.SqlSelectCommand1.Connection = Me.connReg
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@RETURN_VALUE" ,
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue,
False, CType(10, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Username",
System.Data.SqlDbType.VarChar, 20))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Password",
System.Data.SqlDbType.VarChar, 16))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SecretQuestio n",
System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SecretAnswer" ,
System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@FirstName",
System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@LastName",
System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BirthMonth",
System.Data.SqlDbType.VarChar, 10))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BirthDay",
System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input,
False, CType(3, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BirthYear",
System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Gender", System.Data.SqlDbType.VarChar,
6))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SchoolState",
System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SchoolName",
System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Classificatio n",
System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Major", System.Data.SqlDbType.VarChar,
120))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardNam e",
System.Data.SqlDbType.VarChar, 120))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardTyp e",
System.Data.SqlDbType.VarChar, 20))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardNum ber",
System.Data.SqlDbType.VarChar, 16))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardExp Month",
System.Data.SqlDbType.VarChar, 10))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardExp Year",
System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingAddres s1",
System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingAddres s2",
System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingCity",
System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingState" ,
System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingPostal Code",
System.Data.SqlDbType.VarChar, 10))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@EmailAddress" ,
System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@PhoneAreaCode ",
System.Data.SqlDbType.VarChar, 3))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@PhoneNumber",
System.Data.SqlDbType.VarChar, 8))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ActivationDat e",
System.Data.SqlDbType.DateTime, 8))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@RenewalDate",
System.Data.SqlDbType.DateTime, 8))
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@LastUpdate",
System.Data.SqlDbType.DateTime, 8))
'
'SqlInsertCommand1
'
Me.SqlInsertCommand1.CommandText = "[Add_Member]"
Me.SqlInsertCommand1.CommandType = System.Data.CommandType.StoredProcedure
Me.SqlInsertCommand1.Connection = Me.connReg
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@RETURN_VALUE" ,
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue,
False, CType(10, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Username",
System.Data.SqlDbType.VarChar, 20))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Password",
System.Data.SqlDbType.VarChar, 16))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SecretQuestio n",
System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SecretAnswer" ,
System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@FirstName",
System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@LastName",
System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BirthMonth",
System.Data.SqlDbType.VarChar, 10))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BirthDay",
System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input,
False, CType(3, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BirthYear",
System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Gender", System.Data.SqlDbType.VarChar,
6))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SchoolState",
System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SchoolName",
System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Classificatio n",
System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Major", System.Data.SqlDbType.VarChar,
120))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardNam e",
System.Data.SqlDbType.VarChar, 120))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardTyp e",
System.Data.SqlDbType.VarChar, 20))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardNum ber",
System.Data.SqlDbType.VarChar, 16))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardExp Month",
System.Data.SqlDbType.VarChar, 10))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CreditCardExp Year",
System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input,
False, CType(5, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingAddres s1",
System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingAddres s2",
System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingCity",
System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingState" ,
System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@BillingPostal Code",
System.Data.SqlDbType.VarChar, 10))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@EmailAddress" ,
System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@PhoneAreaCode ",
System.Data.SqlDbType.VarChar, 3))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@PhoneNumber",
System.Data.SqlDbType.VarChar, 8))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ActivationDat e",
System.Data.SqlDbType.DateTime, 8))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@RenewalDate",
System.Data.SqlDbType.DateTime, 8))
Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@LastUpdate",
System.Data.SqlDbType.DateTime, 8))
'
'dsAddMember
'
Me.dsAddMember.DataSetName = "dsAddMember"
Me.dsAddMember.Locale = New System.Globalization.CultureInfo("en-US")
Me.dsAddMember.Namespace = "http://www.tempuri.org/dsAddMember.xsd"
CType(Me.dsClassification,
System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsCreditCard, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsDay, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsGender, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsMajor, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsMonth, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsMySchool, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsSecretQuestion,
System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsState, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsYear, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsAddMember, System.ComponentModel.ISupportInitialize).EndInit( )
If Me.IsValid = True Then
Me.adptAddMember.InsertCommand.Parameters(0).Value = Me.txtUsername.Text
Me.adptAddMember.InsertCommand.Parameters(1).Value = Me.txtPassword.Text
Me.adptAddMember.InsertCommand.Parameters(2).Value =
Me.ddlSecretQuestion.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(3).Value = Me.txtSecretAnswer.Text
Me.adptAddMember.InsertCommand.Parameters(4).Value = Me.txtFirstName.Text
Me.adptAddMember.InsertCommand.Parameters(5).Value = Me.txtLastName.Text
Me.adptAddMember.InsertCommand.Parameters(6).Value =
Me.ddlBirthMonth.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(7).Value =
Me.ddlBirthDay.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(8).Value = Me.txtBirthYear.Text
Me.adptAddMember.InsertCommand.Parameters(9).Value =
Me.rbtGender.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
Me.ddlSchoolState.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
Me.ddlSchoolName.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
Me.ddlClassification.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
Me.ddlSchoolMajor.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
Me.txtCreditCardName.Text
Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
Me.ddlCreditCardType.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
Me.txtCreditCardNumber.Text
Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
Me.ddlExpMonth.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
Me.ddlExpYear.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
Me.txtBillingAddress1.Text
Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
Me.txtBillingAddress2.Text
Me.adptAddMember.InsertCommand.Parameters(21).Valu e = Me.txtBillingCity.Text
Me.adptAddMember.InsertCommand.Parameters(22).Valu e =
Me.ddlBillingState.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
Me.txtBillingZipCode.Text
Me.adptAddMember.InsertCommand.Parameters(24).Valu e = Me.txtEmail.Text
Me.adptAddMember.InsertCommand.Parameters(25).Valu e =
Me.txtPhonerAreaCode.Text
Me.adptAddMember.InsertCommand.Parameters(26).Valu e = Me.txtPhone.Text
Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtCurrentDate.Text
Me.adptAddMember.InsertCommand.Parameters(28).Valu e = Me.txtFutureDate.Text
Me.adptAddMember.InsertCommand.Parameters(29).Valu e = Me.txtCurrentDate.Text
Me.adptAddMember.Fill(Me.dsAddMember)
Me.adptAddMember.Update(Me.dsAddMember)
End If
End Sub
"William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message
news:e2**************@TK2MSFTNGP09.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.com> wrote in message news:ez*************@tk2msftngp13.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), @CreditCardNumber [varchar](16), @CreditCardExpMonth [varchar](10), @CreditCardExpYear [smallint], @BillingAddress1 [varchar](200), @BillingAddress2 [varchar](200), @BillingCity [varchar](200), @BillingState [varchar](50), @BillingPostalCode [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], [CreditCardNumber], [CreditCardExpMonth], [CreditCardExpYear], [BillingAddress1], [BillingAddress2], [BillingCity], [BillingState], [BillingPostalCode], [EmailAddress], [PhoneAreaCode], [PhoneNumber], [ActivationDate], [RenewalDate], [LastUpdate])
VALUES ( @Username, @Password, @SecretQuestion, @SecretAnswer, @FirstName, @LastName, @BirthMonth, @BirthDay, @BirthYear, @Gender, @SchoolState, @SchoolName, @Classification, @Major, @CreditCardName, @CreditCardType, @CreditCardNumber, @CreditCardExpMonth, @CreditCardExpYear, @BillingAddress1, @BillingAddress2, @BillingCity, @BillingState, @BillingPostalCode, @EmailAddress, @PhoneAreaCode, @PhoneNumber, @ActivationDate, @RenewalDate, @LastUpdate)
SELECT MemberID = @@IDENTITY GO
"William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message news:%2***************@tk2msftngp13.phx.gbl... Have you changed any of your code or is it still the same?
bill
"Leon Shaw" <vn*****@msn.com> wrote in message news:OZ**************@TK2MSFTNGP12.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.InvalidCastException: Object must
implement > IConvertible. > > Source Error: > > Line 508: Me.cmdAddMember.Parameters(30).Value = > Me.txtCurrentDate.Text > Line 509: Me.cmdAddMember.Connection.Open() > Line 510: Me.cmdAddMember.ExecuteNonQuery() > Line 511: Me.cmdAddMember.Connection.Close() > Line 512: Me.txtMemberId.Visible = True > > Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 510 > > Stack Trace: > > [InvalidCastException: Object must implement IConvertible.] > System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 > System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 > solo.index.btSubmit_Click(Object sender, EventArgs e) in > c:\inetpub\wwwroot\solo\reg\index.aspx.vb:510 > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 > >
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo > stBackEvent(String eventArgument) +57 > System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler > sourceControl, String eventArgument) +18 > System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection
postData) +33 > System.Web.UI.Page.ProcessRequestMain() +1277 > > >
-------------------------------------------------------------------------- -- > ---- > Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET > Version:1.1.4322.573 > "William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message > news:uR**************@TK2MSFTNGP11.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.com> wrote in message > > news:uf**************@TK2MSFTNGP11.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), > > > @CreditCardNumber [varchar](16), > > > @CreditCardExpMonth [varchar](10), > > > @CreditCardExpYear [smallint], > > > @BillingAddress1 [varchar](200), > > > @BillingAddress2 [varchar](200), > > > @BillingCity [varchar](200), > > > @BillingState [varchar](50), > > > @BillingPostalCode [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], > > > [CreditCardNumber], > > > [CreditCardExpMonth], > > > [CreditCardExpYear], > > > [BillingAddress1], > > > [BillingAddress2], > > > [BillingCity], > > > [BillingState], > > > [BillingPostalCode], > > > [EmailAddress], > > > [PhoneAreaCode], > > > [PhoneNumber], > > > [ActivationDate], > > > [RenewalDate], > > > [LastUpdate]) > > > > > > VALUES > > > ( @Username, > > > @Password, > > > @SecretQuestion, > > > @SecretAnswer, > > > @FirstName, > > > @LastName, > > > @BirthMonth, > > > @BirthDay, > > > @BirthYear, > > > @Gender, > > > @SchoolState, > > > @SchoolName, > > > @Classification, > > > @Major, > > > @CreditCardName, > > > @CreditCardType, > > > @CreditCardNumber, > > > @CreditCardExpMonth, > > > @CreditCardExpYear, > > > @BillingAddress1, > > > @BillingAddress2, > > > @BillingCity, > > > @BillingState, > > > @BillingPostalCode, > > > @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.ddlSecretQuestion.SelectedItem > > > > > > Me.cmdAddMember.Parameters(4).Value = Me.txtSecretAnswer.Text > > > > > > Me.cmdAddMember.Parameters(5).Value = Me.txtFirstName.Text > > > > > > Me.cmdAddMember.Parameters(6).Value = Me.txtLastName.Text > > > > > > Me.cmdAddMember.Parameters(7).Value = Me.ddlBirthMonth.SelectedItem > > > > > > Me.cmdAddMember.Parameters(8).Value =
Me.ddlBirthDay.SelectedItem > > > > > > Me.cmdAddMember.Parameters(9).Value = Me.txtBirthYear.Text > > > > > > Me.cmdAddMember.Parameters(10).Value = Me.rbtGender.SelectedItem > > > > > > Me.cmdAddMember.Parameters(11).Value =
Me.ddlSchoolState.SelectedItem > > > > > > Me.cmdAddMember.Parameters(12).Value =
Me.ddlSchoolName.SelectedItem > > > > > > Me.cmdAddMember.Parameters(13).Value = Me.ddlClassification.SelectedItem > > > > > > Me.cmdAddMember.Parameters(14).Value = Me.ddlSchoolMajor.SelectedItem > > > > > > Me.cmdAddMember.Parameters(15).Value = Me.txtCreditCardName.Text > > > > > > Me.cmdAddMember.Parameters(16).Value = Me.ddlCreditCardType.SelectedItem > > > > > > Me.cmdAddMember.Parameters(17).Value =
Me.txtCreditCardNumber.Text > > > > > > Me.cmdAddMember.Parameters(18).Value =
Me.ddlExpMonth.SelectedItem > > > > > > Me.cmdAddMember.Parameters(19).Value =
Me.ddlExpYear.SelectedItem > > > > > > Me.cmdAddMember.Parameters(20).Value =
Me.txtBillingAddress1.Text > > > > > > Me.cmdAddMember.Parameters(21).Value =
Me.txtBillingAddress2.Text > > > > > > Me.cmdAddMember.Parameters(22).Value = Me.txtBillingCity.Text > > > > > > Me.cmdAddMember.Parameters(23).Value = Me.ddlBillingState.SelectedItem > > > > > > Me.cmdAddMember.Parameters(24).Value = Me.txtBillingZipCode.Text > > > > > > Me.cmdAddMember.Parameters(25).Value = Me.txtEmail.Text > > > > > > Me.cmdAddMember.Parameters(26).Value = Me.txtPhonerAreaCode.Text > > > > > > Me.cmdAddMember.Parameters(27).Value = Me.txtPhone.Text > > > > > > Me.cmdAddMember.Parameters(28).Value = Me.txtCurrentDate.Text > > > > > > Me.cmdAddMember.Parameters(29).Value = (Me.txtFutureDate.Text) > > > > > > Me.cmdAddMember.Parameters(30).Value = (Me.txtCurrentDate.Text) > > > > > > Me.cmdAddMember.Connection.Open() > > > > > > Me.cmdAddMember.ExecuteNonQuery() > > > > > > Me.cmdAddMember.Connection.Close() > > > > > > Me.txtMemberId.Visible = True > > > > > > End If > > > > > > "S. Justin Gengo" <sj*****@aboutfortunate.com> wrote in message > > > news:%2****************@tk2msftngp13.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.txtCurrentDate.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.com> wrote in message > > > > news:ug**************@TK2MSFTNGP11.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.InvalidCastException: Object must > implement > > > > > IConvertible. > > > > > > > > > > Source Error: > > > > > > > > > > Line 509: Me.cmdAddMember.Parameters(30).Value = > > > > > Me.txtCurrentDate.Text > > > > > Line 510: Me.cmdAddMember.Connection.Open() > > > > > Line 511: Me.cmdAddMember.ExecuteNonQuery() > > > > > Line 512: Me.cmdAddMember.Connection.Close() > > > > > Line 513: Me.txtMemberId.Visible = True > > > > > > > > > > Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: 511 > > > > > > > > > > Stack Trace: > > > > > > > > > > [InvalidCastException: Object must implement IConvertible.] > > > > > System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior > > > > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 > > > > > System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 > > > > > solo.index.btSubmit_Click(Object sender, EventArgs e) in > > > > > c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511 > > > > > System.Web.UI.WebControls.Button.OnClick(EventArgs e)
+108 > > > > > > > > > > > > > > > > > > > >
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo > > > > > stBackEvent(String eventArgument) +57 > > > > >
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler > > > > > sourceControl, String eventArgument) +18 > > > > > System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection > postData) > > > +33 > > > > > System.Web.UI.Page.ProcessRequestMain() +1277 > > > > > > > > > > > > > > > > > > > > > > > > >
-------------------------------------------------------------------------- > > > > -- > > > > > ---- > > > > > Version Information: Microsoft .NET Framework Version:1.1.4322.573; > > > > ASP.NET > > > > > Version:1.1.4322.573 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
reply to my email for continuing this...
bill
"Leon Shaw" <vn*****@msn.com> wrote in message
news:OA**************@TK2MSFTNGP11.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.adptAddMember.InsertCommand = Me.SqlInsertCommand1
Me.adptAddMember.SelectCommand = Me.SqlSelectCommand1
Me.adptAddMember.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "Add_Member", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("MemberID", "MemberID")})})
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "[Add_Member]"
Me.SqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure
Me.SqlSelectCommand1.Connection = Me.connReg
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE" , System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(10, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Username", System.Data.SqlDbType.VarChar, 20))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Password", System.Data.SqlDbType.VarChar, 16))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SecretQuestio n", System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SecretAnswer" , System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FirstName", System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastName", System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BirthMonth", System.Data.SqlDbType.VarChar, 10))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BirthDay", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, False, CType(3, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BirthYear", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Gender",
System.Data.SqlDbType.VarChar, 6))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SchoolState", System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SchoolName", System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Classificatio n", System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Major",
System.Data.SqlDbType.VarChar, 120))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardNam e", System.Data.SqlDbType.VarChar, 120))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardTyp e", System.Data.SqlDbType.VarChar, 20))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardNum ber", System.Data.SqlDbType.VarChar, 16))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardExp Month", System.Data.SqlDbType.VarChar, 10))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardExp Year", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingAddres s1", System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingAddres s2", System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingCity", System.Data.SqlDbType.VarChar, 200))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingState" , System.Data.SqlDbType.VarChar, 50))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingPostal Code", System.Data.SqlDbType.VarChar, 10))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@EmailAddress" , System.Data.SqlDbType.VarChar, 64))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PhoneAreaCode ", System.Data.SqlDbType.VarChar, 3))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PhoneNumber", System.Data.SqlDbType.VarChar, 8))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ActivationDat e", System.Data.SqlDbType.DateTime, 8))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RenewalDate", System.Data.SqlDbType.DateTime, 8))
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastUpdate", System.Data.SqlDbType.DateTime, 8))
'
'SqlInsertCommand1
'
Me.SqlInsertCommand1.CommandText = "[Add_Member]"
Me.SqlInsertCommand1.CommandType = System.Data.CommandType.StoredProcedure
Me.SqlInsertCommand1.Connection = Me.connReg
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE" , System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(10, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Username", System.Data.SqlDbType.VarChar, 20))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Password", System.Data.SqlDbType.VarChar, 16))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SecretQuestio n", System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SecretAnswer" , System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FirstName", System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastName", System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BirthMonth", System.Data.SqlDbType.VarChar, 10))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BirthDay", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, False, CType(3, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BirthYear", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Gender",
System.Data.SqlDbType.VarChar, 6))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SchoolState", System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SchoolName", System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Classificatio n", System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Major",
System.Data.SqlDbType.VarChar, 120))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardNam e", System.Data.SqlDbType.VarChar, 120))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardTyp e", System.Data.SqlDbType.VarChar, 20))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardNum ber", System.Data.SqlDbType.VarChar, 16))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardExp Month", System.Data.SqlDbType.VarChar, 10))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreditCardExp Year", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingAddres s1", System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingAddres s2", System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingCity", System.Data.SqlDbType.VarChar, 200))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingState" , System.Data.SqlDbType.VarChar, 50))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BillingPostal Code", System.Data.SqlDbType.VarChar, 10))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@EmailAddress" , System.Data.SqlDbType.VarChar, 64))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PhoneAreaCode ", System.Data.SqlDbType.VarChar, 3))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PhoneNumber", System.Data.SqlDbType.VarChar, 8))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ActivationDat e", System.Data.SqlDbType.DateTime, 8))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RenewalDate", System.Data.SqlDbType.DateTime, 8))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastUpdate", System.Data.SqlDbType.DateTime, 8))
'
'dsAddMember
'
Me.dsAddMember.DataSetName = "dsAddMember"
Me.dsAddMember.Locale = New System.Globalization.CultureInfo("en-US")
Me.dsAddMember.Namespace = "http://www.tempuri.org/dsAddMember.xsd"
CType(Me.dsClassification, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsCreditCard, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsDay, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsGender, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsMajor, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsMonth, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsMySchool, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsSecretQuestion, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsState, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsYear, System.ComponentModel.ISupportInitialize).EndInit( )
CType(Me.dsAddMember, System.ComponentModel.ISupportInitialize).EndInit( )
If Me.IsValid = True Then
Me.adptAddMember.InsertCommand.Parameters(0).Value = Me.txtUsername.Text
Me.adptAddMember.InsertCommand.Parameters(1).Value = Me.txtPassword.Text
Me.adptAddMember.InsertCommand.Parameters(2).Value = Me.ddlSecretQuestion.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(3).Value =
Me.txtSecretAnswer.Text Me.adptAddMember.InsertCommand.Parameters(4).Value = Me.txtFirstName.Text
Me.adptAddMember.InsertCommand.Parameters(5).Value = Me.txtLastName.Text
Me.adptAddMember.InsertCommand.Parameters(6).Value = Me.ddlBirthMonth.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(7).Value = Me.ddlBirthDay.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(8).Value = Me.txtBirthYear.Text
Me.adptAddMember.InsertCommand.Parameters(9).Value = Me.rbtGender.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(10).Valu e = Me.ddlSchoolState.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(11).Valu e = Me.ddlSchoolName.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(12).Valu e = Me.ddlClassification.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(13).Valu e = Me.ddlSchoolMajor.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(14).Valu e = Me.txtCreditCardName.Text
Me.adptAddMember.InsertCommand.Parameters(15).Valu e = Me.ddlCreditCardType.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(16).Valu e = Me.txtCreditCardNumber.Text
Me.adptAddMember.InsertCommand.Parameters(17).Valu e = Me.ddlExpMonth.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(18).Valu e = Me.ddlExpYear.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(19).Valu e = Me.txtBillingAddress1.Text
Me.adptAddMember.InsertCommand.Parameters(20).Valu e = Me.txtBillingAddress2.Text
Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
Me.txtBillingCity.Text Me.adptAddMember.InsertCommand.Parameters(22).Valu e = Me.ddlBillingState.SelectedItem
Me.adptAddMember.InsertCommand.Parameters(23).Valu e = Me.txtBillingZipCode.Text
Me.adptAddMember.InsertCommand.Parameters(24).Valu e = Me.txtEmail.Text
Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtPhonerAreaCode.Text
Me.adptAddMember.InsertCommand.Parameters(26).Valu e = Me.txtPhone.Text
Me.adptAddMember.InsertCommand.Parameters(27).Valu e =
Me.txtCurrentDate.Text Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
Me.txtFutureDate.Text Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
Me.txtCurrentDate.Text Me.adptAddMember.Fill(Me.dsAddMember)
Me.adptAddMember.Update(Me.dsAddMember)
End If
End Sub
"William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message news:e2**************@TK2MSFTNGP09.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.com> wrote in message news:ez*************@tk2msftngp13.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), @CreditCardNumber [varchar](16), @CreditCardExpMonth [varchar](10), @CreditCardExpYear [smallint], @BillingAddress1 [varchar](200), @BillingAddress2 [varchar](200), @BillingCity [varchar](200), @BillingState [varchar](50), @BillingPostalCode [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], [CreditCardNumber], [CreditCardExpMonth], [CreditCardExpYear], [BillingAddress1], [BillingAddress2], [BillingCity], [BillingState], [BillingPostalCode], [EmailAddress], [PhoneAreaCode], [PhoneNumber], [ActivationDate], [RenewalDate], [LastUpdate])
VALUES ( @Username, @Password, @SecretQuestion, @SecretAnswer, @FirstName, @LastName, @BirthMonth, @BirthDay, @BirthYear, @Gender, @SchoolState, @SchoolName, @Classification, @Major, @CreditCardName, @CreditCardType, @CreditCardNumber, @CreditCardExpMonth, @CreditCardExpYear, @BillingAddress1, @BillingAddress2, @BillingCity, @BillingState, @BillingPostalCode, @EmailAddress, @PhoneAreaCode, @PhoneNumber, @ActivationDate, @RenewalDate, @LastUpdate)
SELECT MemberID = @@IDENTITY GO
"William F. Robertson, Jr." <wf*********@kpmg.com> wrote in message news:%2***************@tk2msftngp13.phx.gbl... > Have you changed any of your code or is it still the same? > > bill > > > "Leon Shaw" <vn*****@msn.com> wrote in message > news:OZ**************@TK2MSFTNGP12.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.InvalidCastException: Object must implement > > IConvertible. > > > > Source Error: > > > > Line 508: Me.cmdAddMember.Parameters(30).Value = > > Me.txtCurrentDate.Text > > Line 509: Me.cmdAddMember.Connection.Open() > > Line 510: Me.cmdAddMember.ExecuteNonQuery() > > Line 511: Me.cmdAddMember.Connection.Close() > > Line 512: Me.txtMemberId.Visible = True > > > > Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line:
510 > > > > Stack Trace: > > > > [InvalidCastException: Object must implement IConvertible.] > > System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 > > System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 > > solo.index.btSubmit_Click(Object sender, EventArgs e) in > > c:\inetpub\wwwroot\solo\reg\index.aspx.vb:510 > > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 > > > > >
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo > > stBackEvent(String eventArgument) +57 > > System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler > > sourceControl, String eventArgument) +18 > > System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 > > System.Web.UI.Page.ProcessRequestMain() +1277 > > > > > > >
-------------------------------------------------------------------------- > -- > > ---- > > Version Information: Microsoft .NET Framework
Version:1.1.4322.573; > ASP.NET > > Version:1.1.4322.573 > > "William F. Robertson, Jr." <wf*********@kpmg.com> wrote in
message > > news:uR**************@TK2MSFTNGP11.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.com> wrote in message > > > news:uf**************@TK2MSFTNGP11.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), > > > > @CreditCardNumber [varchar](16), > > > > @CreditCardExpMonth [varchar](10), > > > > @CreditCardExpYear [smallint], > > > > @BillingAddress1 [varchar](200), > > > > @BillingAddress2 [varchar](200), > > > > @BillingCity [varchar](200), > > > > @BillingState [varchar](50), > > > > @BillingPostalCode [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], > > > > [CreditCardNumber], > > > > [CreditCardExpMonth], > > > > [CreditCardExpYear], > > > > [BillingAddress1], > > > > [BillingAddress2], > > > > [BillingCity], > > > > [BillingState], > > > > [BillingPostalCode], > > > > [EmailAddress], > > > > [PhoneAreaCode], > > > > [PhoneNumber], > > > > [ActivationDate], > > > > [RenewalDate], > > > > [LastUpdate]) > > > > > > > > VALUES > > > > ( @Username, > > > > @Password, > > > > @SecretQuestion, > > > > @SecretAnswer, > > > > @FirstName, > > > > @LastName, > > > > @BirthMonth, > > > > @BirthDay, > > > > @BirthYear, > > > > @Gender, > > > > @SchoolState, > > > > @SchoolName, > > > > @Classification, > > > > @Major, > > > > @CreditCardName, > > > > @CreditCardType, > > > > @CreditCardNumber, > > > > @CreditCardExpMonth, > > > > @CreditCardExpYear, > > > > @BillingAddress1, > > > > @BillingAddress2, > > > > @BillingCity, > > > > @BillingState, > > > > @BillingPostalCode, > > > > @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.ddlSecretQuestion.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(4).Value = Me.txtSecretAnswer.Text > > > > > > > > Me.cmdAddMember.Parameters(5).Value = Me.txtFirstName.Text > > > > > > > > Me.cmdAddMember.Parameters(6).Value = Me.txtLastName.Text > > > > > > > > Me.cmdAddMember.Parameters(7).Value = Me.ddlBirthMonth.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(8).Value =
Me.ddlBirthDay.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(9).Value = Me.txtBirthYear.Text > > > > > > > > Me.cmdAddMember.Parameters(10).Value =
Me.rbtGender.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(11).Value = Me.ddlSchoolState.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(12).Value = Me.ddlSchoolName.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(13).Value = > Me.ddlClassification.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(14).Value = Me.ddlSchoolMajor.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(15).Value =
Me.txtCreditCardName.Text > > > > > > > > Me.cmdAddMember.Parameters(16).Value = > Me.ddlCreditCardType.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(17).Value = Me.txtCreditCardNumber.Text > > > > > > > > Me.cmdAddMember.Parameters(18).Value = Me.ddlExpMonth.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(19).Value = Me.ddlExpYear.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(20).Value = Me.txtBillingAddress1.Text > > > > > > > > Me.cmdAddMember.Parameters(21).Value = Me.txtBillingAddress2.Text > > > > > > > > Me.cmdAddMember.Parameters(22).Value = Me.txtBillingCity.Text > > > > > > > > Me.cmdAddMember.Parameters(23).Value = Me.ddlBillingState.SelectedItem > > > > > > > > Me.cmdAddMember.Parameters(24).Value =
Me.txtBillingZipCode.Text > > > > > > > > Me.cmdAddMember.Parameters(25).Value = Me.txtEmail.Text > > > > > > > > Me.cmdAddMember.Parameters(26).Value =
Me.txtPhonerAreaCode.Text > > > > > > > > Me.cmdAddMember.Parameters(27).Value = Me.txtPhone.Text > > > > > > > > Me.cmdAddMember.Parameters(28).Value = Me.txtCurrentDate.Text > > > > > > > > Me.cmdAddMember.Parameters(29).Value = (Me.txtFutureDate.Text) > > > > > > > > Me.cmdAddMember.Parameters(30).Value =
(Me.txtCurrentDate.Text) > > > > > > > > Me.cmdAddMember.Connection.Open() > > > > > > > > Me.cmdAddMember.ExecuteNonQuery() > > > > > > > > Me.cmdAddMember.Connection.Close() > > > > > > > > Me.txtMemberId.Visible = True > > > > > > > > End If > > > > > > > > "S. Justin Gengo" <sj*****@aboutfortunate.com> wrote in
message > > > > news:%2****************@tk2msftngp13.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.txtCurrentDate.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.com> wrote in message > > > > > news:ug**************@TK2MSFTNGP11.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.InvalidCastException: Object
must > > implement > > > > > > IConvertible. > > > > > > > > > > > > Source Error: > > > > > > > > > > > > Line 509: Me.cmdAddMember.Parameters(30).Value
= > > > > > > Me.txtCurrentDate.Text > > > > > > Line 510: Me.cmdAddMember.Connection.Open() > > > > > > Line 511: Me.cmdAddMember.ExecuteNonQuery() > > > > > > Line 512: Me.cmdAddMember.Connection.Close() > > > > > > Line 513: Me.txtMemberId.Visible = True > > > > > > > > > > > > Source File: c:\inetpub\wwwroot\solo\reg\index.aspx.vb Line: > 511 > > > > > > > > > > > > Stack Trace: > > > > > > > > > > > > [InvalidCastException: Object must implement
IConvertible.] > > > > > > System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior > > > > > > cmdBehavior, RunBehavior runBehavior, Boolean
returnStream) +723 > > > > > > System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195 > > > > > > solo.index.btSubmit_Click(Object sender, EventArgs e)
in > > > > > > c:\inetpub\wwwroot\solo\reg\index.aspx.vb:511 > > > > > > System.Web.UI.WebControls.Button.OnClick(EventArgs e)
+108 > > > > > > > > > > > > > > > > > > > > > > > > > > >
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo > > > > > > stBackEvent(String eventArgument) +57 > > > > > > System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler > > > > > > sourceControl, String eventArgument) +18 > > > > > >
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection > > postData) > > > > +33 > > > > > > System.Web.UI.Page.ProcessRequestMain() +1277 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
-------------------------------------------------------------------------- > > > > > -- > > > > > > ---- > > > > > > Version Information: Microsoft .NET Framework > Version:1.1.4322.573; > > > > > ASP.NET > > > > > > Version:1.1.4322.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...
|
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...
|
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....
|
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...
|
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...
|
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,...
|
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:
...
|
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...
|
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...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
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,...
| |