cmd = new SqlCommand("Select isnull( max(date),0), isnull(max(balance),0) from chinnamaniaccounts where customerid='" + TextBox1.Text + "'", con);

I did used the above querry to call the value balance stored in the max date row. But when retreving this value i'm receiving the max value from balance instead of max date. So how could i call the balance value under max date value . Please help mew out i cant get it done...

The query you used is wrong. This will return independant max values of date and balance. You should use something like... Hope that helps.
Cheers.

_________________________
- Vijay G
Strive for Perfection