ADOCE.NET

[Anand Kumar]

New Message on dotNET User Group Hyd ADOCE.NET Reply   Reply to Sender   Recommend Message 1 in Discussion From: Anand Kumar Hi folks, Today I am give an over view of ADOCE.NET   What is ADOCE.NET To build an application using the .NET Compact Framework, you would use ADO.NET managed provider in the System.Data.SqlServerCE namespace.The process to develop an application to use SQL Server CE is first to open the local database by creating a SqlCeEngine object. Then you update the local database by making a connection and executing SQL DDL statements. You make the connection by using the SqlCeConnection object. Once you connect to the database, you then use SqlCeCommand object to issue the DDL statements that will actually create the database table. Once the SqlCeCommand object is created, you then use ExecuteNonQuery method to run the DDS statements that creates the database. Next, you add data using SqlCeCommand object. Finally, you retrieve data from the database using the SQL Server CE Data Provider by one of two ways: (1) by using Data reader (implemented by the SqlCeDataReader object) that provides a very swift forward only motion to access data rows or (2) by using the Data adapter (implemented by the SqlCeData Adapter) that provides a 'Fill' method to fill DataSet objects with data in which you are also able to use data binding. Preferably use SqlCeDataReader because it allocates less memory than the DataSet method, which is easily destroyed after the population of the control. After the SQL Server CE database is created and the data is formed, you are then able to merge the information from the SQL Server CE database to a backend database such as SQL Server 2000. It is important to explicitly close or dispose of SqlServerCe objects after the connection is closed. In my next article I will provide sample code for ADOCE.NET  and other application targeting  to PDA. View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.