I have been tasked to convert the methods in a data access class from
returning an open OdbcDataReader to a DataTable. I use the standard
type of code, like:
adapter = new OdbcDataAdapter();

I am using C# to write a windows app that uses a MS Access DB.  I have a
query saved in Access (stored procedure) that has some parameters:
SELECT *
FROM Loans

We have a series of list pages on our ASP.NET 3.5 website for
displaying various searchable lists from our SQL 2008 database. The
master page for these pages has a message box for us to display
messages from the SQL stored procedures, and this works fine when we

Hi together,
I have a DataTableAdapter with different configured insert and update
commands.
Now I have to fire some of theses inside an transaction. For this I must

I am using visual studio with .Net and I am trying to import a text file into
a table
I have a date in this file ie
01012002

I want that a certain client access to the database would block any other
client access until another access of this specific client would unblock the
other clients.
Is that possible?

for working with more then one DB.
thanks!!

I'm developing an ASP.NET site and need a couple of queries to create
various content. As it stands, I'm running each query separately, reading
the result into a SqlDataReader.
It occurs to me that one thing that consumes a fair amount of time is the

I have traditionally developed winform db apps using typed datasets with
bound controls. With progress in ADO.NET am I able to use another technique
which is more suitable in the long run?
Thanks

After doing a bunch of work with ASP.NET and SQL Server, I'm now starting to
work with C#.NET Windows Forms applications.
So far, the database stuff doesn't seem that impressive to me. We'll see.
I've got a details view setup on a form. It wasn't too much trouble. But I

We are trying to migrate to Linq to Entity for managing access to an SQL
Database. We are experiencing problems when dealing with an EDMX model
containing a lot of entities and relations between entities. Everything
works fine when we add 50 entities to the model, with an average ...

I want to update an entity without loading the entity from the database first.
I've accomplished this but only by knowing all of the entities properties
and then using the "attachto" method.
My issues is i don't want my app to need to remember all of the properties.

Is the entity framework anything that can be used in serious database
winfrom applications now? I am just not clear on that. Would appreciate some
comments on where to place EF.
Thanks

I trying to connect remote sql server from my machine. but
it giving me some errors
Here are few errors listed,
An error has occurred while establishing a connection to the server.

Our department is currenly testing a web application that utilizes the
Entity Framework.  After installing the application on IIS it works as
expected with one user but as soon as 2 people start working the same
application with different login information the following error ...