**已关闭。**此问题需要debugging details。当前不接受答案。

编辑问题以包含desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem。这将有助于其他人回答问题。
昨天关门了。
Improve this question
在一个公共的空白我有这个代码下面。我试图输入信息，它将应该进入数据网格视图，但相反，它说，输入字符串是不是在正确的格式。我将如何解决这个问题？

Boolean hasPurchase = false;
int i =0;
double total = 0;
double discount = 0;
double totalDiscount = 0;
double vatTotal = 0;
double vatDiscount = 0;
dgvCash.Rows.Clear();
cn.Open();
cm = new SqlCommand("SELECT p.ID_Purchase, p.ID_Medicine, m.BrandName, m.GenericName, p.Price, p.Quantity, p.DiscountedQuantity, p.Discount, p.NormalDiscountTotal, p.VatDiscount, p.VatTotal, p.Total from tblPurchase AS p INNER JOIN tblMedicine AS m ON p.ID_Medicine = m.ID_Medicine WHERE p.TransactionNumber LIKE @TransactionNumber and p.Status LIKE 'Pending'", cn);
cm.Parameters.AddWithValue("@TransactionNumber", lblTransNo.Text);
dr = cm.ExecuteReader();
while (dr.Read())
{
    i++;
    total += Convert.ToDouble(dr["Total"].ToString());
    discount += Convert.ToDouble(dr["Discount"].ToString());
    totalDiscount += Convert.ToDouble(dr["NormalDiscountTotal"].ToString());
    vatTotal += Convert.ToDouble(dr["VatTotal"].ToString());
    vatDiscount += Convert.ToDouble(dr["VatDiscount"].ToString());
    dgvCash.Rows.Add(i, dr["ID_Purchase"].ToString(), dr["ID_Medicine"].ToString(), dr["BrandName"].ToString(), dr["GenericName"].ToString(), dr["Price"].ToString(), dr["Quantity"].ToString(), dr["DiscountedQuantity"].ToString(), dr["Discount"].ToString(), dr["NormalDiscountTotal"].ToString(), dr["VatDiscount"].ToString(), dr["VatTotal"].ToString(), double.Parse(dr["Total"].ToString()).ToString("#,##0.00"));
    hasPurchase = true;
}
dr.Close();
cn.Close();