I have a table that's as follows.
         Report Table
ReportAN bigint (autonumber),
ClientId int,

Is there a list of acceptable RowFilter syntax somewhere?  Or is T-SQL
syntax generally accepted?  (I couldn't find anything on MSDN.)
Many thanks,
Marty

I have a database with quite a few tables in it.
Is it good practice to use a different DataAdapter
for each and every table i want to use in my
application? Or should I use a single DataAdapter

Using a lengthy stored procedure that has 2 temp tables, one of which is the table that the final SELECT is performed against to return the SP result response.  The stored procedure works fine in query analyzer, odbc call, or thru other connection/client like Crystal Report ...

I am retrieving a dataset with over 100 records and can vary based on user
in which it can get even larger.  I am displaying the dataset in a datagrid.
I was looking for reccomendations on how to breakup the dataset because I do
not want to show 100 records in a datagrid.  I was ...

I am not quite familiar with how to handle a opened cursor from the store
procedure using SqlParameter class, how should I define the parameters. And
any special techniques?
My store procedure:

Is there a managed library for using sql dmo or must I use sql dmo com
object and interop?
Bernie Yaeger

i use asp.net and i have a general class that manages database access using
ado.net and sqlclient provider.
this class upon deconstructor closes connection to DB.
it appears on sql 2000 manager when i look in management/current

I'm trying to let my users dynamically filter records from a table that
relate to other tables.
RELATIONSHIPS:
[CustomersTable].[CustomerID] = [OrdersTable].[CustomerID]

i have oledb connection with this string
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Downloads\sase2.xls;Extended Properties="Excel
8.0;HDR=Yes;IMEX=1"" and work fine with normal *.xls file but when file is

Is there an equivalent to CurrencyManager when I'm using a datagrid-dataview
in an asp.net webform??  I need to know exactly which record is selected
when my datagrid(view) is sorted, filtered etc.
Thanks,

I have an app with various pages running a DataReader in the Page _Load event pulling data from a database and filling text boxes.
But of coruse, if a column in the DB is blank, then the application fails and says it 'Invalid attempt to read when no data is present.'
I've tried, ...

I have created a SQLServerCE database table with 22 fields, I have a
parameterised INSERT Query, that looks something like this
CDisplay.CommandText = "INSERT INTO CDisplay ( " &
_"Status,LstTiPNo,CC,LastVisitDate

The update that gets generated with adapters always include all the
columns. That means that with each record update, all the columns get
updated as well. This presents a bit of a problem as I have some
triggers going on changes on specific fields. Is there way to instruct

I am working on a project in VB.Net which mostly deals with ADO.Net..
The tool I am working is an Import & Export Tool..It transfers data from any platform to any other i.e from Oracle to SQL Server or viceversa and Oracle to Access or viceversa and also textfiles..
So, I generate ...