I'm creating a component that contains a function. This function is to return
a data set of state values (AL,IL,TN,CA,...). I'm new to dataadapters this is
my first, but something just doesn't seem right.
the function return a dataset, but do it need to define a dataset in the

Has anyone done this yet?  I know it is easily done in Paradox, but I would
like to do it in VB.Net.
Can anyone point me in the right direction?
Thanks,

I install Crystal Reports 8, and some  permissions for the registry subkeys and their lower-level subkeys are modified. I used a Crystal restoration utility, and everything come back fine again, all except for the OLEDB connections using Microsoft.Jet.OLEDB.4.0
provider, I can't ...

Keyvalue :AETHAE
Keyvalue : AETH
 The problem is that I am using the Datatable .select method and
Filter expression is %AE%.This Pattern is searchs only mid string not

How can I toggle case-sensitivity within a stored procedure? I'd like to
compare 2 passed in parameters against fields in a table. The first
comparison is case-sensitive, the second is not.
How can I do that? By default it seems they're not case-sensitive.

How can I know which row is currently being editing when I have some
controls bound to a DataSet.DataTable in order to call the EndEdit method
prior to update data to the database?
Is there any CurrentRecord indexer?

Maybe there's something I'm doing wrong here. I'm open to any
suggestions.
I'll see if I can explain this clearly...
I have a C# application that runs 24x7 collecting data from some

We've moved a database from one SQL server to another using a backup
and restore, we had some problems because the location was slightly
different when we moved the database, then we had to create all the
users again.

Correct me if I'm wrong, but once I have my data returned from a stored
procedure, in a dataset and displayed in a DataGrid (ASP.Net)...I can filter
the data correct, without making a return trip to the server?
Anyone have an example of how this works?

After a dataset has been populated, it no longer reflects changes in
database. It is the shortcoming I found in ADO.NET. In ADO, we have dynamic
recordset, keyset recordset which can reflect the changes to database done by
other users immediately. Why can't I find these useful ...

The following valid XSD schema can NOT be successfully read by the
ReadXMLSchema method of the DataSet object - it errors out with a
"NonEmptyString not defined" error.  This schema is more complex than a
plain vanilla schema, but doesn't strike me as obscenely complex.

Working with a Microsoft Access database, what is the best way to get
the name of the primary key field? I know the table name.

Why and how is this property used?
Documentation says it is number of rows changed, inserted, deleted and
can only be used after the DataReader is closed. I thought the
DataReader was for forward read only access...so how can there be rows

I am building an App that takes an Excel file and populates 3 DataTable's in
a Dataset.  I then was to create a relationship between these 3 DataTables.
After doing so I want to run some code to process / modify the data in the
tables and then return the result back into an Excel ...

   Is there an easier \ shorter way of doing this?
       If txtreason.Text = "" Then
           NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value
= vbNull