Insert Command Statement Help

[Brian Conway]

Can anyone give me a quick little break down of what I would need to do to
insert information into a database onClick of and Submit button? I am new
to all of this and have done it with datagrids, but want to do it with just
textboxes filled in and on click of the Submit button that it would take
those boxes and insert a record into the database. This is for C#. below
is a little of what I have on the submit button but I don't think it is
correct.

private void btnSubmit_Click (object sender, System.EventArg s e)

{

this.oleDbInser tCommand1.Comma ndText = @"INSERT INTO
CONFERENCE.REQU EST(CUID, REQ_NUM, REQ_TYPE, CREATE_DT, START_DT, END_DT,
START_TM, END_TM, REQ_TTL, ATTENDEE_QTY, SETUP_DT, SETUP_TM, REQ_DESC,
CATERING_IND, WALK_THRU_IND, STORAGE_IND, BREAKOUT_RM_IND , MATERIALS_IND,
SPECIAL_REQ_TXT , REQ_STATUS, UPDATE_DT, UPDATED_BY_CUID ,
CARD_EXPIRATION _VALUE, CHARGE_CD, BILL_METHOD_CD) VALUES (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

this.oleDbInser tCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("CUID",
System.Data.Ole Db.OleDbType.Va rChar, 8, "CUID"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("REQ_NUM",
System.Data.Ole Db.OleDbType.De cimal, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 10)),
((System.Byte)( 0)), "REQ_NUM", System.Data.Dat aRowVersion.Cur rent, null));

[Miha Markic [MVP C#]]

Hi Brian,

Assuming the sql command is correct, you'll have to add a parameter for each
? and assign a value (.Value property) to each.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Brian Conway" <Br**********@q west.com> wrote in message
news:u0******** ******@TK2MSFTN GP09.phx.gbl...

Can anyone give me a quick little break down of what I would need to do to
insert information into a database onClick of and Submit button? I am new
to all of this and have done it with datagrids, but want to do it with just textboxes filled in and on click of the Submit button that it would take
those boxes and insert a record into the database. This is for C#. below
is a little of what I have on the submit button but I don't think it is
correct.

private void btnSubmit_Click (object sender, System.EventArg s e)

{

this.oleDbInser tCommand1.Comma ndText = @"INSERT INTO
CONFERENCE.REQU EST(CUID, REQ_NUM, REQ_TYPE, CREATE_DT, START_DT, END_DT,
START_TM, END_TM, REQ_TTL, ATTENDEE_QTY, SETUP_DT, SETUP_TM, REQ_DESC,
CATERING_IND, WALK_THRU_IND, STORAGE_IND, BREAKOUT_RM_IND , MATERIALS_IND,
SPECIAL_REQ_TXT , REQ_STATUS, UPDATE_DT, UPDATED_BY_CUID ,
CARD_EXPIRATION _VALUE, CHARGE_CD, BILL_METHOD_CD) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

this.oleDbInser tCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("CUID",
System.Data.Ole Db.OleDbType.Va rChar, 8, "CUID"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("REQ_NUM",
System.Data.Ole Db.OleDbType.De cimal, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 10)),
((System.Byte)( 0)), "REQ_NUM", System.Data.Dat aRowVersion.Cur rent, null));

[Brian Conway]

Can you give me an example of how to do this. Are the insert commands in
the correct spot? Should I be putting these in the Submit button click
area?


"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:e7******** ******@TK2MSFTN GP09.phx.gbl...

Hi Brian,

Assuming the sql command is correct, you'll have to add a parameter for each ? and assign a value (.Value property) to each.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Brian Conway" <Br**********@q west.com> wrote in message
news:u0******** ******@TK2MSFTN GP09.phx.gbl...

Can anyone give me a quick little break down of what I would need to do to insert information into a database onClick of and Submit button? I am new to all of this and have done it with datagrids, but want to do it with

just

textboxes filled in and on click of the Submit button that it would take
those boxes and insert a record into the database. This is for C#. below is a little of what I have on the submit button but I don't think it is
correct.

private void btnSubmit_Click (object sender, System.EventArg s e)

{

this.oleDbInser tCommand1.Comma ndText = @"INSERT INTO
CONFERENCE.REQU EST(CUID, REQ_NUM, REQ_TYPE, CREATE_DT, START_DT, END_DT,
START_TM, END_TM, REQ_TTL, ATTENDEE_QTY, SETUP_DT, SETUP_TM, REQ_DESC,
CATERING_IND, WALK_THRU_IND, STORAGE_IND, BREAKOUT_RM_IND , MATERIALS_IND, SPECIAL_REQ_TXT , REQ_STATUS, UPDATE_DT, UPDATED_BY_CUID ,
CARD_EXPIRATION _VALUE, CHARGE_CD, BILL_METHOD_CD) VALUES (?, ?, ?, ?, ?,

?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

this.oleDbInser tCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("CUID",
System.Data.Ole Db.OleDbType.Va rChar, 8, "CUID"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("REQ_NUM",
System.Data.Ole Db.OleDbType.De cimal, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 10)),
((System.Byte)( 0)), "REQ_NUM", System.Data.Dat aRowVersion.Cur rent, null));

[Miha Markic [MVP C#]]

Hi,

"Brian Conway" <Br**********@q west.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

Can you give me an example of how to do this. Are the insert commands in
the correct spot?
I guess so.

Should I be putting these in the Submit button click area?
You might define the command and parameters at class level somewhere.
Within the submit method you just set parameter values.
See the
Inserting Data Into a SQL Database
..net help topic - it will give you an idea of what to do.
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:e7******** ******@TK2MSFTN GP09.phx.gbl...

Hi Brian,

Assuming the sql command is correct, you'll have to add a parameter for each

? and assign a value (.Value property) to each.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Brian Conway" <Br**********@q west.com> wrote in message
news:u0******** ******@TK2MSFTN GP09.phx.gbl...

Can anyone give me a quick little break down of what I would need to do to

insert information into a database onClick of and Submit button? I am new to all of this and have done it with datagrids, but want to do it with

just

textboxes filled in and on click of the Submit button that it would

take those boxes and insert a record into the database. This is for C#. below is a little of what I have on the submit button but I don't think it is correct.

private void btnSubmit_Click (object sender, System.EventArg s e)

{

this.oleDbInser tCommand1.Comma ndText = @"INSERT INTO
CONFERENCE.REQU EST(CUID, REQ_NUM, REQ_TYPE, CREATE_DT, START_DT, END_DT, START_TM, END_TM, REQ_TTL, ATTENDEE_QTY, SETUP_DT, SETUP_TM, REQ_DESC,
CATERING_IND, WALK_THRU_IND, STORAGE_IND, BREAKOUT_RM_IND , MATERIALS_IND, SPECIAL_REQ_TXT , REQ_STATUS, UPDATE_DT, UPDATED_BY_CUID ,
CARD_EXPIRATION _VALUE, CHARGE_CD, BILL_METHOD_CD) VALUES (?, ?, ?, ?,

?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

this.oleDbInser tCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("CUID",
System.Data.Ole Db.OleDbType.Va rChar, 8, "CUID"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("REQ_NUM",
System.Data.Ole Db.OleDbType.De cimal, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 10)),
((System.Byte)( 0)), "REQ_NUM", System.Data.Dat aRowVersion.Cur rent,

null));