update dataset

[pas07920]

How can I update a dataset loaded with data from an xml file?

The structure of the xml:



<Poll>

<Choice>First Choice</Choice>

<Value>0</Value>

</Poll>
....
....
I think I want to load a dataset with the data, update the dataset, then
write it back to the xml file.
Question: how do I update the dataset? The choice will be made by selecting
a radio button

[Nikolaus Hruska]

try the WriteXml() method of your DataSet:

ex.
myDataSet.WriteXml("~/Components/FileName.xml")

--
Nikolaus R. Hruska
AASHTO Materials Reference Laboratory
National Institute of Standards and Technology
[url]http://amrl.net[/url]
[email]nhruska@amrl.net[/email]


"pas07920" <pasimard@verizon.net> wrote in message
news:eRi7VTJQDHA.1612@TK2MSFTNGP11.phx.gbl...

> How can I update a dataset loaded with data from an xml file?
>
> The structure of the xml:
>
>
>
> <Poll>
>
> <Choice>First Choice</Choice>
>
> <Value>0</Value>
>
> </Poll>
> ...
> ...
> I think I want to load a dataset with the data, update the dataset, then
> write it back to the xml file.
> Question: how do I update the dataset? The choice will be made by

selecting

> a radio button
>
>

[Marc Hoeppner]

Hi,

could you post the full (relevant) sources and the error message if any?

Best regards,

Marc Höppner
NeoGeo

"Leon Shaw" <vnality@msn.com> wrote in message
news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...

> how do you update the datasource in a ms sql 2000 database using an data
> adapter and a dataset?
> Is this Correct? It's not working!
> Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtEmail.Text
>
> Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> Me.txtPhonerAreaCode.Text
>
> Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtPhone.Text
>
> Me.adptAddMember.InsertCommand.Parameters(28).Valu e =

Me.txtCurrentDate.Text

>
> Me.adptAddMember.InsertCommand.Parameters(29).Valu e =

Me.txtFutureDate.Text

>
> Me.adptAddMember.InsertCommand.Parameters(30).Valu e =

Me.txtCurrentDate.Text

>
> Me.txtMemberId.Text = Me.adptAddMember.SelectCommand.Parameters(0).Value
>
> Me.adptAddMember.Update(Me.DsReg)
>
> Me.txtMemberId.Visible = True
>
>

[Leon Shaw]

mainly I have a stored (insert) procedure built with ms sql2000 that gets
all of the member information and read back the primary key for that member.
Inside my code I map the values of all the parameters inside of the stored
procedure, and wish to update the datasource using a dataset and data
adapter? The error that I'm getting is that the data is not being added to
my database. Do I have to fill the dataset doing an insert command or call
the update command of the data adapter?

"Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...

> Hi,
>
> could you post the full (relevant) sources and the error message if any?
>
> Best regards,
>
> Marc Höppner
> NeoGeo
>
> "Leon Shaw" <vnality@msn.com> wrote in message
> news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...

> > how do you update the datasource in a ms sql 2000 database using an data
> > adapter and a dataset?
> > Is this Correct? It's not working!
> > Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtEmail.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > Me.txtPhonerAreaCode.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtPhone.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =

> Me.txtCurrentDate.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =

> Me.txtFutureDate.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =

> Me.txtCurrentDate.Text

> >
> > Me.txtMemberId.Text = Me.adptAddMember.SelectCommand.Parameters(0).Value
> >
> > Me.adptAddMember.Update(Me.DsReg)
> >
> > Me.txtMemberId.Visible = True
> >
> >

>
>

[Marc Hoeppner]

Well, I am not sure why you use a DataAdapter if you don't have a DataSet.
From the online help:
"The SqlDataAdapter, serves as a bridge between a DataSet and SQL Server for
retrieving and saving data. The SqlDataAdapter provides this bridge by
mapping Fill, which changes the data in the DataSet to match the data in the
data source, and Update, which changes the data in the data source to match
the data in the DataSet, using the appropriate Transact-SQL statements
against the data source."

You should use SqlConnection and SqlCommand.

"Leon Shaw" <vnality@msn.com> wrote in message
news:%23l1jFvqUDHA.2104@TK2MSFTNGP10.phx.gbl...

> mainly I have a stored (insert) procedure built with ms sql2000 that gets
> all of the member information and read back the primary key for that

member.

> Inside my code I map the values of all the parameters inside of the stored
> procedure, and wish to update the datasource using a dataset and data
> adapter? The error that I'm getting is that the data is not being added to
> my database. Do I have to fill the dataset doing an insert command or call
> the update command of the data adapter?
>
> "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...

> > Hi,
> >
> > could you post the full (relevant) sources and the error message if any?
> >
> > Best regards,
> >
> > Marc Höppner
> > NeoGeo
> >
> > "Leon Shaw" <vnality@msn.com> wrote in message
> > news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...

> > > how do you update the datasource in a ms sql 2000 database using an

data

> > > adapter and a dataset?
> > > Is this Correct? It's not working!
> > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtEmail.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > Me.txtPhonerAreaCode.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtPhone.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =

> > Me.txtCurrentDate.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =

> > Me.txtFutureDate.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =

> > Me.txtCurrentDate.Text

> > >
> > > Me.txtMemberId.Text =

Me.adptAddMember.SelectCommand.Parameters(0).Value

> > >
> > > Me.adptAddMember.Update(Me.DsReg)
> > >
> > > Me.txtMemberId.Visible = True
> > >
> > >

> >
> >

>
>

[Leon Shaw]

This is the Stored Procedure:
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

This Is The CODE:
Private Sub btSubmit_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btSubmit.Click

If Me.IsValid = True Then

Me.adptAddMember.InsertCommand.Parameters(1).Value = Me.txtUsername.Text

Me.adptAddMember.InsertCommand.Parameters(2).Value = Me.txtPassword.Text

Me.adptAddMember.InsertCommand.Parameters(3).Value =
Me.ddlSecretQuestion.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(4).Value = Me.txtSecretAnswer.Text

Me.adptAddMember.InsertCommand.Parameters(5).Value = Me.txtFirstName.Text

Me.adptAddMember.InsertCommand.Parameters(6).Value = Me.txtLastName.Text

Me.adptAddMember.InsertCommand.Parameters(7).Value =
Me.ddlBirthMonth.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(8).Value =
Me.ddlBirthDay.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(9).Value = Me.txtBirthYear.Text

Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
Me.rbtGender.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
Me.ddlSchoolState.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
Me.ddlSchoolName.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
Me.ddlClassification.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
Me.ddlSchoolMajor.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
Me.txtCreditCardName.Text

Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
Me.ddlCreditCardType.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
Me.txtCreditCardNumber.Text

Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
Me.ddlExpMonth.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
Me.ddlExpYear.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
Me.txtBillingAddress1.Text

Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
Me.txtBillingAddress2.Text

Me.adptAddMember.InsertCommand.Parameters(22).Valu e = Me.txtBillingCity.Text

Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
Me.ddlBillingState.SelectedItem

Me.adptAddMember.InsertCommand.Parameters(24).Valu e =
Me.txtBillingZipCode.Text

Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtEmail.Text

Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
Me.txtPhonerAreaCode.Text

Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtPhone.Text

Me.adptAddMember.InsertCommand.Parameters(28).Valu e = Me.txtCurrentDate.Text

Me.adptAddMember.InsertCommand.Parameters(29).Valu e = Me.txtFutureDate.Text

Me.adptAddMember.InsertCommand.Parameters(30).Valu e = Me.txtCurrentDate.Text

Me.txtMemberId.Text = Me.adptAddMember.SelectCommand.Parameters(0).Value

Me.adptAddMember.Update(Me.DsReg)

Me.txtMemberId.Visible = True

Do you see anything wrong? No errors is being generated? I must use a
dataset! Before calling the data adapter update command, should I fill the
dataset or not?

"Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
news:%23Ef44$qUDHA.3312@tk2msftngp13.phx.gbl...

> Well, I am not sure why you use a DataAdapter if you don't have a DataSet.
> From the online help:
> "The SqlDataAdapter, serves as a bridge between a DataSet and SQL Server

for

> retrieving and saving data. The SqlDataAdapter provides this bridge by
> mapping Fill, which changes the data in the DataSet to match the data in

the

> data source, and Update, which changes the data in the data source to

match

> the data in the DataSet, using the appropriate Transact-SQL statements
> against the data source."
>
> You should use SqlConnection and SqlCommand.
>
> "Leon Shaw" <vnality@msn.com> wrote in message
> news:%23l1jFvqUDHA.2104@TK2MSFTNGP10.phx.gbl...

> > mainly I have a stored (insert) procedure built with ms sql2000 that

gets

> > all of the member information and read back the primary key for that

> member.

> > Inside my code I map the values of all the parameters inside of the

stored

> > procedure, and wish to update the datasource using a dataset and data
> > adapter? The error that I'm getting is that the data is not being added

to

> > my database. Do I have to fill the dataset doing an insert command or

call

> > the update command of the data adapter?
> >
> > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...

> > > Hi,
> > >
> > > could you post the full (relevant) sources and the error message if

any?

> > >
> > > Best regards,
> > >
> > > Marc Höppner
> > > NeoGeo
> > >
> > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...
> > > > how do you update the datasource in a ms sql 2000 database using an

> data

> > > > adapter and a dataset?
> > > > Is this Correct? It's not working!
> > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =

Me.txtEmail.Text

> > > >
> > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > Me.txtPhonerAreaCode.Text
> > > >
> > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =

Me.txtPhone.Text

> > > >
> > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > Me.txtCurrentDate.Text
> > > >
> > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > Me.txtFutureDate.Text
> > > >
> > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > Me.txtCurrentDate.Text
> > > >
> > > > Me.txtMemberId.Text =

> Me.adptAddMember.SelectCommand.Parameters(0).Value

> > > >
> > > > Me.adptAddMember.Update(Me.DsReg)
> > > >
> > > > Me.txtMemberId.Visible = True
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Leon Shaw]

you did not see the dataset in all the code I sent you?
Me.adptAddMember.Update(Me.DsReg) at the end! So you are saying I need to
fill the dataset before updating it.
"Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
news:%23zg%23JPrUDHA.3152@tk2msftngp13.phx.gbl...

> Yes, that's the idea: You build a DataAdapter and use Fill(MyDataSet) to
> build the DataSet. Then you work with the DataSet, change, delete, add

stuff

> in MyDataSet. Then you use the DataAdapter again with Update(MyDataSet,
> MyTableName) to persist the changes. Update will then go through all the
> rows of that table and calls the UpdateCommand, InsertCommand,
> DeleteCommand. Therefore you'll need all three of these. And yes, you can
> use SProcs. In your sources you don't use a DataSet at all, as far as I

can

> see. There you should use a simple Command instead of the DataAdapter:
>
> SqlConnection con = new SqlConnection( MyConnectionString);
> SqlCommand com = new SqlCommand("SprocName", con);
> com.CommandType = CommandType.StoredProcedure;
> com.Parameters.Add( "@username", txtUsername.Text );
> etc.
>
> con.Open();
> com.ExecuteNonQuery();
> con.Close();
>
>
> "Leon Shaw" <vnality@msn.com> wrote in message
> news:%23roybGrUDHA.2332@TK2MSFTNGP09.phx.gbl...

> > This is the Stored Procedure:
> > 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
> >
> > This Is The CODE:
> > Private Sub btSubmit_Click(ByVal sender As System.Object, ByVal e As
> > System.EventArgs) Handles btSubmit.Click
> >
> > If Me.IsValid = True Then
> >
> > Me.adptAddMember.InsertCommand.Parameters(1).Value = Me.txtUsername.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(2).Value = Me.txtPassword.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(3).Value =
> > Me.ddlSecretQuestion.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(4).Value =

> Me.txtSecretAnswer.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(5).Value =

Me.txtFirstName.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(6).Value = Me.txtLastName.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(7).Value =
> > Me.ddlBirthMonth.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(8).Value =
> > Me.ddlBirthDay.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(9).Value =

Me.txtBirthYear.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
> > Me.rbtGender.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
> > Me.ddlSchoolState.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
> > Me.ddlSchoolName.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
> > Me.ddlClassification.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
> > Me.ddlSchoolMajor.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
> > Me.txtCreditCardName.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
> > Me.ddlCreditCardType.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
> > Me.txtCreditCardNumber.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
> > Me.ddlExpMonth.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
> > Me.ddlExpYear.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
> > Me.txtBillingAddress1.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
> > Me.txtBillingAddress2.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(22).Valu e =

> Me.txtBillingCity.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
> > Me.ddlBillingState.SelectedItem
> >
> > Me.adptAddMember.InsertCommand.Parameters(24).Valu e =
> > Me.txtBillingZipCode.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtEmail.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > Me.txtPhonerAreaCode.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtPhone.Text
> >
> > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =

> Me.txtCurrentDate.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =

> Me.txtFutureDate.Text

> >
> > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =

> Me.txtCurrentDate.Text

> >
> > Me.txtMemberId.Text = Me.adptAddMember.SelectCommand.Parameters(0).Value
> >
> > Me.adptAddMember.Update(Me.DsReg)
> >
> > Me.txtMemberId.Visible = True
> >
> > Do you see anything wrong? No errors is being generated? I must use a
> > dataset! Before calling the data adapter update command, should I fill

the

> > dataset or not?
> >
> > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > news:%23Ef44$qUDHA.3312@tk2msftngp13.phx.gbl...

> > > Well, I am not sure why you use a DataAdapter if you don't have a

> DataSet.

> > > From the online help:
> > > "The SqlDataAdapter, serves as a bridge between a DataSet and SQL

Server

> > for

> > > retrieving and saving data. The SqlDataAdapter provides this bridge by
> > > mapping Fill, which changes the data in the DataSet to match the data

in

> > the

> > > data source, and Update, which changes the data in the data source to

> > match

> > > the data in the DataSet, using the appropriate Transact-SQL statements
> > > against the data source."
> > >
> > > You should use SqlConnection and SqlCommand.
> > >
> > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > news:%23l1jFvqUDHA.2104@TK2MSFTNGP10.phx.gbl...
> > > > mainly I have a stored (insert) procedure built with ms sql2000 that

> > gets

> > > > all of the member information and read back the primary key for that
> > > member.
> > > > Inside my code I map the values of all the parameters inside of the

> > stored

> > > > procedure, and wish to update the datasource using a dataset and

data

> > > > adapter? The error that I'm getting is that the data is not being

> added

> > to

> > > > my database. Do I have to fill the dataset doing an insert command

or

> > call

> > > > the update command of the data adapter?
> > > >
> > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...
> > > > > Hi,
> > > > >
> > > > > could you post the full (relevant) sources and the error message

if

> > any?

> > > > >
> > > > > Best regards,
> > > > >
> > > > > Marc Höppner
> > > > > NeoGeo
> > > > >
> > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...
> > > > > > how do you update the datasource in a ms sql 2000 database using

> an

> > > data
> > > > > > adapter and a dataset?
> > > > > > Is this Correct? It's not working!
> > > > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =

> > Me.txtEmail.Text

> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > > > Me.txtPhonerAreaCode.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =

> > Me.txtPhone.Text

> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > > > Me.txtCurrentDate.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > > > Me.txtFutureDate.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > > > Me.txtCurrentDate.Text
> > > > > >
> > > > > > Me.txtMemberId.Text =
> > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > >
> > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > >
> > > > > > Me.txtMemberId.Visible = True
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Marc Hoeppner]

Yes, I did not see it, sorry. You did not send the full sources, for example
the part where you load the DS was missing.

If you already have a DS and filled it, you have to update the correct row
instead of adding parameters and then you can use Update like you do in your
code.

"Leon Shaw" <vnality@msn.com> wrote in message
news:%23t%23YDdsUDHA.1680@tk2msftngp13.phx.gbl...

> you did not see the dataset in all the code I sent you?
> Me.adptAddMember.Update(Me.DsReg) at the end! So you are saying I need to
> fill the dataset before updating it.
> "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> news:%23zg%23JPrUDHA.3152@tk2msftngp13.phx.gbl...

> > Yes, that's the idea: You build a DataAdapter and use Fill(MyDataSet) to
> > build the DataSet. Then you work with the DataSet, change, delete, add

> stuff

> > in MyDataSet. Then you use the DataAdapter again with Update(MyDataSet,
> > MyTableName) to persist the changes. Update will then go through all the
> > rows of that table and calls the UpdateCommand, InsertCommand,
> > DeleteCommand. Therefore you'll need all three of these. And yes, you

can

> > use SProcs. In your sources you don't use a DataSet at all, as far as I

> can

> > see. There you should use a simple Command instead of the DataAdapter:
> >
> > SqlConnection con = new SqlConnection( MyConnectionString);
> > SqlCommand com = new SqlCommand("SprocName", con);
> > com.CommandType = CommandType.StoredProcedure;
> > com.Parameters.Add( "@username", txtUsername.Text );
> > etc.
> >
> > con.Open();
> > com.ExecuteNonQuery();
> > con.Close();
> >
> >
> > "Leon Shaw" <vnality@msn.com> wrote in message
> > news:%23roybGrUDHA.2332@TK2MSFTNGP09.phx.gbl...

> > > This is the Stored Procedure:
> > > 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
> > >
> > > This Is The CODE:
> > > Private Sub btSubmit_Click(ByVal sender As System.Object, ByVal e As
> > > System.EventArgs) Handles btSubmit.Click
> > >
> > > If Me.IsValid = True Then
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(1).Value =

Me.txtUsername.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(2).Value =

Me.txtPassword.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(3).Value =
> > > Me.ddlSecretQuestion.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(4).Value =

> > Me.txtSecretAnswer.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(5).Value =

> Me.txtFirstName.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(6).Value =

Me.txtLastName.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(7).Value =
> > > Me.ddlBirthMonth.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(8).Value =
> > > Me.ddlBirthDay.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(9).Value =

> Me.txtBirthYear.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
> > > Me.rbtGender.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
> > > Me.ddlSchoolState.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
> > > Me.ddlSchoolName.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
> > > Me.ddlClassification.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
> > > Me.ddlSchoolMajor.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
> > > Me.txtCreditCardName.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
> > > Me.ddlCreditCardType.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
> > > Me.txtCreditCardNumber.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
> > > Me.ddlExpMonth.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
> > > Me.ddlExpYear.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
> > > Me.txtBillingAddress1.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
> > > Me.txtBillingAddress2.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(22).Valu e =

> > Me.txtBillingCity.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
> > > Me.ddlBillingState.SelectedItem
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(24).Valu e =
> > > Me.txtBillingZipCode.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtEmail.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > Me.txtPhonerAreaCode.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtPhone.Text
> > >
> > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =

> > Me.txtCurrentDate.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =

> > Me.txtFutureDate.Text

> > >
> > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =

> > Me.txtCurrentDate.Text

> > >
> > > Me.txtMemberId.Text =

Me.adptAddMember.SelectCommand.Parameters(0).Value

> > >
> > > Me.adptAddMember.Update(Me.DsReg)
> > >
> > > Me.txtMemberId.Visible = True
> > >
> > > Do you see anything wrong? No errors is being generated? I must use a
> > > dataset! Before calling the data adapter update command, should I fill

> the

> > > dataset or not?
> > >
> > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > news:%23Ef44$qUDHA.3312@tk2msftngp13.phx.gbl...
> > > > Well, I am not sure why you use a DataAdapter if you don't have a

> > DataSet.

> > > > From the online help:
> > > > "The SqlDataAdapter, serves as a bridge between a DataSet and SQL

> Server

> > > for
> > > > retrieving and saving data. The SqlDataAdapter provides this bridge

by

> > > > mapping Fill, which changes the data in the DataSet to match the

data

> in

> > > the
> > > > data source, and Update, which changes the data in the data source

to

> > > match
> > > > the data in the DataSet, using the appropriate Transact-SQL

statements

> > > > against the data source."
> > > >
> > > > You should use SqlConnection and SqlCommand.
> > > >
> > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > news:%23l1jFvqUDHA.2104@TK2MSFTNGP10.phx.gbl...
> > > > > mainly I have a stored (insert) procedure built with ms sql2000

that

> > > gets
> > > > > all of the member information and read back the primary key for

that

> > > > member.
> > > > > Inside my code I map the values of all the parameters inside of

the

> > > stored
> > > > > procedure, and wish to update the datasource using a dataset and

> data

> > > > > adapter? The error that I'm getting is that the data is not being

> > added

> > > to
> > > > > my database. Do I have to fill the dataset doing an insert command

> or

> > > call
> > > > > the update command of the data adapter?
> > > > >
> > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > > news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...
> > > > > > Hi,
> > > > > >
> > > > > > could you post the full (relevant) sources and the error message

> if

> > > any?
> > > > > >
> > > > > > Best regards,
> > > > > >
> > > > > > Marc Höppner
> > > > > > NeoGeo
> > > > > >
> > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...
> > > > > > > how do you update the datasource in a ms sql 2000 database

using

> > an

> > > > data
> > > > > > > adapter and a dataset?
> > > > > > > Is this Correct? It's not working!
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =
> > > Me.txtEmail.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > > > > Me.txtPhonerAreaCode.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =
> > > Me.txtPhone.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > > > > Me.txtCurrentDate.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > > > > Me.txtFutureDate.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > > > > Me.txtCurrentDate.Text
> > > > > > >
> > > > > > > Me.txtMemberId.Text =
> > > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > > >
> > > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > > >
> > > > > > > Me.txtMemberId.Visible = True
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Leon Shaw]

Thanks so much Marc for all the help, but I don't understand where this line
of code fit into my code:
MyDataSet.Table[0].Row[0].MyName = txtName.Text;
MyAdapter( MyDataSet );
and I have to use a dataset! Do I have to fill the data set before loading
in all the parameters? I don't think so! and when I do fill the dataset with
in the click button event I get an error after clicking the submit button
saying that the @Username parameter value is missing which number 1
parameter in my code.

"Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
news:eAdCJ0sUDHA.2284@TK2MSFTNGP12.phx.gbl...

> > did I send you enough code to understand what I'm trying to do?

>
> That's correct.
>

> > Nevertheless, is the code I sent you correct because it's not working.

>
> No, as I stated in my last email, your code is incorrect and therefore it

is

> not working. You can either forget about the DS and Adapter stuff and use
> the code that I sent you a couple of posts ago or you update the DS and

call

> Update:
>
> MyDataSet.Table[0].Row[0].MyName = txtName.Text;
>
> MyAdapter( MyDataSet );
>
>
>
> "Leon Shaw" <vnality@msn.com> wrote in message
> news:OXQFqtsUDHA.1816@TK2MSFTNGP09.phx.gbl...

> > did I send you enough code to understand what I'm trying to do?
> > Nevertheless, is the code I sent you correct because it's not working.
> > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > news:ukk82psUDHA.2252@TK2MSFTNGP10.phx.gbl...

> > > Yes, I did not see it, sorry. You did not send the full sources, for

> > example

> > > the part where you load the DS was missing.
> > >
> > > If you already have a DS and filled it, you have to update the correct

> row

> > > instead of adding parameters and then you can use Update like you do

in

> > your

> > > code.
> > >
> > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > news:%23t%23YDdsUDHA.1680@tk2msftngp13.phx.gbl...
> > > > you did not see the dataset in all the code I sent you?
> > > > Me.adptAddMember.Update(Me.DsReg) at the end! So you are saying I

> need

> > to

> > > > fill the dataset before updating it.
> > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > news:%23zg%23JPrUDHA.3152@tk2msftngp13.phx.gbl...
> > > > > Yes, that's the idea: You build a DataAdapter and use

> Fill(MyDataSet)

> > to

> > > > > build the DataSet. Then you work with the DataSet, change, delete,

> add

> > > > stuff
> > > > > in MyDataSet. Then you use the DataAdapter again with

> > Update(MyDataSet,

> > > > > MyTableName) to persist the changes. Update will then go through

all

> > the

> > > > > rows of that table and calls the UpdateCommand, InsertCommand,
> > > > > DeleteCommand. Therefore you'll need all three of these. And yes,

> you

> > > can
> > > > > use SProcs. In your sources you don't use a DataSet at all, as far

> as

> > I

> > > > can
> > > > > see. There you should use a simple Command instead of the

> DataAdapter:

> > > > >
> > > > > SqlConnection con = new SqlConnection( MyConnectionString);
> > > > > SqlCommand com = new SqlCommand("SprocName", con);
> > > > > com.CommandType = CommandType.StoredProcedure;
> > > > > com.Parameters.Add( "@username", txtUsername.Text );
> > > > > etc.
> > > > >
> > > > > con.Open();
> > > > > com.ExecuteNonQuery();
> > > > > con.Close();
> > > > >
> > > > >
> > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > news:%23roybGrUDHA.2332@TK2MSFTNGP09.phx.gbl...
> > > > > > This is the Stored Procedure:
> > > > > > 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
> > > > > >
> > > > > > This Is The CODE:
> > > > > > Private Sub btSubmit_Click(ByVal sender As System.Object, ByVal

e

> As

> > > > > > System.EventArgs) Handles btSubmit.Click
> > > > > >
> > > > > > If Me.IsValid = True Then
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(1).Value =
> > > Me.txtUsername.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(2).Value =
> > > Me.txtPassword.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(3).Value =
> > > > > > Me.ddlSecretQuestion.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(4).Value =
> > > > > Me.txtSecretAnswer.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(5).Value =
> > > > Me.txtFirstName.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(6).Value =
> > > Me.txtLastName.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(7).Value =
> > > > > > Me.ddlBirthMonth.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(8).Value =
> > > > > > Me.ddlBirthDay.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(9).Value =
> > > > Me.txtBirthYear.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
> > > > > > Me.rbtGender.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
> > > > > > Me.ddlSchoolState.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
> > > > > > Me.ddlSchoolName.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
> > > > > > Me.ddlClassification.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
> > > > > > Me.ddlSchoolMajor.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
> > > > > > Me.txtCreditCardName.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
> > > > > > Me.ddlCreditCardType.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
> > > > > > Me.txtCreditCardNumber.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
> > > > > > Me.ddlExpMonth.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
> > > > > > Me.ddlExpYear.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
> > > > > > Me.txtBillingAddress1.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
> > > > > > Me.txtBillingAddress2.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(22).Valu e =
> > > > > Me.txtBillingCity.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
> > > > > > Me.ddlBillingState.SelectedItem
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(24).Valu e =
> > > > > > Me.txtBillingZipCode.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =

> > Me.txtEmail.Text

> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > > > Me.txtPhonerAreaCode.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =

> > Me.txtPhone.Text

> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > > > Me.txtCurrentDate.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > > > Me.txtFutureDate.Text
> > > > > >
> > > > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > > > Me.txtCurrentDate.Text
> > > > > >
> > > > > > Me.txtMemberId.Text =
> > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > >
> > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > >
> > > > > > Me.txtMemberId.Visible = True
> > > > > >
> > > > > > Do you see anything wrong? No errors is being generated? I must

> use

> > a

> > > > > > dataset! Before calling the data adapter update command, should

I

> > fill

> > > > the
> > > > > > dataset or not?
> > > > > >
> > > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > > > news:%23Ef44$qUDHA.3312@tk2msftngp13.phx.gbl...
> > > > > > > Well, I am not sure why you use a DataAdapter if you don't

have

> a

> > > > > DataSet.
> > > > > > > From the online help:
> > > > > > > "The SqlDataAdapter, serves as a bridge between a DataSet and

> SQL

> > > > Server
> > > > > > for
> > > > > > > retrieving and saving data. The SqlDataAdapter provides this

> > bridge

> > > by
> > > > > > > mapping Fill, which changes the data in the DataSet to match

the

> > > data
> > > > in
> > > > > > the
> > > > > > > data source, and Update, which changes the data in the data

> source

> > > to
> > > > > > match
> > > > > > > the data in the DataSet, using the appropriate Transact-SQL
> > > statements
> > > > > > > against the data source."
> > > > > > >
> > > > > > > You should use SqlConnection and SqlCommand.
> > > > > > >
> > > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > > news:%23l1jFvqUDHA.2104@TK2MSFTNGP10.phx.gbl...
> > > > > > > > mainly I have a stored (insert) procedure built with ms

> sql2000

> > > that
> > > > > > gets
> > > > > > > > all of the member information and read back the primary key

> for

> > > that
> > > > > > > member.
> > > > > > > > Inside my code I map the values of all the parameters inside

> of

> > > the
> > > > > > stored
> > > > > > > > procedure, and wish to update the datasource using a dataset

> and

> > > > data
> > > > > > > > adapter? The error that I'm getting is that the data is not

> > being

> > > > > added
> > > > > > to
> > > > > > > > my database. Do I have to fill the dataset doing an insert

> > command

> > > > or
> > > > > > call
> > > > > > > > the update command of the data adapter?
> > > > > > > >
> > > > > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > > > > > news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > could you post the full (relevant) sources and the error

> > message

> > > > if
> > > > > > any?
> > > > > > > > >
> > > > > > > > > Best regards,
> > > > > > > > >
> > > > > > > > > Marc Höppner
> > > > > > > > > NeoGeo
> > > > > > > > >
> > > > > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > > > > news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...
> > > > > > > > > > how do you update the datasource in a ms sql 2000

database

> > > using
> > > > > an
> > > > > > > data
> > > > > > > > > > adapter and a dataset?
> > > > > > > > > > Is this Correct? It's not working!
> > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =
> > > > > > Me.txtEmail.Text
> > > > > > > > > >
> > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > > > > > > > Me.txtPhonerAreaCode.Text
> > > > > > > > > >
> > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =
> > > > > > Me.txtPhone.Text
> > > > > > > > > >
> > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > > >
> > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > > > > > > > Me.txtFutureDate.Text
> > > > > > > > > >
> > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > > >
> > > > > > > > > > Me.txtMemberId.Text =
> > > > > > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > > > > > >
> > > > > > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > > > > > >
> > > > > > > > > > Me.txtMemberId.Visible = True
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Marc Hoeppner]

That's why I asked for more source code, it is difficult to see what you do
without it. Did you do a Mapping for DS to help the adapter understand which
parameter of the SProc corresponds to which field in the DS? - From what you
said so far, I guess the answer is no (look up DataTableMapping in
correspondence to DataAdapter, MSDN has some examples, even though
admittedly it is not easy...). Do you persist the DataSet between page
loads? - If yes, then you should be fine to update the DataSet you persisted
in memory. If not, you will have to load the DataSet again, then make the
changes to the correct row and then call Update(...). I assume that you do
not persist the DataSet in between page loads:

1st loading of the page
- load the DS
- use the DS to fill the form
- send page to user

after this step your DS is essentially gone! - HTTP is stateless and so is
ASP.NET unless you do something about it. So you could do this:

1st loading of the page
- load the DS
- use the DS to fill the form
- save the DS in memory, for example in session state or in cache (do
you know how to do that?)
- send page to user

now, the DS is still in memory (in session or cache memory), so you can use
it when the user POSTs the form back to the server:

2nd loading of the page (user pressed submit)
- load the DS from memory
- change the DS by using the form data
- use the Adapter to Update( DS ) the DB
- send a result page to the user

I am not a VB guy, but you should be able to do something like this: instead
of this:

Me.adptAddMember.InsertCommand.Parameters(1).Value = Me.txtUsername.Text

you do this:

[assuming your table is table[0] and your row is row number 0 as well, and
assuming you set up the mapping between the SProc and the DS correctly!]
Me.DsReg.Tables[0].Rows[0]["UserName"] = Me.txtUsername.Text

"Leon Shaw" <vnality@msn.com> wrote in message
news:ecR4u8sUDHA.1276@TK2MSFTNGP09.phx.gbl...

> Thanks so much Marc for all the help, but I don't understand where this

line

> of code fit into my code:
> MyDataSet.Table[0].Row[0].MyName = txtName.Text;
> MyAdapter( MyDataSet );
> and I have to use a dataset! Do I have to fill the data set before

loading

> in all the parameters? I don't think so! and when I do fill the dataset

with

> in the click button event I get an error after clicking the submit button
> saying that the @Username parameter value is missing which number 1
> parameter in my code.
>
> "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> news:eAdCJ0sUDHA.2284@TK2MSFTNGP12.phx.gbl...

> > > did I send you enough code to understand what I'm trying to do?

> >
> > That's correct.
> >

> > > Nevertheless, is the code I sent you correct because it's not working.

> >
> > No, as I stated in my last email, your code is incorrect and therefore

it

> is

> > not working. You can either forget about the DS and Adapter stuff and

use

> > the code that I sent you a couple of posts ago or you update the DS and

> call

> > Update:
> >
> > MyDataSet.Table[0].Row[0].MyName = txtName.Text;
> >
> > MyAdapter( MyDataSet );
> >
> >
> >
> > "Leon Shaw" <vnality@msn.com> wrote in message
> > news:OXQFqtsUDHA.1816@TK2MSFTNGP09.phx.gbl...

> > > did I send you enough code to understand what I'm trying to do?
> > > Nevertheless, is the code I sent you correct because it's not working.
> > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > news:ukk82psUDHA.2252@TK2MSFTNGP10.phx.gbl...
> > > > Yes, I did not see it, sorry. You did not send the full sources, for
> > > example
> > > > the part where you load the DS was missing.
> > > >
> > > > If you already have a DS and filled it, you have to update the

correct

> > row

> > > > instead of adding parameters and then you can use Update like you do

> in

> > > your
> > > > code.
> > > >
> > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > news:%23t%23YDdsUDHA.1680@tk2msftngp13.phx.gbl...
> > > > > you did not see the dataset in all the code I sent you?
> > > > > Me.adptAddMember.Update(Me.DsReg) at the end! So you are saying I

> > need

> > > to
> > > > > fill the dataset before updating it.
> > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > > news:%23zg%23JPrUDHA.3152@tk2msftngp13.phx.gbl...
> > > > > > Yes, that's the idea: You build a DataAdapter and use

> > Fill(MyDataSet)

> > > to
> > > > > > build the DataSet. Then you work with the DataSet, change,

delete,

> > add

> > > > > stuff
> > > > > > in MyDataSet. Then you use the DataAdapter again with
> > > Update(MyDataSet,
> > > > > > MyTableName) to persist the changes. Update will then go through

> all

> > > the
> > > > > > rows of that table and calls the UpdateCommand, InsertCommand,
> > > > > > DeleteCommand. Therefore you'll need all three of these. And

yes,

> > you

> > > > can
> > > > > > use SProcs. In your sources you don't use a DataSet at all, as

far

> > as

> > > I
> > > > > can
> > > > > > see. There you should use a simple Command instead of the

> > DataAdapter:

> > > > > >
> > > > > > SqlConnection con = new SqlConnection( MyConnectionString);
> > > > > > SqlCommand com = new SqlCommand("SprocName", con);
> > > > > > com.CommandType = CommandType.StoredProcedure;
> > > > > > com.Parameters.Add( "@username", txtUsername.Text );
> > > > > > etc.
> > > > > >
> > > > > > con.Open();
> > > > > > com.ExecuteNonQuery();
> > > > > > con.Close();
> > > > > >
> > > > > >
> > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > news:%23roybGrUDHA.2332@TK2MSFTNGP09.phx.gbl...
> > > > > > > This is the Stored Procedure:
> > > > > > > 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
> > > > > > >
> > > > > > > This Is The CODE:
> > > > > > > Private Sub btSubmit_Click(ByVal sender As System.Object,

ByVal

> e

> > As

> > > > > > > System.EventArgs) Handles btSubmit.Click
> > > > > > >
> > > > > > > If Me.IsValid = True Then
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(1).Value =
> > > > Me.txtUsername.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(2).Value =
> > > > Me.txtPassword.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(3).Value =
> > > > > > > Me.ddlSecretQuestion.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(4).Value =
> > > > > > Me.txtSecretAnswer.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(5).Value =
> > > > > Me.txtFirstName.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(6).Value =
> > > > Me.txtLastName.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(7).Value =
> > > > > > > Me.ddlBirthMonth.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(8).Value =
> > > > > > > Me.ddlBirthDay.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(9).Value =
> > > > > Me.txtBirthYear.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
> > > > > > > Me.rbtGender.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
> > > > > > > Me.ddlSchoolState.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
> > > > > > > Me.ddlSchoolName.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
> > > > > > > Me.ddlClassification.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
> > > > > > > Me.ddlSchoolMajor.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
> > > > > > > Me.txtCreditCardName.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
> > > > > > > Me.ddlCreditCardType.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
> > > > > > > Me.txtCreditCardNumber.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
> > > > > > > Me.ddlExpMonth.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
> > > > > > > Me.ddlExpYear.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
> > > > > > > Me.txtBillingAddress1.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
> > > > > > > Me.txtBillingAddress2.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(22).Valu e =
> > > > > > Me.txtBillingCity.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
> > > > > > > Me.ddlBillingState.SelectedItem
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(24).Valu e =
> > > > > > > Me.txtBillingZipCode.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =
> > > Me.txtEmail.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > > > > Me.txtPhonerAreaCode.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =
> > > Me.txtPhone.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > > > > Me.txtCurrentDate.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > > > > Me.txtFutureDate.Text
> > > > > > >
> > > > > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > > > > Me.txtCurrentDate.Text
> > > > > > >
> > > > > > > Me.txtMemberId.Text =
> > > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > > >
> > > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > > >
> > > > > > > Me.txtMemberId.Visible = True
> > > > > > >
> > > > > > > Do you see anything wrong? No errors is being generated? I

must

> > use

> > > a
> > > > > > > dataset! Before calling the data adapter update command,

should

> I

> > > fill
> > > > > the
> > > > > > > dataset or not?
> > > > > > >
> > > > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > > > > news:%23Ef44$qUDHA.3312@tk2msftngp13.phx.gbl...
> > > > > > > > Well, I am not sure why you use a DataAdapter if you don't

> have

> > a

> > > > > > DataSet.
> > > > > > > > From the online help:
> > > > > > > > "The SqlDataAdapter, serves as a bridge between a DataSet

and

> > SQL

> > > > > Server
> > > > > > > for
> > > > > > > > retrieving and saving data. The SqlDataAdapter provides this
> > > bridge
> > > > by
> > > > > > > > mapping Fill, which changes the data in the DataSet to match

> the

> > > > data
> > > > > in
> > > > > > > the
> > > > > > > > data source, and Update, which changes the data in the data

> > source

> > > > to
> > > > > > > match
> > > > > > > > the data in the DataSet, using the appropriate Transact-SQL
> > > > statements
> > > > > > > > against the data source."
> > > > > > > >
> > > > > > > > You should use SqlConnection and SqlCommand.
> > > > > > > >
> > > > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > > > news:%23l1jFvqUDHA.2104@TK2MSFTNGP10.phx.gbl...
> > > > > > > > > mainly I have a stored (insert) procedure built with ms

> > sql2000

> > > > that
> > > > > > > gets
> > > > > > > > > all of the member information and read back the primary

key

> > for

> > > > that
> > > > > > > > member.
> > > > > > > > > Inside my code I map the values of all the parameters

inside

> > of

> > > > the
> > > > > > > stored
> > > > > > > > > procedure, and wish to update the datasource using a

dataset

> > and

> > > > > data
> > > > > > > > > adapter? The error that I'm getting is that the data is

not

> > > being
> > > > > > added
> > > > > > > to
> > > > > > > > > my database. Do I have to fill the dataset doing an insert
> > > command
> > > > > or
> > > > > > > call
> > > > > > > > > the update command of the data adapter?
> > > > > > > > >
> > > > > > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in

message

> > > > > > > > > news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > could you post the full (relevant) sources and the error
> > > message
> > > > > if
> > > > > > > any?
> > > > > > > > > >
> > > > > > > > > > Best regards,
> > > > > > > > > >
> > > > > > > > > > Marc Höppner
> > > > > > > > > > NeoGeo
> > > > > > > > > >
> > > > > > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > > > > > news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...
> > > > > > > > > > > how do you update the datasource in a ms sql 2000

> database

> > > > using
> > > > > > an
> > > > > > > > data
> > > > > > > > > > > adapter and a dataset?
> > > > > > > > > > > Is this Correct? It's not working!
> > > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =
> > > > > > > Me.txtEmail.Text
> > > > > > > > > > >
> > > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > > > > > > > > Me.txtPhonerAreaCode.Text
> > > > > > > > > > >
> > > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =
> > > > > > > Me.txtPhone.Text
> > > > > > > > > > >
> > > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > > > >
> > > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > > > > > > > > Me.txtFutureDate.Text
> > > > > > > > > > >
> > > > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > > > >
> > > > > > > > > > > Me.txtMemberId.Text =
> > > > > > > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > > > > > > >
> > > > > > > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > > > > > > >
> > > > > > > > > > > Me.txtMemberId.Visible = True
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Marc Hoeppner]

Ok, there are several problems on this page, so it is not a single line to
fix. It has conceptual issues. My advise is to start out with a simpler
example, maybe from a book or somewhere from the web. Here are some
pointers:

1) You shouldn't use DSs the way you use them here: you built a large DS
that is basically a full dump of your database. You shouldn't do this as
this is not very effective in terms of performance and memory. Use
DataReaders or single table DSs to fill the dropdownlists with their values
(during PageLoad when IsPostBack = false like you do). Goto
[url]http://www.microsoft.com/patterns[/url] and download the Data Access Application
Blocks, they are very helpful and reduce code size.

2) Inside the IsPostBack = false, load only the single DataRow with the
person you would like to display. You can do that with a
SqlConnection/SqlCommand.ExecuteQuery. Then, fill all the textboxes with the
values from the DataRow and set the DDLs to their proper values.

3) Now, when the user presses submit, you check for errors and then use a
SqlConnection/SqlCommand.ExecuteNonQuery to call your stored procedure and
give it the values similar to what you do know, just without the
SqlDataAdapter stuff.

That should be fairly easy to do. Next, you try to recode it using DSs if
you want, but you definitely don't need DSs here. If you still want to use
them, fine, just make sure that you don't load all persons, just load a
single row and then use the row to set the form controls as in 2), this time
from the DS (txtUserName.Text = DsReg.Tables[0].Rows[0]["Username"] etc.).
Save the DS in session state or in cache, so you don't have to reload it
next time. If you don't want this, make sure you load the DS again, after
the user presses submit during page load. Then as in 3) use the controls to
update the DS (DsReg.Tables[0].Rows[0]["Username"] = txtUserName.Text ).
After you did this for every control you need, use Adapter.Update( DsReg,
MyTableName ) to update the data.

"Leon Shaw" <vnality@msn.com> wrote in message
news:O4Y3yOtUDHA.216@TK2MSFTNGP10.phx.gbl...

> Ok this is my full code, now what missing for as you can see!
> Imports System.Data.SqlClient
>
> Public Class index
>
> Inherits System.Web.UI.Page
>
> Protected WithEvents txtUsername As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtPassword As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtCheckPassword As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtSecretAnswer As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtFirstName As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtLastName As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtBirthYear As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents rbtGender As

System.Web.UI.WebControls.RadioButtonList

>
> Protected WithEvents txtEmail As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtCurrentDate As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtFutureDate As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents ddlSecretQuestion As
> System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlBirthMonth As

System.Web.UI.WebControls.DropDownList

>
> Protected WithEvents ddlBirthDay As System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlSchoolState As
> System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlSchoolName As

System.Web.UI.WebControls.DropDownList

>
> Protected WithEvents ddlClassification As
> System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlSchoolMajor As
> System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlCreditCardType As
> System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlExpMonth As System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlExpYear As System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents ddlBillingState As
> System.Web.UI.WebControls.DropDownList
>
> Protected WithEvents valreqUsername As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valcusUsername As
> System.Web.UI.WebControls.CustomValidator
>
> Protected WithEvents valexpUsername As
> System.Web.UI.WebControls.RegularExpressionValidat or
>
> Protected WithEvents valreqPassword As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valcmpPasswordAndUsername As
> System.Web.UI.WebControls.CompareValidator
>
> Protected WithEvents valcusPassword As
> System.Web.UI.WebControls.CustomValidator
>
> Protected WithEvents valexpPassword As
> System.Web.UI.WebControls.RegularExpressionValidat or
>
> Protected WithEvents valreqRetypePassword As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valcmpRetypePassword As
> System.Web.UI.WebControls.CompareValidator
>
> Protected WithEvents valreqSecretAnswer As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valcmpSecretAnswer As
> System.Web.UI.WebControls.CustomValidator
>
> Protected WithEvents valreqFirstName As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqLastName As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqBirthMonth As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqBirthDay As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqBirthYear As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqGender As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqSchoolState As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqSchoolName As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqClassification As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqSchoolMajor As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqEmail As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valexpEmail As
> System.Web.UI.WebControls.RegularExpressionValidat or
>
> Protected WithEvents valreqCreditCardName As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqCreditCardType As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqCreditCardNumbe As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents txtCreditCardNumber As
> System.Web.UI.WebControls.TextBox
>
> Protected WithEvents txtCreditCardName As

System.Web.UI.WebControls.TextBox

>
> Protected WithEvents valreqBillingAddress1 As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents txtBillingAddress1 As

System.Web.UI.WebControls.TextBox

>
> Protected WithEvents txtBillingAddress2 As

System.Web.UI.WebControls.TextBox

>
> Protected WithEvents valreqBillingCity As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents txtBillingCity As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents valreqBillingState As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqBillingZipCode As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valexpBillingZipCode As
> System.Web.UI.WebControls.RegularExpressionValidat or
>
> Protected WithEvents txtBillingZipCode As

System.Web.UI.WebControls.TextBox

>
> Protected WithEvents valreqPhoneAreaCode As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents valreqPhone As
> System.Web.UI.WebControls.RequiredFieldValidator
>
> Protected WithEvents txtPhonerAreaCode As

System.Web.UI.WebControls.TextBox

>
> Protected WithEvents txtPhone As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents btSubmit As System.Web.UI.WebControls.Button
>
> Protected WithEvents rbtagree As System.Web.UI.WebControls.RadioButton
>
> Protected WithEvents lblFormHead1 As System.Web.UI.WebControls.Label
>
> Protected WithEvents lblFormHead2 As System.Web.UI.WebControls.Label
>
> Protected WithEvents adptClassification As
> System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents adptCreditCard As

System.Data.SqlClient.SqlDataAdapter

>
> Protected WithEvents cmdClassification As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents cmdCreditCard As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents adptDay As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdDay As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents connReg As System.Data.SqlClient.SqlConnection
>
> Protected WithEvents adptGender As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdGender As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents adptMajor As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdMajor As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents adptMonth As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdMonth As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents adptMySchool As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdMySchool As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents adptSecretQuestion As
> System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdSecretQuestion As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents adptState As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdState As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents adptYear As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdYear As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents DsReg As solo.dsReg
>
> Protected WithEvents txtUnitPrice As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents adptAddMember As System.Data.SqlClient.SqlDataAdapter
>
> Protected WithEvents cmdMemberId As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents cmdAddMember As System.Data.SqlClient.SqlCommand
>
> Protected WithEvents txtMemberId As System.Web.UI.WebControls.TextBox
>
> Protected WithEvents lblFormHead3 As System.Web.UI.WebControls.Label
>
> #Region " Web Form Designer Generated Code "
>
> 'This call is required by the Web Form Designer.
>
> <System.Diagnostics.DebuggerStepThrough()> Private Sub

InitializeComponent()

>
> Me.adptClassification = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdClassification = New System.Data.SqlClient.SqlCommand()
>
> Me.connReg = New System.Data.SqlClient.SqlConnection()
>
> Me.adptCreditCard = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdCreditCard = New System.Data.SqlClient.SqlCommand()
>
> Me.adptDay = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdDay = New System.Data.SqlClient.SqlCommand()
>
> Me.adptGender = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdGender = New System.Data.SqlClient.SqlCommand()
>
> Me.adptMajor = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdMajor = New System.Data.SqlClient.SqlCommand()
>
> Me.adptMonth = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdMonth = New System.Data.SqlClient.SqlCommand()
>
> Me.adptMySchool = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdMySchool = New System.Data.SqlClient.SqlCommand()
>
> Me.adptSecretQuestion = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdSecretQuestion = New System.Data.SqlClient.SqlCommand()
>
> Me.adptState = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdState = New System.Data.SqlClient.SqlCommand()
>
> Me.adptYear = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdYear = New System.Data.SqlClient.SqlCommand()
>
> Me.DsReg = New solo.dsReg()
>
> Me.adptAddMember = New System.Data.SqlClient.SqlDataAdapter()
>
> Me.cmdAddMember = New System.Data.SqlClient.SqlCommand()
>
> Me.cmdMemberId = New System.Data.SqlClient.SqlCommand()
>
> CType(Me.DsReg, System.ComponentModel.ISupportInitialize).BeginIni t()
>
> '
>
> 'adptClassification
>
> '
>
> Me.adptClassification.SelectCommand = Me.cmdClassification
>
> Me.adptClassification.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_Classification", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("Classificati onID",
> "ClassificationID"), New
> System.Data.Common.DataColumnMapping("Classificati on",

"Classification")})})

>
> '
>
> 'cmdClassification
>
> '
>
> Me.cmdClassification.CommandText = "[Get_Classification]"
>
> Me.cmdClassification.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdClassification.Connection = Me.connReg
>
> Me.cmdClassification.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))
>
> '
>
> 'connReg
>
> '
>
> Me.connReg.ConnectionString = "data source=BUSINESS;initial
> catalog=Stunation;integrated security=SSPI;persist s" & _
>
> "ecurity info=False;workstation id=BUSINESS;packet size=4096"
>
> '
>
> 'adptCreditCard
>
> '
>
> Me.adptCreditCard.SelectCommand = Me.cmdCreditCard
>
> Me.adptCreditCard.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_CreditCard", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("CardID", "CardID"), New
> System.Data.Common.DataColumnMapping("Card", "Card")})})
>
> '
>
> 'cmdCreditCard
>
> '
>
> Me.cmdCreditCard.CommandText = "[Get_CreditCard]"
>
> Me.cmdCreditCard.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdCreditCard.Connection = Me.connReg
>
> Me.cmdCreditCard.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))
>
> '
>
> 'adptDay
>
> '
>
> Me.adptDay.SelectCommand = Me.cmdDay
>
> Me.adptDay.TableMappings.AddRange(New

System.Data.Common.DataTableMapping()

> {New System.Data.Common.DataTableMapping("Table", "Get_Day", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("DayID", "DayID"), New
> System.Data.Common.DataColumnMapping("ShortDay", "ShortDay")})})
>
> '
>
> 'cmdDay
>
> '
>
> Me.cmdDay.CommandText = "[Get_Day]"
>
> Me.cmdDay.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdDay.Connection = Me.connReg
>
> Me.cmdDay.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))
>
> '
>
> 'adptGender
>
> '
>
> Me.adptGender.SelectCommand = Me.cmdGender
>
> Me.adptGender.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_Gender", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("GenderID", "GenderID"), New
> System.Data.Common.DataColumnMapping("Gender", "Gender")})})
>
> '
>
> 'cmdGender
>
> '
>
> Me.cmdGender.CommandText = "[Get_Gender]"
>
> Me.cmdGender.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdGender.Connection = Me.connReg
>
> Me.cmdGender.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))
>
> '
>
> 'adptMajor
>
> '
>
> Me.adptMajor.SelectCommand = Me.cmdMajor
>
> Me.adptMajor.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_Major", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("MajorID", "MajorID"), New
> System.Data.Common.DataColumnMapping("Major", "Major")})})
>
> '
>
> 'cmdMajor
>
> '
>
> Me.cmdMajor.CommandText = "[Get_Major]"
>
> Me.cmdMajor.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdMajor.Connection = Me.connReg
>
> Me.cmdMajor.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))
>
> '
>
> 'adptMonth
>
> '
>
> Me.adptMonth.SelectCommand = Me.cmdMonth
>
> Me.adptMonth.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_Month", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("MonthID", "MonthID"), New
> System.Data.Common.DataColumnMapping("MonthShort", "MonthShort"), New
> System.Data.Common.DataColumnMapping("MonthLong", "MonthLong")})})
>
> '
>
> 'cmdMonth
>
> '
>
> Me.cmdMonth.CommandText = "[Get_Month]"
>
> Me.cmdMonth.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdMonth.Connection = Me.connReg
>
> Me.cmdMonth.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))
>
> '
>
> 'adptMySchool
>
> '
>
> Me.adptMySchool.SelectCommand = Me.cmdMySchool
>
> Me.adptMySchool.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_SchoolByState", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("SchoolID", "SchoolID"), New
> System.Data.Common.DataColumnMapping("SchoolName", "SchoolName")})})
>
> '
>
> 'cmdMySchool
>
> '
>
> Me.cmdMySchool.CommandText = "[Get_SchoolByState]"
>
> Me.cmdMySchool.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdMySchool.Connection = Me.connReg
>
> Me.cmdMySchool.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.cmdMySchool.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@StateID",
> System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input,
> False, CType(3, Byte), CType(0, Byte), "",
> System.Data.DataRowVersion.Current, Nothing))
>
> '
>
> 'adptSecretQuestion
>
> '
>
> Me.adptSecretQuestion.SelectCommand = Me.cmdSecretQuestion
>
> Me.adptSecretQuestion.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_SecretQuestion", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("QuestionID", "QuestionID"), New
> System.Data.Common.DataColumnMapping("Question", "Question")})})
>
> '
>
> 'cmdSecretQuestion
>
> '
>
> Me.cmdSecretQuestion.CommandText = "[Get_SecretQuestion]"
>
> Me.cmdSecretQuestion.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdSecretQuestion.Connection = Me.connReg
>
> Me.cmdSecretQuestion.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))
>
> '
>
> 'adptState
>
> '
>
> Me.adptState.SelectCommand = Me.cmdState
>
> Me.adptState.TableMappings.AddRange(New
> System.Data.Common.DataTableMapping() {New
> System.Data.Common.DataTableMapping("Table", "Get_State", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("StateID", "StateID"), New
> System.Data.Common.DataColumnMapping("State", "State")})})
>
> '
>
> 'cmdState
>
> '
>
> Me.cmdState.CommandText = "[Get_State]"
>
> Me.cmdState.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdState.Connection = Me.connReg
>
> Me.cmdState.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))
>
> '
>
> 'adptYear
>
> '
>
> Me.adptYear.SelectCommand = Me.cmdYear
>
> Me.adptYear.TableMappings.AddRange(New

System.Data.Common.DataTableMapping()

> {New System.Data.Common.DataTableMapping("Table", "Get_Year", New
> System.Data.Common.DataColumnMapping() {New
> System.Data.Common.DataColumnMapping("YearID", "YearID"), New
> System.Data.Common.DataColumnMapping("YearShort", "YearShort"), New
> System.Data.Common.DataColumnMapping("YearLong", "YearLong")})})
>
> '
>
> 'cmdYear
>
> '
>
> Me.cmdYear.CommandText = "[Get_Year]"
>
> Me.cmdYear.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdYear.Connection = Me.connReg
>
> Me.cmdYear.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))
>
> '
>
> 'DsReg
>
> '
>
> Me.DsReg.DataSetName = "dsReg"
>
> Me.DsReg.Locale = New System.Globalization.CultureInfo("en-US")
>
> Me.DsReg.Namespace = "http://www.tempuri.org/dsReg.xsd"
>
> '
>
> 'adptAddMember
>
> '
>
> Me.adptAddMember.InsertCommand = Me.cmdAddMember
>
> Me.adptAddMember.SelectCommand = Me.cmdMemberId
>
> 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")})})
>
> '
>
> 'cmdAddMember
>
> '
>
> Me.cmdAddMember.CommandText = "[Add_Member]"
>
> Me.cmdAddMember.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdAddMember.Connection = Me.connReg
>
> Me.cmdAddMember.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.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Username",
> System.Data.SqlDbType.VarChar, 20))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Password",
> System.Data.SqlDbType.VarChar, 16))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SecretQuestio n",
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SecretAnswer" ,
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@FirstName",
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@LastName",
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BirthMonth",
> System.Data.SqlDbType.VarChar, 10))
>
> Me.cmdAddMember.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.cmdAddMember.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.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Gender",

System.Data.SqlDbType.VarChar,

> 6))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SchoolState",
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SchoolName",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Classificatio n",
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Major",

System.Data.SqlDbType.VarChar,

> 120))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardNam e",
> System.Data.SqlDbType.VarChar, 120))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardTyp e",
> System.Data.SqlDbType.VarChar, 20))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardNum ber",
> System.Data.SqlDbType.VarChar, 16))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardExp Month",
> System.Data.SqlDbType.VarChar, 10))
>
> Me.cmdAddMember.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.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingAddres s1",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingAddres s2",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingCity",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingState" ,
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingPostal Code",
> System.Data.SqlDbType.VarChar, 10))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@EmailAddress" ,
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@PhoneAreaCode ",
> System.Data.SqlDbType.VarChar, 3))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@PhoneNumber",
> System.Data.SqlDbType.VarChar, 8))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@ActivationDat e",
> System.Data.SqlDbType.DateTime, 8))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@RenewalDate",
> System.Data.SqlDbType.DateTime, 8))
>
> Me.cmdAddMember.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@LastUpdate",
> System.Data.SqlDbType.DateTime, 8))
>
> '
>
> 'cmdMemberId
>
> '
>
> Me.cmdMemberId.CommandText = "[Add_Member]"
>
> Me.cmdMemberId.CommandType = System.Data.CommandType.StoredProcedure
>
> Me.cmdMemberId.Connection = Me.connReg
>
> Me.cmdMemberId.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.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Username",
> System.Data.SqlDbType.VarChar, 20))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Password",
> System.Data.SqlDbType.VarChar, 16))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SecretQuestio n",
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SecretAnswer" ,
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@FirstName",
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@LastName",
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BirthMonth",
> System.Data.SqlDbType.VarChar, 10))
>
> Me.cmdMemberId.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.cmdMemberId.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.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Gender",

System.Data.SqlDbType.VarChar,

> 6))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SchoolState",
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@SchoolName",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Classificatio n",
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@Major",

System.Data.SqlDbType.VarChar,

> 120))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardNam e",
> System.Data.SqlDbType.VarChar, 120))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardTyp e",
> System.Data.SqlDbType.VarChar, 20))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardNum ber",
> System.Data.SqlDbType.VarChar, 16))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@CreditCardExp Month",
> System.Data.SqlDbType.VarChar, 10))
>
> Me.cmdMemberId.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.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingAddres s1",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingAddres s2",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingCity",
> System.Data.SqlDbType.VarChar, 200))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingState" ,
> System.Data.SqlDbType.VarChar, 50))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@BillingPostal Code",
> System.Data.SqlDbType.VarChar, 10))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@EmailAddress" ,
> System.Data.SqlDbType.VarChar, 64))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@PhoneAreaCode ",
> System.Data.SqlDbType.VarChar, 3))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@PhoneNumber",
> System.Data.SqlDbType.VarChar, 8))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@ActivationDat e",
> System.Data.SqlDbType.DateTime, 8))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@RenewalDate",
> System.Data.SqlDbType.DateTime, 8))
>
> Me.cmdMemberId.Parameters.Add(New
> System.Data.SqlClient.SqlParameter("@LastUpdate",
> System.Data.SqlDbType.DateTime, 8))
>
> CType(Me.DsReg, System.ComponentModel.ISupportInitialize).EndInit( )
>
> End Sub
>
> Private Sub Page_Init(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles MyBase.Init
>
> 'CODEGEN: This method call is required by the Web Form Designer
>
> 'Do not modify it using the code editor.
>
> InitializeComponent()
>
> End Sub
>
> #End Region
>
> Dim CurrentDate As Date = Today
>
> Dim FutureDate As Date = CurrentDate.AddYears(1)
>
> Dim Current As String = Format(CurrentDate, "MM/dd/yy")
>
> Dim Future As String = Format(FutureDate, "MM/dd/yy")
>
> Dim Price As Integer = 1000
>
> Dim Password As String
>
> Dim ck_Password As String
>
> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles MyBase.Load
>
> Me.txtCurrentDate.Text = Current
>
> Me.txtFutureDate.Text = Future
>
> Me.txtUnitPrice.Text = Price
>
> If Not Me.IsPostBack Then
>
> Me.adptClassification.Fill(Me.DsReg)
>
> Me.adptCreditCard.Fill(Me.DsReg)
>
> Me.adptGender.Fill(Me.DsReg)
>
> Me.adptDay.Fill(Me.DsReg)
>
> Me.adptMajor.Fill(Me.DsReg)
>
> Me.adptMonth.Fill(Me.DsReg)
>
> Me.adptSecretQuestion.Fill(Me.DsReg)
>
> Me.adptState.Fill(Me.DsReg)
>
> Me.adptYear.Fill(Me.DsReg)
>
> Me.ddlClassification.DataBind()
>
> Me.ddlCreditCardType.DataBind()
>
> Me.rbtGender.DataBind()
>
> Me.ddlBirthDay.DataBind()
>
> Me.ddlSchoolMajor.DataBind()
>
> Me.ddlBirthMonth.DataBind()
>
> Me.ddlExpMonth.DataBind()
>
> Me.ddlSecretQuestion.DataBind()
>
> Me.ddlSchoolState.DataBind()
>
> Me.ddlBillingState.DataBind()
>
> Me.ddlExpYear.DataBind()
>
> Me.ddlBirthMonth.Items.Insert(0, New ListItem("Month", ""))
>
> Me.ddlBirthDay.Items.Insert(0, New ListItem("Day", ""))
>
> Me.ddlSchoolState.Items.Insert(0, New ListItem("--Choose--", ""))
>
> Me.ddlSchoolName.Items.Insert(0, New ListItem("--Choose--", ""))
>
> Me.ddlCreditCardType.Items.Insert(0, New ListItem("--Choose--", ""))
>
> Me.ddlBillingState.Items.Insert(0, New ListItem("--Choose--", ""))
>
> Me.ddlClassification.Items.Insert(0, New ListItem("--Choose--", ""))
>
> End If
>
> End Sub
>
> Private Sub txtPassword_TextChanged(ByVal sender As System.Object, ByVal e
> As System.EventArgs) Handles txtPassword.TextChanged
>
> Me.Password = Me.txtPassword.Text
>
> End Sub
>
> Private Sub txtCheckPassword_TextChanged(ByVal sender As System.Object,
> ByVal e As System.EventArgs) Handles txtCheckPassword.TextChanged
>
> Me.ck_Password = Me.txtCheckPassword.Text
>
> End Sub
>
> Private Sub ddlSchoolState_SelectedIndexChanged(ByVal sender As
> System.Object, ByVal e As System.EventArgs) Handles
> ddlSchoolState.SelectedIndexChanged
>
> Me.cmdMySchool.Parameters(1).Value = Me.ddlSchoolState.SelectedItem.Value
>
> Me.adptMySchool.Fill(Me.DsReg)
>
> Me.ddlSchoolName.DataBind()
>
> Me.ddlSchoolName.Items.Insert(0, New ListItem("--Choose--", ""))
>
> End Sub
>
> Private Sub PasswordCustomValidator_ServerValidate(ByVal source As
> System.Object, ByVal args As
> System.Web.UI.WebControls.ServerValidateEventArgs)
>
> If Len(args.Value) < 6 Then
>
> args.IsValid = False
>
> Else
>
> args.IsValid = True
>
> End If
>
> End Sub
>
> Private Sub UsernameCustomValidator_ServerValidate(ByVal source As
> System.Object, ByVal args As
> System.Web.UI.WebControls.ServerValidateEventArgs)
>
> If Len(args.Value) < 4 Then
>
> args.IsValid = False
>
> Else
>
> args.IsValid = True
>
> End If
>
> End Sub
>
> Private Sub SecretAnswerCustomValidator_ServerValidate(ByVal source As
> System.Object, ByVal args As
> System.Web.UI.WebControls.ServerValidateEventArgs)
>
> If Len(args.Value) < 5 Then
>
> args.IsValid = False
>
> Else
>
> args.IsValid = True
>
> End If
>
> End Sub
>
> Private Sub btSubmit_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles btSubmit.Click
>
> If Me.IsValid = True Then
>
> Me.txtMemberId.Text = Me.adptAddMember.SelectCommand.Parameters(0).Value
>
> Me.adptAddMember.InsertCommand.Parameters(1).Value = Me.txtUsername.Text
>
> Me.adptAddMember.InsertCommand.Parameters(2).Value = Me.txtPassword.Text
>
> Me.adptAddMember.InsertCommand.Parameters(3).Value =
> Me.ddlSecretQuestion.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(4).Value =

Me.txtSecretAnswer.Text

>
> Me.adptAddMember.InsertCommand.Parameters(5).Value = Me.txtFirstName.Text
>
> Me.adptAddMember.InsertCommand.Parameters(6).Value = Me.txtLastName.Text
>
> Me.adptAddMember.InsertCommand.Parameters(7).Value =
> Me.ddlBirthMonth.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(8).Value =
> Me.ddlBirthDay.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(9).Value = Me.txtBirthYear.Text
>
> Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
> Me.rbtGender.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
> Me.ddlSchoolState.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
> Me.ddlSchoolName.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
> Me.ddlClassification.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
> Me.ddlSchoolMajor.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
> Me.txtCreditCardName.Text
>
> Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
> Me.ddlCreditCardType.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
> Me.txtCreditCardNumber.Text
>
> Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
> Me.ddlExpMonth.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
> Me.ddlExpYear.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
> Me.txtBillingAddress1.Text
>
> Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
> Me.txtBillingAddress2.Text
>
> Me.adptAddMember.InsertCommand.Parameters(22).Valu e =

Me.txtBillingCity.Text

>
> Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
> Me.ddlBillingState.SelectedItem
>
> Me.adptAddMember.InsertCommand.Parameters(24).Valu e =
> Me.txtBillingZipCode.Text
>
> Me.adptAddMember.InsertCommand.Parameters(25).Valu e = Me.txtEmail.Text
>
> Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> Me.txtPhonerAreaCode.Text
>
> Me.adptAddMember.InsertCommand.Parameters(27).Valu e = Me.txtPhone.Text
>
> Me.adptAddMember.InsertCommand.Parameters(28).Valu e =

Me.txtCurrentDate.Text

>
> Me.adptAddMember.InsertCommand.Parameters(29).Valu e =

Me.txtFutureDate.Text

>
> Me.adptAddMember.InsertCommand.Parameters(30).Valu e =

Me.txtCurrentDate.Text

>
> Me.adptAddMember.Update(Me.DsReg)
>
> Me.txtMemberId.Visible = True
>
> End If
>
> End Sub
>
> End Class
>
> "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> news:eSNKcKtUDHA.2316@TK2MSFTNGP09.phx.gbl...

> > That's why I asked for more source code, it is difficult to see what you

> do

> > without it. Did you do a Mapping for DS to help the adapter understand

> which

> > parameter of the SProc corresponds to which field in the DS? - From what

> you

> > said so far, I guess the answer is no (look up DataTableMapping in
> > correspondence to DataAdapter, MSDN has some examples, even though
> > admittedly it is not easy...). Do you persist the DataSet between page
> > loads? - If yes, then you should be fine to update the DataSet you

> persisted

> > in memory. If not, you will have to load the DataSet again, then make

the

> > changes to the correct row and then call Update(...). I assume that you

do

> > not persist the DataSet in between page loads:
> >
> > 1st loading of the page
> > - load the DS
> > - use the DS to fill the form
> > - send page to user
> >
> > after this step your DS is essentially gone! - HTTP is stateless and so

is

> > ASP.NET unless you do something about it. So you could do this:
> >
> > 1st loading of the page
> > - load the DS
> > - use the DS to fill the form
> > - save the DS in memory, for example in session state or in cache

(do

> > you know how to do that?)
> > - send page to user
> >
> > now, the DS is still in memory (in session or cache memory), so you can

> use

> > it when the user POSTs the form back to the server:
> >
> > 2nd loading of the page (user pressed submit)
> > - load the DS from memory
> > - change the DS by using the form data
> > - use the Adapter to Update( DS ) the DB
> > - send a result page to the user
> >
> > I am not a VB guy, but you should be able to do something like this:

> instead

> > of this:
> >
> > Me.adptAddMember.InsertCommand.Parameters(1).Value = Me.txtUsername.Text
> >
> > you do this:
> >
> > [assuming your table is table[0] and your row is row number 0 as well,

and

> > assuming you set up the mapping between the SProc and the DS correctly!]
> > Me.DsReg.Tables[0].Rows[0]["UserName"] = Me.txtUsername.Text
> >
> > "Leon Shaw" <vnality@msn.com> wrote in message
> > news:ecR4u8sUDHA.1276@TK2MSFTNGP09.phx.gbl...

> > > Thanks so much Marc for all the help, but I don't understand where

this

> > line

> > > of code fit into my code:
> > > MyDataSet.Table[0].Row[0].MyName = txtName.Text;
> > > MyAdapter( MyDataSet );
> > > and I have to use a dataset! Do I have to fill the data set before

> > loading

> > > in all the parameters? I don't think so! and when I do fill the

dataset

> > with

> > > in the click button event I get an error after clicking the submit

> button

> > > saying that the @Username parameter value is missing which number 1
> > > parameter in my code.
> > >
> > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > news:eAdCJ0sUDHA.2284@TK2MSFTNGP12.phx.gbl...
> > > > > did I send you enough code to understand what I'm trying to do?
> > > >
> > > > That's correct.
> > > >
> > > > > Nevertheless, is the code I sent you correct because it's not

> working.

> > > >
> > > > No, as I stated in my last email, your code is incorrect and

therefore

> > it

> > > is
> > > > not working. You can either forget about the DS and Adapter stuff

and

> > use

> > > > the code that I sent you a couple of posts ago or you update the DS

> and

> > > call
> > > > Update:
> > > >
> > > > MyDataSet.Table[0].Row[0].MyName = txtName.Text;
> > > >
> > > > MyAdapter( MyDataSet );
> > > >
> > > >
> > > >
> > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > news:OXQFqtsUDHA.1816@TK2MSFTNGP09.phx.gbl...
> > > > > did I send you enough code to understand what I'm trying to do?
> > > > > Nevertheless, is the code I sent you correct because it's not

> working.

> > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > > news:ukk82psUDHA.2252@TK2MSFTNGP10.phx.gbl...
> > > > > > Yes, I did not see it, sorry. You did not send the full sources,

> for

> > > > > example
> > > > > > the part where you load the DS was missing.
> > > > > >
> > > > > > If you already have a DS and filled it, you have to update the

> > correct

> > > > row
> > > > > > instead of adding parameters and then you can use Update like

you

> do

> > > in
> > > > > your
> > > > > > code.
> > > > > >
> > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > news:%23t%23YDdsUDHA.1680@tk2msftngp13.phx.gbl...
> > > > > > > you did not see the dataset in all the code I sent you?
> > > > > > > Me.adptAddMember.Update(Me.DsReg) at the end! So you are

saying

> I

> > > > need
> > > > > to
> > > > > > > fill the dataset before updating it.
> > > > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > > > > > > news:%23zg%23JPrUDHA.3152@tk2msftngp13.phx.gbl...
> > > > > > > > Yes, that's the idea: You build a DataAdapter and use
> > > > Fill(MyDataSet)
> > > > > to
> > > > > > > > build the DataSet. Then you work with the DataSet, change,

> > delete,

> > > > add
> > > > > > > stuff
> > > > > > > > in MyDataSet. Then you use the DataAdapter again with
> > > > > Update(MyDataSet,
> > > > > > > > MyTableName) to persist the changes. Update will then go

> through

> > > all
> > > > > the
> > > > > > > > rows of that table and calls the UpdateCommand,

InsertCommand,

> > > > > > > > DeleteCommand. Therefore you'll need all three of these. And

> > yes,

> > > > you
> > > > > > can
> > > > > > > > use SProcs. In your sources you don't use a DataSet at all,

as

> > far

> > > > as
> > > > > I
> > > > > > > can
> > > > > > > > see. There you should use a simple Command instead of the
> > > > DataAdapter:
> > > > > > > >
> > > > > > > > SqlConnection con = new SqlConnection( MyConnectionString);
> > > > > > > > SqlCommand com = new SqlCommand("SprocName", con);
> > > > > > > > com.CommandType = CommandType.StoredProcedure;
> > > > > > > > com.Parameters.Add( "@username", txtUsername.Text );
> > > > > > > > etc.
> > > > > > > >
> > > > > > > > con.Open();
> > > > > > > > com.ExecuteNonQuery();
> > > > > > > > con.Close();
> > > > > > > >
> > > > > > > >
> > > > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > > > news:%23roybGrUDHA.2332@TK2MSFTNGP09.phx.gbl...
> > > > > > > > > This is the Stored Procedure:
> > > > > > > > > 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
> > > > > > > > >
> > > > > > > > > This Is The CODE:
> > > > > > > > > Private Sub btSubmit_Click(ByVal sender As System.Object,

> > ByVal

> > > e
> > > > As
> > > > > > > > > System.EventArgs) Handles btSubmit.Click
> > > > > > > > >
> > > > > > > > > If Me.IsValid = True Then
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(1).Value =
> > > > > > Me.txtUsername.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(2).Value =
> > > > > > Me.txtPassword.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(3).Value =
> > > > > > > > > Me.ddlSecretQuestion.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(4).Value =
> > > > > > > > Me.txtSecretAnswer.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(5).Value =
> > > > > > > Me.txtFirstName.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(6).Value =
> > > > > > Me.txtLastName.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(7).Value =
> > > > > > > > > Me.ddlBirthMonth.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(8).Value =
> > > > > > > > > Me.ddlBirthDay.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(9).Value =
> > > > > > > Me.txtBirthYear.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(10).Valu e =
> > > > > > > > > Me.rbtGender.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(11).Valu e =
> > > > > > > > > Me.ddlSchoolState.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(12).Valu e =
> > > > > > > > > Me.ddlSchoolName.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(13).Valu e =
> > > > > > > > > Me.ddlClassification.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(14).Valu e =
> > > > > > > > > Me.ddlSchoolMajor.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(15).Valu e =
> > > > > > > > > Me.txtCreditCardName.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(16).Valu e =
> > > > > > > > > Me.ddlCreditCardType.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(17).Valu e =
> > > > > > > > > Me.txtCreditCardNumber.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(18).Valu e =
> > > > > > > > > Me.ddlExpMonth.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(19).Valu e =
> > > > > > > > > Me.ddlExpYear.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(20).Valu e =
> > > > > > > > > Me.txtBillingAddress1.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(21).Valu e =
> > > > > > > > > Me.txtBillingAddress2.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(22).Valu e =
> > > > > > > > Me.txtBillingCity.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(23).Valu e =
> > > > > > > > > Me.ddlBillingState.SelectedItem
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(24).Valu e =
> > > > > > > > > Me.txtBillingZipCode.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(25).Valu e =
> > > > > Me.txtEmail.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(26).Valu e =
> > > > > > > > > Me.txtPhonerAreaCode.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(27).Valu e =
> > > > > Me.txtPhone.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(28).Valu e =
> > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(29).Valu e =
> > > > > > > > Me.txtFutureDate.Text
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.InsertCommand.Parameters(30).Valu e =
> > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > >
> > > > > > > > > Me.txtMemberId.Text =
> > > > > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > > > > >
> > > > > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > > > > >
> > > > > > > > > Me.txtMemberId.Visible = True
> > > > > > > > >
> > > > > > > > > Do you see anything wrong? No errors is being generated? I

> > must

> > > > use
> > > > > a
> > > > > > > > > dataset! Before calling the data adapter update command,

> > should

> > > I
> > > > > fill
> > > > > > > the
> > > > > > > > > dataset or not?
> > > > > > > > >
> > > > > > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in

message

> > > > > > > > > news:%23Ef44$qUDHA.3312@tk2msftngp13.phx.gbl...
> > > > > > > > > > Well, I am not sure why you use a DataAdapter if you

don't

> > > have
> > > > a
> > > > > > > > DataSet.
> > > > > > > > > > From the online help:
> > > > > > > > > > "The SqlDataAdapter, serves as a bridge between a

DataSet

> > and

> > > > SQL
> > > > > > > Server
> > > > > > > > > for
> > > > > > > > > > retrieving and saving data. The SqlDataAdapter provides

> this

> > > > > bridge
> > > > > > by
> > > > > > > > > > mapping Fill, which changes the data in the DataSet to

> match

> > > the
> > > > > > data
> > > > > > > in
> > > > > > > > > the
> > > > > > > > > > data source, and Update, which changes the data in the

> data

> > > > source
> > > > > > to
> > > > > > > > > match
> > > > > > > > > > the data in the DataSet, using the appropriate

> Transact-SQL

> > > > > > statements
> > > > > > > > > > against the data source."
> > > > > > > > > >
> > > > > > > > > > You should use SqlConnection and SqlCommand.
> > > > > > > > > >
> > > > > > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > > > > > news:%23l1jFvqUDHA.2104@TK2MSFTNGP10.phx.gbl...
> > > > > > > > > > > mainly I have a stored (insert) procedure built with

ms

> > > > sql2000
> > > > > > that
> > > > > > > > > gets
> > > > > > > > > > > all of the member information and read back the

primary

> > key

> > > > for
> > > > > > that
> > > > > > > > > > member.
> > > > > > > > > > > Inside my code I map the values of all the parameters

> > inside

> > > > of
> > > > > > the
> > > > > > > > > stored
> > > > > > > > > > > procedure, and wish to update the datasource using a

> > dataset

> > > > and
> > > > > > > data
> > > > > > > > > > > adapter? The error that I'm getting is that the data

is

> > not

> > > > > being
> > > > > > > > added
> > > > > > > > > to
> > > > > > > > > > > my database. Do I have to fill the dataset doing an

> insert

> > > > > command
> > > > > > > or
> > > > > > > > > call
> > > > > > > > > > > the update command of the data adapter?
> > > > > > > > > > >
> > > > > > > > > > > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in

> > message

> > > > > > > > > > > news:eElUoUoUDHA.2204@TK2MSFTNGP10.phx.gbl...
> > > > > > > > > > > > Hi,
> > > > > > > > > > > >
> > > > > > > > > > > > could you post the full (relevant) sources and the

> error

> > > > > message
> > > > > > > if
> > > > > > > > > any?
> > > > > > > > > > > >
> > > > > > > > > > > > Best regards,
> > > > > > > > > > > >
> > > > > > > > > > > > Marc Höppner
> > > > > > > > > > > > NeoGeo
> > > > > > > > > > > >
> > > > > > > > > > > > "Leon Shaw" <vnality@msn.com> wrote in message
> > > > > > > > > > > > news:eDcG1%23mUDHA.1928@TK2MSFTNGP12.phx.gbl...
> > > > > > > > > > > > > how do you update the datasource in a ms sql 2000
> > > database
> > > > > > using
> > > > > > > > an
> > > > > > > > > > data
> > > > > > > > > > > > > adapter and a dataset?
> > > > > > > > > > > > > Is this Correct? It's not working!
> > > > > > > > > > > > >

Me.adptAddMember.InsertCommand.Parameters(25).Valu e

> =

> > > > > > > > > Me.txtEmail.Text
> > > > > > > > > > > > >
> > > > > > > > > > > > >

Me.adptAddMember.InsertCommand.Parameters(26).Valu e

> =

> > > > > > > > > > > > > Me.txtPhonerAreaCode.Text
> > > > > > > > > > > > >
> > > > > > > > > > > > >

Me.adptAddMember.InsertCommand.Parameters(27).Valu e

> =

> > > > > > > > > Me.txtPhone.Text
> > > > > > > > > > > > >
> > > > > > > > > > > > >

Me.adptAddMember.InsertCommand.Parameters(28).Valu e

> =

> > > > > > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > > > > > >
> > > > > > > > > > > > >

Me.adptAddMember.InsertCommand.Parameters(29).Valu e

> =

> > > > > > > > > > > > Me.txtFutureDate.Text
> > > > > > > > > > > > >
> > > > > > > > > > > > >

Me.adptAddMember.InsertCommand.Parameters(30).Valu e

> =

> > > > > > > > > > > > Me.txtCurrentDate.Text
> > > > > > > > > > > > >
> > > > > > > > > > > > > Me.txtMemberId.Text =
> > > > > > > > > > Me.adptAddMember.SelectCommand.Parameters(0).Value
> > > > > > > > > > > > >
> > > > > > > > > > > > > Me.adptAddMember.Update(Me.DsReg)
> > > > > > > > > > > > >
> > > > > > > > > > > > > Me.txtMemberId.Visible = True
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>