I have a datagrid binded to a datatable and a save button..
everything works fine except the following scenario:
1. user enters a value
2. after that user clicks the save button but without moving from the

I have a class deriving from datatable. In ctor i define the columns
and set the pk. And there it crashes on the unique = true line.
public DTNomenclatureLevel() : DataTable
{

While retrieving multiple rows from a dataset, we go for a datareader.
Following best practices, i had implemented the
commandbehaviour.closeconnection to ensure that associated connection is
closed, when datareader is closed.

The actual data is
10/12/2004 6:04:06 PM
being retrieved.
However,

I'm trying to get progress messages from a long-running stored proc to a C#
client program.  In the proc, I use RAISERROR (@Message,10,1) WITH NOWAIT",
and I've set up a SqlInfoMessageEventHandler.  The handler gets all messages
at the end of the proc, not as they are generated.  ...

I am playing with .NET 2.0 Beata version.  This code that works fine under .NET 1.1 is now broken.  Any suggestions to fix it will be appreciated.
<%@ Page Language="vb" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>

Using a datatable and want to delete a datarow that has been added to
the datatable and reset the AutoIncrement column number. How do you
reset a column setup for AutoIncrement number? I can delete
the datarow and then call exceptchanges which works fine but, the

Generally, I try to use "using" in my c# code whenever possible so that I
make sure all my resources are disposed of properly. I'm in somewhat of a
quandry over the OracleTransaction object. Normally I would do something like
...

 I hope if anybody could help me in this situation:
I have a Dataset that I fill using some sort of Business Objects Class
from Oracle 8i (using OLEDB NOT ORACLE Client) and there is None
English Characters (Varchar2) Esp. Arabic charset. so, when i fill the

Hello, I am under taking my first project that will use MS Access as it's
back end data store. The project was originally written against SQL Server
and worked happily but the client suddenly wanted to switch to Access (don't
ask me why because I don't know). Anyway, here is my ...

I would like to know how to perform something like
select sum(amt) from table where id>10
in DataTable,
assuming that i have a DataTable dtTable which stores the "select id, amt

Currently I have a piece of code that exports data to an Excel spreadsheet.
This is all good and well except for the fact that, even though the data
being exported is numeric, Excel prefixes the data with an apostrophe and
this makes the data completely useless when it comes to ...

How do I define the desired DataAdapter at runtime?
A ComboBox is used to select the desired table. The selected value is
the name of the table to be loaded into the datagrid.
My solution works but seems less than elegant.

Child grids won't show new or edited values unless grid clicked
The child grids are read only.  Below them are edit, add and delete buttons.
The edit and add buttons open up separate forms in which one field (keyword
or searchphrase, respectively) can be edited.  The two forms ...

I am new to sql server ce and am trying to get my head round how to develop
using sql ce as opposed to sql server 2000. I want to develop for hand held
devices using windows mobile. The vs.net 2003 ibuyspy compact framework
sample runs fine on the handheld when compiled and run. My ...