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 […]
Tag Archives: .NET
4 Simple steps to learn SqlCeDataAdapater, SqlCeDataSet to modify data in SQL Server CE tables
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 […]
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 […]
4 Easy steps to create and consume .ACX web user controls in ASP.NET 4.0, Visual Studio 2010 SP1
What are ASP.NET Web User Controls? Web User Controls are re-usable controls that you can create and use across multiple ASPX pages. When you need functionality in a control that is not provided by the built-in ASP.NET Web server controls such as <asp:TextArea>, you can create your own controls. User controls are containers into which you can […]
How to use the System.Web.Caching.Cache Object – ASP.NET Data Caching
Data caching is storing of data in web-server’s (IIS) memory for quick access by requesting browsers. Any information that is expensive to get (in terms of performance) is saved in the data cache. For example, commonly SELECTED database values that do not change often can be stored in data cache. This way instead of making repeated calls to SELECT […]
ASP.NET 4.0 Output Caching – What is VaryByParam and VaryByCustom
One of the easiest ways to cache ASP.NET pages is using OutputCache page directive. ASP.NET output caching reduces the time needed to execute ASP code by simply saving the output of the ASP in the HTML format inside IIS memory and returning the saved or cached HTML in the future request to the same page. So the […]