Sir I jus resolved the problem little while ago. The issue was i was using the same output parameter for two command object.
After soving the issue
if (GridView1.Rows.Count == 0 )
{
cmd = new SqlCommand("Insert_Orders", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter outparm1 = new SqlParameter("@OrderID", SqlDbType.Int);
outparm1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(outparm1);
cmd.Parameters.AddWithValue("@OrderDt", currentdate.Value);
cmd.Parameters.AddWithValue("@CustID", res);
cmd.Parameters.AddWithValue("@Amount", totalamount.Value);
cmd.Parameters.AddWithValue("@AmountPaid", amountpaid.Value);
cmd.Parameters.AddWithValue("@PaymentMode", payment.Value);
cmd.Parameters.AddWithValue("@CenterID", Session["Center_Id"]);
cmd.Parameters.AddWithValue("@Modifieddate", currentdate.Value);
cmd.Parameters.AddWithValue("@EmployeeID", empid);
cmd.ExecuteNonQuery();
OrderID = Convert.ToInt32(outparm1.Value);
cmd = new SqlCommand("insert_orderDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderID", OrderID);
cmd.Parameters.AddWithValue("@price", price.Value);
cmd.Parameters.AddWithValue("@discount", discount.Value);
cmd.Parameters.AddWithValue("@Tax", tax.Value);
cmd.Parameters.AddWithValue("@Product_start_date", currentdate.Value);
cmd.Parameters.AddWithValue("@Product_modified_date", currentdate.Value);
cmd.Parameters.AddWithValue("@Product_expiry_date", exirydate.Value);
cmd.Parameters.AddWithValue("@ProductID", productdropdown.SelectedValue);
cmd.ExecuteNonQuery();
}
while (count < GridView1.Rows.Count)
{
cmd = new SqlCommand("Insert_Orders", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter outparm1 = new SqlParameter("@OrderID", SqlDbType.Int);
outparm1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(outparm1);
cmd.Parameters.AddWithValue("@OrderDt", currentdate.Value);
cmd.Parameters.AddWithValue("@CustID", res);
cmd.Parameters.AddWithValue("@Amount", price_array[count]);
cmd.Parameters.AddWithValue("@AmountPaid", amount_array[count]);
cmd.Parameters.AddWithValue("@PaymentMode", paymode_array[count]);
cmd.Parameters.AddWithValue("@CenterID", Session["Center_Id"]);
cmd.Parameters.AddWithValue("@Modifieddate", currentdate.Value);
cmd.Parameters.AddWithValue("@EmployeeID", empid);
cmd.ExecuteNonQuery();
OrderID = Convert.ToInt32(outparm1.Value);
cmd = new SqlCommand("insert_orderDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderID", OrderID);
cmd.Parameters.AddWithValue("@price", Convert.ToInt32((GridView1.Rows[count].Cells[1].Text)));
cmd.Parameters.AddWithValue("@discount", Convert.ToInt32(GridView1.Rows[count].Cells[5].Text));
cmd.Parameters.AddWithValue("@Tax", Convert.ToInt32(GridView1.Rows[count].Cells[2].Text));
cmd.Parameters.AddWithValue("@Product_start_date", Convert.ToDateTime(GridView1.Rows[count].Cells[3].Text));
cmd.Parameters.AddWithValue("@Product_modified_date", Convert.ToDateTime(GridView1.Rows[count].Cells[7].Text));
cmd.Parameters.AddWithValue("@Product_expiry_date", Convert.ToDateTime(GridView1.Rows[count].Cells[4].Text));
cmd.Parameters.AddWithValue("@ProductID", Convert.ToInt32(GridView1.Rows[count].Cells[6].Text));
cmd.ExecuteNonQuery();
count++;
}