Latest posts on "ADO-NET"

How to prevent sql injection using store procedure in ASP.Net c#?

5 May 2016

In this article we will discuss, How to prevent sql injection using parameterized query in ASP.Net c#. Write a store procedure, that returns the list of products. That store procedure takes input parameter as @name.

How to prevent sql injection using parameterized query in ASP.Net c#?

5 May 2016

In this article we will discuss, How to prevent sql injection using parameterized query in ASP.Net c#. In order to prevent sql injection attack, query that uses parameter @name. The value for the parameter is provided using AddwithValue() method.

How to use ExecuteNonQuery() method in ASP.Net c#?

5 May 2016

In this article we will discuss, how to use ExecuteNonQuery () method in ASP.Net c#. When we want to perform insert, update or delete by using ExecuteNonQuery().

How to use ExecuteReader() method in ASP.Net c#?

5 May 2016

In this article we will discuss, how to use ExecuteReader() method in ASP.Net c#. When we want to return more than a single value by using ExecuteReader().

How to use ExecuteScalar() method in ASP.Net c#?

5 May 2016

In this article we will discuss, how to use ExecuteScalar () method in ASP.Net c#. when we want o return a single value by using ExecuteScalar () method.

How to connect ADO.NET code to SQL Server Database and retrieve data?

4 May 2016

In this article we will discuss, to connect ADO.NET code to SQL Server Database and retrieve data. We are using SQLConnection,SQLCommand and SQLDataReader classes are present in System.Data.SqlClient namespace. System.Data.SqlClient is also called as .Net data provider.

Page 2 of 2