Click here to Skip to main content
16,007,111 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Database issues Pin
Colin Angus Mackay6-Jan-07 0:08
Colin Angus Mackay6-Jan-07 0:08 
QuestionNew class Pin
Marcus J. Smith5-Jan-07 9:50
professionalMarcus J. Smith5-Jan-07 9:50 
AnswerRe: New class Pin
Christian Graus5-Jan-07 9:55
protectorChristian Graus5-Jan-07 9:55 
QuestionNeed a help to design a 3-tier architecture Pin
hmt20045-Jan-07 8:10
hmt20045-Jan-07 8:10 
AnswerRe: Need a help to design a 3-tier architecture Pin
Christian Graus5-Jan-07 9:58
protectorChristian Graus5-Jan-07 9:58 
QuestionHow to send text in status bar and blank Data Grid cell Pin
rehan_cop5-Jan-07 6:58
rehan_cop5-Jan-07 6:58 
AnswerRe: How to send text in status bar and blank Data Grid cell Pin
Thomas Stockwell6-Jan-07 8:34
professionalThomas Stockwell6-Jan-07 8:34 
QuestionInsert into MySql using vb.net Pin
jds12075-Jan-07 5:42
jds12075-Jan-07 5:42 
I am trying to insert items into MySQL db using parameters but I keep getting this error message:

Failed to convert parameter value from a String to a DateTime.

Here is some sample code:
Dim myConnString AsString = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=192.168.1.27;" & _
"DATABASE=testship;" & _
"USER=;" & _
"PASSWORD=;" & _
"OPTION=3;"
Dim MyConnection AsNew Odbc.OdbcConnection(myConnString)
MyConnection.Open()
Dim MyCommand AsNew Odbc.OdbcCommand
MyCommand.Connection = MyConnection

MyCommand.CommandText = "INSERT INTO ls_orderitems (OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES (@OrderDate, @OrderCustomer, @OrderAcctNum, @OrderType, @OrderSoNum, @OrderItemPartNum, @OrderItemPartDesc, @OrderItemQty, @OrderItemQtyRec, @OrderItemQtyDtRec, @OrderItemBO, @OrderItemBODt, @OrderItemCanceled, @OrderItemCanceledDt, @OrderItemNotes, @OrderItemPONum, @OrderItemRetailPrice, @OrderItemSalePrice, @Status, @InsertDate)"

MyCommand.Parameters.Add(New Odbc.OdbcParameter("@OrderDate", OdbcType.Date)).Value = OrderDate
MyCommand.Parameters.Add(New Odbc.OdbcParameter("@OrderCustomer", OdbcType.VarChar)).Value = OrderCustomer
MyCommand.Parameters.Add(New Odbc.OdbcParameter("@OrderAcctNum", OdbcType.VarChar)).Value = OrderAcctNum
MyCommand.Parameters.Add(New Odbc.OdbcParameter("@OrderType", OdbcType.VarChar)).Value = OrderType
MyCommand.Parameters.Add(New Odbc.OdbcParameter("@OrderSoNum", OdbcType.Int)).Value = OrderSoNum

AnswerRe: Insert into MySql using vb.net Pin
Colin Angus Mackay5-Jan-07 5:46
Colin Angus Mackay5-Jan-07 5:46 
QuestionHelp to find an error!! Pin
tranceunte5-Jan-07 4:54
tranceunte5-Jan-07 4:54 
Questionview installed softwares Pin
MjRazzaghi4-Jan-07 23:57
MjRazzaghi4-Jan-07 23:57 
AnswerRe: view installed softwares Pin
MatrixCoder5-Jan-07 3:42
MatrixCoder5-Jan-07 3:42 
Questiondatabase table problem implementation in vb.net Pin
amaneet4-Jan-07 23:14
amaneet4-Jan-07 23:14 
QuestionWrong Exception which called Microsft Exception Block Pin
vivek_cs4-Jan-07 21:32
vivek_cs4-Jan-07 21:32 
AnswerRe: Wrong Exception which called Microsft Exception Block Pin
Colin Angus Mackay4-Jan-07 22:28
Colin Angus Mackay4-Jan-07 22:28 
QuestionObtaining Random Numbers Pin
WestSideRailways4-Jan-07 20:52
WestSideRailways4-Jan-07 20:52 
AnswerRe: Obtaining Random Numbers Pin
Christian Graus4-Jan-07 21:25
protectorChristian Graus4-Jan-07 21:25 
GeneralRe: Obtaining Random Numbers Pin
CPallini4-Jan-07 21:47
mveCPallini4-Jan-07 21:47 
AnswerRe: Obtaining Random Numbers Pin
CPallini4-Jan-07 21:34
mveCPallini4-Jan-07 21:34 
GeneralRe: Obtaining Random Numbers [modified] Pin
WestSideRailways4-Jan-07 23:14
WestSideRailways4-Jan-07 23:14 
GeneralRe: Obtaining Random Numbers Pin
Christian Graus4-Jan-07 23:36
protectorChristian Graus4-Jan-07 23:36 
GeneralRe: Obtaining Random Numbers Pin
WestSideRailways4-Jan-07 23:53
WestSideRailways4-Jan-07 23:53 
GeneralRe: Obtaining Random Numbers Pin
Dave Kreskowiak5-Jan-07 2:53
mveDave Kreskowiak5-Jan-07 2:53 
GeneralRe: Obtaining Random Numbers Pin
WestSideRailways5-Jan-07 9:56
WestSideRailways5-Jan-07 9:56 
GeneralRe: Obtaining Random Numbers Pin
Christian Graus5-Jan-07 10:04
protectorChristian Graus5-Jan-07 10:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.