My goal with the question is to make sure I'm not doing
this the hardest way possible.  I have a dataAdapter (da1)
which I create in the formload event and I have 2 source
tables (tbl1 and tbl2) from a sql server which I join in

This code produces the "Could not find Installable ISAM" error message.
Anybody have any suggestions?
strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strFilePath

Is it possible to read data from one database table into a dataset,
apply a sort of mapping scheme to the dataset and update two other
database tables with the data from the source table?
If yes, how can this be achieved?

I have attached the java script code to Button web control as follows.
myButton.Attributes.Add("OnClick", "OpenWindow()")
I have written java script to open the window in the OpenWindow function.
When I click on the myButon, one more window will open and at the sametime

I have been using a HashTable to store name/value pairs, but now I
need to add a third element (name/value/flag).  I still need to be
able to index by ["Name"], and I'd like to keep lookup speed as high
as possible.

When I use the ExecuteScalar and the sql looks like this "Insert ...; Select
SCOPE_IDENTITY()" I get the return value as decimal - how can I cast it so
it will return an integer? I use .net c#
Thanks

I'm having a problem that I'm hoping someone can help me with.  To start, I
have to mention a couple of limitations I'm working with:
1) My organization uses an in-house framework to handle database
connections, calling stored procs etc..  To call a stored proc, I use

I am using VB.NET and SQL Server 2000.
I Created a small stored procedure that returns a string value:
CREATE PROCEDURE sp_GetEmployee
@EmpNo int

I am writting an application in VB.Net, as part of programming I realize that depending on what database I connect to Access, SQL Server or Oracle, I have to use a different SQL Query Syntax... and include different type of database libraries in my code
In phase one we want to ...

I'd like to be able to iterate throught the rows of a dataview but only 2
particular cols. of the dataview - col1 & col.4, to populate an array with
the values for the particular columns for all the rows in the dataview.  My
problem is that I don't know how to access the particular ...

Let's say I first fill a DataTable in a DataSet by using some
SQL command
"SELECT * FROM SomeTable"
Now I have another database,

Find method can search a row according to tables PrimaryKey, my question
here is, if the primary key contains multiple fields (columns) with
different data types. how should I use Find method in this case?
Thanks!

I have a simple stored procedure that returns a REF CURSOR. The query
retrieves 190 rows from the database (see query below). Following the
example laid out in the web page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cp
contheadonetdatareader.asp

Is there anything in ADO.NET that is equivalent to the old ADO GetString?
This would return a record/recordset as a string.
Thanks.
Tom

With IDENTITY(1,1) I can create an AutoIncrement Column.
I however need a column with a uniqueidentifier that is created whenever a
new datarow is created.
This is possible with access, but how can I create such a column via SQL?