Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
glenharvy
Starting Member
5 Posts |
 Posted - 2008-02-13 : 06:21:40
|
| Hi,I am having the following problem AFTER converting to VS2008 from VS2005 and SQLCE 3.5 from 3.01:SQL CE db file has a table called Court0 with various columns of type float. I populate the values by copying floats from another table/tables. I do this via ado.net using this code snippet: foreach (DataColumn column in this.mycourtsDataSet1.Tables[tableName].Columns) { string columnName = column.ColumnName.ToString(); string columnValue = aRow[0][columnName].ToString(); object cValue = aRow[0][columnName]; if (columnName.Remove(1) == "T" && !string.IsNullOrEmpty(columnValue)) { // Add the value to the Court0 table. DataRow[] bRow = this.mycourtsDataSet1.Tables["Court0"].Select("BookingPeriod = '" + columnName + "'"); if (bRow.Length > 0) { double colValue = Convert.ToDouble(cValue); //bRow[0][tableName] = Convert.ToInt32(columnValue); ========> bRow[0][tableName] = colValue; <==== colValue is '1055.01' } } } }This works fine in VS2005/CE3.01 BUT not in VS2008/CE3.5In CE3.5, the value entered into the cell looses it's decimal value.For example, '1055.01' becomes '1055.0' in CE3.5 .Can someone explain to me why the conversion stuffs up in CE3.5 and what do I do to fix it.Thanks, |
|
|
glenharvy
Starting Member
5 Posts |
Posted - 2008-02-14 : 01:09:07
|
| Its necessary to update the datatables dataadapter as CE3.01 and 3.5 are not compatible.Took me 2 days but I got there. |
 |
|
|
|
|
|
SQL CE 3.01 and 3.5 differences