Chalaki Systems
Training About

Category Archives: Data Access

How to Bind a DropDownList with a EditItemTemplate in the GridView

By admin | Published: May 1, 2012

ASP.NET GridViews are very handy to display data from a database table, view or a select statement that may contain joined tables. By default the gridview provides the fields in the boundfield format. The boundfields are fileds that have fixed GUI type and an associated datafield.

1
<asp:BoundField DataField="state" HeaderText="State" SortExpression="state" />

Convert a asp:BoundField to a asp:TemplateField In order to […]

Also posted in ASP.NET, GridView | 2 Responses

4 Simple steps to learn SqlCeDataAdapater, SqlCeDataSet to modify data in SQL Server CE tables

By Raja S | Published: March 18, 2011

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 […]

Also posted in ASP.NET, SQL Server Compact | 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

By Raja S | Published: March 17, 2011

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, SQL Server Compact | 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

By Raja S | Published: March 17, 2011

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, SQL Server Compact, Visual Studio 2010 SP1 | Tagged .NET, ADO.NET, ASP.NET, Data Access, Deployment, Entity Framework, SQL Server Compact | 8 Responses
  • Tags

    .NET ADO.NET ascx ASP.NET ASP.NET Performance asp:Content asp:ContentPlaceHolder C# Cache Canonical CGI Cookies CSS3 Data Access Data Cache Deployment Entity Framework GET HTML5 HTTP HTTP Headers IIS IIS Express 7.5 Install Master Page MVC3 Output Cache Partial Views Port POST Query String Reusable Routes RouteTable SQL Server Compact URL Mapping User Control VaryByCustom VaryByParam ViewState Virtual Directory Visual C# Express 2010 Visual Studio 2010 SP1 Web Platform Installer Windows XP
  • Recent Posts

    • How to design Tag based hierarchical categories, manage them using ASP.NET, EF, MVC, View Models
    • Two ways to render MVC3 Partial Views: Client side Javascript or server side html helper
    • How to Bind a DropDownList with a EditItemTemplate in the GridView
    • Fundamentals of ASP.NET MVC 3 Partial Views
    • How to program MSAGL (GLEE) to create hierarchical graph layouts
  • Calendar

    January 2021
    M T W T F S S
    « Nov    
     123
    45678910
    11121314151617
    18192021222324
    25262728293031
Copyright 2005-2011. Privacy Policy.