Loading

I am getting an error when reading data from sqldatareader

Harish Batchu

Hii

I am attaching the command

SqlCommand cmd = new SqlCommand("select SUM(cast(UserIncomeDetail_Amount as int)) as amount from ft_UserIncomeDetail where User_Uniq='Harish'", con);

con.Open();

sda=cmd.ExecuteReader();

if (sda != null)

{

ViewBag.income = sda["amount"];

}

error-

System.InvalidOperationException: 'Invalid attempt to read when no data is present.'

please the fix issue

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ruchi Sharavat8y ago
Try This:

SqlCommand cmd = new SqlCommand("select SUM(cast(UserIncomeDetail_Amount as int)) as amount from ft_UserIncomeDetail where User_Uniq='Harish'", con);
con.Open();
sda=cmd.ExecuteReader();
if (sda.Read())
{
ViewBag.income = sda["amount"];
}
0
Abhishek Mishra8y ago
Seems sda["amount"] is returning DbNull. Run the query manually on Management Studio and check. You can add below check to handle DBNull

if (sda["amount"] != DBNull) { ... Your code goes here }
0
Laxmi Katti8y ago
I think you use executescalar instead of executereader
+1