Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / ADO.NET

ADO.NET

ADO.NET

Great Reads

by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by ortund
Login system with breach redundancy handling.
by KRucker
A description of how how to convert a .NET DataSet to an ADODB Recordset.
by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database

Latest Articles

by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by ortund
Login system with breach redundancy handling.
by KRucker
A description of how how to convert a .NET DataSet to an ADODB Recordset.
by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database

All Articles

Sort by Score

ADO.NET 

by ortund
Login system with breach redundancy handling.
by KRucker
A description of how how to convert a .NET DataSet to an ADODB Recordset.
by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database
by John Kenedy S.Kom
This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it
by arunlala
.NET Performance Tips & Tricks
by Vagif Abilov
The article describes limitations of WCF Data Services client and shows how Simple.OData.Client can become a better alternative
by Eunge
The article introduces how to easily develop business solutions in RapidWebDev through developing a product management system with the special requirement step by step.
by Leslie Sanford
Using code generation with the .NET state machine toolkit.
by Joe Sweeney
How to build a single datalayer DLL that can be used by any application
by Gordon Moore
In this part I have added the routines to update the database on exit, and because I felt very generous, I have added in a routine to import data from an Excel datasheet.
by Gordon Moore
A base Windows Form for displaying, editing and automatically updating many-to-many relationships.
by Stanciu Vlad
It implements an object that is intended for data viewing; the idea was to derive from a ListView.
by Raj Lal
Chapter 11 of "Fun with Silverlight 4" More information at http://silverlightfun.com
by Rahul Rajat Singh
A beginner's tutorial for understanding ADO.NET using a simple application.
by Rahul Rajat Singh
This article is a beginner's tutorial for understanding what are transactions and how can transactions be implemented using .Net framework and ADO.NET for any ASP.NET web application or any other database driven application.
by Steef D.
A listview with support for Databinding, Sorting & Autofit and upon rebinding data reselection of a previous selected item
by Abhijit Jana
This article describes how to use RAISERROR in SQL Server 2005
by Dr. Song Li
This is part 2 of a comparison on Data Access methods in the .NET environment.
by Dr. Song Li
This is the part 1 of a comparison on Data Access methods in the .NET environment.
by Dr. Song Li
This is the part 3 of a comparison on Data Access methods in the .NET environment.
by Gurdeep Singh Toor
A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.
by Stanciu Vlad
This article provides a combo box that is easy to use with data sources.
by Qwertie
Demonstrates a variety of Windows Forms data binding features through several simple examples.
by jebarson
New features of Visual Studio 2010 discussed
by Jörgen Andersson
A high performance extension for creating a DataTable from a Generic collection.
by santosh poojari
This article shows you how to make use of DataAccessLayer and caching.
by MeraMBA.com
Purely object oriented ADO code component to get your project running, no matter what database you are using at the backend. Specialised for SQL Server.
by lost in transition
This article illustrates a helpful database library.
by TofuBug24
Shows a solution for creating a Master-Detail relation using textboxes.
by Mohamed Kalmoua
In this article, I will create a master-detail view using the Entity Framework.
by WendellH
A C# implementation of the TextFieldParser class submitted by Tony Selkes that includes the ability to put the schema in an XML file and load the data directly into a DataTable.
by Eunge
ValidationScope is used to collect all input errors in a context although validation code exists in independent APIs.
by Ws Hu
This article tries to introduce a decoupled, unit-testable, deployment-flexible, implementation-efficient and validation-flexible N-Tier architecture in .NET
by Pete2004
The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid
by FiegeU
A pragmatically introduction to DOJO for form based CRUD database operations with ASP.NET
by Jörgen Andersson
A propertymapping extension for DataReaders
by Mike Baldini
Finally, a RichTextBox that can bind to the RTF property
by David Donovan
This is a short series of articles about Abstract Programming. This part is a look at C# authoring a JavaScript file at design time.
by Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
by Anand Ranjan Pandey
The purpose of this article is to create a proof of concept to demonstrate the feasibility of ASP.NET Web API Beta Version.
by codeajay
A simplified SQL-CSV import/export functionality.
by Sergey Busel
Basic CRUD methods with some other interesting features
by Patrice Borne
This article demonstrates how to implement a paging DataGrid with an Oracle database. It also demonstrates how to limit the volume of data to exchange between the Web Server and the browser by retrieving only the rows necessary and updating changes in bulk.
by chiranjeeviD
A two-way sortable DataGrid with a colors column whose colors are dependent on a particular column value of your choice.
by Dariush Tasdighi
With this library, you can easily create some RSS 2.0 files for your site and/or use some RSS 2.0 files from other sites into your site.
by Bernardo Castilho
This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string.
by David Donovan
This is a short series of articles about Abstract Programming. This part details how Abstract Programming can be used at runtime to create JavaScript that will serve as a .NET DataSet, only living on the client.
by Rahul Rajat Singh
This article introduces Dapper to absolute beginners.
by Oleg Vorkunov
Abstract simplified stored procedure execution using .NET interfaces without dealing with ADO.NET classes
by Jerod Johnson
This article shows how to access NetSuite data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
by A. Rajesh Kumar
Add or Retrieve Session Object from Silverlight and ASP.NET
by fstrahberger
Access to Oracle without tnsnames.ora
by PIEBALDconsult
Describes adding public properties to a TableAdapter to access the CommandTimeouts of the private DataAdapter
by Ashish Tripathi
A Complete Account Management System
by Florence FZ Li
This article shows how to add a JavaScript tree menu to a DataGrid head text.
by jdkulkarni
This article describes DataGridView manipulation like add, edit, and delete, with paging, and using asynchronous method calls.
by hamityildirim
Add-in - add-on programming and an example for Outlook add-in regions, views, rules, and reports.
by saharkiz
Using a table name as the querystring to generate admin views
by logicchild
Understanding ADO.NET
by ASP.NET Community
ADO.NET stands for ActiveX Data Objects for .NET. It refers to the suite of data access technologies used to manipulate databases. ADO.NET is part
by mysorian
A tutorial on connecting to SQL 2000 Server.
by mfmaneef
Explains how to send bulk records to a database using OPENXML.
by Johnny Worker
A VB code generator that reads a SQL Server table and generates ADO.NET code and also Stored Procedures.
by ra1234567890
Using Data Link files with SQLClient and OracleClient.
by gbd77rc
How to use asynchronous calls to SQL to receive progress information
by Neeraj Saluja
Connection pooling can increase the performance of any application by using active connections of the pool for consecutive requests, rather than creating a new connection each time.And at the same time, the developer who is the best judge of his/her application, can configure the connection pooling.
by AdamNThompson
A data access component for SQL Server in VB.NET.
by Bibhas Paul
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
by sarvesh.upadhyay
ADO.NET Entity Framework as Data Access Layer
by Shivprasad koirala
Quick revision of 25 important ADO.NET Entity Framework interview questions with answers.
by logicchild
How to Create an Application to Access Data
by David Veeneman
In this article, we will see how to use ADO.NET to serialize an object model. Once we have finished with serialization, we will look at how to bind our object model to user controls.
by David Veeneman
In this second part of the article series, we will revisit the ADO.NET CRUD operations. Only this time, we will use an application with far better architecture. Once that is done, we will move on to data binding with objects.
by Michael Ceranski
This generic function will allow you to copy data between any two ADO.NET providers with one simple method call
by Shivprasad koirala
Ado Dot Net Interview Question Part 1
by João Martins
An ADO.NET recordset class.
by Paulo Zemek
This library is intended to "replace" ADO.NET by solving type mismatches and by creating typed readers that are faster and easier to use than DataTables.
by SHRIDHAR TL
Enables remote access to your files and folders via FTP
by Huisheng Chen
monitor sql server processes and jobs, analyse performance, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach etc
by Vincent-Philippe Lauzon
Samples showcasing usage of OData in .NET (WCF Data Services); samples go in increasing order of complexity, addressing more and more advanced scenarios.
by Monjurul Habib
Introduction to Agile software development methodologies and how to apply them. It is about how to work together to achieve a common goal. This article focus on how technology team work together well to plan, build and deliver software.
by Alexander German
With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.
by azamsharp
See AJAX in action.
by Dave Elliott
An attempt to create a flexible and re-usable Data Access Layer
by salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
by vivekthangaswamy
How to use a MySQL 4.1 database from an ASP.NET application and some ODBC basics.
by Dr. Song Li
This article makes an experimental comparison on the performance of the different methods to pass structured data to SQL Server Stored Procedure parameters from ADO.NET.
by Handpeople
An article introducing Oracle's Berkeley XML Database and the command shell
by aquila huang
Introduction of the open source project Light.Data
by Danilo Corallo
An Oracle query tool with syntax highlighting and a tabbed MDI interface.
by Vincent-Philippe Lauzon
Overview of the OData protocol: what it is, how it works, and where it makes sense to use it.
by logicchild
How to understand data access in .NET.
by Lachlan Keown
Describes a crude method of executing an SQL statement against an in-memory DataSet and returning a new DataSet containing the result table(s).
by Sacha Barber
An example application using angular/Rx for JavaScript/Web Sockets/jQuery
by tranthanhtu.vn
In this article, We will learn why do we need to manage the stages of our application.
by tranthanhtu.vn
In this article, we will learn how to build and deploy the code
by Gordon Moore
In this part I explain how to deal with concurrency issues.
by Rabeek
An article on Word append using interop.
by Chad Z. Hower aka Kudzu
In this article, I’ll explain how you can easily store and retrieve your application settings with just a few lines of code
by Serioja Sidorov
The focus is on how one can test the content of a database to see if it adheres to certain assumptions
by Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
by Pedro J. Molina
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
by Vadim Loboda
A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.
by Vadim Loboda
ADO.NET Micro-ORM to SQL Server
by Tal Bronfer
Introduction to ASP .NET MVC 5 for .NET developers that are completely new to Web development, MVC frameworks and Web Application Frameworks in general.
by M Sheik Uduman Ali
An article describes ASP.NET AJAX 4.0 template programming with DataView and DataContext
by M Sheik Uduman Ali
This article describes the live data binding of client side template programming in ASP.NET AJAX 4.0
by Razi Syed
Easily bind a class to .NET data controls like GridView, FormView, etc., and get an updated object or list back in the code-behind effortlessly.
by Oleg Kobchenko
A simple way to bind a Vertical Table with a DataGrid in ASP.NET
by Pete Sutcliffe
How to utilize the ObjectContainerDatasource from the Web Client Software Factory to perform databinding while maintaining an MVP architecture. Samples are provided for Entity Framework, LINQ to SQL, and ADO.NET.
by Muhammad Abubakar Dar
An extension to the ASP.NET DataGrid control with built-in client side sorting, column dragging, fixed header, check all, uncheck all, highlight selected row, and more...
by Gary Dryden
ASP.NET GridView - how to add a new record.
by elSeten
ASP.NET GridView delete confirmation using asp:CommandField with LINQ to SQL.
by Muhammad Abubakar Dar
Extension to the ASP.NET GridView control, with built-in client side sorting, column dragging, fixed header etc.
by Uwe Keim
A one-to-one ASP to ASP.NET port of a simple guestbook application using ASP and an Access database
by Angel Gabriel Valdés Sarduy
This project is an ASPNET Core MVC site with a generic controller for CRUD and searchs.
by Steven Berkovitz
An article on building a time field that mimics the behavior of the one found in Microsoft Outlook.
by Igor Krupitsky
ASP.NET page that lets you process an SSAS (SQL Server Analysis Services) cube database.
by Srinivasu Pemma
This is most common but very important part of every developer's life, Taken from my technical blog http://www.srinetinfo.com
by Yitzhak Gootvilig
A tutorial on adding design time support to ASP.NET custom server control.
by Jeff Bazinet
VwdCms.SplitterBar is a server control that allows you to easily add resizing to your web page layout, now supports both vertical and horizontal resizing.
by Abi Bellamkonda
ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper
by kannankeril
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
by Vincent Maverick Durano
A quick demo that highlights how to upload and import CSV file to SQL Server database in ASP.NET WebForms.
by codeontime
Learn to build modern AJAX and ASP.NET 3.5 applications with free Aquarium Express Framework
by Tom Cook (UK)
How to asynchronously poll a database for an Entity with EntityFramework 5
by Babak Ansari
A custom asynchronous setup with progress indicator.
by Peter Huber SG
Saving a changed row in the DataGridView automatically to the database seems to be a basic task, but is challenging to implement. Read here why the most intuitive approaches fail and how to get it working.
by Vinay Jade
AutoCompleteExtender with WCF
by adamAFA46
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
by SoftWidgets
In just a few minutes, predefined templates, containing formatted sheets and charts, can be generated from any database using simple SQL statements, macros and/or custom C# or VB.NET snap-ins. Generated files can be distributed to a file server or as an email attachment. Usually, no coding is needed
by Nirosh
This will create a set of classes that generate a set of C# class files which map into the database tables. They will have the class name same as the table name and they will have a set of properties that are same as the table attributes.
by Juan Pablo G.C.
Automatizing creation of a database, tables, SUID actions, and easy WPF to class mapping.
by Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
by Ws Hu
This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.
by mbyamukama
In this article, I will show you how to interface your simple C# applications to the FirebirdSQL Server using the Firebird ADO.NET Client 2.5.
by Abhijit Jana
Beginners Introduction to Rendering XML data using XSL transformation, a step by step guide to rendering XML data using XSL
by Alexander Galkin
Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.
by Ziyad Mohammad
This article explains the best strategy to be followed while designing data storage applications by System Architects
by Declan Brennan
An alternative to the standard DataBinder that can handle missing data and validation failures
by Alessandro Del Sole
Binding a generic collection to a DataGridView in VB 2008, with a few lines of code.
by Gabriel Szabo
Enables binding of any public data member of any object into a control at design time.
by Ravi Selvaraj
Bind the menu control with list of Category and Sub Categories
by Ralph Varjabedian
The TreeView can not bind to a DataSet or to an ObjectDataSource. With one line of code, you can do that now.
by Huseyin Altindag
In this simple article, I'd like to show how to use the new components BindingSource and BindingNavigator in C# 2.0.
by Marc Clifton
An investigation into different data entry modalities and the need for a transaction sandbox.
by Hayder Marzouk
A small framework to design and print documents containing shapes, text, images, bar codes...
by Kareem Shaker
This article shows you the structure of RSS 1.0, RSS 2.0 and ATOM standards, and how to make RSS feed and consume others' feeds easily.
by ASP.NET Community
Programming theMicrosoft® ADO.NET Entity Framework            by David SceppaPublisher : MicrosoftProgramming EntityFrameworkBuilding Data Centric
by Uwe Eichkorn
BSEtunes is a MySQL based, full manageable, networkable single or multiuser jukebox application
by Waleed Zedan
Custom editors in building user controls
by Vimalsoft(Pty) Ltd
This article will show you how to build an N-Tier application in VB.NET.
by Yulianto.
An article on building database with ADO.NET application for a beginner.
by Arno Petersen
Classes to build insert and update statements for Microsoft SQL, OleDb and ODBC dataprovider
by Jovan Popovic(MSFT)
How to build REST services with ASP.NET Core Web API and Azure SQL Database
by mcondon013
Code that adds built-in serialization functionality to your classes in C#
by Ferreri Gabriele (Megasoft78)
How to implement bulk edit with GridView without xxxDataSource (SqlDataSource, ObjectDataSource, etc.)
by Måns Tånneryd
Extending the entity framework with bulk operations for both inserts and updates
by Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
by Kenneth Young
This article demonstrates the use of an XML Schema validation class.
by kribo
How to insert images / binary data into a database.
by kribo
.NET project with a SQLite embedded database
by Steve Michelotti
An article on nullable data readers for .NET 2.0 nullable types.
by gaurav_verma_mca
How to send bulk data using table value parameters from C#
by PaulMcKenzie
This stored procedure will generate all the C# code for calling any Stored Procedure
by Edacio
This is a MySQL based Profile Provider written in C# for .NET 2.0
by Not Active
A C# Windows application to store and retrieve photos from a SQL Server database.
by Hasan Habib Surzo
Class, Database Connection, Login Winform
by Baxter P
Dependency Injection Data Demo with Lazy Loading and Data Mocking
by Nikhil Contractor
An article on how to show large amounts of records using DataGridView's virtual mode in paging.
by Michael Lockwood
How to call a web service using SSIS, store XML results and then query XML using XQuery
by Muthupandiammal
Ajax PageMethods in JavaScript use to call server side methods in Client side
by John Faris
Produce a captcha image for an aspx web page
by Mahsa Hassankashi
This is a very easy and user friendly technique for web applications to implement cascading menus without page refresh.
by S. M. SOHAN
An article that shows a simple way of changing the default value of the DataContext CommandTimeout
by mrjvdveen
How to change column collations through C# and ADO.NET
by Silent Jesus
Display data to a chart using LINQ and XML.
by Razi Syed
Function to check if a table or field exists in an MS Access or SQL Server database.
by IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
by Emil Lerch
Command line tool to check validity of objects in SQL Server databases
by gtamir
Ways to check for the presence of optional data elements in a DataTable or a DataSet.
by Marc Clifton
Performance differences on the rPi
by Alex S. Robson
This article is intended to introduce custom attributes and show how they can be used to create a lightweight data access layer.
by Dave Hurt
How to setup a DataGrid to accept a user's click on a row.
by Siddhartha Batra
MicrosoftExcelClient is a small assembly coded in C#.NET which is used to interface with, i.e., read from and write into an Excel sheet in the .NET Framework.
by Jesús López Méndez
This article introduces you to client side multi-column dynamic pivot, a cleaner, simpler and elegant alternative to the complex and convoluted dynamic server side pivot.
by jebarson
This article shows how to use a checkbox in a DataGrid using JavaScript.
by Sandeep Mewara
A client callback custom control and how to use it in WebForms.
by Chris Wuestefeld
Uses a cache on the client side of a distributed .NET application to improve performance.
by whennessy63
A very simple, cross-browser approach to client-side paging.
by gn_srini
How to do client-side validation of radio button column in a DataGrid.
by Appusamy.subbian
Cloning the Entity object and all its children using the Entity Framework, using LINQ and Reflection.
by Won Dong
To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances
by Santx - Santosh
Code First with Entity Framework 5 using MVC4 and MVC Scaffold
by Samuel Gonzalo
A code first real life data model case
by napster_ghb
This tool generate the c# code using the code smith templates and API
by Prashant M. Tailor
Using COM components in .NET framework.
by MarkWei
To dynamically generate a Google Map with combined data sources from an external web service or API and from an internal MS SQL database, using AJAX and the ASP.NET environment.
by Venkat Eswaran
4-in-1 component for ASP.NET DHTML tab, tree, panel, menu - horizontal, vertical, pop-up, fading effects
by Y Kasan
Comparing DataSets in Visual Studio 2008 using LINQ.
by Henry He
In this article, I will explain what transparent lazy loading is and how it's implemented in NHibernate and Entity Framework.
by Afzaal Ahmad Zeeshan
This article contains a basic overview of the complex numbers, and their creation and functions most specifically the operator overloading for arithmetic functions. Programming languages include Java, C++, C# and VB.NET at the moment.
by Anas Karkoukli
Design Patterns Series - Part I
by A$TRAL Moristar
Using this FastDataTable you can serialize your data with fast and good compressing.
by Adrian_Moore
Using .NET 2.0 DeflateStream and GZipStream to compress persisted DataSets.
by David Donovan
This is a short series of articles about Abstract Programming. This part is an overview of Abstract Programming, and how and when one program authors another program.
by Rawat Sandeep
Platform for people to share their emotions
by hong_wei_li@yahoo.com
Configure MS SQL Server 2005 Remote Access ( mixed mode )
by Eugene Mirotin (Guard)
Demonstrates the easiest way to use all the advantages of SqlDataSource and GridView, and to allow flexible DataSource configuration.
by Hithendra Reddy
Building Custom Webparts to interact with Database
by alex turner
How about a .NET COBOL program which uses ADO.NET to connect to either MySQL or SQL Server?
by Muhusin Khan
Effective perfomance for database application uses database
by User-Rock
Approaches describing a design to handle connection objects and pools in C#.
by Rainer Halanek
A Connection Scope for the Entity Framework that allows to execute commands in a single connection
by AXI_IeD
How to Filter contextually the list shown by a DataGridComboBoxCell?
by blue_arc
This class will help developers to convert their data table into a ready to use JSON string on the client end JavaScript.
by sohaibahmad
Convert an MS Dynamics CRM 4 BusinessEntityCollection to a DataTable.
by Benzi K. Ahamed
Presents a simple utility framework that helps in converting DataSets to generic Lists.
by Raja Chandrasekaran
This is project is to know about how to convert the retrieved data from database to Excel file thro' c# code
by Aaron VanWieren
How to copy data from a modified dataset into a SQL Server Database
by Ameet Parse
How to use SMO to copy database schema and data using C#.
by Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
by User 5711348
This article shows an easy way to create a guestbook using ASP.NET and XML serialization.
by NobsterTheLobster
Publish a WCF DataService with entity model, updatable views, filtering and authentication
by Dain Ucak
How to make an intellisense textbox using web service and JavaScript which works with all platforms (IE, Chrome, Firefox) without problems
by Jeff Gaines
An application that creates a C# class to read/write data to/from an Access, SQLite, or XML database.
by Gordon Kushner
Utility program for generating SQL Server INSERT scripts
by justindhas
Create Sample Application Using Entity Objects Using C#.Net
by Ravikumar Commuri
How to Create 3DBarChart with Graphics, Bitmap Objects in ASP.NET 2.0
by Paul Reynolds
This is phase 2 of a 3 phase project. This phase accesses the database created and loaded in phase one to expose an API of common business date functions.
by Beavis Killer
This article demonstrates how to write a domain service factory to host plain old class object (POCO) entities and use them through RIA Services in Silverlight version 4.
by defwebserver
How to create a DotNetNuke® module using Visual Studio Express - for DotNetNuke version 4
by Malik Nasir
An article on creating and populating an automated MS Access file from other databases.
by Luis Ramirez
This article shows you how to generate SQL code for CRUD operations using the SqlNetFramework and CodeSmith.
by Ali Adly
A simple example that shows how to create detail grid template at runtime using ASPxGridView
by Sushant Joshi
This article describes how to generate Excel at client side and embedd "Pivot Tables" and "Charts" into the Excel.
by Debendra0256
In this article we will learn to create MVC project from scratch following n-tier architecture.Along with this we will focus on designing views.
by apna
Article describing how to work of girds which needs to add columns dynamically at run time.
by Bibhas Paul
CRUD (Create, Read, Update, Delete) Operation With Generic List
by ColinBashBash
Simple code that can be updated. This generates CRUD procedures.
by Jigar Bagadai
Easy approach to implement AJAX in ASP.NET without using an AJAX control
by Michael Sync
The simplest way to do CRUD (Create, Retrieve, Update, Delete) operations in Silverlight using ADO.NET Data Service (Astoria).
by Sahil Saini @ Software Developer
This article starts with creating the project in MVC with using the bootstrap classes to give better look to the UI and controls used on UI.
by Rehan Ahmad Abbasi
Crystal Report with Dataset and DataTable using C#
by Abdul Quadir Saifee
Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005
by Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
by Muammar©
How to read, filter and write your CSV files
by LarryCharlton
Dynamic data forms.
by Paul Brower
Manage SuspendBindings and ResumeBindings for all CurrencyManagers in your app.
by Shivanand Alagi
Data access layer for MySQL based web projects.
by RayBez
A short sample of how to customise the .NET DataGrid for SEO (Search Engine Optimization).
by S. M. Ahasan Habib
Custom JSON serializer for the Entity Framework
by Murali Manohar Pareek
ASP.NET Gridview with Default and Custom Paging, Sorting, Export Data, Freeze Header, Column Resizing, Row Hover, Row Selection, Grid Cell Tooltip features for better Performance, functionality and GUI with Oracle Database
by tanweer
Easy way to implement ASP.NET GridView paging .
by Prashant_Hirapara
Custom Paging on any database
by Stefan Wloch
An introduction to Custom Roles Based Reporting for ASP.NET MVC applications using the Entity Framework. Protecting confidential information is a business requirement and in many cases also an ethical and legal requirement.
by Munsifali Rashid
Making the pager in a DataGrid more useful by adding additional information about the data being displayed.
by razi bin rais
How to customize the pager of a DataGrid control.
by User 753751
Describes the steps and wiring required to add customized buttons in web application DataGrids.
by cyqdata
This is a presentation of a cyq.data ORM article.
by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
by zhongzf
An open source Data Access Component
by Aj 2010
A simple data access component for connecting with different types of data sources.
by Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
by Halil Ibrahim Kalyoncu
This tutorial aims to show a basic approach for designing a data access layer independent from databases and entities.
by theoutlander
An overview on inheriting a ListView and implementing design-time data binding capability.
by Addison-Wesley
Chapter 6: Presenting Data with the DataGridView Control.
by dotnetdan
VS 2005 debug visualizers for DataSet, DataTable, DataView, DataRow and DataColumn objects.
by Mahmoud Nasr
Data form wizard for ASP.NET similar to that for the Windows applications.
by kvlcek
A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.
by C Razzeto
Database abstraction using factory design pattern
by Duncan Edwards Jones
An extensible tool to package and deploy database schema objects
by Amir Mehrabi-Jorshari
With this tool, you can compare two databases and generate a difference report.
by PIEBALDconsult
A system of plug-ins that provide very simple database access
by Aneesur Rehman Khan
This article demonstrates how to develop client side calculations in a GridView, and calculation expressions are configurable at the DB side.
by Mugombi
An article on how to generate an HTML popup menu from a database.
by Jaryl Sim
Use different database providers without tying implementation to one.
by konamiman.MSX
A C# class that uses the local file system to cache binary objects stored in a database.
by Huseyin Altindag
Personal address book using ADO.NET and C#
by db_developer
This article consists of a data layer and forms for database tables editing.
by Marc Clifton
Another rabbit hole, this time how to handle AJAX calls in a manner that lets you roll back the entire set of transactions if any particular AJAX call fails.
by Brice Schagane
An article on using Transactions with Strongly Typed Datasets and multiple Table Adpaters while taking advantage of Partial Classes.
by avronp
View and update any database table and metadata. Includes sample databases.
by PIEBALDconsult
A simple base class that encapsulates basic database access functionality
by dakeefer
A introduction to the flexibilities provided by the use of SQL extended properties in business layer code templates.
by Paulo Zemek
An easy to use framework with multi-tier, user types, and LINQ support.
by Arindam Sinha
Databinding - Searching and sorting BindingList.
by Jos Branders
These data controls can show scheduled events automatically
by Jorge Bay Gondra
A TreeView that can be bound to a DataTable, and can keep track of changes in it.
by Wai Friend
A way to bind up a simple TreeView control.
by DataDirect
The Internet Security Advisors Group reviewed the DataDirect Technologies Connect product line of standards-based data access components. The DataDirect Connect products provide high performance access to a wide range of relational databases and incorporate a variety of important security features.
by Y. Shahabudeen
Simple datagrid tooltip of each cell values and header tooltip
by RameshSengamalai
DataGrid in WPF using SQL Server Compact 3.5 Sp1
by Manoh
DataGrid paging using C# Windows Forms - Select only the required (page size) records from the table.
by Manoh
DataGrid paging using DataReader.
by Nikfazan
DataGrid View with "CRUD operations" using Dojo DataGrid, JsonRest Store, Entity Framework, SQL Server, ASP.NET MVC Web API
by Robert Rohde
A reusable component which extends the DataGrid and adds functionality for real time filtering.
by Doug Healy
Allows user defined sizing of DataGrid column header height to support multi-line header text.
by Lisa Jorgensen
A DataGrid that displays the correct ToolTip on each cell after sorting, and displays the ToolTip on a cell even when it is being edited.
by Jakob Farian Krarup
A utility class to ease adding CSS classes and confirmation dialogs to the ASP.NET DataGrid component.
by Afrasiab Cheraghi
An article on DataGrdView printing.
by Ahmed R El Bohoty
How to Fill dataGridview Using DataReader in Win App
by Robert R Freeman
How to create a DataGridView with an associated Detail Edit Form using a strongly typed dataset data layer.
by Ron Dunant
An application demonstrating how to save column width, order and visibility information for a DataGridView control, bound to an Access database, using the Windows Forms Application Settings feature
by David Wulff
A framework to completely separate objects from their data source - allowing any data source to be used without prior consideration in your code or designs. Databases, text files, web services and potentially anything else can all be used or swapped transparently.
by Eunge
DataQuicker helps build a clear application structure, accelerates developement, and decreases maintenance costs. It's more possible to provide our customer a perfect on-time project, and release us from over-time working and other delays.
by Juraj Borza
Integer and string indexing of System.Data.DataRow columns - head to head
by Krishna_accent
Cool Component exports DataSet(s) to Excel as Row-wise,Column-wise or Sheet-wise.
by George Zabanah
This article demonstrates the amazing transformation power of the DataSet with agnostic XML schemas, XML, and Excel Read/Write (all with colourful XML rendering using XmlBrowser).
by Alexandros Pappas
This project implements caching of DataTables and provides functionality for testing performance.
by Michael 'Tex' Hex
This article demonstrates the first version of a DataTable Generator. This generator uses information found in custom attributes on any class and transforms the class, or several instances of it, to a System.Data.DataTable.
by Marc Clifton
Adds synchronization to the DataTable Transaction Logger.
by Marc Clifton
Undo/Redo DataTable transactions by logging row changes (insert/delete) and field changes.
by vacen2
Allows you to perform a Distinct query against a Datatable
by vacen2
Allows you to perform a Distinct query against a DataTable.
by J van Rooyen
A simple article: From DB to Browser using Silverlight
by seesharper
An abstract syntax tree implementation for SQL
by voloda2
An article describing a simple .NET library which simply keeps your database schema up-to-date.
by Wael Amer, Hossam Barakat_
DBLayer Wizard is a code generator that generates Data Layer classes in C# using ADO.NET and SQL Server 2000.
by Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
by Pieter Van Parys
Creating profiling information in our ProxyDbxxx classes
by Paulo Zemek
Generate DataReaders at run-time and get the best performance by avoiding repetitive code and by using the database's most appropriate Get methods.
by Alex Kolesnichenko
Article describes design, development and testing of a home-grown tool for database schema updates using TDD approach.
by lecamarade
Using Domain Driven Design together with the ADO.NET Entity Framework.
by Chandramouleswar Chakicherla
This article details a new practice to prepare the .NET Business Objects using the data retrieved from the Database and binding them to .NET UI Controls dynamically using Reflection through centralized mapping between a types’ Properties Vs Data-Columns Vs UI-Controls.
by Sandy Place
Sometimes, it is nice to prototype up a simple database application. This code may help, by providing the automatic transactional model of COM+ in a non-COM+ environment. This example uses "Interception" to provide automatic transactioning support for non-COM+ classes.
by Gil Fink
The article explains how to define custom functions in Entity Framework
by Gil Fink
DefiningQueries are a very useful elements that you can use in Entity Framework in order to create views from the model against your database. The article will explain the DefiningQuery element.
by Tadas Budvytis
Explains a mechanism of deleting a record when the selected record has related records in other tables.
by NavnathKale
Lightweight and simple
by David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
by gtamir
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
by Antonello Provenzano
A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS
by Kelum Priyadarshane
This project developed using combination of Entity Framework 6.0 + Code First Approach + Web API 2 + Repository Pattern + ASP.NET MVC 5 + SQL Server 2012 + Unit of Work Testing + Bootstrap.
by Ben Kotvis
This article explains about developing abstract functions for accessing Stored Procedures.
by Suranjan Nandi
The report is build on XML Schema and the data and binded the report at runtime.
by Jeffrey T. Fritz
How IT operations can engage more with a customer’s experience and assist software development in isolating problems in a production environment with no code changes needed from the development engineers.
by Mostafa Kaisoun
Using ADO.NET in Visual Studio.NET to display database in TreeView and ListView
by Ravi Karia
This article explains how to display large amount of data and implement search functionality in GridView in ASP.NET 3.5
by Abhijit Jana
A simple guide for beginners, explaining one method of displaying images taken from a database on a GridView inside an ASP.NET web page
by Mahendra Kumar Srivastava
An article on selecting distinct values from a DataSet.
by BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
by Dr Gadgit
Covers SSDP messages and XML replies plus how to stream a play-list
by Alaric Dailey
Correctly using provider factories to create database independant code
by O.Nasri
You will learn how you can build a management user interface using DotnetCore, Angular2, typescript and web API.
by Jigar Bagadai
Add interactivity to Shopping Cart Using JQuery and ASP.NET MVC
by Mark Ericksen
Don't Repeat Yourself (DRY) when working with your database. Simple and easy code that makes it harder to make common mistakes.
by Asif Sayed
An article to demonstrate the creating of business document ids without using stored counters.
by Pakorn Indhatep
Dynamic report by using the PrintDocument component with SQL queries.
by Shivprasad koirala
Dynamic validation according to logged in user
by Vincent Maverick Durano
A simple demo on how to dynamically add rows in GridView with TextBox and DropDownList, retain the values on postbacks and save all row values at once using SQLBulkCopy.
by Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
by mbarbac
Describes how to use C# dynamics to convert a delegate into an expression tree
by interface Mirror
The easier way of accessing data using intermidiate classes between basic ADO.NET classes and your own application.
by Matty22
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
by Chad Z. Hower aka Kudzu
Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.
by Frank Kerrigan
An article on easily binding ADO data to control using reusable code.
by Jason Scolaro
A JavaScript solution for a common routine, especially for those DataGrid/GridView Delete buttons.
by Igor Tkachev
Run-time data accessor generation
by Plamen Kovandjiev
This library gives an easy data access tool for different data sources.
by Declan Brennan
Article to accompany source for controls to edit a wide range of data types and/or complex DataSets
by Declan Brennan
Allow your DataGrid to edit pictures and a whole range of other data types.
by JeyKey
This article explains how to make an ASP.NET editable DataGrid.
by V Sridhar Chary
How to access User Controls from the EditorPart directly, and how to move EditorParts at runtime.
by Abdul Quader Mamun
Paging must be effective for large scaleable applications. Without smart and effective paging and sorting for huge amount of data, user request takes more time and uses more resources.
by Dan Letecky
An example that shows how Firebird database excels in embedding.
by Carey Payette
In this article, our focus will be installing Actian Zen Edge Server for IoT on an ARM-based Raspberry Pi running the Windows IoT Core operating system, capturing some simple time series data, writing it to the Zen database and retrieving data from the database.
by Igor Tkachev
A wrapper for the System.Reflection.Emit namespace
by Marlon Hizole
This article will explain the class library I created and how you can use it in your code. The aim of this class library is to simplify coding of data access and/or manipulation by encapsulating the core components of ADO.NET.
by Koenraad
This class lib allows encrypting DataSets to XML files and reading them back. A Win Form app is included as a showcase.
by Wendelius
Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.
by CodeBureau - Matt Simner
A VS.NET add-in to visualise standard and typed DataSets, DataTables and DataRows whilst debugging.
by Refky Wahib
This Article supporting these features: Logging to file, TransactionScopeActivity, WorkflowCommitBatchService, SqlTrackingService, fault Handler Activity and Bi-Directional communication using custom services
by venugopalm
A guided tour of the distributed enterprise application design in .NET
by venugopalm
Database and Library Design for Customer Order Management System
by gaurav_verma_mca
Configuration of .NET applications using database
by Gil Fink
How to use the Fluent configuration API with the Data Access Application Block.
by Tomz_KV
Explore the behaviors of IDataReader in the Enterprise Library 5.0 data access application block.
by Raja.Lakshman
Enterprise Library wrapper class to implement run-time dynamic connection strings without using config file
by Dylan Morley
How to enable second level caching in the Entity Framework when using DbContext.
by Jason Sobell
This article describes a utility that modifies EF4 edmx files so that they support SQL Server's 'Default Value or Binding' property
by Ali Ozgur
I've been recently working on a smart client (WinForms) application backed by Entitiy Framework 4 (EF4) on Visual Studio 2010. In this blog post I will try to give you some tips regarding some limitations and points to be careful about EF4.
by Alexander Iskhakov
A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.
by Radu Pascal
Support for enums in Entity Framework is probably the most desired feature, and it's strange it is not supported. This article will show a way to implement it using templates.
by Alexandros Pappas
This project describes how to use Entity Framework Core with update triggers and audit tables.
by Neerajan Lamsal
Entity Framework Implementation using ASP.NET MVP
by Bernardo Castilho
A component that makes it easy to use Entity Framework in WinForms projects, including design-time binding support.
by Emiliano Musso
In this article, we will see how to use entity framework in our Applications, developed through the various languages that Visual Studio allows us to use. The examples in this article and probably in the next, will be C # used under WinForms, but - as mentioned - this choice is not going to affect a
by Vincent-Philippe Lauzon
Introduce different patterns in Entity Framework around selecting a list of entities.
by Not Active
A comparison of performance between ADO.NET and Entity Framework.
by Code Help 2014
A simple tutorial for beginners to learn the basics of Entity Framework. It will teach you how to perform CRUD operations using EF.
by Alexandros Pappas
This project describes how to use Entity Framework with update triggers and audit tables.
by Adriaan Booysen
Adding Seeding Framework towards EntityFrameworkCore that can be wired up in either a dotnet core Web Application or WebAPI
by Razi Syed
This is an alternative for "EntityUI Automatic UI Generator using CodeFirst Approach"
by Razi Syed
Automatic UI Generator with two-way binding for ASP.NET Forms from an object using Code First Principals
by earmitage
An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.
by Paul Brower
Use the ErrorProvider to display friendly 'Value Required' warnings.
by db_developer
Establishing of an existent connection to SQL Server with a sample: XML/A script execution tracing.
by Miloslav Beno
Simply implement events and CacheDependency with the database
by Wahab Hussain
This will help you manipulate an Excel file through your code. You can update the Excel file as well.
by Somnath Mondal
A fully customizable and extensible C# library that makes it easy to generate Excel files for a given DataSet, with column layout design support.
by Sujith John Thomas
This article explores the concepts of XMLSS and its transformation to XL.
by Amalorpavanathan Yagulasamy(AMAL)
This article demonstrates Excel report generation in ASP.NET using C# and DataGrid.
by Joao Tito Livio
Pull data directly from SQL Server to Excel using C# and VSTO.
by Dan Radu
This article explains how to use the Office 2003 SpreadsheetML feature to display data stored in .NET datasets.
by Wendelius
This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
by Samir NIGAM
This article describes how to expand and collapse columns of a GridView using JavaScript
by Samir NIGAM
This article describes how to expand and collapse rows of a GridView using JavaScript.
by Dennis Betten
Export all tables and data to an Excel file.
by Johnson Manuel Devadoss ("Johnson Smith")
Way to export search results(BDC datalist/Enterprise Search) to Excel/PDF
by Gianmaria Gregori
How to export data from a SQL Server CE database to an Excel sheet
by Dr. Song Li
This article presents an example to export tabular data through the web in CSV as well as Excel formats.
by Mister Bee
How to export a .NET DataSet to an Excel Workbook.
by azamsharp
How to export DataGrid to Excel, Word and Text files.
by iowarobbie
An extended version of the DataSet Quick Watch application.
by Michiel van Eerd
An extended ListView control that can show multiple images on subitems, lets the user edit subitems with user-defined controls (also image-subitems), contains boolean subitems, and can sort columns by date, number, string, and image.
by Tamer Oz
ExtendedDataTable is a component which provides more functionality compared to native .NET Framework DataTable. It is also platform independent, you can use it with Web or Windows applications.
by Chad Z. Hower aka Kudzu
Ever wished you could truly embed SQL functionality in your C# code without using strings or late binding? Imagine being able to write complex Where clauses purely in C#.
by mbarbac
Kerosene ORM support for complete database-alike WCF services and connections
by Chris_McGrath
A few minor modifications to improve the DataGridView.
by Charles T II
A Data Access Framework using Generics, Lambda Expressions, Fluent Interfaces, and the SqlProviderFactory.
by seejay1120
A Fast Way to Update Treeview Nodes Using a Database as a Source
by Lyubomir Rumenov Velchev
Fast, flexible and easy to use N-tier Software Architecture
by Rashutosh Paul
How to fetch data from Microsoft Excel using SQL
by Rafael Mizrahi, Laurence Moroney
When working with Microsoft SQL JDBC driver, you cannot invoke a stored procedure without specifying all the parameters, including the optional parameters that have default values. Learn how to fix that problem here.
by rickwright2000
Avoid the pesky table adapter load error failed to enable constraints.
by KK Kod
Document describes about One way web Method creation and consumption in Traditional ASP.net Web Service.
by Praveen Nair (NinethSense)
This article explains how to use an ASP.NET WebService from Adobe Flex
by Praveen Nair (NinethSense)
A beginners tutorial on HTTPService of Flex and ASP.NET
by Eric Lynch
Flexible CSV reader/writer with progress reporting and many file format variations.
by Jörgen Andersson
Fluent database access
by Mike Ellison
Demonstrates how to apply conditional formatting in a GridView or DataGrid when columns are dynamically generated, and wrap such code in an IExtenderProvider control.
by CroweMan
Learn how to take advantage of the caching support in FrameworkGen
by junnark
This is a tutorial on how to use WinFormsGen's generated code.
by Kurt Evenepoel
Implementing Business Logic, Logging, and Validation for the Entity Framework.
by Scott Page
FreeCal is a free 100% .NET suite of utilities and instrument drivers for controlling multiple instruments in a Test and Measurement environment.
by dakshithaw
This article explains how to join two data tables and get the result set into a new data table using C#. Here, this has been done without using Database Access.
by Dan Letecky
How to search data stored in a Firebird SQL database using a fulltext index.
by vbar
BoundCheckedListBox is bindable to three tables representing a many-to-many data relation.
by Pakorn Indhatep
Function for clear null and set default value in DataTable
by martin.nedopil
Map your database table as network disk
by mark.stratman
How to gain access to the DataGridViewComboBoxEditingControl’s properties, methods, and events.
by Nirosh
Nido Framework with .Net 4.0 and Entity Framework help you standardize your Business Logic Layer (BLL).
by ProEnggSoft
General purpose class to fill some or all of the DataTables of strongly typed DataSet from DataBase and to save some or all of the DataTables to DataBase by creating TableAdapters using reflection.
by Ian Semmel
A class for automatically generating SQL INSERT for Typed Datasets.
by Sunny Ahuwanya
This tool helps developers generate their ADO.NET stored procedure wrapper methods and any related strongly-typed data object class.
by Valentin Billotte
The proxy generated by the ADO.NET Data
by Ashutosh Phoujdar
This article will demonstrate how to generate a data access layer using SubSonic.
by lampiclobe
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
by Brian Perrin
Eliminate the pain of calling SQL stored procedures from C#.
by #realJSOP
A rewrite of a previous article with more liquid nitrogen and bacon
by #realJSOP
When you're using other people's code, especially code that might get updated from time to time, it's important to remember that you can probably extend it and make it in your own image, without necessarily changing the original code, and by using the power of object-oriented programming.
by #realJSOP
Avoid ORMs with this reasonably generic approach to ADO
by Mercede
Generic data manager provides thread specific IUnitOfWork repository tailored for your entities and takes care of all the plumbing and cleaning in a thread safe way.
by Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
by KevGUID
Generic grid search and data paging explained.
by Barathan
Generic Customizable login control for VB.NET Windows Forms.
by santosh poojari
This article is basically about a Paging control required for project purposes. One can use this just by changing three parameters.
by Leszek Koc
Generic Repository Framework (Generic Unit of Work)
by S Sansanwal
This article explains how to create a web user control and trap its events.
by murtaza dhari
How to get DataGrid row value without postback or AJAX.
by Vincent Maverick Durano
This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core.
by TomDK
How to start using SQL Server Everywhere in C# programs.
by radioman.lt
GMap.NET is a powerful, free, cross platform, Open Source .NET control. It enables the use of routing, geocoding, and maps from Google, Yahoo!, OpenStreet in Windows Forms and Presentation, and supports caching!
by Lokesh_1937444
This article describes how to manage events in calender.
by Mike Ellison
Combining a BuildProvider and IExtenderProvider to create a declarative framework for conditional formatting in ASP.NET GridViews.
by padmanabhan N
Provides a clear idea about working with the GridView.
by azamsharp
How to implement row deletion in GridView, with confirmation.
by Gary Dryden
How to view detail records inline with the master records, using the GridView control.
by Nikhil Contractor
An article on how to use a GridView control in ASP.NET 2.0, having multiple controls in templates inside it.
by Brian Rush
In this brief article, the author mentions two techniques that he uses to allow for mapping GridViews to DataTables that are built upon existing middle tier objects.
by Gary Dryden
How to add/edit a GridView in style.
by Samir NIGAM
This article describes how to navigate GridView rows with the help of arrow (up/down) keys using JavaScript.
by ZeroDev
Convert the current Gridview to a datatable
by Lukas Holota
Comfort editing of a GridView row.
by John Bhatt
Let's learn how to make a scrollable GridView and Fix headers with simple steps.
by sudhanvag
Grouping repeated data in a GridView control.
by Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
by Alaric Dailey
Building an O/R Mapper: step 3.
by David Killian
A reflective approach to providing stored procedure based data access methods with a reuse pattern based on polymorphic Types as arguments in ObjectResult
by Raju Chandra Dey
An article on handling data persistency on multiple DataGrids with JavaScript an code-behind.
by Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table
by Kenneth Young
Shows a developer how to dynamically hide or show DataGrid columns.
by Sakthivel Ganesan
Explains how to create a hierarchical GridView control in ASP.NET using AJAX
by Jomar Pabuaya
An explanation of the useful code within Hotel Reservation System
by Samir NIGAM
This article describes how to apply hover effects on GridView rows using CSS.
by Steingrebe
Not really new, but a solution
by gaurav_verma_mca
An end to end article describing how to use file stream data type in SQL Server. This article discusses both SQL Server and .NET side of things.
by Samer M. Abdallah
Access SQL database from iPhone Via WCF and JSON hosted on IIS 7.5
by Buddhi Dananjaya
This article describes how to add controls to a DataGrid. This will add controls at runtime. I hope this will be helpful for developers who are using DataGrids for data entry forms.
by PalaniEllappan
Calling the Asp.net Code Behind method into Javascript
by Ali Marzban
Changing ConnectionString like an attribute in C#
by Okta Endy
An article on converting a Collection Base to a DataSet.
by Jimmy M Joy
This article explains how to convert DataGrid into a data entry form for same kind of data.
by Joao Tito Livio
Creating a simpleTable with fields in an Access Database using ADOX and JET SQL
by David Thielen
If you are having trouble connecting to a database using a program that uses an ADO.NET connector, this program is a great way to test it step by step.
by Sacha Barber
Export Gridview to Excel, render cells, add WordArt, and fill a custom template.
by Thomas Yan
Build web component based on recursive data
by Aqeeel
Though GridView provides a way to implement paging however when the record count in very big we need to optimize it at the query level.
by Uri Lavi
How to improve performance of typed DataSet creation.
by Klaus Salchner (Canada)
Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.
by Ahmed jamil Kattan
An article explaining how to link your home database in your C# application.
by Ach1lles
A simple technique for selecting random records from a table.
by Marc Clifton
When you override GetRowType, you also need to override NewRowFromBuilder().
by mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
by linush
Explains how to mock test an EF Model-First project using ADO.NET Entity Data Model template
by Wendelius
How to pass multiple records to a Stored Procedure in a single roundtrip.
by T.Ashraf
How to pass values between user control and ASPX page without JavaScript
by Daniele Fontani
How to perform a database-independent databind with UDLA (Universal Database Layer Access)
by M I developer
How to read and write .xlsx (Excel 2007) file via C# - Part II
by Kelum W. Ganegoda
Reading BLOBs (images) from a database and displaying them in an ASP.NET application.
by Mihadh
This article explains how to connect to Microsoft Excel 2007 using a connection string and populate DataGridView
by Sandeep Aparajit
This article tells you how to save data from a DataSet into T-SQL tables.
by Sigurd Johansen
This article explains how to set an entire DataGrid column to edit mode.
by Santiago Sanchez
How to set the maximum allowed length of textboxes dynamically.
by Vimalsoft(Pty) Ltd
How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File
by hong_wei_li@yahoo.com
How to truncate log file in SQL Server 2005
by Sergiy Korzh
A small utility which allows to modify AssemblyVersion attribute specified in AssemblyInfo.cs files
by T.Ashraf
How to use sharepoint webservices in web application
by CoperNick
This article provides an example solution for presenting data in "real-time" from Microsoft SQL Server in an HTML browser. The article presents how to implement Comet functionality in ASP.NET and how to connect Comet with Query Notification from SQL Server.
by Rudi Breedenraedt
How to mix relational and document oriented data in SQL Server and query it with Entity Framework? Including pitfalls, limitations and performance notes.
by PAPAYA
IGotMesasge is an open source Web-based application that allows individuals to easily record and send video messages to others. The software is free to download, install and use, and is easy to integrate with any website.
by Mark Woan
Shows an implementation of displaying images in a DataGridView with image resizing and paging.
by KSAhmed
Demonstration of paging and Sorting with example , using ObjectDataSource and GridView
by Morshed Anwar
Implementing Audit Trail using Entity Framework's caching entries
by Sascha Knopf
An article on implementing complex data binding (DataSource and DataMember) on a custom control.
by Leya Samuel
This article mainly explains about how you can write custom webhook using persistent storage, how they can be created and also a sample source code on custom webhook. The purpose of this article is just to give an idea on writing your own custom web hook.
by Samir NIGAM
This article describes how to implement Hover Delay on the GridView rows for click event.
by User 1895297
Explains how to properly implement the IEquatable interface.
by Ehsan Sajjad
Repository pattern implementation in ADO.NET using Generics
by Morshed Anwar
Undo Redo with DbContext of Entity Framework
by Vivekananda Swamy.M
This article mainly describes how to import data from Excel sheet to SQL Server, Viewing the data from SQL Server using the Gridview Control, Deleting the Data. In case the Excel sheet does not contain data (null values), those values are replaced by zero.........
by ColinBashBash
Allows for inputting Excel tables into a DataSet.
by Alagarsamy, Srinivas
This article explains AJAX and shows a sample using ASP.NET demonstating how it can be used to improve user experience of our web applications
by Erick Cerra
Implementing and using an INCLUDE method in classic ADO.NET.
by Jesús López Méndez
This article introduces you to EntityLite and explains how to use it
by Tom McCartan
A look at the advanced features of IBF 1.5.
by pinx
Extend generated Strong Typed Datasets, add your own business-specific functionality to a real DataSet object. Binding to forms and updating to a database is all done by the .NET Framework. This is built on Shawn Wildermuth's a.k.a. ADO Guy's DataSetGenerator.
by Igor Ignatov
This article explains and illustrates on a practical example, how the support of different inheritance mapping strategies is implemented in Entity Developer with Fluent NHibernate.
by Bob Crowley
In this article, I will explain the sometimes surprising behavior of  the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.
by Bob Carboni
Use the DataGrid to easily enter new data values with a hidden row.
by Tariqaziz
All about stored procedure
by Mohd Manzoor Ahmed
Insert, Update and Delete Function Mapping to Stored Procedures In Entity Framework 6
by AmitGajjar
Create, Read, Update and Delete operations in ASP.Net with MySQL database with N-Tier Architecture
by Mauricio Ritter
This article describes the process of inserting data in a DataSet and then submitting this changes to the database. It targets the issue when having IDENTITY/AutoNumber columns in the database.
by bhadeliaimran
Inserting value of Collection into Database
by Frank Kerrigan
Integrate reporting services with VS.NET pages and VS.NET controls.
by psined
Introduction to Boomerang Framework
by mohamad halabi
Shows how to build new-design distributed applications with WF 4.0 and Data Services.
by Vishal Shukla
This article shows how easily we can create occasionally connected WinForms application using ADO.NET Sync services.
by Alex_Xia
A simple introduction for beginner to jump start on Entity Framework. The Model and query language are explained.
by Marc Clifton
Looking at the EF and database association patterns.
by Andy Marshall
Basic Introduction to jQuery using SQL Server, Web Services
by Dr. Curtis Shull
Using IOC/DI and Repository Factory with LightCore.
by Ujwal Watgule
The article discusses threats to application in the absence of proper validation procedure.
by Samir NIGAM
This article describes how to create an Expandable / Collapsible Panel Control using JavaScript.
by John Kenedy S.Kom
This is a .NET 3.5 library that acts as Data Access Layer with many automatic features
by KK Kod
How to perform Inline editing in JqGrid
by Proneetkumar Pradeep Ray
JQuery Datatable (Dynamic columns) populate after Ajax JSON response via server side processing - Using EF Raw SQL query
by Vishal_007
hassle less free fast ajax grid with the use of javascript and asp.net
by dale.newman
Importing Excel & Delimited Files into a Junk Database
by mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
by mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
by Rajan Patekar
N-tier architecture of Project
by icemanind
Automatically generate Business and Data layers in C# or VB.Net from a SQL Server, Microsoft Access, MySql or SQLite database design.
by BillLange1968
Solution for creating a Leaderboard for a Windows Phone 7 (WP7) XNA game
by Mustafa Ismail Mustafa
An alternative approach to blogging engines
by Akhil Mittal
In this article, we look at how we can leverage Entity Framework approaches and, as per need, use those.
by Akhil Mittal
Code First Approach and Migrations in Microsoft .NET Entity Framework
by Akhil Mittal
ASP.NET Web API 2 with Entity Framework 6 Code First Migrations
by Nic_Roche
A simple mechanism for partitioning settings for development, acceptance, and production.
by Sergey Busel
This article is about the Light Object-Relational Mapping library.
by Lino Barreca
A simple DataGrid column for LinkLabels.
by Sibeesh Passion
Here, in this post, we are going to see some LINQ queries, which covers both basics and advanced.
by Dan-el Khen
A library that enables typed queries to Facebook
by Duane S Moraes
LINQ to Objects helps us use LINQ to query objects in a collection.
by Le Sourcier
How to use LINQ to SQL
by Dan-el Khen
An open source utility that synchronizes your database structure with a LINQ to SQL model.
by Muigai Mwaura
LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code
by Islam ElDemery
A simple speed comparison.
by Michael Piccolo
How to simplify LINQ Transactions using a custom base Datacontext
by J van Rooyen
From a developer's perspective, a comparative article
by Muigai Mwaura
Use LinqToSql to query these popular RDMS products
by Muigai Mwaura
Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database
by Noordin
ExpertSearch Can be used to get value from a list Like Combobox but with ComboBox we can see one value at a time no special searching/filtering is available , with this component you can just call the execute function passing it SQL, Connection and the Column Number you want to retrive value
by Sergey Busel
A small ORM library
by anagram of iEnableMuch = Michael Buen
This article presents how to load rows virtually in a DataGridView without using its RowCount (memory hog).
by Dr. Song Li
This article introduces a method to load and execute SSIS packages in Microsoft Windows with a demo WPF application.
by Alaric Dailey
Building An O/R Mapper Step 1
by David Rogers Dev
Learn how to load related entities using the Entity Framework with simple examples
by pinx
Put language-dependent column captions in the DataSet itself and use it in your code wherever you need it!
by Luis Angel R.C.
A full featured and easy to use DB component.
by Samir NIGAM
This article describes how to manage states of the Checkboxes inside the GridView in different pages.
by Tiago Freitas Leal
The best kept secrets of CslaGen code generation and customization of generated Business Objects.
by Tiago Freitas Leal
All screen shots of CslaGen code generation
by Tiago Freitas Leal
This project shows how to have a master/detail DataGridView using CSLA EditableRootListBase (or DynamicRootList) as the master list object. It shows how to have sorted list and auto save on both the master and detail DataGridView.
by Tiago Freitas Leal
Handling the DataGridView: sorting, auto save for detail DGV, etc.
by Changming Wang
A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar
by Faisal(mfrony)
This Article will help you to manage our CRUD operation more efficient way
by JSpruell
A primer on creating ASP.NET pages that use User.Identity.Name available from Forms Authentification to permit a customer/employee to logon, retrieve their specific records, and format the information as a Master Detail record.
by peter gabris
Force DevExpress Extensions for ASP.NET MVC V2010 vol 2 to do Master-Detail
by Meir Krudo
three ways to create Master-Details Using ASP.NET MVC
by db_developer
MDX query for Get last valid value for measure before the date and then calculate all values that contribute to this value till given date. ADOMD.Net. MDX usage in C#.
by Alexandros Pappas
Measuring COM+ performance
by Terence Wallace
A membership tracking application using Atlas and a customized MembershipProvider.
by Prerak Shah
This article describes the technique to merge the header of a DataGrid by modifying the HTML in a tricky way.
by Jayaprakash V
This article describes the simple trick to merge the header columns of a DataGrid at run-time.
by gnk424
How to merge two DataSets by eliminating the duplicate rows.
by Sekhar Lanka
This article gives an overview of Microsoft Application Block for Data Access, its advantages and specifies its usage in a .NET application.
by Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
by Ilya Verbitskiy
This article describes how to provide full text search using Microsoft Indexing Service in .NET applications.
by jpaulino
This article shows the basic steps of creating a report, define the data source at runtime, work with parameters, include images, use the expression editor, and how to feed data to a subreport and charts. Finally it will demonstrate some easy customizations to ReportViewer.
by Broken Bokken
Learn how to use the ReportViewer with any data source, and build reports on the fly for use on the web or in Windows applications.
by T.Ashraf
My first example of using Microsoft SQL Server 2008 Reporting Services (SSRS)
by Wendelius
This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.
by Michael Vanhoutte
This article explains how to give a user the minimum rights required for SqlDependency to work
by Henry He
There are three development styles in Entity Framework: Database-First, Model-First, and Code-First. In this article, I will show a mixed development style with Entity Framwork.
by Fakher Halim
An article on leveraging Entity Framework to create a set of inherited business objects from a single table. Writing code without any conditionals!
by Khaleel Esbaitah
Models (POCO), Entity Framework and Data Patterns
by Rizwan Qureshi
MOS protocol from introduction to implementation
by smoore4
Move multiple computers from one OU to another using a SQL Server table as a datasource.
by Yasser Daheek
A very productive, easy to use tool to edit your Sql Queries against MS Access Databases
by Tammam Koujan
MSDTC manager
by Jovan Popovic(MSFT)
Create powerful REST API with just few lines of C# code using MsSql.RestApi package
by Gary Dryden
Multi-column dropdown combobox - an ASP.NET 2.0 server control.
by G. Mohyuddin
How GridViews can be used to show data having multilevel master detail relationships.
by Jay Kulaindevelu
An article on multiple column dropdownlists for the ASP.NET DataGrid.
by TSells
Utility to manage multiple DB connection strings for an application.
by santosh poojari
There is already a control available in .NET for single upload. There are cases where we actually have requirement of multiple and bulk select upload of files in application so as to achieve this functionality I came up with the solution that will help developer a lot..
by Neeraj Saluja
Various ways to do Multiple Inserts in SQL Server 2000/2005 or Oracle Database using ADO.NET in single database round trip.
by Messir
An easy and strongly-typed way to invoke queries and stored procedures from your code
by DiponRoy
Conditinal filter query example in SQL, Lambda Expression, C#
by hussain.attiya
A bundle of tutorials which I hope will be useful for Android developers (beginners) to start with
by John C Rayan
MyBatis.NET as DataMapper
by Kirill__
How to manage data using different tools from .NET
by defwebserver
A simple example using MySQL 5 and stored procedures with ObjectDataSources and Generics, in ASP.NET 2.0.
by Benjamin Mayrargue
Adds support for MySQL databases in the Data Access Application Block.
by Amgad Fahmi
This an easy way to interact with your mysql database.
by Igor Krupitsky
Tool that will let you import data from SQL Server and Access to MySQL
by Wayne Gaylard
A class to generate a complete backup of a MySQL database.
by saharkiz
Anti Spam Filter using Naive Bayes Theorem
by Himanshu D
This article demonstrates the ASP.NET 2.0 feature to extend menu generation using SiteMapPath.
by smwhit
Create a data-driven report web page with nested ASP.NET repeaters.
by fawadhq
Nesting GridViews without writing any JavaScript code [AJAX driven].
by questprogrammer
NHibernate using VB.Net
by firefalcon
The first article in the Nhibernate vs. NEO series. Introduction to NEO O/R mapping tool.
by fstrahberger
nls_lang when using multiple Oracle homes
by Mahsa Hassankashi
This article illustrates how to use Node.js by WCF which is written in C# and using node.js as real time communication technology with the aid of C# code to connect MS SQL Server.
by vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
by Packt Publishing
A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005
by George MVC Study
How to use ODP.NET user defined type feature
by sean_mufc
Binding a variable number of DataTable objects using nested Repeaters.
by Robert R Freeman
A tutorial on how to create a hierarchical (1:m) RDLC report in Visual Studio .NET 2005 (local mode).
by Shivprasad koirala
One-many and one-one relationships using LINQ to SQL.
by Donsw
Discussion of concurrency using the IOC and DI Design Patterns with the PostgreSQL database.
by billxie
Minimize viewsate and database access to achieve optimized DataGrid sorting.
by Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
by NielsHoldijk
How a different way of looking at a problem can result in better performance.
by ColinBashBash
Allows for outputting multiple tables, and marking text columns appropriately. Uses Excel's XML format.
by Abhijit Jana
Overview of Error and Exception Handling in SQL Server 2005 using @@Error and Try-Catch
by Mike Lang
A data abstraction layer for .NET applications. Write your application code to be database neutral. Swap out the type of database your application uses without updating or even recompiling your business components.
by Ryzhiy
Optimizing paging in DataGrids.
by commenter2
A really simple to deploy ASP.NET Pager control.
by Alon_Catz
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
by Socrate1
This article explains how to implement custom paging in the GridView web control using the ROW_NUMBER() function of SQL Server 2005
by Anuj Khadloya
Implementing paging in any ASP.NET grid using SQL Server 2005.
by Lars-Inge Tønnessen
How to make paging with a ASP.NET 1.1 Grid control using J#.NET.
by Vimalsoft(Pty) Ltd
How to use paging without a wizard in ASP.NET.
by Rolf Cerff
An ASP.NET 2.0 AJAX Extender to enhance the ASP.NET GridView to page, select, delete, edit and sort rows with keyboard shortcuts.
by Patrickquinn1212
Uses DataBase Schema to aid in Parameter Building for commands.
by Abdul Quader Mamun
Custom TreeView web user control for parent child relatioinal data upto infinity
by S. M. Ahasan Habib
In this article I will demonstrate how to read a large CSV file chunk by chunk (line basis) and populate DataTable object and bulk insert to database.
by Svante Seleborg, Alphons van der Heijden, Dave Shaw, katakana2
A Windows Mobile C# reader for the popular Password Safe archive files.
by Mark
An article describing a pattern for updating only certain values that have changed in a web form.
by Perry Marchant
An article describing the best practices for Entity Framework performance.
by Perry Marchant
An article describing the best practices for Entity Framework performance
by KshitijPandey
This article seeks to compare existing approaches with the new ones released with
by Steven A. Lowe
Permalinks provide an easy way to redirect incoming traffic to specific pages, track hits and goals, and prevent external links from expiring.
by Thomas Lykke Petersen
Enable persistance and population of objects without writing ADO.NET code.
by Ansil
This is an article about maintaining checked state across pages in a DataGrid.
by Mostafa Kaisoun
This is a program for phone index to see how we can use the alphabetical English characters (A..Z) to search a customer name which begin with any character.
by WillemM
Article describing how to build pluggable data access components.
by rasheed1979
Personal Pocket Health Record (PPHR) application helps to store and track a user's personal details and visits information on Windows powered pocket PC.
by lakhdarr
Working with different data stores (SQL, NoSQL ..) in high performance enterprise application using DDD and Repository unit of work pattern
by Bryian Tan
This article shares the idea on how to utilize free tools to download log files from server, upload IIS log files into the database, display the results and compare the baseline and production files.
by carlos@takeapps
A webservice implementation to connect to POP3 servers
by raelango
This is a sample project to access Microsoft Access MDB data in Silverlight via OLEDB and dynamically populate a DataGrid.
by azamsharp
How to populate a TreeView control from the database.
by siva pinnaka
A complete article on how to populate custom business objects using a common method, binding these objects to a GridView using the ObjectDataSource control.
by Vinay Jade
ModalPopupExtender and ConfirmButtonExtender with GridView to View/Add/Edit data
by Mr.Sourav.Maitra
This article is a step by step approach to create HyperLinkField in GridView in ASP.NET.
by PSK_
Using a simple example, I'll explain how to prevent a program that can register thousands of dummy users to your database and play with your database and application performance.
by Life with .NET
This article will print all the records in a datagridview in tabular form
by Afrasiab Cheraghi
An article on printing selected columns and rows in a DataGrid.
by Syed Hasan Hyder
This article focuses on internal supply chain management systems visibility via chart reports, and provides assessment apparatus to manage and monitor activities spawned during business processes, hence paves the way for timely and precise business decisions.
by saanj
This article demonstrates how can you dynamically handle SQL Server Reporting Services Subscriptions without using the SSRS interface at all.
by Xinjie ZHANG
With ADO.NET, a database can be regarded as a virtual XML document. XPath query and XSLT transformation are naturally available.
by Wendelius
This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
by jaullo1
Protecting ADO.NET applications
by Aydin Khatamneajd
Using ModelMetadataProvider to Set Display Name Metadata for the Model Fields at Runtime
by Ahmad Eid Salim
Provider Design Pattern is a new pattern that Microsoft formalized in .NET 2 to increase application performance where there is no need to explicitly instantiate classes.
by Rajesh Pillai
This project is meant to provide a tool similar to query analyzer which can be used to execute queries, create tables, and do all other common database activities.
by Abhishek Sur
The article demonstrates how you can use SQL Server Query Notification feature to get notification from database whenever the result of a command gets changed. Sample application demonstrating SqlDependency and SqlCacheDependency is also included.
by Marek Mizov
Query paging by one trip to MS-SQL Server 2005 via a simple query. Without using a Stored Procedure, View, or others features. Only uses T-SQL and .NET.
by Mikael Håkansson
QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.
by Shahriar Iqbal Chowdhury/Galib
T4 templetes with built-in support for CRUD operations, that utilize XML/XSD for DAL/BLL generation.
by Balachandar Ganesan
Auto Generate the ASPX page quickly
by Derwin Dexter Sy
This is a base class that can be used to create model objects for database connectivity via ODBC in C# .NET.
by Angsuman Chakraborty
In this article, we will discuss how to use sqlbulkcopy.
by Farooq Kaiser
In this article, I will examine how to store and retrieve binary files such as image or PDF into Microsoft SQL or Oracle database.
by Dieder Timmerman
Shows how to use OLEDB to read from and write to Excel workbook files.
by dasblinkenlight
Working around an Entity Framework exclusion of sql_variant
by S. M. SOHAN
An article that shows how one can use Log4Net to capture the log messages that are generated by the LINQ to SQL DataContext classes
by Carlos Conceição
Using data-structures to do away with boiler plate code.
by azamsharp
This article describes how to refresh a GridView control on the parent page, from a pop up window.
by Marc Clifton
An Integrated Development Environment (IDE) for the Relationship Oriented Programming Tool.
by TimMerksem
Remove those strings from your .NET 4.0 applications using the dynamic feature.
by Daniel Zaharia
Article on a simple report builder.
by Asif Sayed
An article to demonstarte the use of Reporting Services using Smart Client interfaces.
by Asif Sayed
A step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client..
by Asif Sayed
This article will show you how to report XML data with Crystal Reports and a Windows Forms client.
by Ali-DN
Restaurant and Waiter project! (WPF - Windows Mobile)
by FREEDEV
Restore database during application deployment using Windows Installer and Visual Studio Setup Project
by Deepak.M
This article describes on building a Database from scratch using Batch File from the existing Database
by Alexander German
Displays data contained in a DataSet into a RichEdit control.
by Patrick Bounaix
Generate .resx files from an Excel spreadsheet; fully customizable.
by Joshi, Rushikesh
Retrieve hierarchical data from database in effective way!
by David Catriel
How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation
by DiponRoy
Select data as DataSet object for a database using Entity Framework and map results them to entity lists
by Levi Rosol
Review of Patterns of Enterprise Application Architecture by Martin Fowler
by mrwisdom
Source code for how to create a RichTextBox column in a DataGridView
by Omar Al Zabir
RSS Feed aggregator and blogging Smart Client which uses Enterprise Library, Updater Application Block, lots of XML hacks and desktop tricks. A comprehensive guide to real life hurdles of Smart Client development.
by SathiMahesh
A VB.NET RSS news reader. RSS sites are stored in an Access database, and items can be selected from a DataGrid. Selected news items are displayed in an embedded browser.
by SumanBiswas
That code can run any type of stored procedure.
by sasikumarg1983
This article describes how to create a DataGrid at runtime according to the tables available in the DataSet.
by Bala Murali S
This project is used to easily understand and implement Ajax in C#.net , ASP.Net with Ajax.dll
by anand P Singh
This is a simple example to show how to connect to SAP using SAP .Net Connector 3.0
by inishant12
Using SSRS report, generate the PDF, save it into DB and send it through mail using C#
by Ilya Builuk
Using log4net to save data in database with help of NHibernate
by Henry He
In this article, I will show you how to use Entity Framework Self-Tracking Entity to save temporary data in Enterprise Applications.
by A. Najafzadeh
Saving zip files in access database with encrypting bytes when file saved in access database and decrypting bytes when extracting files from database . . .
by Jimmy Zhang
Agile, efficient XML data binding without schema.
by Serkant Samurkas
SDXGrid, is a comprehensive data grid component for Microsoft .NET 2.0 web application developers, easing the exhausting process of implementing the necessary code for sorting, navigation, grouping, searching, and real time data editing in a simple data representation object.
by Tim Corey
Learn how to use ADO.NET objects to create a Google-like auto-search for your WinForms grid
by Walid Abdulrazik
An extension to the Microsoft SqlProfileProvider, to provide a search interface. This article is based on Shawn Wildermuth's - "a.k.a. ADO Guy" - work.
by Alaric Dailey
Simple code and explanations to enable secure password authentication.
by Surath Rath - 2010
This article introduces the fundamental concepts behind SQL Server 2008 Application Role and illustrates its use in securing data and database objects.
by Samir NIGAM
This article describes how to select and unselect all the checkboxes inside a GridView control.
by Murugan Sivananantha Perumal
Self Hosted WCF Service as Windows Service with custom User Authentication over Http.
by Aydin Homay
In this article, we will discover the power of generics in C#.
by Aydin Homay
In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.
by Fedor Dzjuba
Sometimes, we need to present MDX result on the web or a client application that has no native provider to Microsoft Analysis Service. Solution is to use Adodm.Client CellSet, serialize it into sensible JSON and spit it out to the client to render.
by Siddharth Gajbhiye
In this article, we will learn how to create server side paging which is very useful whenever we have to display large number of records.
by deepaktripathi
Setting up MySql membership provider with .NET Framework 4.0 and VS 2010
by Bruno Altinet
How to set up a basic application using Silverlight, RIA and NHibernate with top to bottom validation, all nice and fluent:)
by TofuBug24
Collection of information on optional paramters in Stored Procedures, as well as passing null values into the Fill method of a stongly typed data adapter.
by Ayman M. El-Hattab
Demistifying the SharePoint delegate controls, allowing fast and painless SharePoint branding.
by Noel Baidya
A SharePoint like GridView menu.
by Olmo del Corral
In this part, we will focus on writing business logic, LINQ queries and explain inheritance
by Olmo del Corral
In this part we'll write the loading application to move data from Northwind to Southwind.
by Joerg Lang
The article describes how to create a Deep Zoom image and store the tiles in a database, and how to read the image from the database and display it in the browser.
by Lalith Bommera
A simple AJAX approach that includes an HTML page client, and a JavaScript making an AJAX call and receiving a response. A remote page will receive the parameter information and respond to the JavaScript call method with the necessary information.
by Aleksey Shurtygin
An easy way to manage application configuration with a wide range of options for storage.
by 6opuc
Fast and easy to use data access class library.
by Muhammed Anseer K K
Creating a metro style application with WCF
by Erase Me Please
A very simple ORM class. It doesn't have all the functionality that others have, but it might be an easy solution for smaller things.
by Mohammad Hamed Akhter
This is a simple user friendly query tool which helps end-users to extract data from the database. The UI looks similar to query windows in Team Foundation Server, this is a modest beginning which can be enhanced and used more effectively.
by stexavcar
Simple sample with entity framework in 3 layers with ASP.NET
by Pawel Zarzycki
Simple class that helps accessing and managing SQL Connection Strings.
by ChrisLee1
A class to allow easy running of T-SQL code against .NET data sources.
by Marc Brooks
Simple C# code to convert an ADO.NET (System.Data) DataTable to an ADODB Recordset.
by BoneSoft
An API to simplify access to databases through ADO.NET.
by PIEBALDconsult
Using the ADO.NET Interfaces to build a small framework to simplify Database Access
by Swift coder
How to simplify the ASP.NET DataGrid by eliminating code-behind.
by Abhishek Sur
Using this article you will get the basic idea of how you could use NDepend to control/analyze your application. It allows to apply design rules and refactor code.
by Asif Sayed
A tutorial demonstrating the power of the AutoComplete feature of the TextBox control using a Windows Forms client and SQL Server 2000 data.
by Alberto Venditti
A proposed class to simulate the ADODB.Recordset behavior in .NET.
by tranthanhtu.vn
How to build the SPA for enterprise application using Angular2 and WebApi (RESTful)
by tranthanhtu.vn
In this article, we will learn how to create/edit Role
by alon1980
An open source password manager with some advanced features and cool interface
by sklivvz
SixPack Library tutorial on how to use the StoredProcedure class.
by Samir NIGAM
This article describes how to create a slide-show user control with the help of the DataList control.
by Lou Flees
An ADO.NET toolbox that is meant to serve as the lowest level database IO layer for an application based on an Access, Microsoft SQL Server, or Oracle database.
by John-ph
WinForms application developed using C#, ADO.NET and MS Access
by xbiplav
An Article on Some Advanced Sql Statements and Aggregated Functions
by Neil de Weerdt
This articles details some best practices for improving performance and scalability.
by Dave Elliott
How to sort tables so data can be retrieved for offline sychronization and not violate foreign key relationships.
by Sailung Limbu
This article demonstrate flexible client-side table sorting
by Raj Settipalli
An article on generating SQL strored procedures and VB.NET function calls.
by Vikash Kumar
SQL bulk copy with strongly typed data including validation.
by Charl Pohlmann
An article on a SQL database editor.
by Charl Pohlmann
An article on automatically building the relationships between tables in a DataSet.
by Lyubomir Rumenov Velchev
A simple console application, which executes all SQL files added by developers working with decentralised development environment.
by mysorian
A step-by-step approach to creating a report from scratch using the SQl Server 2000 Reporting Services.
by R. Senthil Kumaran
Using tranasaction on distributed servers and querying them - Linked Servers in SQL Server.
by mfmaneef
Using SQL Server 2008 table valued parameters to insert multiple records (VS 2008).
by Tadeusz Kaliszewski
A small .NET class library for maintaining SQL CE database schema written in C#.
by yuvalsol
Helper class to mitigate working with Dapper against SQL Server database
by User 992674
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
by App Software
SQL Server Express Automated Backup Console Application
by Mohammad A Gharakhanlou
this application is answer for ;How to encrypt sql server procedures and functions at a time
by singh
This article shows general code that creates stored procedures for SQL tables and C# DAL
by M.M.Mohseni
An ASP.NET one page application for getting backup from MS-SQL Server
by Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
by Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
by Bojan Sala
SqlBinder is a free, open-source library that helps you transform a given SQL template and a set of conditions into any number of valid SQL statements along with their associated parameters.
by idreeskhan
SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, Transferring Data Using SqlBulkCopy - SqlBulkCopy - Copy Table Data Between SQL Servers at High Speeds, perform bulk copies with .NET 2.0's SqlBulkCopy class, SqlBulkCopy tutorial
by Zahid Nawaz Ch.
SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.
by Amit Chaudhary
SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.
by Roger Martin
Complete, production-ready Membership, Role, and Profile providers for SQLite. Includes instructions for migrating data between SQL Server and SQLite.
by Awesh Vishwakarma
The easiest way to use Entity Framework with SQLite databases in C# Winform and Console Applications
by adambl
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
by Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
by Mike Ellison
A user interface web control for building conditions suitable for use in a SQL statement.
by Paul_Gordon
An easy way to call and manage Stored Procedures in .NET.
by César de Souza
Explore your data using statistical distributions: explore, initialize, create, estimate and use statistical distributions from the Accord.NET Framework using an application based entirely on reflection.
by Alvaro Mendez
A simple class library for database access without the pervasive and often-fragile connection management details.
by b_hardman
Generate code classes to access stored procedures via web services.
by Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
by Haider Ali Khan
This software generates Insert, Update, Delete, and Select stored procedures (whichever you want) for selected tables.
by N a r e s h P a t e l
This article describe how to add image directly to database and how to view the Image stored from Database.
by Kazim Sardar Mehdi
Storing and retrieving images from SQL Server using Microsoft .NET.
by Thilina Chandima
An introduction on how to store and retrieve images from SQL Server 2008 by using Stored Procedures and C#.
by Akram Mellice
Generate strongly typed datasets
by Mark Kestenbaum
An entry to the Windows Azure Developer Challenge.
by Gil Fink
The article explains what Table Per Hierarchy Inheritance is and how to apply it in Entity Framework.
by Rahul Pratap Singh
How to create common procedure to insert the data in any table.
by Rafik Robeal
Build occasionally connected applications using Microsoft Synchronization Services for ADO.NET
by Tim Schwallie
A few ways to work with In-Clause and Stored Procedures with SQL Server and C#.
by DavidSherwood
Added property change notification and validation code to Microsoft’s VB.NET text transform files that create the POCO classes and DBConext class.
by Danilo Mendez
SmartCode is a template based code generator.This tutorial describes the process of building a templates to SmartCode
by Ambalavanar Thirugnanam
The HTML report engine is a .NET class library which helps in generating well formatted HTML reports.
by Petr Ivankov
Long time strategy of software design and development
by Alex_2979
A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.
by db_developer
An approach to create a master-details grid and to show the parent column in the child table.
by Santiago Sanchez
This article shows how to populate any generic list from a DataTable.
by Gunawan Hadikusumo
Another way around to navigate and control the records with out depending on data binding.
by Samir NIGAM
This article describes how to toggle the states of all CheckBoxes inside a particular DataGridView column.
by Sriram Chitturi
Tool to generate script for Linked Servers in SQL Server 2000, using C# and SQLDMO.
by mcondon013
Article listing and evaluating useful third-party tools and libraries for the independent developer of shareware and freeware .NET applications.
by Dr. Song Li
This article presents an example on how to control the transaction isolation level in ADO.NET Entity Framework.
by gaurav_verma_mca
This article details out the best practices of transaction management across application domains
by Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
by Adrian Pasik
This article is about transferring backups without raising the privileges of SQL Server, or using custom copying tools.
by Rob Lyndon
Using parallel implementations of SqlBulkCopy to achieve fast data transfer from a single XML source into multiple tables.
by dale.newman
Combining de-normalization, transformation, replication, and awesome-ness.
by Satheesh Kumar Subramanian
Transpose DataTable rows into columns and vice versa using C#.
by Anil kumar Bhardwaj
Create HTML tree or organization structure for web applications.
by Viswanath Majeti
How to raise a GridView RowCommand event from a child DropDownList control using a Submit button.
by Theo Bebekis
A tutorial on using Tripous data access classes
by Theo Bebekis
A tutorial on how to use Tripous data entry forms in order to display data from different types of data sources.
by Theo Bebekis
An Open Source desktop database (data entry) application framework.
by Michael.Piccolo
How to add DataGrid columns dynamically with ITemplate, XML and templated controls.
by Casper Leon Nielsen
T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)
by Rahul Rajat Singh
How to use dapper to read mutiple resultsets from database in a single database call
by aSarafian
Converting a Typed DataSet to and from LINQ entities.
by aztekka
UDL.Net is a ConnectionString editor built from scratch, modeled after the Universal Data Link (UDL) and the Visual Studio DataConnectionDialog.
by Al-Farooque Shubho
Exploring Set based and Procedural approaches to write better SQL in SQL Server.
by Debopam Pal
What is three layer architecture and how to implement it.
by freedeveloper
How to create a data access class in a way, that is possible to execute unit test on it
by liron.levi
My small, home-brewed database upgrade framework for upgrading SQLite databases...
by Don Ashworth
Upload a Microsoft Office Power Point, Excel, Visio, or Word File to webserver, of which will be converted to HTML and hosted as a document link on the page in which it was uploaded.
by Dr. Song Li
This article presents an example to upload and download files with SQL Server in ASP.NET.
by zam664
Illustrates how to upload and download BLOB data to Microsoft Access.
by Vinod Giri T
An article on Microsoft SQLXML
by Execusoft
How to use the combobox at runtime, adding items, selecting default value, and returning selection.
by Sreekanth Mothukuru
The idea is to use Dependency Injector (DI) framework Ninject to dynamically target our application to SQL Server or Oracle database either by using Entity framework (EF) or Dapper ORM using global settings
by JasonShort
Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code?  You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!
by Tomz_KV
Explain how to use a SQL CLR function to overcome the limitation of a standard SQL user-defined function to execute ad-hoc SQL query.
by Ole Oren
Fast and simple REST development for SQL devs
by Bill Seddon
Shows how a .NET based WebDAV server can be created by combining two Open Source projects. The example implementation returns files from a file system, but you can extend it to return resources from any repository.
by Muammar©
How to use a DataGrid control.
by gjvdkamp
This article demonstrates a technique how you can write recursive algorithms in F# using a Reader instead of a list, so you don't have to load all your data into memory first
by Dylan Fairbairn
Outlines an alternative to using the SqlDataAdapter to perform updates from a DataTable to enable the use of minimal updates.
by Huseyin Altindag
ADO.NET for beginners.
by Umut ŞİMŞEK
An article on using ADO.NET programmatically.
by caramels
Simple to use ADO.NET in C#
by sea_caty
The article shows how to use AJAX in your applications based on the Microsoft MVC Framework.
by Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
by saanj
Using ASP.NET AJAX TAB Control
by DreamInHex
Create a simple, scalable XML-consuming rules engine in just a few minutes, using OpenXML.
by Ansil
This article is about using CheckBoxes in a Datagrid control to select records as in a mail box.
by alifaraze
A trick to use config file for Custom assembly in reporting services
by Rehan Ahmad Abbasi
Using Crystal Report with Oracle and parametrized Query (C#.NET Windows application). Passing SQL query parameters to Crystal reports
by dakeefer
An exploration of how to use the EntitySpaces business object framework within a WPF application.
by Balamurali Balaji
This article explores the usage of InfoMessage event of SqlConnection object
by Alaric Dailey
Using information from the .NET DataProvider to improve dynamic SQL and allow the use of multiple databases
by DreamInHex
Demonstrates how to apply JavaScript functionality and CSS effects to an ASP.NET DataGrid.
by Roman Ivantsov
The article provides a comparative analysis and gives patterns of using explicit locks to manage concurrent access to database documents (data split over multiple tables) in MS SQL Server, MySql, PostgreSql and Oracle. As it turned out, the solution is not always obvious or simple.
by Robin_Roy
Using Microsoft Enterprise Library Data Access Application Block to Retrieve Data from Database.
by User 388430
How to use a DropDownList on each row of a DataGrid and determine if the selections changed when posting back.
by Custec
An article on connecting to and using MySQL from Mono.
by Dustin Metzgar
Shows how to use NHibernate in a COM+ distributed transaction.
by Jan Schreuder
A simple class to help you get started with the OleDb Jet Engine to import text files
by Petrovik Aleksandar
How to use Oracle (and other non Microsoft) SP in SqlDataSource Select command
by rajiv404
Query Notification in SQL Server 2005 solves the problem of having to maintain a polling database to get the updated data. The new notification service of SQL Server 2005 can perform this amazing task of notifying a .NET code when any DML operations are performed to a specified table.
by Joe Cleland
This article describes classes that can be used to update data sources with object data via reflection.
by Jason Witty
With the release of SQL Server 2005, Microsoft introduces the long overdue ROW_NUMBER() function. In this article, we will walk through a C# implementation of pagination using the ROW_NUMBER() method.
by Mark Killmer
A method for emulating a complex class.
by fulcrumweb
This article introduces FulcrumWeb RAD Framework - A Silverlight UI Engine to build user friendly database driven applications
by Alden John Snow
This project demonstrates what is likely the fastest way to upload one of those fixed width reports from a mainframe to a SQL server table.
by Aman Bhullar
An article to explain the use of SqlBulkCopy class in ASP.NET
by Not Active
Using SQL Server 2005 and SqlDependency to keep your application's data updated.
by dotScott
Using SqlParameters with stored procedures in .NET.
by Yunus Emre Kalkan
How to create custom repostories in ASP.NET Boilerplate and use stored procedure, view, user defined functions inside your repository
by Danko Greiner
Use TableAdapters with transactions.
by Huseyin Altindag
An introduction to using the ADO.NET control.
by Peter Carrasco
This article describes how to use the Entity Framework version 4.3 in your Windows desktop or web application for database access.
by Robin_Roy
Using the Microsoft Enterprise Library Data Access Application Block to insert data into a database.
by Dustin Metzgar
Shows how to use TIP to communicate with web services in a COM+ distributed transaction.
by netbard
An introduction to SQL Server transactions and how to use them in ADO.NET.
by Edward Moemeka
A continuation of using XAML for configuring applications
by Rahul S Chavhan
Validate an XML document in SQL Server using XSD by Rahul Chavhan
by jopascual
Connecting from VB.NET to a MySQL database.
by G Ryno
Using and extending the data access classes, and runtime selection and instantiation using a factory and XML configuration file.
by kepboy
Use the correct data access classes for the current version of the database
by scubaduba
An ASP.NET user control for a DHTML drop down menu, with high compatibility and customization features.
by David Catriel
An extremely fast and efficient way to import a table from any ODBC-capable database into MS Access (while running in a C# project), by using the Microsoft Access built-in import functionality.
by marcmanuel
The use of ORM mapping with LINQ
by Bob Stoom
Walkthrough in detail to create a relational database application using C# .NET without code.
by srilatkol
This basic example illustrates invoking database tables using a WCF service.
by SP.Murugesa Pandian
WCF DataContract
by Venkat Krishna Turlapati
Automated process of downloading a XML file and inserting the contents into a database.
by bob.bumsuk.lee
Web app that manages customer complaints and demonstrate how to use Web API, SignalR and AngularJS technologies
by Olivier_Giulieri
Just 200 lines of VB.NET to document your SQL Server databases.
by Forkossigan
Show developers how to manage state of long running web service and then use this state in Ajax enabled web form
by vivekthangaswamy
This articles is an introduction to web services, with a simple illustration.
by FredParcells
Online month-view calendar of items rented by the day, with user defined rental lists.
by hestol
This load the "ECB" xml file and parse it into a dataset. From that we can calculated the Exchange rate between difference countries.
by shah vatsal
Website scraping using Watin
by koolprasad2003
Have you lost your data from SQL table? Have you lost your SQL table? Want to know who ran DELETE or DROP Query on your database? Then go through this step by step article, it will help you to find the culprit
by Babak Ansari
A method to create Windows and Web components with the same interface
by FrankNight
This article shows an example of how to build a software component according to best practices that is customizable through code generation techniques.
by Babak Ansari
A framework to develop Win-Form and Web-Form applications using generic components
by Dan Radu
This article explains how to use Office 2003 WordML features to display data stored in .NET datasets.
by Michael Ecklin
Very often, Excel spreadsheets are using to transfer data between applications. CSV files are also used for the same purposes.
by Alaric Dailey
Working around issues when using SQL Server indexed views.
by Arul Nayagam C A
This article demonstrates the DataGrid , ADO.NET components, and storing data into the database and retrieving from the same.
by Mohammad Elsheimy
Learn the details of how to work with SQL Server logins.
by Dimitris Nemtsov
Master-Detail binding in WPF to SQLite database
by Joel Ivory Johnson
An introduction to data binding with WPF.
by FatCatProgrammer
StarReport: WPF-less GDI+.NET report component.
by Not Active
Synchronizing external data sources with SharePoint Lists.
by CS Rocks
This article walks you through creating a simple windows database with an Xml file as it's datasource.
by Venkata Kancharla
A Windows service which monitors the directory changes, writes an entry in the event log about the change, notifies the change to the users by sending a mail, and also converts the input XML file into a DataSet.
by Stein Borge
Template based code generator
by Antonello Genuario
A class library that helps to create WHERE clauses in a SQL statement or a filter expression for a System.Data.DataRow select operation.
by GerVenson
ADO.NET ORM
by Uwe Keim
A small set of general-purpose classes for using in .NET applications (2.0 or higher)
by Uwe Keim
An application to manage support request with tickets and events
by Uwe Keim
A web application for generating and measuring shortcut hyperlinks, similar to bit.ly
by dmihailescu
Zip/Unzip using java.util.zip from managed code.