Click here to Skip to main content
15,900,258 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
oogyboogyme3-Jan-07 8:51
oogyboogyme3-Jan-07 8:51 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
Tim Carmichael3-Jan-07 10:17
Tim Carmichael3-Jan-07 10:17 
GeneralRe: VB6 to VB.NET printing using Printer Language Pin
oogyboogyme4-Jan-07 13:00
oogyboogyme4-Jan-07 13:00 
GeneralRe: VB6 to VB.NET printing using Printer Language Pin
Tim Carmichael5-Jan-07 2:41
Tim Carmichael5-Jan-07 2:41 
QuestionEngineering problem-please advise Pin
neobavesten3-Jan-07 6:10
neobavesten3-Jan-07 6:10 
GeneralRe: Engineering problem-please advise Pin
nagendra rao s.v.3-Jan-07 20:07
nagendra rao s.v.3-Jan-07 20:07 
QuestionMySql connection Pin
jds12073-Jan-07 5:59
jds12073-Jan-07 5:59 
AnswerRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 6:34
mveDave Kreskowiak3-Jan-07 6:34 
jds1207 wrote:
MyCommand.CommandText = "INSERT INTO ls_orderitems (OrderItemID, OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES('OrderItemID', 'OrderDate', 'OrderCustomer', 'OrderAcctNum', 'OrderType', 'OrderSoNum', 'OrderItemPartNum', 'OrderItemPartDesc', 'OrderItemQty', 'OrderItemQtyRec', 'OrderItemQtyDtRec', 'OrderItemBO', 'OrderItemBODt','OrderItemCanceled', 'OrderItemCanceledDt', 'OrderItemNotes', 'OrderItemPONum', 'OrderItemRetailPrice', 'OrderItemSalePrice', 'Status', 'InsertDate')"



jds1207 wrote:
Data is being inserted to the db but the column names are being inserted instead of the values.


Did you happen to look at what's in the VALUES clause?? It's inserting the Column names because that exactly what your telling it to do! VALUES ('OrderItemID', 'OrderDate', ... You've told it to insert these strings into the database. You have to build the SQL statement to insert the data you have stored in variables somewhere, preferrably using a parameterized query.


Dave Kreskowiak
Microsoft MVP - Visual Basic


AnswerRe: MySql connection Pin
jds12073-Jan-07 7:17
jds12073-Jan-07 7:17 
GeneralRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 7:22
mveDave Kreskowiak3-Jan-07 7:22 
GeneralRe: MySql connection Pin
jds12073-Jan-07 7:29
jds12073-Jan-07 7:29 
GeneralRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 11:37
mveDave Kreskowiak3-Jan-07 11:37 
QuestionVB 6.0 IDE Project Explorer form icon Pin
A long way from home3-Jan-07 5:16
A long way from home3-Jan-07 5:16 
QuestionProblem Pin
amaneet3-Jan-07 1:25
amaneet3-Jan-07 1:25 
AnswerRe: Problem Pin
Dave Kreskowiak3-Jan-07 2:16
mveDave Kreskowiak3-Jan-07 2:16 
AnswerRe: Problem Pin
Martin.Smith3-Jan-07 3:57
Martin.Smith3-Jan-07 3:57 
AnswerRe: Problem Pin
Kevin McFarlane3-Jan-07 5:48
Kevin McFarlane3-Jan-07 5:48 
QuestionReading XML Pin
vivek_cs3-Jan-07 0:57
vivek_cs3-Jan-07 0:57 
AnswerRe: Reading XML Pin
Martin.Smith3-Jan-07 2:27
Martin.Smith3-Jan-07 2:27 
GeneralRe: Reading XML Pin
vivek_cs3-Jan-07 19:47
vivek_cs3-Jan-07 19:47 
GeneralRe: Reading XML Pin
Martin.Smith3-Jan-07 21:29
Martin.Smith3-Jan-07 21:29 
QuestionError Message Pin
morteza573-Jan-07 0:05
morteza573-Jan-07 0:05 
AnswerRe: Error Message Pin
Christian Graus3-Jan-07 0:19
protectorChristian Graus3-Jan-07 0:19 
GeneralRe: Error Message Pin
morteza573-Jan-07 0:34
morteza573-Jan-07 0:34 
GeneralRe: Error Message Pin
Dave Kreskowiak3-Jan-07 2:14
mveDave Kreskowiak3-Jan-07 2:14 

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.