Posted inADO.Net
Insert and Update in SQL Using User-Defined Table Type and XML
In this article I show various ways to insert in SQL. Using Datatable Using XML By showing examples of inserts using a Datatable in SQL. Let us Start with C#…
Posted inADO.Net
Working with the SqlTransaction Class in ADO.NET
Introduction: The SqlTransaction class is very important class of .NET Framework. The SqlTransaction class is used for satisfying the ACID property of DBMS (I am not describing ACID property here.).…
SQL Helper for C#.Net
using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.VisualBasic; using System.Collections; using System.Data; using System.Diagnostics; using System.Data.SqlClient; using System.Xml; using System.Configuration; namespace PeshawarDHASW.Helper { class SQLHelper { #region "private…