Trouble trying to display integer values

[tadhg88]

Hi I am developing an asp.net web application using c# and having trouble trying to display integer values, that I have taken from the database, correctly on my webform textboxes. The values are consistently displayed with four 0’s after the decimal point and I am just wondering if anyone knows how to prevent this from happening. Thanks in advance.
Tadhg88

[Phil Weber]

What code are you using to read and display the values?

[tadhg88]

sorry amateur error they are actually stored in the sql server database table as "money" and the code im using to display them is

sqlDataAdapter1.Fill(archivedConcertDataSet1);

DataTable archivedConcerts = archivedConcertDataSet1.Tables["ArchivedConcert"];

foreach(DataRow myRow in archivedConcerts.Rows)
{
if(SelectConcert.SelectedItem.ToString() == myRow[0].ToString())
{
//*** fill textboxes with the concert data
ViewNumOfPerformances.Text = myRow[1].ToString();
ViewFeesDue.Text = myRow[2].ToString();
ViewPercentageOfTicketSales.Text = myRow[3].ToString();
ViewTotalTicketSales.Text = myRow[4].ToString();
ViewProfitOrLoss.Text = myRow[5].ToString();
}
}

[Phil Weber]

Try this:
ViewFeesDue.Text = myRow[2].Value.ToString("c");