We stop a separate server with a SQL Server instance for backups at night
the restart after backups are completed.  The ADO connection on our web
server (Win Svr 2k w/IIS) cannot reconnect to the database server unless the
web machine is rebooted.  We have tried to restart IIS ...

I have a data adapter and trying to connect it to multiple tables. I am
not sure if it is possible and if so, I can't find what I am doing
wrong. I am using HTML controls because the original page was created
with another software, but I changed all the controls to "Run as Server

I have a data adapter and would really like to be able to change the value
of a column on update.  I am using
New System.Data.SqlClient.SqlParameter("@DateModified",
System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input,

Here's a variation on the old chestnut, but I can't get a handle on it.
I have a database that has a many to many relation. Table A has two
columns AID and AName, table B has two columns BID and BName and table
AB has three columns ABID, AID and BID for relating tables A and B.

Hi, I have a doubt I'd like to solve.
We are making an app, in which we use many sql queries in order to
return datatables.
But today someone has told us not to use sql queries, but stored

I was wrong. When the CommandBuilder is hooked to the DataAdapter, the
UPDATE statements generated DO morph from row-to-row. This way only the
changed columns are SET. This is a good feature, but given the other
limitations of the CB, I still can't recommend its use.

I have an asp datagrid where i'd like to display four colums, each one
showing datas coming from a different dataset.
Each dataset has a common PK, so i'd like to make a join on this PK,
and fill a result dataset to bind it to my asp datagrid.

I'm currently working writing a Windows service in C# which needs, among
other things, to interface with Microsoft Great Plains 8.0, specifically to
add General Ledger entries. In order to add a new General Ledger entry to a
Great Plains database, it's necessary to supply a ...

I'm working on upgrading a VB3 app that reads a text file line by line,
and executes inserts or updates to an Access database.  Because of
speed issues, I recently moved from using OleDb objects and an Access
database to a SQL Server database, and using SQLCommands and

I am using ADOX to create an Access table and populate it with one row of
data. The ADOX code sets two columns as primary keys (I can view the table
in Access and see that they are set). When I try to create the UpdateCommand
I get an error that it fails because the Select does ...

Windows Forms Application
Sql Server backend
Controls are bound to a DataSet
I want to restrict the amount of numbers to the right of the decimal a user

I am running a VB.NET app on my desktop with Access 2003 as the DB. The
table I am working with has a PK made up of 2 columns.  I am currently the
only user. I built my own UpdateCommand for the data adapter. The command
uses values for the PK columns in the WHERE clause ad then ...

I can't use DataTable!
I try to write ( in form load):
Dim myDataTable As DataTable = New DataTable("ParentTable")
I then get "Type expected" for the DataTable (in Task List)

I create a script file (.sql) with DTS.
How can I read it into Asp.net and execute it?

Can somebody tell me where can I find in the msdn site info about database
design patterns when working with C# and SQL 2k
Thanks
Jose Luis