Select TOP 5 * from SomeTable, using Dataview.RowFilter?
I need to select 5 most recent rows from cached Dataview object, is there any way to do that?
ado.net
Oracle & Pagination
I have a oracle table with record count of 99896618.
Managing Entity Framework ObjectContext in ASP.NET
I’m using the Entity Framework for an ASP.NET Web Forms application and I’m wondering how I should deal with ObjectContext and it’s lifetime.
For example, I have an InviteService class that manages invites such as creating and accepting invites. The class itself is in another project/namespace from the Web project.
An InviteUsers() method creates Invite entities for a list of users, calls a repository to save them to the database and mails each user an invite link.
If ObjectDataSource isn’t the answer for a large application, what is?
Quoting the answer of Andrew Hare on the This Question.
How to insert value into primary key identity column in SQL through C#?
(My problem solved. As almost everyone said I had to remove @OB_ID and left it to SQL to assign value.)
Error: Time-out interval must be less than 2^32-2. Parameter name: dueTm
I have a one-to-many relationship within my class model.
Writing DataReader Rows to Excel File
I’ve got data in SQL Server 2000 and have a HyperLink that goes to a pass-through form whose code-behind will output the data to an Excel file. I’ve been following this tutorial:
Stored procedure OUTPUT VARCHAR2 value truncated using 12c client
I am using oracle 11g. My stored procedure is returning varchar2 but its value is being truncated by oracle client.
Below is my code :
DateTime issue in SQL Server
I’m trying to do an INSERT into an already set DB in MS SQL Server, the DB server is in a shared hosting (godaddy).
data insert using input output stored procedure
I am creating a web application using ASP.net C#. I have a booking form and I need to insert data into a table using a Stored Procedure. The table has several columns, out of which second column is a computed column. The Stored Procedure is set up to insert the data and fetch the value from the second column after insert. Below is the code for Stored Procedure: