How to populate GridView from code behind? To populate GridView from the code behind using a data source, we can follow this approach.
|
Yes
|
How to check for the existence of record into the database? To check whether a record exists into the database or not, we can follow this approach.
|
Yes
|
How to use transactions in ADO.NET? To guarantee that failing execution of one sql statements in the group of statements rollback
changes made by other successful statements as well, we can use this approach. So in this approach
either all sql statemetns executes successfully or none executes.
|
Yes
|
How to work with multiple results set using and SqlDataReader? To retrieve more than one result sets using Stored Procedure or multiple select statements in one go
using SqlDataReader, we can follow this approach.
|
Yes
|
How to work with multiple results set using DataSet? To retrieve more than one result sets from the Stored Procedure or multiple select statements at
one go using DataSet, we can use this approach.
|
Yes
|
How to retrieve records from SqlDataReader? To retrieve records from the database using SqlDataReader and getting their values by iterating
through them, we can use this approach.
|
Yes
|
How to bind data using SqlDataReader and where to use SqlDataReader? To retrieve data from database using xxxDataReader and bind to the data controls, we can follow
this approach. This also explains in which scenario we should use xxxDataReader.
|
Yes
|
How to retrieve the saved imaged into database and show them on the page? To retrieve and show saved images from the database inside asp:GridView we can follow this
approach.
|
Yes
|
How to save the Image into the database using Stored Procedure? To save the image into the database (using stored procedure), we can follow this approach.
|
Yes
|
How to use the stored procedure in ADO.NET? To use stroed procedure to retrieve records from the database, we can follow this approach.
|
Yes
|
How to delete a record from the database? To delete a selected record fromt the database, we can follow this approach.
|
Yes
|
How to update record into the database? To retrieve selected record and update record into the databse, we can follow this approach.
|
Yes
|
How to insert records into the database? To connect to the database and insert records into the database, we can follow this approach.
|
Yes
|
How to retrieve data from the database? To connect to the database and retrieve records, we can follow this approach.
|
Yes
|
How to create a custom section in the web.config file and retrieve its value? To create a custom section in web.config file to store some data and retrieve those data, we can
follow this approach.
|
Yes
|
How to encrypt .config appSettings and connectionStrings values for security reason? To encrypt the appSettings or connectionStrings of the web.config, we can follow this approach.
|
Yes
|
How to write & retrieve appSettings and connectionStrings settings from web.config file? To save and retrieve the appSettings and connectionStrings in the web.config file we can follow this
approach.
|
Yes
|
How to log application level error and redirect the user to error page? To log application level error and redirect the user to a generic error page, we can follow this
approach.
|
Yes
|
How to log errors in system event? To log errors in the system event, we can follow this approach.
|
Yes
|
How to log errors in Log file (one log file per day)? To log errors in the log file we can use this approach.
|
Yes
|