Problem I am trying to create a Data Access Layer using ADO.Net. I have created a generic method for ExecuteNonQuery. […]
Tag: ado.net
ADO.NET DAO Layer Design With Base DAO
Problem I have a database with a number of stored procedures. These stored procedures provide the basic CRUD operations against […]
Merge two DataTables by adding corresponding entries
Problem I’ve been looking over internet for a method of combining 2 datatables with exactly the same cells with numbers […]
Using model view presenter (MVP) in C# code
Problem I’m a beginner to Model-View-Presenter pattern and I’m finding a way to use it in a sample application In […]
C# function to execute queries in a SQL Server database [closed]
Problem Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add […]
Handle IDisposable objects
Problem When I work a lot with objects, that implements IDisposable I am using this pattern, like shown here with […]
Transform DataReader to List using reflections
Problem I have implemented the code to convert datareader to list of objects. My intention was to not to use […]
Database connection approach
Problem We have recently started working in ASP.NET and starting a simple CRUD Web application in ASP.Net. Here is the […]
Multiple SQL statements in a single transaction
Problem Using the following query I’m doing transactions with two tables BEGIN TRANSACTION UPDATE SalaryTrans SET carried_forward_amount = @carriedForwardAmount, net_wage=@netWage, […]
Interacting with a database
Problem I’ve written my first class to interact with a database. I was hoping I could get some feedback on […]
- 1
- 2