Comments by Naseer A Khan (Top 20 by date)

sir i have removed this condition from both places and Run my Project now i have this Error

ERROR: Unable to cast object of type 'System.Byte[]' to type 'System.IConvertible'.

sir i have made some changes as you mentioned but now its give me an error on next
line i.e
Error:
if (totalExp == "")
{
totalExp = "0";
}
Operator '==' cannot be applied to operands of type 'double' and 'string'
Cannot implicitly convert type 'string' to 'double'

Code:
string GetAmountInBank(string Bank)
{
string strSQL = "select Sum(AmountinBank) from BankAccount,accountitem,accountcategory where accountitem.ItemcatID=accountcategory.CategoryID and BankAccount.ItemID=accountitem.ItemID and accountcategory.IsExpense=1 and BankId like '" + Bank + "'";
double totalExp = Convert .ToDouble ( db.selectquery_One(strSQL));

if (totalExp == "")
{
totalExp = "0";
}

sir db.selecrtquery return my complete query in strSQl

and sir i have pasted my both screen shot on word file and still i am confuse how to send this file.. well sir i have copied my Method you can check it..

Sir here is my selectquery_One method:

public object selectquery_One(string query)
{
object obj="";

cammMYSQL = new MySqlCommand(query, connMYSQL);
try
{
if (connMYSQL.State == ConnectionState.Closed)
connMYSQL.Open();
obj=cammMYSQL.ExecuteScalar();

if (connMYSQL.State == ConnectionState.Open)
connMYSQL.Close();
if (obj == null) obj = "";
return obj;

}
catch (Exception e)
{
if (connMYSQL.State == ConnectionState.Open)

connMYSQL.Close();
return obj;
}

}

sir i have debug point to point my code and in both variable totalDep and totalExp System.Byte[]
array shown.. and i have taken screen short during debug so is there any way to send you these screen shot...

sir i have change Convert.ToDouble to Double.TryParse or Double.Parse but still having same issue

in my code sir you can see totalDep and totalExp both are variable those data type is String

sir after your commit i have changed my Complete query to this query
"select Sum(AmountinBank) from BankAccount ";
but again sir i am having same problem..

but sir i have run this query alone its fetching record..

sir I have posted my complete code..

one thing more i have checked my Query its fetching amount from Database..

sir i have a Bank Combo Box in my form in which list of bank is fetch from database through Select query and when i select any bank name it should bring that Bank amount from Amount TABLE unfortunately it is not done like that and this error is prompt which i have mentioned above.

One thing more i.e
in (totalDep) or in (totalExp) the System.Byte[] array in fetched, i just mark the break point on my method and then Run my code line by line so i found this Error.

I have posted my Complete Code now please help me to resolve this problem.