Net Programming (Web & Windows) - Database (SQL Server, My SQL, Oracle 9i, Oracle 10g) - Java Script, VB, XML, Ajax - Reports (Crystal & Jasper) - Infragistics, Devexpress - SAP BO, WEBI, Universe designer I have tried this with versions 9.2.3 and 9.3.2.
For example purpose I have used connection strings and queries in same file but for you, you need to retrieve it from web.config file and also use stored procedures.
This happens because LINQ defines the query language.
It does not define how data modifications should be performed.1) Handle the ASPx Grid View's Row Updating, Row Inserting, Row Deleting events; 2) Prevent the ASPx Grid View from trying to process modifications itself; 3) Delegate data modification operations to this additional data source.
First, we will explain how the ASPx Grid View works.At times, however, we may want to allow the user to pick an arbitrary number of items from the grid.Web-based email clients, for example, typically display the list of messages with a column of checkboxes.In particular, we'll build an example that closely mimics the web-based email client user interface.Our example will include a paged Grid View listing the products in the database table with a checkbox in each row (see Figure 1).