Comments by d!l33p nair (Top 9 by date)

tq for your reply.
the error line is...

cmd.Parameters.AddWithValue( "@item_name", dgNewSale.Rows[row].Cells["dgItemName"].Value.ToString());

till the end. i mean the all lines related to datagridview.

hey buddy, i tried new codes, in new ways. it can insert multiple rows but, i got an error, which is "object reference not set to an instance of an object" here is the code... why this error happened?



private void cmdSave_Click(object sender, EventArgs e)
{
string config = "server=localhost; userid = root; database = db_malabar";
MySqlConnection con = new MySqlConnection(config);
string query = "INSERT INTO db_malabar.temp_sales_info(invoice_number, customer_name, address, customer_phone_number, date_of_purchase, time_of_purchase, item_code, item_name, unit, quantity, retail_unit_price, total_amount, discount, grand_total) VALUES (@invoice_number, @customer_name, @address, @customer_phone_number, @date_of_purchase, @time_of_purchase, @item_code, @item_name, @unit, @quantity, @retail_unit_price, @total_amount, @discount, @grand_total)";

MySqlCommand cmd = new MySqlCommand(query, con);
con.Open();
try
{
for (int row = 0; row < dgNewSale.Rows.Count; row++)
{

cmd.Parameters.AddWithValue(
"@invoice_number", txtInvoiceNumber.Text);
cmd.Parameters.AddWithValue(
"@customer_name", txtCustomerName.Text);
cmd.Parameters.AddWithValue(
"@address", txtAddress.Text);
cmd.Parameters.AddWithValue(
"@customer_phone_number", txtPhoneNumber.Text);
cmd.Parameters.AddWithValue(
"@date_of_purchase", lblDateDisplay.Text);
cmd.Parameters.AddWithValue(
"@time_of_purchase", lblTimeDisplay.Text);
cmd.Parameters.AddWithValue(
"@item_name", dgNewSale.Rows[row].Cells["dgItemName"].Value.ToString());
cmd.Parameters.AddWithValue(
"@item_code", dgNewSale.Rows[row].Cells["dgItemCode"].Value.ToString());
cmd.Parameters.AddWithValue(
"@unit", dgNewSale.Rows[row].Cells["dgUnit"].Value.ToString());
cmd.Parameters.AddWithValue(
"@quantity", dgNewSale.Rows[row].Cells["dgQuantity"].Value.ToString());
cmd.Parameters.AddWithValue(
"@retail_unit_price", dgNewSale.Rows[row].Cells["dgUnitPrice"].Value.ToString());
cmd.Parameters.AddWithValue(
"@total_amount", dgNewSale.Rows[row].Cells["dgAmount"].Value.ToString());
cmd.Parameters.AddWithValue(
"@discount", dgNewSale.Rows[row].Cells["dgDiscount"].Value.ToString());
cmd.Parameters.AddWithValue(
"@grand_total", dgNewSale.Rows[row].Cells["dgGrandTotal"].Value.ToString());


cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
MessageBox.Show("Success");
}
con.Close();
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
}

tq for your reply. i am not perfect in c#. but i will try. tq. :)