Click here to Skip to main content
15,882,017 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: Object reference not set to an instance of an object. Pin
balanjingot6-May-07 14:28
balanjingot6-May-07 14:28 
hi everybody,

thanks for your reply and suggestions, finally i got the solution to my problem...


my revised code:

private void button13_Click(object sender, EventArgs e)
{
try
{


for (int i = 0; i < dataGridView4.Rows.Count -1; i++)
{
DataGridViewRow row = dataGridView4.Rows[i];

long itemcode = 0;
string description = "";
int quantity = 0;
string unit = "";

itemcode = Convert.ToInt64(row.Cells[0].Value);

if (description != null)
{
description = row.Cells[1].Value.ToString() + "";
}

quantity = Convert.ToInt32(row.Cells[2].Value);
unit = row.Cells[3].Value.ToString();

String query = "INSERT INTO test(itemcode,description,quantity,unit) VALUES ("
+ " " + itemcode
+ " ,'" + description + "'"
+ " , " + quantity
+ " ,'" + unit + "'"
+ " )";


MySqlCommand command = new MySqlCommand(query, connection);
MessageBox.Show(command.ExecuteNonQuery().ToString());

}
}

thanks guys


regardsSmile | :)

jing

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 
AnswerRe: Desktop icon positioning/re-positioning... Pin
AFSEKI7-May-07 3:17
AFSEKI7-May-07 3:17 

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.