Thank you

I have a question regarding the use of timer. I have created a VB .Net form with a timer that run at the background which at interval of one minutes will make a connection to the SQLCE database to retrieve data. At the same time there are others forms which is also be running based on the user interaction with the system. The others form it will too make connection to the database based on user interaction (example click button to save data). I want to ask is that if the timer is currently on executing it codes, and then when the user click to save data into database, will the system complete the timer execution then follow by the user execution code or run at the same time? I'm sorry that I unable to provide a clear question (it may be confusing) but I'm really need help for this. Thanks in advance

Hi, I currently faced a problem on inserting decimal value from vb .net into SQLCE which declared as money data type. ANyone know how to solve this?? Thanks in advance!

Anyone know how to set the listview forecolor and backgroundcolor? (For .Net Compact Framework) I'm facing difficulty in understanding on how to set text color for a particular cell or item in the listview and also the background color for a row. Please help... really need to know how to do it. Thanks a million!!!

Anyone know how to set the listview forecolor and backgroundcolor? I'm facing difficulty in understanding on how to set text color for a particular cell or item in the listview and also the background color for a row. Please help... really need to know how to do it. Thanks a million!!!

Anyone know how to convert from string to time? I have a dropdown list that contain a list of time. When I retrieve the value selected by user, but the problem is the value return from the dropdown list is in text/string. How can I convert it to time? Thank you very very much in advance for reply my question.

Hi, anyone know how to set a particular cell text color in datagrid for .Net Compact Framework? Thanks in advance!

Anyone know how to sum as decimal in SQLCE database? I had try using below statement: SELECT SUM(decimal(eAmount),9,6) AS Total FROM ExpenseDetail WHERE catID = 1 It give the error that it is not regcognize by SQLCE. Please help!! Thanks in advance.

Anyone know how to sum as decimal in SQLCE database? I had try using below statement: SELECT SUM(decimal(eAmount),9,6) AS Total FROM ExpenseDetail WHERE catID = 1 It give the error that it is not regcognize by SQLCE. Please help!! Thanks in advance.

Thanks for your reply.... Some how I get to manage solve the error through out the night. The problem solve when replace '+' with '&' in SQL statement.

Thanks for your reply.... Some how I get to manage solve the error through out the night. The exception is occur at the last SQL statement.

I'm having problem on the following code: Public Class ExpenseEntity Public Function saveNewExpense(ByVal tempName As String, _ ByVal tempType As String, _ ByVal tempAmt As Integer, ByVal tempCatID As Integer) Dim cnNewEx As SqlCeConnection = New SqlCeConnection( _ "Data Source=\My Documents\PFMS.sdf; password=9EbK63Lj") Dim SQLNewEx As String Dim cmdSQLEx As SqlCeCommand Dim getEName As SqlCeDataReader Dim tempID As Integer SQLNewEx = "INSERT INTO ExpenseDetail(expenseID, catID, eType, eAmount) " & _ "VALUES (" + tempID + ", " + tempCatID + ", '" + tempType + "', " + tempAmt + ")" cmdSQLEx = New SqlCeCommand(SQLNewEx, cnNewEx) cmdSQLEx.CommandType = CommandType.Text cmdSQLEx.ExecuteNonQuery() cmdSQLEx.Dispose() cnNewEx.Close() I receive the error as: "An unhandled exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll Additional information: InvalidCastException" Please help... thanks in advance

Anyone know how to create textbox without border in .Net Compact framework running in Pocket PC? Thanks in advance.

I found a link in CodeProject about creating notification and time application. The source codes included is build from scretch which is too confusing to me. Anyone know any easier way to make a reminder notication in Pocket PC. Thanks for reply.

Thank Dan_P for your reply. Just try to confirm with you. The SQL server CE tools is pre-installed on the PDA or it needed to get the software install in it.

Hi, I'm developing a stand alone system for Pocket PC. Currently facing problem on how to create database for Pocket PC. I using VB .net to develop the system. Anyone can help here? Thanks in advance!