Hello Group,
being relatively new to ADO.NET (and using whidbey nonetheless)
seemingly strange things continue to happen in my app. Most of them are
dealt with by reading more about .net, but this one keeps bugging me.

I would like to retrieve MS-Access database tables, columns and
relationships dynamically from .NET. However I could not find any
article/help material to do that. Could any one help me in this regard?

this is a nice site, how can i put a graphic in the URL like this site?
http://www.windowsformsdatagridhelp.com/default.aspx?ID=886bba68-8a2f-4b99-8f66-
7139b8970071

Using vb.net for code behind on a asp.net application.
I need to run a number of sqlcommands, based on user input.  The commands
need to run as a single transaction.  The commands are all stored procedures.
How do I do this?  I was thinking that I could build an array of the

I created a dataset that contains several datatables. I'd like to know how
to query data from these tables, like table join in sql?
thanks in advance

I am built a massive set of if/else if statement to examine different
OleDbType types. I would like to make this into a switch, but that
only seems to work on Int and String. What is a better way to do this?
Thanks.

Here's what should probably be a a simple DataSet question
I have queried a dataset from databaseA and now I want to insert its
contents into databaseB.  If I do a DataAdapter.Update(), it only stores rows
added since it was queried from databaseA - which is understandable as it

I've bound a Datagrid to a Dataset, which works OK, however the update
isn't working correctly, I think the problem may be that
I am using a DataAdapter generated with a wizard with stored procedures
to select and update.

I am trying to get Data from ODBC into a Datagrid.
This is the very simple code i am using:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

I have the following code:
private int buildetcsforacctperiod(int iAcctPeriod, string szSEMS_User_ID)
{
  SqlDataReader Reader;

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred
in system.data.dll
Additional information: System error.

I am trying to write code to allow my users to upload a file. The code I am
using is as follows:
Dim upfilename As String = ""
If fileDetails.Value <> "" AndAlso fileDetails.PostedFile.ContentLength > 0

I am a csv file into a typed datset using the OLEDB provider. However
when the file is read into the dataset via the dataadapter fill method
my field lose there leading zeroes.
I have set the columns in the typed dataset to strings to avoid a

I have two tables of scores of student:
The Fields of the two table like:
Table1:StID,  Math, Nature
Table2: StID, GradeID, Math, Nature

i have a web.config file that specifies the connection string for my
database.  the database server on the ISP is using a different port than
1433.  how do i specify in the connection string to use a specific port
number?