I want to start using databinding in a new winforms application.  I am using
VB.Net 2003.  The database has several fields that contain a numeric code
that translates to a text status.  For example 1=Open, 2=Closed, etc.  
I would like to bind this field to a dropdown combo box.  ...

I'm running a process which takes records from an XML file and inserts
them one at a time into a database table. I'm using an SqlTransaction
to commit after each record is inserted but it doesn't seem to work. (I
need to commit each time because I sleep the thread after inserting 10

I am working on an SQL Server client for .NET and I have created a simple
recordlist class that accepts a table or row-returning sql command on
construction and provides a list view of the resultant query.
It would be good if i could create a relationship-aware version of the

It might be a very basic question, but I don't the answer. Please clear my
boubt.
From the client system when we execute "select * from Employee" where does
the execution takes place.

Is there a way to navigate through the rows of a dataset without having to
bind to a control? (at a guess, something like .Current +1)
Thanks for any ideas
Ant

I just heard from the Microsoft development team that the DisplayExpression property is supposed to be marked as "obsolete". It's not enabled (or only partially so) in the 2.0 Framework. (This is in response to a question asked quite some time ago). I wanted to get this into ...

I have this page however the sqlclient is not defined, i thought you just
had to put
Imports system
Imports System.Data

There are several ways of updating a database through ADO.Net 2.
In my case, I'm interested in using queries to update my Access data.
I'm not sure what all the pros and cons are for each method.
Below I've listed what I know, I'd welcome some discussion. And some

I want to ask how to connect a vb.net window client application to a remote
MS Access databae which is located on a server?
How to set the connection string in order to do so?
Thank you

Hi all...
I have a typed dataset that corresponds to a SQL Server database model.
I have in a table a datetime column that cannot be null, but it has a
default value of getdate().

Using the Visual Studio designer, I can easily create a typed dataset. It is
possible to set default values for table columns by setting the default in
the designer.  I can do this easily for boolean and integer types, but if I
have a string field and I want to set the default to ...

I have an oracle function that looks like this:
AuthenticateUser(UserName IN VARCHAR2, pPassword IN VARCHAR2, AppName IN
 VARCHAR2) RETURN VARCHAR2
Using the Oracle client provider, I'm setting up my command text as:

I'm currently using the following code to count non-deleted rows in a
DataTable. Is there another more efficient method?
int count = (int)myDataSet.myDataTable.Computer("Count(columnId)","");
// The following will also count the deleted rows

Several of you were helpful in disuading me from using Jet in a prior post.
I'm developing an application that needs a "person manager" attached to it,
with typical interfaces like "add person" "edit person" "get list of people"
plus some custom items.

Dear Group,
I have a heirarchical set of database tables, say - "order" and "order_type"
and want to display a series of orders in a grid control, and in place of
the order_type foreign key identifier, I would like a dropdown combo box