XP - vs 2002 - vb 2002 - win forms
Anyplace I can look at an example of how to extract the following from an
access mdb
Table name

Am I correct that you can not create a DataView that has arbitrary
"pointer rows" referencing the underlying DataTable? Seems like an
oversight but maybe I am just dense.
I have a situation where RowFilter does not provide sufficient

We know SQL connection lifetime is 60 seconds for idle connections.
If I set the lifetime of my ADO.NET connection object to 500 seconds.
And the connection sits idle in the pool for say 150 seconds. Will SQL
shuts down its side of the connection?

It's gone .. or atleast I can't find it ... any explanations?
- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

I have this question:
Where Enterprise Services (ES) can offer secure model (at a cost of
added comlexity) can one this achieve this purely using ADO.NET?
if no, how does this one simulate the Role Based Security if we dont

This should be simple but I can't seem to find how to do it...
I have created a data form using the data wizard within VB.Net and now I
have added a new record.
What I want to do now is return the ID which is an AutoNumber (or

I have a Windows Form application that is calling a stored procedure to
insert a record into a SQL Server 2000 database table.  I am using a
SqlConnection/SqlCommand object pair. When I execute the procedure from C#
code I get an exception with the message, "Line 1: Incorrect ...

I am accesing an SQL Server through a stored procedure which (this stored
procedure) accesses a linked-server (an access database).
Fom Win2000/XP PCs I am having no problems.
From 98 PCs I am having SqlException: Could not create an instance of OLE DB

I have a sortable readonly datagrid bound to a strongly typed dataset parent
table which has an associated child table via a relationship. I can get the
selected datatable row via the BindingManagerBase. I then want to launch a
new windows form and display the columns of the ...

I have a sortable single-select read-only datagrid displaying the master list.
Therefore to get the selected item to edit in another windows form, I obtain
the required master DataRow from the Row property of the cast of
myCurrencyManager.Current to a DataRowView.

If I want to use two fields in the RowFillter,
like under code ?
view.RowFillter="ID='"+xxStr+"' "+"Country='"+xxxStr+"' "

Hi, i've made a connection with an informix database and now I want to
pass a parameter via a textbox to get the right values of the database
in a datagrid. When I enter an integer, I get the desired values, but
when I enter a string, I get no value at all. I don't know exactly why

When I attempt to create a new data connection through the Server Exporer,
I'm asked select or enter a server name.  When I click on the drop down I
get "Error enumerating data servers".  I've got SQL Server and InterBase
both running on this machine.  Any ideas on why I'm having ...

Can anyone offer any advice on migrating data programatically from Acces to
SQL Server? I want the datatypes in the SQL Server version of the data to
reflect SQL Server types such as using Varchar instead of NVarchar. Is this
possible without using the Enterprise Manager?

Did I do something wrong, or there is no AdventureWorks database in this
CTP?
BTW - I did go to advanced and select it - but it just ain't there. :-/
- Sahil Malik [MVP]