I am going to crazy and feeling myself so stupid but I don't understand such behavior.
I have code:
public int getNextAgentId()
{

we had very strange memory usage in our application when continiously
updating a dataset. We were able to exactly localize the problem in the
datatable.Select method.
Each time we check the datatables for changes with Select, there is an

I working on implementing a scrolling and record navigation with ADO.NET. In
ado recordset having builtin caching/paging and record navigation methods.
but i could find a similar conecpts in ADO.NET classes.. Am i missing
something?? In dataset class i cannot set ...

i am trying to make a window application that create graphs (plot data as
in excel) for a given set of points, how can i do this?
thanx

   I have an application, which requires several SQL activities, so I wrap
them in a transaction:
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();

I am trying to export info about a SQL server database in vb.net. I
need to retrieve the following info about the fields in the tables:
names, data type, length and default values.
I have used the following code to retrieve the first three properies:

I want to compare two datasets (of 2 datatables). I just need to know whether
the 2 datasets are same or different. I do not want to know how it differs.
(I would be nice to have though).. Is there any easy way to accompilsh this.
Thanks

Hi Every Body,
I build an application using vb.net.
Now i m deploying on the client system.
I know that the deployment automatically check the .net framework on the client system at startup.

I'm trying to set the RowFilter = "MyDateTimeColumn in ('2005-02-21')" but
it returns 0 rows. I know the row is there. If change the RowFilter to
RowFilter = "MyDateTimeColumn not in (all the other dates but 2005-02-21) it
returns the rows.

I am accessing an Access db.  I generated the adapter and ds thru the
wizard.
I have a datetime field in the database (simply called Time) that I am
posting to from a textbox.  I had to convert it to dattime format, which

I've created a strongly typed DataSet, with a 2 related tables. a couple of
the columns in the parent are computed with expressions. One of which is a
Sum of a Child.column (Sum(Child.UnitCost).
Eitherway, since adding these expressions, I'm getting a

For some reasons, these lines of code sometimes differ in results:
myDataView.Item(1).row("MyColumn")
myDataView.Item(1)("MyColumn")
Sometimes the second version throws a NullReferenceException in the

We need to update an image stored in a SQL server. I understand that the
basic code *could* go something like:
BEGIN
Load the image from the file into a byte array

I am using a dataset containing  Parent/Child tables. When I attempt to delete
more than a single row, I get the DeletedRowInaccessibleException error on the
second row to be deleted. I cannot figure out why.
I have looked at the data just before the failed call (identified by ==>). ...

How do i find out what version of ADO.NET is being used in my .NET
application.
Iam building vc++ application in visual studio.net 2003 (7.1 version) and
.NET framework version 1.1. I would like use the new feature of ADO.NET 2.0