I've been following the "Re: DataReader is connected?" thread with interest.
A thought occurred to me... And I would like to hear what others think about
it.
Best practice: Open connections as late as you can, close them as soon as

When I use the following code in VB.NET :
Public Function test() As String
       Try
           Dim da1 As OdbcDataAdapter

I am loading an Access table using an OleDbDataAdapter and calling the
Fill method on a datatable. Then I display the records using a dataview
and apply some filters.
If I want to reload the datatable by calling OleDbDataAdapter.Fill on

What are the system requirements for the ASP.NET version?
- Web Server
- Database
Thanks,Carl

I'm looking for an event which is fired before the current row changes.
Similar to the CM.PositionChange event but right before it actually changes.
I thought I could use the RowChanging event of the DataTable but this only
gets fired if the row changed.

in my application I add personal information about customers to a database
by sending a SQL string. Now, sometimes there are customers with names that
contain an apostrophe (like D'Artienne, etc.). Now, when I create a SQL
string with such an apostrophe it gets malformatted (like ...

I am trying to run cmd.ExecuteNonQuery() in order to perform an update and
even though the database is updated OK I keep getting the following error
message:
"SQL Web Assistant: Web task not found. Verify the name of the task for

Is there a SQL Server best practices document/site out there? I went to MS's
Sql Server area and couldn't find one. I found good tech articles, etc. but
not best practices and I know one exists.
I.e. I am working on a project where the current DB developer created a

My app running under iis was experiencing crashes when I started using
ODP.NET 9.2.0.4.01, with the Oracle client 9.2.0.1.0 to replace legacy
ADO calls. (I also tried with the new 10 client and ODP.NET 10 with
the same behavior). After a couple of weeks of painfully unfruitfull

We have a table "Table1" in a database "DB1". There is one more table
"Table2" in different Dataabse "DB2". Table1 and Table2 have same
schema(Structure). From Table1 I want to transfer all  the records
(Which may be 3-5 millions) to Table2.

I'm developing a supermarket application using VB.NET.  I have a situation
where there are two tables namely Categories and SubCategories.
I have a form which has a combo box which lists the Categories present in
the Categories Table.  I have a textbox where the user enters the data ...

web.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<!-- application specific settings -->

how to set cursor in datagridview on new created row.
Source:
private void btnAdd_Click(object sender, EventArgs e)
{

Adding a distinct row filter or select
"SELECT * FROM Records INNER JOIN OtherTable..." is the select and DS is
filled with a da
Dim DR() As DataRow = DS.Tables(0).Select("Distinct Count(RecordID)")

I am writing a program in VB NET and accesiing an Access 2003 database.  I
have an ID field in my table that is AutoNumber.  In my code, I use and
autogen statement to automatically generate the INSERT, UPDATE, and DELETE
SQL, but when the program runs, it never adds the ID field ...