I have a Windows application that uses Crystal Reports 9 (bundled Version)
developed using VS.NET 2003 on a windows server 2003 m/c.
The application has to be deployed on the client machine that has Windows
XP installed. Before deploying we make sure that .NET framework 1.1 is

H
Is there an easy way of performing the "SELECT Count(columnname), columnname from tablename" database command on a disconnected DataSet to enable me to display a chart of numbers of distinct values, which will vary, in a Windows form
Many thank
djm

H
Does anyone know how to pass back the specific database error number from a SQL Server stored procedure, or else how the exception can beused to get this - I want to detect error 547 (foreign key violation) and display a more user friendly error message to the user but when the ...

I have the following simple code. I can see the changes in the dataset by
displaying it to a data grid. All the new rows added
can be seen on the data grid. But when I try to update the database, it does
not commit. What am I doing wrong?? I tried both

I have a 2 tables merged. After merge, I need to sort the target table
by specifc column. How to do it?
Thanks,
Posted Via Usenet.com Premium Usenet Newsgroup Services

I have a datagrid bound to a sqlserver table. It has 2 columns. how can i write a statement that will evaluate when i change data in a cell of column 1 of the datagrid and trigger the data in column 2 to change base off of the column 1 change?

The SQL for the SelectCommand of my data adapter is:
    "Select contact_id, firstname, lastname from Contact where contact_id
in (<val1>, <val2>, ...)"
The goal here is to use an input parameter that is an array of values used

Access database column is set to true/false checkboxes
DataSet Table is set to boolean type
the following conditionals fail if the Access checkbox is "true" (i get invalid cast exceptions)
if ((bool)row["Resolved"]){...

I am new to asp.net. I need some good tutorial about recordset,
fabricated recordset, adapter and datagrid. How all work together. I
want to build a record set that all the time i can add row to the end
of existing rerordset. At the end I want to display the recordset on

How do I get what datatype a database field is (not what kind of data it
contains)
For example in Access database if I have a DateTime field and it contains
Null if I use the following code I get "System.DbNull"

Anyone konws haow I can save as populated Dataset (with one datatable) in a Temporary Table in sql server
Thanks

Hi chaps,
I was wondering if it is possible to make execute one stored procedure and
get more than one table back.
I particular, what I'm looking to do is get a some info from a primary

Dear reader
I'm building a multi-user application in .NET and was wondering what benefits the dataset has (for my application).
(1).  Database contains tables with 10.000 - 20.000 records. Do I have to use a dataset to fetch all the records from the database (and load it into the ...

Hiya
I am passing a dataset to a middle-tier object, which in turn updates the
data source and retrieves an Identity value from the database, replacing the
ID value in my dataset with the correct value. When the function returns to

What event fires when particular tab is clicked?