I have a database with two tables, with a foreign relation between them; the
schema is like this:
Table 1 {A, B, C, D, E}
Table 2 {E, F}

Is there a way to know how many rows have been fetched into dataset
when we are filling huge amount of data. I want to show the progress
status in the ASP.net UI in a  fixed intervals. Please let me know the
best way to do this.

OK, check out this XML representations of my Dataset schema:
<PIAccounting>
   <Transmittal>
       <Transaction>

I have a query to a LDAP directory which is supposed to get a list of records to be displayed in an ASP.NET page
There is not many of them, almost 3 dozen. But the query is rather long, too long for a web page indeed
Is there a way to optimize such queries
Thank

ENV: Windows 2003, Visual Studio.Net 2003, .Net Framework 1.1
We have a rather large application that uses ADO.Net to access a SQL
database.  As the database grows, we are seeing SQLCommand timeouts.  So we
added code to configure the SQLCommand.CommandTimeout property in areas

I am having problems populating a datagrid from a datareader Here is my code
Dim sqlGetTitleName As String = "Select name from product where supplier = '0064'"    '" & SupplierI
       Dim odbcConn As OdbcConnection = New OdbcConnection(Configuration.ConfigurationSettings ...

I have created a small app used to transfer data from MSDE to my own
DB.
I am having some serious problems with SQLDataReader.  I use it to
loop through records in order to build my own "INSERT INTO"

Like the dataset, can I load different tables at different intervals into the same datareader?

I dont have a problem with the required 2 clicks to change a checkbox value, however, on the second click, the value change is not immediately visible. I can see the change only after I select a different cell.
Please advise why this visibility problem  is happening.
thanks

How can I get my combobox to list the very first item? When I populate the combobox from the database I dont see any data until I click on the dropdown arrow.

I have the following in my .config fil
<?xml version="1.0" encoding="utf-8" ?><configuration><appsetting><add key="ConnectString" value=""DSN=progress;UID=;PWD=" /></appsetting></configuration
I have the following code in my applicatio
Dim odbcConn As Odbc.OdbcConnection = New Odbc ...

I have a table with a row set as UniqueIdentifier, RowGuid = Yes, and the
row is set as the primary key, but when I try to use the Data Adapter Wizard
it give me an error that it can't create the Update and Delete command
because it can not determine unique columns in the table.  If ...

I'm currently developing a program and I was using SQL server, but I need to
convert it to Oracle.
This itself is not difficult, but how can I then test my program as I don't
have an Oracle database server on my home PC.

We migrated our web server from a single processor, 1 GB RAM to a
dual-processor blade server with 2 GB RAM and we hit this problem. We did
not make any changes to the pool size i.e. using the default settings.
We had encountered this problem occasionally (1-2 times a month) much

I am using VB.NET to retrieve data from an ACCESS database.  I tried using an
oledb data reader as well as an oledb data adapter to retrieve data from the
tables within this database.  Everything works fine for all tables except one.
I get an oledb exception when i try even a ...