I have a C# application that uses a SQL server database. I am ready to roll
out an update, but this update needs some additional fields and changed
default values for some tables together.
With Access and DAO this was easy to do because you had direct access to

I am using the Microsoft Data Access Application Block for .NET v2 to run
stored procedures with the  ExecuteDataset, ExecuteScaler and ExecuteReader
functions. Some of my stored procedures take longer than 30 seconds to run
and I am getting time out errors  in my application.

I would like to use a dataset as a data file (like a database). However, I
didn't find a way to use SQL on the Dataset (except on a DataView, but then
Dataset is all loaded.). I also noted that I must flush the whole dataset to
disk and load it all to read it. I wonder, if there is ...

I'm porting some Java code that uses JDBC to C#.  One of the methods
allows you to start at a relative position in a result set and return n
rows.  Here's some of that code:
Collection LoadResults(ResultSet rs, int start, int rows) {

In ADO.Net, how might one determine whether a column in an Access table is an
AutoNumber type?
Could this be accomplished using OleDbSchemaGuid.   If so could you give an
example.

I've got a dataset with with 2 datatables in it.  We'll call them the Objects
table and the Assignments table.  The primary keys for both tables are
autoincrement fields.  I need to write a record to the Objects table, then
write another record to the Assignments table that has a ...

I have this code in a test program I am playing with, but I receive an object
reference error when I click the Update, Add, or Delete buttons:
Declarations:
' Open a database connection.

I have written a class to handle my sql server connections.  I am not
sure that I am taking the best approach, however I am running into a
specific problem.  In a console app that I am developing, i create a
new instance of the class and then call a method that executes a stored

This insert does not work and i don't know why. I get the following error
System.Data.OleDb.OleDbException: Operation must use an updateable query.
on the cmdInsert.ExecuteNonQuery()
I'm sure it's going to be simple

Hi;
If I do a IDbConnection.BeginTransaction(), will that transaction be used
when I call SqlDataAdapter.Fill() if I use the same connection?

This is a newbie question. Why do we typically open a ADO.NET connection,
run a ExecuteNonQuery and close it  for every DML statement ? Is it not
possible for an application to open the database connection once at start of
application, use that connection throughout that instance of ...

I have DataTable and I perform Rows->AddRow on it. New record is created
and it is visible in datagridview. But how to make new record as focused one
after below operation.
DataRow^ dataRow;

I'm on .NET framework 1.1 with .NET framework SP1. My OS is Windows XP with
SP2.
I have the RowFilter property of the DataView set to...
"[column_one] <= 2 AND [column_two] >= 4"

When I try to display a SQL Timestamp type in a datagrid I get the
following output: System.Byte[]
Is there any way to show the timestamp that the Timestamp type holds?
Cheers,

Is it possible to select rows from a table where a string
starts with certain characters?
i.e. myTable.Select ("Column1='a*'", ...
Many thanks.