In this article we will discuss about to bind a grid using disconnected data access model SqlDataAdapter and DataSet in ASP.Net c#. We are creating instance of SqlDataAdapter by passing sqlconnectiontext and Connection object and create instance for DataSet then fill the dataset with data.
In this article we will discuss, How to retrieving two or more result sets using SqlDataReader object’s NextResult() method in ASP.Net c#. To retrieve the second result-set from SqlDataReader object using the NextResult() .
In this article we will discuss, How to calculate discount price at runtime binding on gridview using Read() method, which returns true there are rows to read. If there are no more rows to read then it will return false.
In this article we will discuss, How to calling a store procedure with output parameters in ASP.Net c#. Write a store procedure with output parameter for employeeId with based on the employee table. The main thing is that to set EmployeeId marked as identity column.
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.
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.
SQL injection is a malicious code some user might inject SQL commands through strings for execution. It seems to very dangerous to the security of application.
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().
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().
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.