Click here to Skip to main content
15,885,216 members
Home / Discussions / C#
   

C#

 
GeneralRe: Object reference not set to an instance of an object. Pin
lmoelleb4-May-07 21:16
lmoelleb4-May-07 21:16 
GeneralRe: Object reference not set to an instance of an object. Pin
balanjingot4-May-07 21:49
balanjingot4-May-07 21:49 
GeneralRe: Object reference not set to an instance of an object. Pin
balanjingot4-May-07 21:46
balanjingot4-May-07 21:46 
GeneralRe: Object reference not set to an instance of an object. Pin
PIEBALDconsult5-May-07 4:14
mvePIEBALDconsult5-May-07 4:14 
GeneralRe: Object reference not set to an instance of an object. Pin
PIEBALDconsult5-May-07 4:45
mvePIEBALDconsult5-May-07 4:45 
GeneralRe: Object reference not set to an instance of an object. Pin
PIEBALDconsult5-May-07 5:01
mvePIEBALDconsult5-May-07 5:01 
GeneralRe: Object reference not set to an instance of an object. Pin
balanjingot6-May-07 14:23
balanjingot6-May-07 14:23 
AnswerRe: Object reference not set to an instance of an object. Pin
Rob Graham5-May-07 12:08
Rob Graham5-May-07 12:08 
balanjingot wrote:
String query = "INSERT INTO test(itemcode,description,quantity,unit) VALUES (itemcode,description,quantity,unit)";


Won't work. C# isn't going to magically convert the variable names in th VALUES clause to the appropriate things.

Best approach would be to make the list in the VALUES clause use parameters.


"INSERT INTO test(itemcode,description,quantity,unit) VALUES ( @itemcode,@description,@quantity,@unit)"
//What is a MySqlCommand? System.Data.SqlCommand is a sealed class, so you can't derive from it...
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.Add( new SqlParameter("@itemcode",itemcode);
... the rest, in order...

command.ExecuteNonQuery();

I would suppose that one other likely cause is that your MySqlCommand Class is flawed, and the constructor
silently fails...




GeneralRe: Object reference not set to an instance of an object. Pin
balanjingot6-May-07 14:28
balanjingot6-May-07 14:28 
AnswerRe: Object reference not set to an instance of an object. Pin
AFSEKI7-May-07 3:07
AFSEKI7-May-07 3:07 
GeneralRe: Object reference not set to an instance of an object. Pin
balanjingot7-May-07 14:32
balanjingot7-May-07 14:32 
QuestionHow to expand/decompress RAR archives with C#? Pin
Uwe Keim4-May-07 10:56
sitebuilderUwe Keim4-May-07 10:56 
AnswerRe: How to expand/decompress RAR archives with C#? Pin
Tarakeshwar Reddy4-May-07 11:04
professionalTarakeshwar Reddy4-May-07 11:04 
GeneralRe: How to expand/decompress RAR archives with C#? Pin
Uwe Keim4-May-07 11:09
sitebuilderUwe Keim4-May-07 11:09 
AnswerRe: How to expand/decompress RAR archives with C#? Pin
Uwe Keim4-May-07 11:04
sitebuilderUwe Keim4-May-07 11:04 
Questionloading form 1 after the other Pin
samreengr84-May-07 10:50
samreengr84-May-07 10:50 
AnswerRe: loading form 1 after the other Pin
MoustafaS4-May-07 12:36
MoustafaS4-May-07 12:36 
AnswerRe: loading form 1 after the other Pin
Arun.Immanuel4-May-07 16:12
Arun.Immanuel4-May-07 16:12 
AnswerRe: loading form 1 after the other Pin
AFSEKI7-May-07 3:13
AFSEKI7-May-07 3:13 
Questionhow to align the label controls in group box according to their text size Pin
engsrini4-May-07 10:35
engsrini4-May-07 10:35 
QuestionComboBox ... Pin
mostafa_h4-May-07 8:44
mostafa_h4-May-07 8:44 
AnswerRe: ComboBox ... Pin
AFSEKI7-May-07 3:14
AFSEKI7-May-07 3:14 
QuestionDesktop icon positioning/re-positioning... Pin
SeanWcom4-May-07 8:20
SeanWcom4-May-07 8:20 
AnswerRe: Desktop icon positioning/re-positioning... Pin
Luc Pattyn4-May-07 8:53
sitebuilderLuc Pattyn4-May-07 8:53 
GeneralRe: Desktop icon positioning/re-positioning... Pin
SeanWcom4-May-07 9:39
SeanWcom4-May-07 9:39 

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.