private void ViewTotQTybyPartNO() { a = '0'; if (DropPartNo.Text != "") { DBServer Db = new DBServer(); DataSet ds = new DataSet(); Db.PartNo = DropPartNo.Text; ds = Db.ViewTotQtybyPartnos(Db); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0].ItemArray[0].ToString() != "") { a = Convert.ToDouble(ds.Tables[0].Rows[0].ItemArray[0].ToString()); TxtProducedQty1.Text = Convert.ToString(a); } //b = TxtProducedQty.Text; //c = a + b; else { a = '0'; TxtProducedQty1.Text = "0"; } } else { } } }