You already know, from my previous blog Using ADO.NET SqlCeCommand and SqlCeDataReader to select data from SQL Server Compact how to SELECT data for ReadOnly using SqlCeDataReader Object. You can’t update the data using SqlCeDataReader object. Instead you will need to use SqlCeDataAdapter and SqlCeDataSet objects if you have to make any changes and save the data […]
Category Archives: SQL Server Compact
4 Simple steps to learn SqlCeDataAdapater, SqlCeDataSet to modify data in SQL Server CE tables
Also posted in ASP.NET, Data Access
Tagged .NET, ADO.NET, ASP.NET, C#, Data Access, SQL Server Compact
5 Responses
How to select data from SQL Server Compact CE using ADO.NET SqlCeCommand and SqlCeDataReader Objects
In this post, I will show you how to use some of the classes in System.Data.SqlServerCe Namespace to access a SQL Server CE database from a ASP.NET 4.0 web forms application. The DLL that contains System.Data.SqlServerCe Namespace and all classes in that namespace is System.Data.SqlServerCe.dll. The System.Data.SqlServerCe namespace is the managed data provider for SQLServer CE. This namespace is a collection […]
Also posted in ASP.NET, Data Access
Tagged .NET, ASP.NET, C#, Data Access, SQL Server Compact
1 Response
4 Easy steps to use SQL Server Compact (CE) in Visual Studio 2010 Express SP1
SQL Server Compact Edition is an embedded database that enables all functionality of SQL Server yet it is a simple and single file based. That means you don’t have to install the SQL Server. Simply copy the database file with .sdf extension and easily distribute it where ever you want to. Very useful in development environments […]
Also posted in ASP.NET, Data Access, Visual Studio 2010 SP1
Tagged .NET, ADO.NET, ASP.NET, Data Access, Deployment, Entity Framework, SQL Server Compact
8 Responses