I'm using a dataview as datasource for a datagrid and it's is filtering and sortering the data Ok
The problem happens when I try to update one of the data view rows and the column I am updating is part of the filter expression.  For instance, if I'm filtering my datagrid by ...

The following code takes data from excel spreadsheets adds a record to the
dataset and puts the excel cell value in the correct column. It uses an
oleCommandBuilder to generate the proper SQL Insert statement.  I get the
excel sheets open and extract the data, add a new row and ...

my data is an access mdb.  the table has several columns of strings, booleans, dates, etc.  i noticed that when i include a bound checkbox to a boolean (yes/no) column to my form that i cant add a new row to the table.  but when i remove the checkbox and replace it with a text ...

I have written a function that takes a few rows out of a table and
returns them in a DataSet. It looks roughly like this
[WebMethod]
public DataSet GetSomeRows()

I am converting a VB6 application to .Net and having problems converting the
following code.
VB6 Code:
       Dim lDataID as Long

Hello, I've got a problem. I need make a transaction with two distincts databases. The two database are SQL-SERVER. Please suggest me the best way to do it.
Best regards

Don't Connections and DataReaders close automatically when destroyed? Do you
HAVE to close them manually, or is it just recommended?
Jon

I am using MySqlCommand  which I am sure it is the same as SqlCommand. I
have a column in the table that auto increment when a record is added into
the table. How can I execute an insert statement into a table and get the
new id number that auto increment at the same time.

Making the following call to a local MSAccess  database works fine:
   Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs)
       Dim intRows As Integer
       Dim strSQL As String

Greetings all.
   I'm in need of some serious guidance.  I'm working on connecting a c#
asp.net app to an InterBase v6 database that sits on a remote machine.  I
can't get any ODBC / Open Source .net data providers to connect successfully

I want to retrieve a single row with only 2 columns, i.e, 2 cells. What is
the most efficient method?

I am adding records to a table using ADO.NET
(I cannot use sql statements e.g. INSERT)
The program through an error on the final update.
The table consists of 3 field:

Well Im fairly new to  .NET but it seems to  me that there is little/
no advantage to using the update, delete, insert methods of a data
adaptor at all. The commandbuilder seems not to  work in many
real-world scenarios so you have to  code the various commands

I'm passing parameters to a stored procedure in sql2000 from asp.net page
I'm using  the same coding technique as in "ASP.NET Starter Kits" to discover the stor proc parameters, but I'm getting
this error :"String was not recognized as a valid Boolean
If I call the same stor proc ...

I have an application where, upon inserting data into a table, I'm receiving
a System.Data.SqlClient.SqlException exception.  The only information
displayed is "System Error".  I've gotten exceptions like this in the past
(with other data adapters), when I've finally determined that ...