I want to add age in fractions like 0.5, 1.5 etc.,

Question

I want to add age in fractions like 0.5, 1.5 etc., in my aplication,
the data type was int earlier, i changed it to decimal but when i put decimal points the aplication exits.
there are some conditions too.. part of the code i found is given below

private void txtAge_TextChanged(object sender, EventArgs e)

{

if (txtAge.Text != "")

{

if (Convert.ToInt32(txtAge.Text) > 18)

{

txtFees.Text = Convert.ToString(2);

}

else

txtFees.Text = Convert.ToString(0);

plz help

Vulpes · Answer

Try inserting G in the Format property for the Age field of the report. This denotes the 'general' format and will, hopefully, suppress the .00 when Age is a whole number.

Vulpes · Answer

Well, rdlc reports generally use a DataSet as their data source and this should contain a DataTable with an Age column. If you've filled this DataSet using a SQL query, then the Age column in the database will probably be an INT or other whole number type which would explain why it's shown as such in the report. However, I'm not sure how the value in the textbox is tying in with the DataSet unless you're inserting a new row ? The ideal solution would be to change the data type of the Age column in the database to one which allows fractional values such as DECIMAL or NUMERiC. If you can't do that, then you could add a 'custom' column to the DataTable, Age2 say, which is of type decimal and use that in the report instead of Age.

Vulpes · Answer

I'm not sure which reporting software you're using there but I would imagine the problem is the same as the original one - the Age variable is declared to be a whole number rather than a decimal and so the report is rounding it to the nearer integer: 0.6 -> 1.

Vulpes · Answer

If it's an ASP.NET application, try it like this: private void txtAge_TextChanged(object sender, EventArgs e) { decimal age; if (!Decimal.TryParse(txtAge.Text, out age) || age if (age > 18m) txtFees.Text = Convert.ToString(2); else txtFees.Text = Convert.ToString(0); }

Neeraja Sathyadas · Answer

hi, Thanks a lot for the helps. Now I have a big problem and a big doubt. Hope you can help me. My software is an OP ticket printing, saving and report giving software for a hospital. In that, while we taking reports it must show the total new OP, total old OP and all. There is a visit again button, which will be used when an old OP comes, we press the visit again button and the no. of visits will be increased by 1. and the last visit date of that person will be updated to the present date. The problem is when we take the daily report It shows all correct, Total old OP count, Total new OP count, All OK, But when we take a monthly report the numbers are not correct. It is because we are counting the Old OP by taking last visit date and no. of visit > 1, so, if the person visited more than 2 times, it is not counting, it counts only the last time as old op. How can I solve this?? I think I must add an another column in the table for saving all visited days of a person. Is that possible? How can I do that?? plz help.. Plz.. :( I am attaching the query with table creation and a stored procedure and parts of the .net code.. plz give me a detailed instruction.. I am new to all these. Plz help..

Neeraja Sathyadas · Answer

i have changed the data type in sql qry to decimal and the pblm solvd.. but now the prblm is even if i give a whole no: as age it shows with fractions Eg: If i give 15, in report it shows 15.00 any solution?? :(

Neeraja Sathyadas · Answer

the report is by rdlc. actly i'm a begnr.. i dunno much about these things.. :( where can i change that variable?? in sql query or?? the age is in a numeric textbox. i want to show the same fraction age in the report.. what can i do? plz help.. plz plz..

Neeraja Sathyadas · Answer

But in the report print details, even if i gave 0.6, it shows 1 as age.. where can I solve that?? plz help me with that too.. plzzz..

Neeraja Sathyadas · Answer

its ok now.. thnx alot :)