OK, it looks like I made a mistake. I was confused by some of the ID's.
The parameter @PK1 should really be called @CustomerUID. So we need to change any
reference of @PK1 to @CustomerUID.
And looking at your original proc called "sp_InsertMain", you were passing in a
parameter called "@AccountUID". This needs to be passed in and you should end up with
the following:
CREATE procedure sp_InsertAllRecords
@AccountUID int,
@AccountNumber varchar(50),
@BillingAddressName varchar(100),
@BillingAddress varchar(100),
@BillingAddressCity varchar(50),
@BillingAddressState char(2),
@BillingAddressZip varchar(20),
@CardUID int,
@CardNum varchar(50),
@CardPIN varchar(50),
@Error_Code int output
as
declare
@SQLErrorCode int,
@WhateverID int,
@CustomerUID int
begin tran InsertAllRecords
-- ************************************************************
-- *** Step 1 - Insert the first record ***
-- ************************************************************
Insert CallingCardAccount (AccountNumber,BillingAddressName, BillingAddress,
BillingAddressCity, BillingAddressState, BillingAddressZip)
Values (@AccountNumber, @BillingAddressName, @BillingAddress, @BillingAddressCity,
@BillingAddressState, @BillingAddressZip)
-- Now check for any errors.
select @SQLErrorCode = @@Error
-- Get the PK for this new record.
select @CustomerUID = @@identity
-- If we have an error, set the variable and return it and rollback the transaction.
if @SQLErrorCode <> 0
begin
rollback tran InsertAllRecords
set @Error_Code = 1
return
end
-- ************************************************************
-- *** Step 2 - Insert the second record using the PK from ***
-- *** the first record inserted above ***
-- ************************************************************
Insert into CallingCardInfo(CustomerUID, AccountUID, CardUID, CardNum, CardPIN)
Values (@CustomerUID, @AccountUID, @CardUID, @CardNum, @CardPIN)
-- Now check for any errors.
select @SQLErrorCode = @@Error
-- If we have an error, set the variable and return it and rollback the transaction.
if @SQLErrorCode <> 0
begin
rollback tran InsertAllRecords
set @Error_Code = 2
return
end
-- If we made it this far, then the transaction was successful.
commit tran InsertAllRecords
set @Error_Code = 0
return
Mark
Anna Leon <[EMAIL PROTECTED]> wrote:
Now it's complaining about @CustomerUID when I run the
webpage:
Procedure 'sp_InsertAllRecords' expects parameter
'@CustomerUID', which was not supplied.
Description: An unhandled exception occurred during
the execution of the current web request. Please
review the stack trace for more information about the
error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException:
Procedure 'sp_InsertAllRecords' expects parameter
'@CustomerUID', which was not supplied.
Source Error:
Line 302: 'Open the db connection &
Execute Command.
Line 303: objConn.Open()
Line 304:
objSQLCommand.ExecuteNonQuery()
Line 305: 'Get the return values.
Line 306: If Not
IsDBNull(objSQLCommand.Parameters("@Error_Code").Value)
Then
Source File: I:\10-16-04\addaccount2.aspx Line: 304
Stack Trace:
[SqlException: Procedure 'sp_InsertAllRecords' expects
parameter '@CustomerUID', which was not supplied.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean
returnStream) +635
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
+198
ASP.addaccount2_aspx.Submit2_Click(Object sender,
EventArgs e) in I:\10-16-04\addaccount2.aspx:304
System.Web.UI.WebControls.Button.OnClick(EventArgs
e) +83
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263
-----------
Thanks!!
--- Mark E <[EMAIL PROTECTED]> wrote:
> Anna,
>
> You changed the name of your column (in the second
> insert) to match the variable @PK1, but it needs to
> match the name of the column in your table
> (AccountID)).
>
> Change your second insert statement to this:
>
> Insert into
> CallingCardInfo(CustomerUID,AccountUID,CardUID,
> CardNum, CardPIN)
> Values (@CustomerUID, @PK1, @CardUID, @CardNum,
> @CardPIN)
>
> Mark
>
> Anna Leon <[EMAIL PROTECTED]> wrote:
> Here's my 2nd insert:
>
> --
>
************************************************************
> -- *** Step 2 - Insert the second record using the
> PK
> from ***
> -- *** the first record inserted above
>
> ***
> --
>
************************************************************
> Insert into CallingCardInfo(CustomerUID, PK1,
> CardUID,
> CardNum, CardPIN)
> Values (@CustomerUID, @PK1, @CardUID, @CardNum,
> @CardPIN)
> -- Now check for any errors.
> select @SQLErrorCode = @@Error
> -- If we have an error, set the variable and return
> it
> and rollback the transaction.
> if @SQLErrorCode <> 0
> begin
> rollback tran InsertAllRecords
> set @Error_Code = 2
> return
> end
> -- If we made it this far, then the transaction was
> successful.
> commit tran InsertAllRecords
> set @Error_Code = 0
> return
> ---------------------------------
> And I get this error:
>
> Server: Msg 207, Level 16, State 1, Procedure
> sp_InsertAllRecords, Line 40
> Invalid column name 'PK1'.
>
>
> It doesn't recognize 'PK1' as a column in my table.
>
> Thanks!!
>
>
> --- Mark E <[EMAIL PROTECTED]> wrote:
>
> > Oh, I see the problem.
> >
> > In the second insert, change @AccountUID to @PK1.
> > That should solve the problem.
> >
> > Mark
> >
> > Anna Leon <[EMAIL PROTECTED]> wrote:
> > Thanks for taking your time to help me. I believe
> I
> > removed all references to that parameter. However,
> > in
> > the SP, in the second step, the primary key and
> > foreign keys are referenced there. And since
> > @AccountUID is referenced there, SQL Analyzer
> gives
> > the error about not @AccountUID not being
> declared.
> >
> >
> > --- Mark E <[EMAIL PROTECTED]> wrote:
> >
> > > Anna,
> > >
> > > Remove all references to this parameter, as you
> do
> > > not need it. As a matter of fact, you do not
> know
> > > the value because it the PK of the record that
> > > hasen't even been inserted.
> > >
> > > Did you use the 1 stored procedure that I
> posted?
> > I
> > > removed that parameter and recommend using it.
> > >
> > > If you like, zip up everything and email it to
> me
> > > off-list and I will look at it tonight.
> > >
> > > Mark
> > >
> > > Anna Leon <[EMAIL PROTECTED]> wrote:
> > > It still gives me an error about the
> "@AccountUID"
> > > parameter. I believe I need to declare it below,
> > as
> > > one of the input parameters since in the SP, it
> is
> > > declared in there. BTW, I had to declare
> > @AccountUID
> > > in the SP because it gave me an error there too.
> > >
> > > If I were to declare the input parameter,
> > > @AccountUID,
> > > what should I put in the bracket below? Because
> my
> > > other parameters are being passed by whatever is
> > in
> > > their corresponding textboxes...
> > >
> > > objParam
> > >
> =objSQLCommand.Parameters.Add("@AccountUID",[WHAT
> > TO
> > > PUT HERE?])
> > >
> > >
> > > Thanks!!!
> > >
> > > --- Mark E <[EMAIL PROTECTED]> wrote:
> > >
> > > > Unless I missed something, It looks fine to
> me.
> > > >
> > > > Mark
> > > >
> > > > Anna Leon <[EMAIL PROTECTED]> wrote:
> > > > BTW, I need to alter this sub routine too?
> > > >
> > > > Sub Submit2_Click(sender As Object, e As
> > > EventArgs)
> > > >
> > > > If Page.IsValid then
> > > >
> > > >
> > > > Dim objConn As SqlConnection
> > > > Dim objSQLCommand As SqlCommand
> > > > Dim objParam As SqlParameter
> > > > Dim boolInsertOK As Boolean =
> False
> > > > Dim intReturnError as Integer
> > > > 'Set up our connection object and
> > SQL
> > > > command object.
> > > > objConn = New
> > > >
> > >
> >
>
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
> > > > objSQLCommand = New
> > > > SqlCommand("sp_InsertAllRecords", objConn)
> > > > 'Set the stored procedure.
> > > > objSQLCommand.CommandType =
> > > > CommandType.StoredProcedure
> > > > 'Add input parameters...
> > > > objParam =
> > > > objSQLCommand.Parameters.Add("@AccountNumber",
> > > > TextBox1.Text)
> > > > objParam =
> > > >
> > >
> >
> objSQLCommand.Parameters.Add("@BillingAddressName",
> > > > TextBox_new.Text)
> > > > objParam =
> > > >
> objSQLCommand.Parameters.Add("@BillingAddress",
> > > > TextBox2.Text)
> > > > objParam =
> > > >
> > >
> >
> objSQLCommand.Parameters.Add("@BillingAddressCity",
> > > > TextBox3.Text)
> > > > objParam =
> > > >
> > >
> >
> objSQLCommand.Parameters.Add("@BillingAddressState",
> > > > DropDownList1.SelectedItem.Text)
> > > > objParam =
> > > >
> > objSQLCommand.Parameters.Add("@BillingAddressZip",
> > > > TextBox4.Text)
> > > > objParam =
> > > > objSQLCommand.Parameters.Add("@CardNum",
> > > > TextBox5.Text)
> > > > objParam =
> > > > objSQLCommand.Parameters.Add("@CardPIN",
> > > > TextBox6.Text)
> > > > 'Add our ouput parameters...
> > > > 'objParam =
> > > > objSQLCommand.Parameters.Add("@Error_Code",
> > > > SqlDbType.Int)
> > > > 'objParam.Direction =
> > > > ParameterDirection.Output
> > > > 'Open the db connection & Execute
> > > > Command.
> > > > objConn.Open()
> > > > objSQLCommand.ExecuteNonQuery()
> > > > 'Get the return values.
> > > > 'If Not
> > > >
> > >
> >
>
IsDBNull(objSQLCommand.Parameters("@Error_Code").Value)
> > > > Then
> > > > 'intReturnError =
> > > >
> (objSQLCommand.Parameters("@Error_Code").Value)
> > > > 'End If
> > > > 'Check the error.
> > > > 'If intReturnError = 0 Then
> > > > 'No errors. Set our confirm
> > msg.
> > > > 'boolInsertOK = True
> > > > 'Else
> > > > 'We had an error. Set our
> error
> > > > msg.
> > > > 'boolInsertOK = False
> > > > 'End If
> > > > 'Close the DB connection.
> > > > objConn.Close()
> > > > End If
> > > >
> > > > End Sub
> > > >
> > > > --- Mark E <[EMAIL PROTECTED]> wrote:
> > > >
> > > > > Anna,
> > > > >
> > > > > Below is 1 SP that does both inserts. You
> > will
> > > > need
> > > > > to remove the first input parameter from
> your
> > > web
> > > > > page, as it's no longer needed.
> > > > >
> > > > > I prefer one since I like the element of
> total
> > > > > control over all related inserts. And by
> > doing
> > > it
> > > > > this way, you can see all your code in 1 SP
> > and
> > > > wrap
> > > > > it within a trans tag. I don't know if you
> > are
> > > > > familiar with SQL Server transactions, but
> if
> > > you
> > > > > use the trans tag, you have the ability to
> > > > > "rollback" transactions (inserts, updates &
> > > > deletes)
> > > > > if something goes wrong anywhere in your SP.
> > > > >
> > > > > Anyhow, look it over and let me know if you
> > have
> > > > any
> > > > > questions.
> > > > >
> > > > > Mark
> > > > >
> > > > > --drop procedure sp_InsertAllRecords
> > > > > CREATE procedure sp_InsertAllRecords
> > > > >
> > > > > @AccountNumber varchar(50),
> > > > > @BillingAddressName varchar(100),
> > > > > @BillingAddress varchar(100),
> > > > > @BillingAddressCity varchar(50),
> > > > > @BillingAddressState char(2),
> > > > > @BillingAddressZip varchar(20),
> > > > > @CardUID int,
> > > > > @CardNum varchar(50),
> > > > > @CardPIN varchar(50),
> > > > > @Error_Code int output
> > > > > as
> > > > > declare
> > > > > @SQLErrorCode int,
> > > > > @WhateverID int,
> > > > > @PK1 int
> > > > >
> > > > > begin tran InsertAllRecords
> > > > > --
> > > > >
> > > >
> > >
> >
>
************************************************************
> > > > > -- *** Step 1 - Insert the first record
> ***
> > > > > --
> > > > >
> > > >
> > >
> >
>
************************************************************
> > > > > Insert CallingCardAccount
> > > > > (AccountNumber,BillingAddressName,
> > > BillingAddress,
> > > > > BillingAddressCity, BillingAddressState,
> > > > > BillingAddressZip)
> > > > > Values (@AccountNumber, @BillingAddressName,
> > > > > @BillingAddress, @BillingAddressCity,
> > > > > @BillingAddressState, @BillingAddressZip)
> > > > > -- Now check for any errors.
> > > > > select @SQLErrorCode = @@Error
> > > > > -- Get the PK for this new record.
> > > > > select @PK1 = @@identity
> > > > > -- If we have an error, set the variable and
> > > > return
> > > > > it and rollback the transaction.
> > > > > if @SQLErrorCode <> 0
> > > > > begin
> > > > > rollback tran InsertAllRecords
> > > > > set @Error_Code = 1
> > > > > return
> > > > > end
> > > > > --
> > > > >
> > > >
> > >
> >
>
************************************************************
> > > > > -- *** Step 2 - Insert the second record
> using
> > > the
> > > > > PK from ***
> > > > > -- *** the first record inserted above
>
> >
> > >
> > > >
> > > > > ***
> > > > > --
> > > > >
> > > >
> > >
> >
>
************************************************************
> > > > > Insert into CallingCardInfo(CustomerUID,
> > > > AccountUID,
> > > > > CardUID, CardNum, CardPIN)
> > > > > Values (@CustomerUID, @AccountUID, @CardUID,
> > > > > @CardNum, @CardPIN)
> > > > > -- Now check for any errors.
> > > > > select @SQLErrorCode = @@Error
> > > > > -- If we have an error, set the variable and
> > > > return
> > > > > it and rollback the transaction.
> > > > > if @SQLErrorCode <> 0
> > > > > begin
> > > > > rollback tran InsertAllRecords
> > > > > set @Error_Code = 2
> > > > > return
> > > > > end
> > > > > -- If we made it this far, then the
> > transaction
> > > > was
> > > > > successful.
> > > > > commit tran InsertAllRecords
> > > > > set @Error_Code = 0
> > > > > return
> > > > >
> > > > > Anna Leon <[EMAIL PROTECTED]> wrote:
> > > > > Yes I am calling multiple SPs. I am passing
> > > > > "@AccountUID" to one of them. Correct me if
> > I'm
> > > > > wrong.
> > > > >
> > > > > From webpage, call sp_InsertMain
> > > > > From sp_InsertMain, call sp_InsertAccount2
> and
> > > > > sp_InsertCallingCardInfo
> > > > >
> > > > >
> > > > > SP1
> > > > > -----------------------------
> > > > > CREATE PROCEDURE sp_InsertMain
> > > > > @AccountUID int,
> > > > > @AccountNumber varchar(50),
> > > > > @BillingAddressName varchar(100),
> > > > > @BillingAddress varchar(100),
> > > > > @BillingAddressCity varchar(50),
> > > > > @BillingAddressState char(2),
> > > > > @BillingAddressZip varchar(20),
> > > > >
> > > > > @CardUID int,
> > > > > @CardNum varchar(50),
> > > > > @CardPIN varchar(50),
> > > > >
> > > > > @Error_Code int
> > > > > AS
> > > > > Declare @WhateverID int
> > > > >
> > > > > EXEC @WhateverID = sp_InsertAccount2
> > > @AccountUID,
> > > > > @AccountNumber,
> > > > > @BillingAddressName,
> > > > > @BillingAddress,
> > > > > @BillingAddressCity,
> > > > > @BillingAddressState,
> > > > > @BillingAddressZip
> > > > >
> > > > >
> > > > > Exec InsertCallingCardInfo @AccountUID,
> > > > @WhateverID,
> > > > > @CardUID,
> > > > > @CardNum,
> > > > > @CardPIN
> > > > > ----------------------
> > > > >
> > > > > SP2
> > > > > ------------------------
> > > > > CREATE PROCEDURE sp_InsertAccount2
> > > > > @AccountUID int,
> > > > > @AccountNumber varchar(50),
> > > > > @BillingAddressName varchar(100),
> > > > > @BillingAddress varchar(100),
> > > > > @BillingAddressCity varchar(50),
> > > > > @BillingAddressState char(2),
> > > > > @BillingAddressZip varchar(20)
> > > > >
> > > > >
> > > > > AS
> > > > > Begin
> > > > > Set NoCount on
> > > > > Insert CallingCardAccount(AccountNumber,
> > > > > BillingAddressName, BillingAddress,
> > > > > BillingAddressCity, BillingAddressState,
> > > > > BillingAddressZip)
> > > > > Values
> > > > > (@AccountNumber, @BillingAddressName,
> > > > > @BillingAddress, @BillingAddressCity,
> > > > > @BillingAddressState, @BillingAddressZip)
> > > > >
> > > > > RETURN @@IDENTITY
> > > > >
> > > > > END
> > > > > -----------------------------
> > > > >
> > > > > SP3
> > > > > -------------------------
> > > > > CREATE PROCEDURE InsertCallingCardInfo
> > > > > @CustomerUID int,
> > > > > @AccountUID int,
> > > > > @CardUID int,
> > > > > @CardNum varchar(50),
> > > > > @CardPIN varchar(50)
> > > > > As
> > > > > Insert into CallingCardInfo
> > > > > (CustomerUID, AccountUID, CardUID,
> > > CardNum,
> > > > > CardPIN)
> > > > > Values
> > > > > (@CustomerUID, @AccountUID, @CardUID,
> > > > > @CardNum,
> > > > > @CardPIN)
> > > > > ----------------------------------
> > > > >
> > > > >
> > > > > Sub Submit2_Click(sender As Object, e As
> > > > EventArgs)
> > > > >
> > > > > If Page.IsValid then
> > > > >
> > > > > Dim objConn As SqlConnection
> > > > > Dim objSQLCommand As SqlCommand
> > > > > Dim objParam As SqlParameter
> > > > > Dim boolInsertOK As Boolean =
> > False
> > > > > Dim intReturnError as Integer
> > > > > 'Set up our connection object
> and
> > > SQL
> > > > > command object.
> > > > > objConn = New
> > > > >
> > > >
> > >
> >
>
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
> > > > > objSQLCommand = New
> > > > > SqlCommand("sp_InsertMain", objConn)
> > > > > 'Set the stored procedure.
> > > > > objSQLCommand.CommandType =
> > > > > CommandType.StoredProcedure
> > > > > 'Add input parameters...
> > > > > objParam =
> > > > >
> objSQLCommand.Parameters.Add("@AccountNumber",
> > > > > TextBox1.Text)
> > > > > objParam =
> > > > >
> > > >
> > >
> >
> objSQLCommand.Parameters.Add("@BillingAddressName",
> > > > > TextBox_new.Text)
> > > > > objParam =
> > > > >
> > objSQLCommand.Parameters.Add("@BillingAddress",
> > > > > TextBox2.Text)
> > > > > objParam =
> > > > >
> > > >
> > >
> >
> objSQLCommand.Parameters.Add("@BillingAddressCity",
> > > > > TextBox3.Text)
> > > > > objParam =
> > > > >
> > > >
> > >
> >
> objSQLCommand.Parameters.Add("@BillingAddressState",
> > > > > DropDownList1.SelectedItem.Text)
> > > > > objParam =
> > > > >
> > >
> objSQLCommand.Parameters.Add("@BillingAddressZip",
> > > > > TextBox4.Text)
> > > > > objParam =
> > > > > objSQLCommand.Parameters.Add("@CardNum",
> > > > > TextBox5.Text)
> > > > > objParam =
> > > > > objSQLCommand.Parameters.Add("@CardPIN",
> > > > > TextBox6.Text)
> > > > > 'Add our ouput parameters...
> > > > > 'objParam =
> > > > > objSQLCommand.Parameters.Add("@Error_Code",
> > > > > SqlDbType.Int)
> > > > > 'objParam.Direction =
> > > > > ParameterDirection.Output
> > > > > 'Open the db connection &
> Execute
> > > > > Command.
> > > > > objConn.Open()
> > > > > objSQLCommand.ExecuteNonQuery()
> > > > > 'Get the return values.
> > > > > 'If Not
> > > > >
> > > >
> > >
> >
>
IsDBNull(objSQLCommand.Parameters("@Error_Code").Value)
> > > > > Then
> > > > > 'intReturnError =
> > > > >
> > (objSQLCommand.Parameters("@Error_Code").Value)
> > > > > 'End If
> > > > > 'Check the error.
> > > > > 'If intReturnError = 0 Then
> > > > > 'No errors. Set our confirm
> > > msg.
> > > > > 'boolInsertOK = True
> > > > > 'Else
> > > > > 'We had an error. Set our
> > error
> > > > > msg.
> > > > > 'boolInsertOK = False
> > > > > 'End If
> > > > > 'Close the DB connection.
> > > > > objConn.Close()
> > > > >
> > > > > Panel1.Visible = False
> > > > > Panel3.Visible = False
> > > > > Panel4.Visible = True
> > > > > Label3.Visible = True
> > > > > Label3.Text = "<b>" & "The
> > following
> > > > > data
> > > > > has been added." & "<p>" & "<table border=0
> > > > > cellpadding=2 cellspacing=5><tr><td>" &
> > "Account
> > > > > #::</td>" & "<td>" & TextBox1.Text & "</td>"
> &
> > > > > "<tr><td>Billing Address Name:</td>" &
> "<td>"
> > &
> > > > > TextBox_new.Text & "</td>" &
> > > > "<tr><td>Address:</td>"
> > > > > &
> > > > > "<td>" & TextBox2.text & "</td><tr><td>" &
> > > > > "City:</td><td>" & TextBox3.Text & "</td>" &
> > > > > "<tr><td>State:" & "<td>" &
> > > > > DropDownList1.SelectedItem.Text & "</td>" &
> > > > > "<tr><td>Zip:</td>" & "<td>" & TextBox4.Text
> &
> > > > > "</td>"
> > > > > & "</table></b>"
> > > > >
> > > > > End If
> > > > >
> > > > > End Sub
> > > > >
> > > > >
> > > > > Thanks!!!
> > > > >
> > > > > --- Mark E <[EMAIL PROTECTED]> wrote:
> > > > >
> > > > > > Anna,
> > > > > >
> > > > > > If I understand correctly, you are calling
> > > > > multiple
> > > > > > SP's. So it looks as though you need to
> > pass
> > > > your
> > > > > > "@AccountUID" to one of them.
> > > > > >
> > > > > > Post a high level flow of how you are
> > calling
> > > > your
> > > > > > SP's. Like this:
> > > > > >
> > > > > > From web page, call sp_InsertMainRecord
> > > > > > Within sp_InsertMainRecord, call
> > > > > > sp_InsertSecondRecord
> > > > > > Within sp_InsertMainRecord, call
> > > > > > sp_InsertThirdRecord
> > > > > >
> > > > > > Mark
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Anna Leon <[EMAIL PROTECTED]> wrote:
> > > > > > Do I have to add as an input parameter,
> the
> > > > > primary
> > > > > > key in my code? i.e.
> > > > > >
> > > > > > objParam =
> > > > > >
> objSQLCommand.Parameters.Add("@AccountUID",
> > > > > > ????)
> > > > > >
> > > > > > What do I put where the question marks
> are?
> > > Like
> > > > > the
> > > > > > other input parameters, I have:
> > > > > >
> > > > > > objParam =
> > > > > >
> > objSQLCommand.Parameters.Add("@AccountNumber",
> > > > > > TextBox1.Text)
> > > > > >
> > > > > >
> > > > > > And right now I'm getting an error:
> > > > > >
> > > > > > =====================================
> > > > > > Procedure 'sp_InsertMain' expects
> parameter
> > > > > > '@AccountUID', which was not supplied.
> > > > > > Description: An unhandled exception
> occurred
> > > > > during
> > > > > > the execution of the current web request.
> > > Please
> > > > > > review the stack trace for more
> information
> > > > about
> > > > > > the
> > > > > > error and where it originated in the code.
>
> > > > > >
> > > > > > Exception Details:
> > > > > > System.Data.SqlClient.SqlException:
> > > > > > Procedure 'sp_InsertMain' expects
> parameter
> > > > > > '@AccountUID', which was not supplied.
> > > > > >
> > > > > > Source Error:
> > > > > >
> > > > > >
> > > > > > Line 302: 'Open the db
> > > connection
> > > > &
> > > > > > Execute Command.
> > > > > > Line 303: objConn.Open()
> > > > > > Line 304:
> > > > > > objSQLCommand.ExecuteNonQuery()
> > > > > > Line 305: 'Get the return
> > > values.
> > > > > > Line 306: 'If Not
> > > > > >
> > > > >
> > > >
> > >
> >
>
IsDBNull(objSQLCommand.Parameters("@Error_Code").Value)
> > > > > > Then
> > > > > >
> > > > > >
> > > > > > Source File: I:\10-16-04\addaccount2.aspx
>
> > > > Line:
> > > > > > 304
> > > > > >
> > > > > >
> > > > > > Stack Trace:
> > > > > >
> > > > > >
> > > > > > [SqlException: Procedure 'sp_InsertMain'
> > > expects
> > > > > > parameter '@AccountUID', which was not
> > > > supplied.]
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> > > > > > cmdBehavior, RunBehavior runBehavior,
> > Boolean
> > > > > > returnStream) +635
> > > > > >
> > > > > >
> > > >
> > System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> > > > > > +198
> > > > > >
> ASP.addaccount2_aspx.Submit2_Click(Object
> > > > > sender,
> > > > > > EventArgs e) in
> > > I:\10-16-04\addaccount2.aspx:304
> > > > > >
> > > > > >
> > > >
> > System.Web.UI.WebControls.Button.OnClick(EventArgs
> > > > > > e) +83
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> > > > > > eventArgument) +57
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > > > > sourceControl, String eventArgument) +18
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > > > > postData) +33
> > > > > > System.Web.UI.Page.ProcessRequestMain()
> > > +1263
> > > > > >
> > > > > >
> > > > > >
> > =============================================
> > > > > > @AccountUID is declared in my main SP.
> > > > > >
> > > > > > Thanks!!
> > > > > >
> > > > > >
> > > > > > --- Mark E <[EMAIL PROTECTED]> wrote:
> > > > > >
> > > > > > > Add this line after the other variable
> > > > > > declarations
> > > > > > > within the sub:
> > > > > > >
> > > > > > > Dim intReturnError as Integer
> > > > > > >
> > > > > > > Mark
> > > > > > >
> > > > > > > sas0riza <[EMAIL PROTECTED]> wrote:
> > > > > > >
> > > > > > > I'm getting an error:
> > > > > > >
> > > > > > > Description: An error occurred during
> the
> > > > > > > compilation of a resource
> > > > > > > required to service this request. Please
> > > > review
> > > > > > the
> > > > > > > following
> > > > > > > specific error details and modify your
> > > source
> > > > > code
> > > > > > > appropriately.
> > > > > > >
> > > > > > > Compiler Error Message: BC30451: Name
> > > > > > > 'intReturnError' is not
> > > > > > > declared.
> > > > > > >
> > > > > > > Source Error:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Line 304: 'Get the return
> > > > values.
> > > > > > > Line 305: If Not
> > > > > > > IsDBNull(objSQLCommand.Parameters
> > > > > > > ("@Error_Code").Value) Then
> > > > > > > Line 306:
> > intReturnError
> > > =
> > > > > > >
> > > >
> (objSQLCommand.Parameters("@Error_Code").Value)
> > > > > > > Line 307: End If
> > > > > > > Line 308: 'Check the
> error.
> > > > > > >
> > > > > > >
> > > > > > > Source File:
> I:\10-16-04\addaccount2.aspx
> >
> > > > > Line:
> > > > > > > 306
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Show Detailed Compiler Output:
> > > > > > >
> > > > > > >
> > > > > > > I:\10-16-04>
> > > > > > >
> > "c:\winnt\microsoft.net\framework\v1.0.3705
> > > > > > > \vbc.exe" /t:library /utf8output
> > > > > > > /R:"c:\winnt\assembly\gac\system.data
> > > > > > > \1.0.3300.0__b77a5c561934e089
> > > > > > > \system.data.dll"
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> /R:"c:\winnt\assembly\gac\system.web.services\1.0.33
> > > > > > >
> > > >
> 00.0__b03f5f7f11d50a3a\system.web.services.dll"
> > > > > > > /R:"c:\winnt\assembly\
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
gac\system.drawing\1.0.3300.0__b03f5f7f11d50a3a\system.drawing.dll"
> > > > > > > /R
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
:"c:\winnt\assembly\gac\system.enterpriseservices\1.0.3300.0__b03f5f7f
> > > > > > > 11d50a3a\system.enterpriseservices.dll"
> > > > > > > /R:"c:\winnt\assembly\gac\syst
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> em.web\1.0.3300.0__b03f5f7f11d50a3a\system.web.dll"
> > > > > > > /R:"c:\winnt\assem
> > > > > > >
> > > >
> bly\gac\system.xml\1.0.3300.0__b77a5c561934e089
> > > > > > > \system.xml.dll"
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
/R:"c:\winnt\assembly\gac\system\1.0.3300.0__b77a5c56
> > > > > > > 1934e089\system.dll"
> > > > > > >
> > > >
> /out:"C:\WINNT\Microsoft.NET\Framework\v1.0.3705
> > > > > > > \Temporary ASP.NET
> > > > > > >
> Files\root\b3a0069f\92c21b1b\wnih9oqm.dll"
> > > > > > > /D:DEBUG=1 /debug+ /win32re
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
source:"C:\WINNT\Microsoft.NET\Framework\v1.0.3705\Temporary
> > > > > > > ASP.NET
> > > > > > >
> Files\root\b3a0069f\92c21b1b\wnih9oqm.res"
> >
> > > > > > > "C:\WINNT\Microsoft.NET\Fr
> > > > > > > amework\v1.0.3705\Temporary ASP.NET
> > > > > > >
> > Files\root\b3a0069f\92c21b1b\wnih9oqm.0.vb"
> > > > > > >
> > > > > > >
> > > > > > > Microsoft (R) Visual Basic .NET Compiler
> > > > version
> > > > > > > 7.00.9466
> > > > > > > for Microsoft (R) .NET Framework version
> > > > > > > 1.00.3705.288
> > > > > > > Copyright (C) Microsoft Corporation
> > > 1987-2001.
> > > > > All
> > > > > > > rights reserved.
> > > > > > >
> > > > > > > I:\10-16-04\addaccount2.aspx(306) :
> error
> > > > > BC30451:
> > > > > >
> > > > > > > Name 'intReturnError' is not declared.
> > > > > > >
> > > > > > > intReturnError =
> > > > > > > (objSQLCommand.Parameters
> > > > > > > ("@Error_Code").Value)
> > > > > > >
> > > > > > > ~~~~~~~~~~~~~~
>
> >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > I:\10-16-04\addaccount2.aspx(309) :
> error
> > > > > BC30451:
> > > > > >
> > > > > > > Name 'intReturnError' is not declared.
> > > > > > >
> > > > > > > If intReturnError = 0
> Then
> > > > > > > ~~~~~~~~~~~~~~
>
> > > > > > >
> > > > > > >
> > > > > > > ??
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --- In
> > > [EMAIL PROTECTED],
> > > > > Mark
> > > > > > E
> > > > > > >
> > > > > > > <[EMAIL PROTECTED]> wrote:
> > > > > > > > @Some_Param would represent a name of
> an
> > > > input
> > > > > > > parameter (value)
> > > > > > > being passed into your proc.
> > > > > > > >
> > > > > > > > SomeValue would be the name of a
> > variable
> > > > that
> > > > > > > holds your value for
> > > > > > > @Some_Param. Or you could use
> > control.value
> > > > or
> > > > > > > control.text.
> > > > > > > >
> > > > > > > > Mark
> > > > > > > >
> > > > > > > > Anna Leon <[EMAIL PROTECTED]> wrote:
> > > > > > > > 'Add input parameters...
> > > > > > > > objParam =
> > > > > > > >
> > > objSQLCommand.Parameters.Add("@Some_Param",
> > > > > > > SomeValue)
> > > > > > > > 'Add our ouput
> parameters...
> > > > > > > > objParam =
> > > > > > > >
> > > objSQLCommand.Parameters.Add("@Error_Code",
> > > > > > > > SqlDbType.Int)
> > > > > > > >
> > > > > > > >
> > > > > > > > @Some_Param is what I'm inserting into
> > the
> > > > > > tables?
> > > > > > > > SomeValue is my textbox ids??
> > > > > > > >
> > > > > > > >
> > > > > > > > --- Mark E <[EMAIL PROTECTED]> wrote:
> > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > Here is a sample of what you can do.
>
> > > Just
> > > > > > note
> > > > > > > that
> > > > > > > > > it was typed directly in to the
> email
> > > and
> > > > > > needs
> > > > > > > > > testing.
> > > > > > > > >
> > > > > > > > > My suggestion is to call your 2nd or
> > 3rd
> > > > > proc
> > > > > > > from
> > > > > > > > > the first one or make it one proc.
> I
> > > > prefer
> > > > > 1
> > > > > > > proc,
> > > > > > > > > unless I see some value in
> seperating
> > > > them,
> > > > > > like
> > > > > > > > > reusing them.
> > > > > > > > >
> > > > > > > > > Anyhow, here is a button:
> > > > > > > > >
> > > > > > > > > <asp:Button ID="btnSubmit"
> > Text="Become
> > > a
> > > > > > > Member"
> > > > > > > > > CssClass="LargeButton"
> > > > > > > Runat="server"></asp:Button>
> > > > > > > > >
> > > > > > > > > Don't forget your imports in your
> > page:
> > > > > > > > >
> > > > > > > > > Imports System.Data
> > > > > > > > > Imports System.Data.SqlClient
> > > > > > > > >
> > > > > > > > > And here is some code. Just replace
> > the
> > > > > > values
> > > > > > > for
> > > > > > > > > the proc name & params to whatever
> you
> > > > need:
> > > > > > > > >
> > > > > > > > > Private Sub btnSubmit_Click(ByVal
> > sender
> > > > As
> > > > > > > > > System.Object, ByVal e As
> > > > System.EventArgs)
> > > > > > > Handles
> > > > > > > > > btnSubmit.Click
> > > > > > > > > Dim objConn As SqlConnection
> > > > > > > > > Dim objSQLCommand As SqlCommand
> > > > > > > > > Dim objParam As
> > SqlParameter
> > > > > > > > > Dim boolInsertOK As
> > Boolean
> > > =
> > > > > > False
> > > > > > > > > 'Set up our connection
> > > object
> > > > > and
> > > > > > > SQL
> > > > > > > > > command object.
> > > > > > > > > objConn = New
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
> > > > > > > > > objSQLCommand = New
> > > > > > > > > SqlCommand("Name_Of_Your_PROC",
> > objConn)
> > > > > > > > > 'Set the stored
> procedure.
> > > > > > > > >
> objSQLCommand.CommandType
> > =
> > > > > > > > > CommandType.StoredProcedure
> > > > > > > > > 'Add input parameters...
> > > > > > > > > objParam =
> > > > > > > > >
> > > > objSQLCommand.Parameters.Add("@Some_Param",
> > > > > > > > > SomeValue)
> > > > > > > > > 'Add our ouput
> > parameters...
> > > > > > > > > objParam =
> > > > > > > > >
> > > > objSQLCommand.Parameters.Add("@Error_Code",
> > > > > > > > > SqlDbType.Int)
> > > > > > > > > objParam.Direction =
> > > > > > > > > ParameterDirection.Output
> > > > > > > > > 'Open the db connection
> &
> > > > > Execute
> > > > > > > > > Command.
> > > > > > > > > objConn.Open()
> > > > > > > > >
> > > > objSQLCommand.ExecuteNonQuery()
> > > > > > > > > 'Get the return values.
> > > > > > > > > If Not
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
IsDBNull(objSQLCommand.Parameters("@Error_Code").Value)
> > > > > > > > > Then
> > > > > > > > > intReturnError =
> > > > > > > > >
> > > > > >
> > > (objSQLCommand.Parameters("@Error_Code").Value)
> > > > > > > > > End If
> > > > > > > > > 'Check the error.
> > > > > > > > > If intReturnError = 0
> Then
> > > > > > > > > 'No errors. Set our
> > > > confirm
> > > > > > > msg.
> > > > > > > > > boolInsertOK = True
> > > > > > > > > Else
> > > > > > > > > 'We had an error.
> Set
> > > our
> > > > > > error
> > > > > > > > > msg.
> > > > > > > > > boolInsertOK = False
> > > > > > > > > End If
> > > > > > > > > 'Close the DB
> connection.
> > > > > > > > > objConn.Close()
> > > > > > > > > '***** Do something here
> > > based
> > > > > on
> > > > > > > > > success or failure of the insert
> > > > > > > > > End Sub
> > > > > > > > >
> > > > > > > > > And watch for wrapping.
> > > > > > > > >
> > > > > > > > > Mark
> > > > > > > > >
> > > > > > > > > sas0riza <[EMAIL PROTECTED]> wrote:
> > > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > I have 3 stored procedures for
> > inserting
> > > > > data
> > > > > > > into
> > > > > > > > > multiple tables.
> > > > > > > > > Mainly 2 tables get the inserted
> data.
> > > The
> > > > > 2nd
> > > > > > > table
> > > > > > > > > requires 2
> > > > > > > > > foreign keys added. One foreign key
> is
> > > > from
> > > > > > the
> > > > > > > 1st
> > > > > > > > > table and the 2nd
> > > > > > > > > foreign key is from another table
> > (which
> > > > I'm
> > > > > > not
> > > > > > > > > doing anything to
> > > > > > > > > other than retrieving the primary
> key)
> > > to
> > > > be
> > > > > > > > > inserted into the 2nd
> > > > > > > > > table.
> > > > > > > > >
> > > > > > > > > How do I call the SP(s) in my code?
> > > Note,
> > > > I
> > > > > > > would
> > > > > > > > > like to call the SP
> > > > > > > > > (s) in my button_click sub routine.
> > > > > > > > >
> > > > > > > > > Thank you.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Yahoo! Groups SponsorADVERTISEMENT
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > ---------------------------------
> > > > > > > > > Yahoo! Groups Links
> > > > > > > > >
> > > > > > > > > To visit your group on the web,
> go
> > > to:
> > > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > > > > > > > >
> > > > > > > > > To unsubscribe from this group,
> > send
> > > an
> > > > > > email
> > > > > > > to:
> > > > > > > > >
> > > > > > >
> > > > >
> > >
> [EMAIL PROTECTED]
> > > > > > > > >
> > > > > > > > > Your use of Yahoo! Groups is
> > subject
> > > to
> > > > > the
> > > > > > > > > Yahoo! Terms of Service.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > [Non-text portions of this message
> > have
> > > > been
> > > > > > > > > removed]
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > _______________________________
> > > > > > > > Do you Yahoo!?
> > > > > > > > Declare Yourself - Register online to
> > vote
> > > > > > today!
> > > > > > > > http://vote.yahoo.com
> > > > > > > >
> > > > > > > > Yahoo! Groups SponsorADVERTISEMENT
> > > > > > > >
> > > > > > > >
> > > > > > > > ---------------------------------
> > > > > > > > Yahoo! Groups Links
> > > > > > > >
> > > > > > > > To visit your group on the web, go
> > to:
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > > > > > > >
> > > > > > > > To unsubscribe from this group,
> send
> > an
> > > > > email
> > > > > > > to:
> > > > > > > >
> > > > > >
> > > >
> > [EMAIL PROTECTED]
> > > > > > > >
> > > > > > > > Your use of Yahoo! Groups is
> subject
> > to
> > > > the
> > > > > > > Yahoo! Terms of
> > > > > > > Service.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message
> have
> > > been
> > > > > > > removed]
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Yahoo! Groups SponsorADVERTISEMENT
> > > > > > >
> > > > > > >
> > > > > > > ---------------------------------
> > > > > > > Yahoo! Groups Links
> > > > > > >
> > > > > > > To visit your group on the web, go
> to:
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > > > > > >
> > > > > > > To unsubscribe from this group, send
> an
> > > > email
> > > > > > to:
> > > > > > >
> > > > >
> > >
> [EMAIL PROTECTED]
> > > > > > >
> > > > > > > Your use of Yahoo! Groups is subject
> to
> > > the
> > > > > > > Yahoo! Terms of Service.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have
> > been
> > > > > > > removed]
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > __________________________________
> > > > > > Do you Yahoo!?
> > > > > > Take Yahoo! Mail with you! Get it on your
> > > mobile
> > > > > > phone.
> > > > > > http://mobile.yahoo.com/maildemo
> > > > > >
> > > > > > Yahoo! Groups SponsorADVERTISEMENT
> > > > > >
> > > > > >
> > > > > > ---------------------------------
> > > > > > Yahoo! Groups Links
> > > > > >
> > > > > > To visit your group on the web, go to:
> > > > > >
> > > > >
> > > >
> > >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > > > > >
> > > > > > To unsubscribe from this group, send an
> > > email
> > > > > to:
> > > > > >
> > > >
> > [EMAIL PROTECTED]
> > > > > >
> > > > > > Your use of Yahoo! Groups is subject to
> > the
> > > > > > Yahoo! Terms of Service.
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have
> been
> > > > > > removed]
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> __________________________________________________
> > > > > Do You Yahoo!?
> > > > > Tired of spam? Yahoo! Mail has the best
> spam
> > > > > protection around
> > > > > http://mail.yahoo.com
> > > > >
> > > > > Yahoo! Groups SponsorADVERTISEMENT
> > > > >
> > > > >
> > > > > ---------------------------------
> > > > > Yahoo! Groups Links
> > > > >
> > > > > To visit your group on the web, go to:
> > > > >
> > > >
> > >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > > > >
> > > > > To unsubscribe from this group, send an
> > email
> > > > to:
> > > > >
> > >
> [EMAIL PROTECTED]
> > > > >
> > > > > Your use of Yahoo! Groups is subject to
> the
> > > > > Yahoo! Terms of Service.
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been
> > > > > removed]
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Yahoo! Mail Address AutoComplete - You start.
> We
> > > > finish.
> > > > http://promotions.yahoo.com/new_mail
> > > >
> > > > Yahoo! Groups SponsorADVERTISEMENT
> > > >
> > > >
> > > > ---------------------------------
> > > > Yahoo! Groups Links
> > > >
> > > > To visit your group on the web, go to:
> > > >
> > >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > > >
> > > > To unsubscribe from this group, send an
> email
> > > to:
> > > >
> > [EMAIL PROTECTED]
> > > >
> > > > Your use of Yahoo! Groups is subject to the
> > > > Yahoo! Terms of Service.
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been
> > > > removed]
> > > >
> > > >
> > >
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam
> > > protection around
> > > http://mail.yahoo.com
> > >
> > > Yahoo! Groups SponsorADVERTISEMENT
> > >
> > >
> > > ---------------------------------
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > >
> > > To unsubscribe from this group, send an email
> > to:
> > >
> [EMAIL PROTECTED]
> > >
> > > Your use of Yahoo! Groups is subject to the
> > > Yahoo! Terms of Service.
> > >
> > >
> > >
> > > [Non-text portions of this message have been
> > > removed]
> > >
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> > protection around
> > http://mail.yahoo.com
> > ----------
> >
> > Sub Submit2_Click(sender As Object, e As
> EventArgs)
> >
> > If Page.IsValid then
> >
> > 'INSERT Account Info and get PKID
> > 'AddAccount(TextBox1.Text,
> > TextBox_new.Text, TextBox2.Text, TextBox3.Text,
> > DropDownList1.SelectedItem.Text, TextBox4.Text)
> >
> >
> > 'Search and retrieve PKID from
> Customer
> > Table
> > 'Dim PKID as String
> > 'PKID = GetCustomerUID(TextBox7.Text)
> >
> >
> > 'INSERT Card#/PIN info plus foreign
> keys
> > from "CallingCardAccount"
> > ' and "Customer" tables.
> >
> >
> >
> >
> '===================================================
> > Dim objConn As SqlConnection
> > Dim objSQLCommand As SqlCommand
> > Dim objParam As SqlParameter
> > Dim boolInsertOK As Boolean = False
> > Dim intReturnError as Integer
> > 'Set up our connection object and SQL
> > command object.
> > objConn = New
> >
>
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
> > objSQLCommand = New
> > SqlCommand("sp_InsertAllRecords", objConn)
> > 'Set the stored procedure.
> > objSQLCommand.CommandType =
> > CommandType.StoredProcedure
> > 'Add input parameters...
> > objParam =
> > objSQLCommand.Parameters.Add("@AccountNumber",
> > TextBox1.Text)
> > objParam =
> >
> objSQLCommand.Parameters.Add("@BillingAddressName",
> > TextBox_new.Text)
> > objParam =
> > objSQLCommand.Parameters.Add("@BillingAddress",
> > TextBox2.Text)
> > objParam =
> >
> objSQLCommand.Parameters.Add("@BillingAddressCity",
> > TextBox3.Text)
> > objParam =
> >
> objSQLCommand.Parameters.Add("@BillingAddressState",
> > DropDownList1.SelectedItem.Text)
> > objParam =
> > objSQLCommand.Parameters.Add("@BillingAddressZip",
> > TextBox4.Text)
> > objParam =
> > objSQLCommand.Parameters.Add("@CardNum",
> > TextBox5.Text)
> > objParam =
> > objSQLCommand.Parameters.Add("@CardPIN",
> > TextBox6.Text)
> > 'Add our ouput parameters...
> > objParam =
> > objSQLCommand.Parameters.Add("@Error_Code",
> > SqlDbType.Int)
> > objParam.Direction =
> > ParameterDirection.Output
> > 'Open the db connection & Execute
> > Command.
> > objConn.Open()
> > objSQLCommand.ExecuteNonQuery()
> > 'Get the return values.
> > If Not
> >
>
IsDBNull(objSQLCommand.Parameters("@Error_Code").Value)
> > Then
> > intReturnError =
> > (objSQLCommand.Parameters("@Error_Code").Value)
> > End If
> > 'Check the error.
> > If intReturnError = 0 Then
> > 'No errors. Set our confirm msg.
> > boolInsertOK = True
> > Else
> > 'We had an error. Set our error
> > msg.
> > boolInsertOK = False
> > End If
> > 'Close the DB connection.
> > objConn.Close()
> >
> >
>
'========================================================
> >
> >
> >
> >
> >
> >
> >
> > Panel1.Visible = False
> > Panel3.Visible = False
> > Panel4.Visible = True
> > Label3.Visible = True
> > Label3.Text = "<b>" & "The following
> > data has been added." & "<p>" & "<table border=0
> > cellpadding=2 cellspacing=5><tr><td>" & "Account
> > #::</td>" & "<td>" & TextBox1.Text & "</td>" &
> > "<tr><td>Billing Address Name:</td>" & "<td>" &
> > TextBox_new.Text & "</td>" &
> "<tr><td>Address:</td>"
> > & "<td>" & TextBox2.text & "</td><tr><td>" &
> > "City:</td><td>" & TextBox3.Text & "</td>" &
> > "<tr><td>State:" & "<td>" &
> > DropDownList1.SelectedItem.Text & "</td>" &
> > "<tr><td>Zip:</td>" & "<td>" & TextBox4.Text &
> > "</td>" & "</table></b>"
> >
> > End If
> >
> > End Sub
> >
> > ----------
> >
> > CREATE procedure sp_InsertAllRecords
> > @AccountNumber varchar(50),
> > @BillingAddressName varchar(100),
> > @BillingAddress varchar(100),
> > @BillingAddressCity varchar(50),
> > @BillingAddressState char(2),
> > @BillingAddressZip varchar(20),
> > @CustomerUID int,
> > @CardUID int,
> > @CardNum varchar(50),
> > @CardPIN varchar(50),
> > @Error_Code int output
> > as
> > declare
> > @SQLErrorCode int,
> > @WhateverID int,
> > @PK1 int
> >
> > begin tran InsertAllRecords
> > --
> >
>
************************************************************
> > -- *** Step 1 - Insert the first record ***
> > --
> >
>
************************************************************
> > Insert CallingCardAccount
> > (AccountNumber,BillingAddressName, BillingAddress,
> > BillingAddressCity, BillingAddressState,
> > BillingAddressZip)
> > Values (@AccountNumber, @BillingAddressName,
> > @BillingAddress, @BillingAddressCity,
> > @BillingAddressState, @BillingAddressZip)
> > -- Now check for any errors.
> > select @SQLErrorCode = @@Error
> > -- Get the PK for this new record.
> > select @PK1 = @@identity
> > -- If we have an error, set the variable and
> return
> > it and rollback the transaction.
> > if @SQLErrorCode <> 0
> > begin
> > rollback tran InsertAllRecords
> > set @Error_Code = 1
> > return
> > end
> > --
> >
>
************************************************************
> > -- *** Step 2 - Insert the second record using the
> > PK from ***
> > -- *** the first record inserted above
>
> > ***
> > --
> >
>
************************************************************
> > Insert into CallingCardInfo(CustomerUID,
> AccountUID,
> > CardUID, CardNum, CardPIN)
> > Values (@CustomerUID, @AccountUID, @CardUID,
> > @CardNum, @CardPIN)
> > -- Now check for any errors.
> > select @SQLErrorCode = @@Error
> > -- If we have an error, set the variable and
> return
> > it and rollback the transaction.
> > if @SQLErrorCode <> 0
> > begin
> > rollback tran InsertAllRecords
> > set @Error_Code = 2
> > return
> > end
> > -- If we made it this far, then the transaction
> was
> > successful.
> > commit tran InsertAllRecords
> > set @Error_Code = 0
> > return
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
> > Yahoo! Groups SponsorADVERTISEMENT
> >
> >
> > ---------------------------------
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> >
> > To unsubscribe from this group, send an email
> to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the
> > Yahoo! Terms of Service.
> >
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We
> finish.
> http://promotions.yahoo.com/new_mail
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
