cannot get the sum total of amount paid in school billing system

Ahmet Taha

hello guyz, i need your help how do i get the sum total of amount paid (cashreceived) of student's payment, thanks a lot.

5 Replies

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

Jignesh Kumar5y ago
Hi,

Please refer this thread,
https://stackoverflow.com/questions/53065091/how-to-get-number-value-with-decimal-from-datareader
+2
Salman Beg5y ago
The reason why it is showing indexoutofrange exception because in dr.GetInt32(6) the index 6 is not present. So you can use the index which is present. Thanks
+2
Rijwan Ansari5y ago
Hi,

You are selecting only one record as sum so use dr.GetDecimal(0) as shown
txttotalamountpaid.Text = Convert.ToString(dr.GetDecimal(0));
+3
Hiesh Kidecha5y ago
Because datatype of CashReceived column is Decimal(18,2), you should use the "GetDecimal" method of SqlDataReader. A SqlDataReader object implmements the IDataRecord interface. Hence, it implements many methods. Among these methods, there is the GetDecimal.

Try this:
```
txttotalamountpaid.Text = Convert.ToString(dr.GetDecimal(0));
```
+2
Nitin Sontakke5y ago
Hello,

Few things to note here:

1/ It should be dr.GetInt32(0).ToString() as it is the first column in the resultset.

2/ Make sure the returning value is of data type Int. Your SQL Server column is decimal, hence you should be requesting a Decimal column.

3/ Because you are getting just one value, you are better of using ExecuteScalar instead of ExecuteReader.

4/ Try to avoid directly accessing database in your application. Use layered approach. Abstract functionality and use objects to fetch data.

5/ Pretty much all your columns are nvarchar(50). This does not look good. Use correct data types.
+3