OLEDB Connection string

The C# OleDbConnection instance takes Connection String as argument and pass the value to the Constructor statement. An instance of the C# OleDbConnection class is supported the OLEDB Data Provider . connetionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=yourdatabasename.mdb;"; cnn = new OleDbConnection(connetionString); ...

Read More

C# ADO.NET SqlCommand - ExecuteScalar

The ExecuteScalar() in C# SqlCommand Object is using for retrieve a single value from Database after the execution of the SQL Statement. The ExecuteScalar() executes SQL statements as well as Stored Procedure and returned a scalar value on first column of first row in the returned Result Set. Command.ExecuteScalar(); The ExecuteNonQuery() performs...

Read More

C# ADO.NET SqlCommand - ExecuteNonQuery

The ExecuteNonQuery() is one of the most frequently used method in SqlCommand Object, and is used for executing statements that do not return result sets (ie. statements like insert data , update data etc.) . Command.ExecuteNonQuery(); The ExecuteNonQuery() performs Data Definition tasks as well as Data Manipulation tasks also. The Data...

Read More

C# ADO.NET SqlDataReader

SqlDataReader Object provides a connection oriented data access to the SQL Server data Sources from C# applications. ExecuteReader() in the SqlCommand Object sends the SQL statements to the SqlConnection Object and populate a SqlDataReader Object based on the SQL statement or Stored Procedures. SqlDataReader sqlReader = sqlCmd.ExecuteReader(); When the ExecuteReader method in the SqlCommand...

Read More

C# ADO.NET SqlDataAdapter

SqlDataAdapter Class is a part of the C# ADO.NET Data Provider and it resides in the System.Data.SqlClient namespace. SqlDataAdapter provides the communication between the Dataset and the SQL database. We can use SqlDataAdapter Object in combination with Dataset Object. DataAdapter provides this combination by mapping Fill method, which changes the data in the DataSet to match the data in the data...

Read More

get the sql server version

 We can get the sql server version by using this query : DECLARE @ver nvarchar(128); SET @ver = CAST(serverproperty('ProductVersion') AS nvarchar); SET @ver = SUBSTRING(@ver, 1, CHARINDEX('.', @ver) - 1) IF ( @ver = '7' )    SELECT 'SQL Server 7' ELSE IF ( @ver = '8' )    SELECT 'SQL Server 2000' ELSE IF ( @ver = '9' )    SELECT 'SQL Server 2005' ELSE IF ( @ver...

Read More