Datatable in ADO.NET is highly useful to do in memory data related operations. But it is very painful to update data when it is bound to a datagridview or bindingsource.While I was developing an application in .NET with C#, I came across this problem in which I had to modify a data table of...

ADO.Net Connectivity using Stored Procedure and Output parameters

by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Auto Complete Control Like in GMail/Hotmail/Facebook

by Bikash Prakash Dash

How to create an auto suggestion control like Gmail/Hotmail/Facebook to add items in list.

AutoComplete ComboBox Control From Database

by alrosan

AutoCompleteExtender working with EntityFramework! (Reload 2015)

by Eduardo Yost

Creating a Web User Control containing an AutoCompleteExtender for data through WCF (JSON) allowing to store the entity selected through EntityFramework. Entity object serialization from the server to the client and the client to the server.

Bulk Copy/Insert from a CSV file to SQL Directly

by Bhishma Anil Kajaria

Browse and Copy data from your CSV file to SQL directly without any Windows application...

C# Photo Viewer with Windows Forms

by puja11191

This is an extension of Photo Viewer on MSDN

Changing Databases at Run-time using Entity Framework

by Matthew Givens

How to change databases at run-time in a user-friendly manner.

Check Network V1.0

by mohamedkamaleed

Network check v1.0

Clientside GridView with jQuery template and AJAX in ASP.NET

by sumit_kapadia

Create and Bind gridview at client side with Jquery Template and ajax in asp.net

Clone an Entity in Entity Framework 4

by markmnl

Method to clone an EntityObject without serilization or detaching it

Combobox Data Binding and Sorting Tip

by wkiess01

How to sort a data bound combobox

Connecting Windows Form Application With ADO.NET in C#

by Bikash Karmokar

Connecting Windows Form Application With ADO.NET in C#

Continuous Integration and Delivery for Beginners (DevOps)

by Thinira

Continuous Integration and Delivery with VSTS (Visual Studio Team Services)

Convert CellSet to HTML Table, and From HTML to Json, Array

by Sibeesh KV

Convert CellSet to HTML table

Convert Outlook Table Content into Datatable using C# EWS and HtmlAgilitypack

by Saurav J

Convert table from outlook email body into datatable or list using .NET C# EWS Managed API and HtmlAgilitypack

Converting DataView to Table

by Sunasara Imdadhusen

Creating a DataTable from a DataView - DataView.ToTable()

Create CSV from JSON in C#

by Yaseer Arafat

Using Extension Method and JSON Serializer

Create Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

by Prakash Lekhak

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#

Creating a Formatted Column within a DataTable

by Mattintosh

How to create a formatted column with nothing more than a knowledge of which columns you want and the format you want them in

Creating a SQL Server Database Project Use in Visual Studio 2012 and Use TFS for Version Control

by Diluka Wittahachchige

Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS

Creating null value SqlParameter parameter objects with AddWithValue

by Brady Kelly

On problems that arise tying to add a null valued SqlParameter using the SqlParameterCollection.AddWithValue method.

Custom Treeview

by sri senthil kumar

Custom Treeview control useful when multilevel hierarchical data need to be displayed and setting default can go at any level and providing access to each level then this can be the right choice.

Dapper.NET Sample with MVC 4- Add,Edit,Update,Delete

by Gihan Liyanage

Simple Dapper.NET Example with MVC

Data Access using ServiceStack

by Daniel Santillanes

Using ServiceStack's ORMLite framework as part of your MVC project's database access

Database Driven Dynamic Menu Control

by Yugal Pandya

Database driven N-Level Dynamic Menu Control using C#.NET and SQL Server with stylesheet CSS

Database Driven Dynamic Menu Control

by Muhammad Ahmed Azam

"Database Driven Dynamic Menu Control"

Database project diff SQL script utility (Using VSDBCMD)

by Umesh Khandelwal

Database project diff SQL script utility (using VSDBCMD).

DataReader into IEnumerable with C#

by Jaume González

How to convert any datareader into generic list.

DataTable from Excel

by Igor Krupitsky

This article shows how to get ADO.NET DataTable out of Excel

Datatables.net Deferred Loading of Data using ASP.NET MVC and jQuery

by Deepan Maheswaran

Implementing dynamic or deferred loading of data using datatables.net plugin in ASP.NET MVC

Day 1 : Database Connectivity ASP.NET/C# with SQL Server (Create Operation)

by VijayRana

CRUD operation in ASP.NET/C# with SQL Server for beginners

Day 2 - Database Connectivity (Retrieve Value from Database and Bind to Gridview)

by VijayRana

Retrieve value from database and bind to gridview

DBConnect

by Sina Shiri Hamedani

This is a simple C# class for connect and using SQL Server easily (SELECT, INSERT, UPDATE, DELETE)

Debug ASP.NET MVC Application with Glimpse

by Muhammad Hassan Tariq

Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications

Debugging DataSet Constraint Errors

by cjb110

How to identify the cause of the DataSet Constraint Exception

Detecting Concurrency Issues with Entity Framework

by Robert Lindblom

Detecting concurrency issues when using Entity Framework model first and SQL Server

Dodgy Database Solution with JSON

by Michael Breeden

Using JSON to simplify, solve and enhance SQL Database issues

DuplicateNameException when adding columns to a DataTable dynamically

by David C. Williams

When building an ADO.NET DataTable dynamically in your code, each column name must be unique or you get a System.Data.DuplicateNameException. If you don't know at design time that the columns you will be adding are certain to have unique names, you can use this method to avoid a runtime error.

Dynamic ASP.NET Web API Controller - Part 1. Dynamic DTO

by David Lee 145

How to make dynamic DTO with ExpandoObject

Dynamic DropDownList Binding in ASP.NET MVC With Database

by Member 10872251

Cascading DropDownList in ASP.NET MVC

Dynamic SQL Connection in ASP.NET 3.5 with User Controls

by ss9o9o9o

Transferring backup files from a remote SQL Server and Dynamic SQL Connection with Restore utility.

Dynamically created menu bar from the database according to user credential using C#.NET

by Dipankar Hazari

How to populate a dynamically created menu bar from the database according to user credentials using C# .NET and ASP.NET.

Dynamically Setting a Parameter from a C# Variable in Crystal Reports

by Kinyanjui Kamau

I have written this tip to help developers automatically set Crystal Report parameters from variables in code (WinForms) at report run time.

EF Remove If Exists

by Robert Lindblom

Removing entity if it exists

Ensure Your Code First DB is Always Initialized

by Brady Kelly

A quick and easy way to ensure that your Code First DB Initializer is always run when your app starts, not just on the first data access operation

Enterprise Library 6 with SQLite Logging and Exception Handling, REAL!

by ModMa

Real and fully functional connection Database Provider and DatabaseTraceListener for SQLite!

Entity Framework: ProviderManifestToken not valid

by User 4324523

This tip attempts to solve ProviderManifestToken issue

EntityWorker.Core - An Alternative to Entity Framework

by Alen Toma

EntityWorker.Core - an alternative to entity Framework

Enumerating OleDb Providers

by PIEBALDconsult

A simple way to enumerate the OleDb Providers installed on the system

Example of gridview rowcommand on Button Click

by Nandakishore G N

Example For Gridview RowCommand Event

Execute Long Running SQL Statements Asynchronously from .NET

by Anil Kumar @AnilAwadh

A beginner's tutorial for understanding Asynchronous execution of SQL statements using a simple application.

Executing Stored Procedure using Entity Framework DataContext

by Manoj Deshmukh

Executing Stored Procedure that returns resultset using Entity Framework DataContext

Export and Import Database using SMO

by Sridhar Pasham

Export and import database using SMO

Export to Excel in ASP.NET C#

by JatinKhimani

Export Gridview data in Excel formate with gridview design.

Exporting a DataTable to PDF

by M.AFTAB.ALAM

Using MigraDoc as an open source .NET library to export a DataTable to PDF.

Extract All Schema Information From Your Database

by sx2008

how to get as much information about your database as possible via ADO.NET

Extract Image Files from Database Image Data

by PallavSingh

Converting data column (contains OLE db image binary Format) to image file (.jpg)

Failproof Bulk Upload SqlBulkCopy

by lalitsrana

Demonstrate a simple yet efficient way to upload the data (SqlBulkCopy)

Fast and Simple IDataReader Implementation to Read CSV Files

by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Five different overloads of the DataAdapter.Fill() method

by Ravindra T C

A look into the five different overloads of the DataAdapter.Fill() method.

Forgot Password With Check Email From Database

by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Generating and Splitting a Delimited String Column

by Tharaka MTR

This article describes the easiest way to create and process delimited row using SQL XQuery.

Generic Method to Convert DataReader Result into List of CLR Objects

by Bankey Sharma

Converting DataReader Result into List of Objects Using Generic Type, Property Attribute and Reflection

Geolocation wifi Scanner and Finder

by Dr Gadgit

Written in C# and VS2010 as a class libary to be used in your own project.

Get SQL Server Database Connection String Easily from Visual Studio

by Srinubabu Ravilla

How to get SQL Server database connection string easily from Visual Studio

GMaps Control Simplified in VB.NET

by Len van den berg

GMaps Control Simplified in VB.NET

High Performance ADO Database Library

by Matthew Ruffell

A high-performance and well tested C# ADO library for connecting and querying a SQL database

Highlight Search Text in Search Result

by Bikash Prakash Dash

How to highlight search text in a search result using ASP.NET

How to Change Date Format in Crystal Report

by Mian Adnan

Using Microsoft Visual Studio Professional 2012, .NET 4.5 and Crystal Report Version regarding .NET 4.5 and VS 2012

How to Check Opened Connection in SQL Server

by Najmul Hoda

Here is the code snippet to check how many database connections are opened in SQL Server.

How to Copy Data from SqlDataSource to Datatable and Operations Using Datatable

by Nandakishore G N

I'll Try To Explain Some Methods of Datatables.

How to Create Subreport using Microsoft Reporting Service

by T.Ashraf

Introduction...

How to execute multiple database script files from a specific directory

by S. M. Ahasan Habib

I will explain very simple way to execute multiple script files (*.sql) from a directory.

How to fix Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

by AlbertoLeon CSharpMan

Insert Ignore with select thousands of rows threw timeout expired exception

How to get Connection String from App.Config in C#

by Alireza C

This code helps you to grab ConnectionString from App.config.

How to Implement ObjectStatus with EntityWorker.Core and JavaScript

by Alen Toma

How to implement ObjectStatus with EntityWorker.Core and JavaScript

How to: Get Data from Multiple Workbooks using One OleDbConnection?

by Maciej Los

This tip shows how to get data from multiple workbooks using one OledbConnection.

How-To Create a CLR Function with EffiProz Database

by arith silva

EffiProz(www.e...

Increase productivity with Visual Studio extensions

by Ahsan Murshed

This article gives ideas to developers to increase development time productivity using the free Visual Studio 2010 extensions.

Increase update performance of sqlDataAdapter

by Shining Legend

Increase update performance of sqlDataAdapter

Insert Multiples Records to SQL Server Database

by Ricardo_Torres_Torres

Read text file and insert mutiples records in just one SQL Sentence

Introduction to EntityWorker

by Alen Toma

EntityWorker ORM

Know More about SQL Constrains

by Mohammed Nazer

SQL Constrains details and its types

LINQ - GroupBy

by Srinivasu Pemma

This tip provides an easy way of dealing with different types of data sources for LINQ Group By taken from my blog http://www.srinetinfo.com/2012/12/linq-group-by.html

LINQ Tutorial for Beginners

by d.ban

A LINQ tutorial for beginners.

Listing Sheets in an Excel File

by PIEBALDconsult

A simple way to use ADO.NET to get a list of sheets in an Excel file

Load a ComboBox at Runtime

by Tim Corey

Learn how to use a dataset object to load a combobox (or other similar objects) at runtime instead of needing to set anything up at design time.

Managing GridView/DataGrid Control Programmatically in Visual Studio (C#) Web Form

by Raphael Adeniji

Many a times, we need to programmatically manage GridView/DataGrid in Visual Studio web applications and this looks very difficult because we do not know what properties or events of the control to use. It may also be as a result of time constraint.

Microsoft ASP.NET Identity MerlinFramework 2.0

by Marc Leger

Microsoft ASP.NET Identity MerlinFramework

Mocking EF DbContext and DbContextTransaction with Proxy

by MaDOnos

How to mock EF DbContext and DbContextTransaction with Proxy

MS Access (*.mdb) + C#: SELECT, INSERT, DELETE and UPDATE Queries

by Emiliarge

Queries in Microsoft Access (MDB) databases.

Multilevel Nested Gridview in ASP.NET

by Chakravarthi Elchuri

Display data in Multi nested gridview using C# in ASP.NET

MVC Load Stocks Data on Runtime in a Grid View

by Wajahat Aftab

How to load data from live market stock feed in a grid view

MySqlCommand, MySqlParameter and "LIKE" with Percent Symbol

by AlbertoLeon CSharpMan

How to search text with LIKE with MySQLParameter in MySQL .NET / Connector

Nested gridview Edit

by JatinKhimani

Nested GridView With Editing Facility of both gridview.

nKnight - Role Based Access Control(RBAC) Solution for C#.NET

by subhajit bhadury

nKnight - RBAC Solution for C#.NET

Number of different ways to get total number of rows from tables

by Pranay Rana

Getting a SQL Server RowCount Without doing a Table Scan

OLEDB Provider is Not Registered on the Local Machine

by Shemeer NS

Solution for Exception: The 'Microsoft.ACE.OLEDB.12.0' 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine.

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

Parameters - SqlCommand vs. OledbCommand and OdbcCommand

by walterhevedeich

A quick tip on using OledbCommand and OdbcCommand

Pass Parameters from Web Page to Telerik Report

by Thinira

In this tip, we discuss how to pass report parameters from web page to Telerik report programmatically.

Pass Variables From Server to JavaScript after JavaScript is Loaded.

by Marcio_Coelho

This sample demonstrates how to pass data (variables) from code behind to JavaScript.

Passing Object Collections to ASP.NET Web API

by Tom Glick Philadelphia, US

POC to demonstrate passing of collections of complex objects to ASP.NET Web API Controllers.

Passing parameters to Success method in executeQueryAsync in SharePoint

by shahed.sohail

Passing Parameters to Success method in executeQueryAsync.

Perfect Pagination with Repeater Control in ASP.NET C#

by ChienVH

Perfect Pagination with Repeater Control in ASP.NET C#

Persisting Winforms Component to C# Code

by Ying LEE

This article introduces a general and robust way to persist/serialize any Winforms component to C# code.

Plug-in Architecture To Work for Multiple Platforms/Techs

by Reader Man San

Plug-in Architecture To Work in WinForms MVC + WPF MVVM + ASP.NET MVC + Mobile (Xamarin MVC/PhoneGap MVC) + Win 10 Universal App MVC

Possible solutions for an .Net 4 compiler bug that raise an MissingMemberException by acessing the index property of an SqlParameterCollection...

by Peter BCKR

In legacy applications you can get a MissingMemberException bei acessing a SqlParameterCollection if you work with object-variables there are reference a SqlCommand-Instance.

PostgreSQL-ADO.NET Framework

by M.M.Mohseni

The simple sample that shows how to connect the ADO.NET Framework to the PostgreSQL

Preventing SQL Injection in ADO.NET

by K C R

This article is to help beginners understand what is SQL injection and how to prevent it

Probable leak while using SqlDataReader in ADO.NET

by Vinayaka Krishna Shenoy

Probable leak while using SqlDataReader in ADO.NET

by Sabrina Hope

If you want to be sure that every object is closed, I would use this method: while (true){ Thread.Sleep(2000); using (SqlConnection objConnection = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Northwind;Data Source=.;Max Pool Size=1"))...

Pure SQL solution to Database Table Paging

by DrABELL

Portable solution encapsulated in single SQL query allows to select N rows offsetting M records

Querying DataSet With LINQ in ASP.NET

by HemendraSingh88

Hi, here we will see how to query a DataSet with LINQ(Language Integrated Query).

Quickest Way to Create a .NET Database Application

by Subha.N

Tip to create a database application using C# .NET in the shortest time possible.

Save image with printed text on it

by Sonali Agarwal

Create an ASP.NET page where the user can edit/modify text for an image and then save that image with printed text on it.

Selecting Distinct Records Using LINQ

by Eric Shandil

How to get dictinct records from a datatable in .NET.

Set the connection string for Entity Framework at runtime

by Bahram Ettehadieh

This shows how to set or change the connection string for Entity Framework at run time (programmatically)

Set the connection string for Entity Framework at runtime

by RedAquarius

The first instruction in .NET 4 becomes:string connectionString = System.Configuration.ConfigurationManager. AppSettings.Get("ConnectionString");

Set the connection string for Entity Framework at runtime

by member60

One possible way is to do it the following way: How to change the connection string in the EntityFramework? [^].

Setting up SQLite and Entity Framework 6 (Code First and Database First)

by User 10668410

How to get SQLite 1.0.98.1 working with Entity Framework 6.1.3 without a massive headache using the Database First Model and Code First Model.

Sharp RepoGen

by Ashish Tripathi

Sharp RepoGen is a simple tool to create repository interface having methods for CRUD operation and its implementing class. Using this tool easily you can generate your repositry class and interface. Code is generated with the help of xml template, so very easily you may change the template to creat

Simple Client Side Consume ASP.NET Web API Server

by Chinh Vo Wili

Send HTTP GET requests, consume ASP.NET Web API server

SimpleThreading Makes Threading Easy!

by Sharp Ninja

Threading can be a daunting topic. This library takes much of the worry (and mistakes) out of multi-threaded application programming.

SP Beginners Part 1 – Create a Web Application on Farm and Getting It Functioning in Visual Studio

by NikiGrly

Steps to create a web application on your farm.

Split comma separated IDs to get batch of records through Stored Procedure

by Nasser Malik

Split comma separated IDs to get batch of records through Stored Procedure.

SQL Group by With Joins

by Pranay Rana

How to use Group By clause when joining to table Let's consider one scenario where I have two table employees (contains employee detail) and sales (contains infomation about sales done by employee).Structure of...

SQL Import Data from Excel

by pramod.hegde

Excel sheet to SQL DB

SQL Query with C# Typed Library - CooQ

by Guni Van

Mapping your database with C# object class, then make typed-safe query like SQL syntax

SQL Schema Support Multi Version Tables

by Simon Korenfeld

SQL schema with multi version tables support

SQL Server 2008 Error: Saving changes is not permitted

by Prasad CM

How to fix this error.

SQL Server Connection Dialog

by Hernán Hegykozi

Show you how to make a connection dialog developed completely from scratch.

SQL Server FILESTREAM with Nhibernate

by Codeman the Barbarian

In the tip, I go through one approach to integrating SQL Server's FILESTREAM type with Nhibernate.

SQL Server: SQL script to find upcoming birthdays

by prashant0556.s.more

The script helps to find out upcoming birthdays even when days cross a year.

SQL to ADO.NET API (Automated ADO.NET or DB API)

by dmytro.sen

SQL to ADO.NET API (Automated ADO.NET)

SqlServer: Parameterized Query With IN() Clause C#

by DiponRoy

A utility class to send parameters for IN() operator in SQL using parameterized queries

SSRS Reports: Show Data from Non-standard Provider

by Michael Ecklin

SSRS Reports: Show Data from Non-standard Provider

Storing Dataset in a file using Object Serialization

by alrosan

Strategy for Separating UI and Back-end Code Development

by Giancarlo Rhodes

Creating the Web UI

String Interpolation or String Handling in C# 6.0 with New Feature

by idreeskhan

String interpolation or String handling in C# 6.0 with new feature

To Generate XML File from Datatable using LINQ

by puja11191

This tip shows how can we generate and save XML files

Transparent Database Encryption Tool

by Tauseef M

This tool is used for Encryption of Database in SQL Server 2008 Enterprise Edition

Twist in Performance counters for Connection pool settings

by Vinayaka Krishna Shenoy

Twist in Performance counters for Connection pool settings

UkrGuru.SqlJson Your Link Between SQL Server and .NET 5

by Oleksandr Viktor (UkrGuru)

Minimally simple UkrGuru.SqlJson package for modern data manipulation

Understanding Normal Forms of Relationship for database

by Kirill__

How to create databese with forst 3 normal forms of relationship

Update Database using Stored Procedure and DataAdapter

by Naresh Patidar

Insert, update and delete operations using stored procedure and DataAdapter in C#

Use UserControls to substitute the job DataList Server Control does in WebForms

by pramodchand

Using collection of UserControls in WinForm since WinForm does not have a control like DataList server control of WebForm.

User Responsive Web Query Builder using ASP.NET

by Reeshabh Choudhary

Web platform based query builder to play with your database :)

Using Effort - Entity Framework Unit Testing Tool

by Roger C Moore

This tip is a guide for using the Codeplex project Effort for testing Entity Framework applications without requiring the unit tests to actually hit the SQL Server database.

Using Explicit Cast instead of Databinder.Eval to Increase Performance

by Fenil Desai

Increase ASP.NET Application performance with explicit casting

Using Oracle with EntityFramework 4

by wshcdr

ODP.NET EF

Using SQL Bulk Copy with your LINQ-to-Entities datacontext - Part 1

by Måns Tånneryd

This tip shows how to significantly speed up inserts of large amounts of data using the entity framework.

Using SQL bulk copy with your LINQ-to-Entities datacontext - Part 2

by Måns Tånneryd

This tip shows how to speed up inserts using POCO objects and the entity framework version 5.

Using SQLite: An Example of CRUD Operations in C#.NET

by Lộc Nguyễn

With a DEMO WPF application (WinNotif)

Verify Oracle Client Installation

by WernfriedD

Single .exe to verify if your Oracle Client is properly installed and working. Verify supported technologies for Oracle connection.

WCF, Entity Framework, and Data Contracts

by Kumar_Jitendra

Expose an Entity Framework class entity as a data contract.

Web Caching with SqlCacheDependency Simplified

by sazakir

Using SqlCacheDependency with Web caching

Working with LINQ to Entities & LINQ to DataTable

by ShaikAnwar

This topic gives us an idea of how to write Linq queries on Entities & DataTable. This covers some basic querying and also usage of joins and group by using LINQ.

Working with MS Chart

by Chamara Janaka

Article Describes how to Generate a Simple Chart using ASP.NET chart control

Xamarin Forms: Check and Request for Permissions

by Harshit Gindra

Check and request for Permissions in Xamarin Forms mobile application

Yet Another Duplicate File Detector

by kaviteshsingh

Simple utility to scan and find duplicate files in a directory.