I tried some code below:
//**************
int row=dataGrid1.CurrentRowIndex;
dataSet1.AcceptChanges();

I have created a simple aspx page with a datagrid, a textbox and a button on
it.
I want the user to enter a date in the textbox press the button and return a
list of items to the datagrid from an SQL database but I am having problems

I'm having some problems with reading data from an Oracle 9i database
using the datareader implementation from the ODP.NET Provider.
I need to fetch around 50.000 -100.000 records, store the data in a
custom dataset. However fetching the data takes around 30 sec till a

I am having difficulty using the SQLHelper object in the DataAccess
application block with SQLTransactions.
I have a function that performs 2 inserts. I intentionally broke the second
insert to see if my rollback occurs on the first inserted row. It appears

Is it possible to filter a dataview, datatable or dataset using the key
values of another dataview, datatable or dataset ? Please advise.
Ben

I am using a data window with textbox's.  some of the data is money keyed in
as "60.00".  I need to convert this to money before I can save it to a sql
data table.
the code is done in C#. can someone help me!!! The specific code is included.

I write a page that delete the records from a dataset ,
and update to the data base ,
I click the delete button ,all that are right !
but when I refresh this page ,

  I have a datagrid with paging enabled so that it displays only 8
records at a time. I have a template column with a textbox. The textbox
accepts numeric values. The problem is when i click on the next or
previous link on the datagrid, the values entered in the textbox is

Scenario:
Table T1 with n columns and 2 columns with expression
Table T2, T1 close without 2 columns with expression
DataAdapter.Fill(T2);

I'm populating a DataTable using a DataAdapter.Fill() statement.  It works
just fine as long as the return is successful.  However, when my query
returns no rows, rather than getting a "0" for rows returned (the function
is supposed to return an integer), I get a "System ...

I have a serious problem. I have multiple sets of tables, several of
which are chained more than two tables deep. That is, I have a parent, a
child, and a great-grandchild table.
Currently, I am allowing the parent to be edited by itself. In order to

Below is code using the Oracle Data Adaptor and VB.NET.
All I am trying to do is make 100 insertions into the database.
From the time of the first "Console.WriteLine" until the last one
is 15 seconds.  That is way too long for 100 insertions.

We use Sybase SQL Anywhere Database (Version 5.5.04).
When running only a asp.net webpage (or webservice) everything is working
fine.
The dbeng50.exe is running under the ASPNET account but you can't see the

I've been doing ASP.NET and PPC apps for years now.  I've gone back to
revive an old application that used Access.
I'm witing it in VB.NET in VS2003 as a WinForms app.  What's the local DB of
choice to use with this type of app.  Is it still Access?  I'm really

I have created a transaction and attached it to the dataadapter of my
dataset in question. When an exception is raised before the transaction is
commited the transaction is rolled back.
The problem I am having is that although the transaction rollback has