-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: BraiNdotNET_53
Message 26 in Discussion
DIM CMD AS OLEDBCOMMAND = NEW OLEDBCOMMAND(INSERTCMD, CON)
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@COMP", OLEDBTYPE.TEXT))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@USER", OLEDBTYPE.TEXT))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@SCRIPT", OLEDBTYPE.TEXT))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@BID_PR", OLEDBTYPE.MONEY))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@BID_QT", OLEDBTYPE.INT))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@BRK", OLEDBTYPE.MONEY))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@TTL_BRK", OLEDBTYPE.MONEY))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@COS", OLEDBTYPE.MONEY))
CMD.PARAMETERS.ADD(NEW OLEDBPARAMETER("@DATE", OLEDBTYPE.DATETIME))
CMD.Prepare() I guess the above prepare method is the resolution for ur
errors. If not let me know what kind of error are u getting say like u could
post the actual error messages rather than posting the code snippet where u are
getting them. CMD.PARAMETERS("@COMP").VALUE = TEXTBOX1.TEXT
CMD.PARAMETERS("@USER").VALUE = TEXTBOX2.TEXT
CMD.PARAMETERS("@SCRIPT").VALUE = TEXTBOX3.TEXT CMD.PARAMETERS("@BID_PR").VALUE
= TEXTBOX4.TEXT CMD.PARAMETERS("@BID_QT").VALUE = TEXTBOX5.TEXT
CMD.PARAMETERS("@BRK").VALUE() = TEXTBOX6.TEXT
CMD.PARAMETERS("@TTL_BRK").VALUE = TEXTBOX7.TEXT
CMD.PARAMETERS("@COS").VALUE = TEXTBOX8.TEXT
CMD.PARAMETERS("@DATE").VALUE = TEXTBOX9.TEXT
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]