I am using the data access application block running on Windows server 2003 and accessing SQL 2000 database (on the same box).  I have some very simple code that is getting executed from a asp.net page.  The code is calling executeNonQuery in a loop 30 times.  I notice that after ...

Hello all;
I'd like a button on my webpage that will enable the user to create a
connection string via the Data Links dialog box that we all use at design
time.  I found this code on CodeProject:

I am trying to write a routine to determine if my database contents have
changed.  Currently this is what I do:
 * Fill dataSet1 from the database and WriteXml to a file
 * perform operations that may change the database

I have a scenario in my C#.NET application in which I have to open an ODBC connection to a DB2 database residing on AS/400. The connection needs to be kept open 24/7. I have a simple stored procedure on AS/400 which declares a simple cursor for a simple select statement and opens ...

I recently came accross a vary strange situation. I created a UDF in
SQL Server 200 as:
CREATE FUNCTION dbo.CheckWeekend
(@sDate datetime)

I've looked throughout the documentation for an exception enumeration, either by name or by number.  I've come across several examples indicating there must be a list available.  Somehow I'm missing it.  Can some generous soul direct me to it?  Thanks
polynomial5
Here are some ...

Using 2 servers, CBCDOMAIN Win2003 server, and BAANSRV1 Win2000 server
- user are authenticate trough CBCDOMAIN
- SQL server is running on BAANSRV1 database baandb (Windows and SQL authentication
My trouble is, It seam I can not figure out how to have the right syntax using the ...

This code failed miserably. And the error shows on the  ConnectionT.open()
ans say exception occured in system.oldbb.  .......
any help please
Dim ConnectionStringT As String =

I wish to use a jet data base with an autoincrement field. How do you update
the database with the new rows added to the dataset and get the new
autoincrement number allocated by the db without refreshing the whole
dataset?

Hi people, there is a way to make searches on active directory thru
ADO.NET?, so the result is an DataSet object and not a DirectoryENtry object
thanks

Hello...
I have two columns in a datatable. column calcCol1 and Col1. When I loop through the records to copy data from the computed column to the original column it gives an error saying that there is no data. (although I know there is).
I loop as follows
dim dr as datarow

I have a Datagrid bound to a dataset.
The Grid uses a DataGridTextBoxColumn style.
If I click on a cell, then enter a single character,then
click in a cell above or below it, the character I typed

I have the following code which reads XML files and merges them in to one
dataset.  Some of the files have duplicate data, my question is what is the
best way to remove the duplicate records after the records are merged or how
to prevent them from merging in a first place?

  I wanna save changes made to dataset liker adding a datarow by dr=ds.tables(0).newrow and then setting thev value for each column of the table. But I couldn't save those to dataset and eventually to Original database (Like SQL,Excel etc.
Please help

I would like to retrive a value from database, and increment it by 1
and update it back to the database
do I need to lock the table explictly??
thx