onlinedays
چهارشنبه 17 فروردین 1390, 14:24 عصر
سلام این کد رو برای ثبت از گریدویو در بانک نوشتم ولی فقط رکورد اول رو تکراری به تعداد رکوردهای موجود ثبت میکنه !
یعنی رکورد اول رو که از گریدویو میخونه به رکورد بعدی next نمیشه.
خواهشا سریع راهنمایی کنید.ممنون
SqlConnection objconnection = new SqlConnection(connection);
SqlCommand objcommand=new SqlCommand();
for (int i = 1; i <= dataGridView1.RowCount; i++)
{
objcommand = new SqlCommand("INSERT INTO factorbuy(factorbuy_id,countfactor,customer_id,cus tomer_family,factorbuy_date,object_name,object_id, factorbuy_value,factorbuy_price_buy,factorbuy_pric e_sell,factorbuy_takhfif,factorbuy_des,factorbuy_a llsum,factorbuy_status_delete)VALUES(@factorbuy_id ,@countfactor,@customer_id,@customer_family,@facto rbuy_date,@object_name,@object_id,@factorbuy_value ,@factorbuy_price_buy,@factorbuy_price_sell,@facto rbuy_takhfif,@factorbuy_des,@factorbuy_allsum,0)", objconnection);
objcommand.Parameters.AddWithValue("@factorbuy_id" , dataGridView1.CurrentRow.Cells[0].Value.ToString());
objcommand.Parameters.AddWithValue("@countfactor", dataGridView1.CurrentRow.Cells[1].Value.ToString());
objcommand.Parameters.AddWithValue("@customer_id", dataGridView1.CurrentRow.Cells[2].Value.ToString());
objcommand.Parameters.AddWithValue("@customer_fami ly", dataGridView1.CurrentRow.Cells[3].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_dat e", dataGridView1.CurrentRow.Cells[4].Value.ToString());
objcommand.Parameters.AddWithValue("@object_name", dataGridView1.CurrentRow.Cells[5].Value.ToString());
objcommand.Parameters.AddWithValue("@object_id", dataGridView1.CurrentRow.Cells[6].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_val ue", dataGridView1.CurrentRow.Cells[7].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_pri ce_buy", dataGridView1.CurrentRow.Cells[8].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_pri ce_sell", dataGridView1.CurrentRow.Cells[9].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_tak hfif", dataGridView1.CurrentRow.Cells[10].Value.ToString());
//long mul = Convert.ToInt64(txtvalue.Text) * Convert.ToInt64(txtpricebuy.Text);
//long sub = mul - Convert.ToInt64(txttakhfif.Text);
//txtallprice.Text = sub.ToString();
objcommand.Parameters.AddWithValue("@factorbuy_all sum", dataGridView1.CurrentRow.Cells[11].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_des ", dataGridView1.CurrentRow.Cells[12].Value.ToString());
objconnection.Close();
objconnection.Open();
objcommand.ExecuteNonQuery();
یعنی رکورد اول رو که از گریدویو میخونه به رکورد بعدی next نمیشه.
خواهشا سریع راهنمایی کنید.ممنون
SqlConnection objconnection = new SqlConnection(connection);
SqlCommand objcommand=new SqlCommand();
for (int i = 1; i <= dataGridView1.RowCount; i++)
{
objcommand = new SqlCommand("INSERT INTO factorbuy(factorbuy_id,countfactor,customer_id,cus tomer_family,factorbuy_date,object_name,object_id, factorbuy_value,factorbuy_price_buy,factorbuy_pric e_sell,factorbuy_takhfif,factorbuy_des,factorbuy_a llsum,factorbuy_status_delete)VALUES(@factorbuy_id ,@countfactor,@customer_id,@customer_family,@facto rbuy_date,@object_name,@object_id,@factorbuy_value ,@factorbuy_price_buy,@factorbuy_price_sell,@facto rbuy_takhfif,@factorbuy_des,@factorbuy_allsum,0)", objconnection);
objcommand.Parameters.AddWithValue("@factorbuy_id" , dataGridView1.CurrentRow.Cells[0].Value.ToString());
objcommand.Parameters.AddWithValue("@countfactor", dataGridView1.CurrentRow.Cells[1].Value.ToString());
objcommand.Parameters.AddWithValue("@customer_id", dataGridView1.CurrentRow.Cells[2].Value.ToString());
objcommand.Parameters.AddWithValue("@customer_fami ly", dataGridView1.CurrentRow.Cells[3].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_dat e", dataGridView1.CurrentRow.Cells[4].Value.ToString());
objcommand.Parameters.AddWithValue("@object_name", dataGridView1.CurrentRow.Cells[5].Value.ToString());
objcommand.Parameters.AddWithValue("@object_id", dataGridView1.CurrentRow.Cells[6].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_val ue", dataGridView1.CurrentRow.Cells[7].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_pri ce_buy", dataGridView1.CurrentRow.Cells[8].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_pri ce_sell", dataGridView1.CurrentRow.Cells[9].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_tak hfif", dataGridView1.CurrentRow.Cells[10].Value.ToString());
//long mul = Convert.ToInt64(txtvalue.Text) * Convert.ToInt64(txtpricebuy.Text);
//long sub = mul - Convert.ToInt64(txttakhfif.Text);
//txtallprice.Text = sub.ToString();
objcommand.Parameters.AddWithValue("@factorbuy_all sum", dataGridView1.CurrentRow.Cells[11].Value.ToString());
objcommand.Parameters.AddWithValue("@factorbuy_des ", dataGridView1.CurrentRow.Cells[12].Value.ToString());
objconnection.Close();
objconnection.Open();
objcommand.ExecuteNonQuery();