Is it possible to not get duplicates when using a data adapter,
SelectCommand.Parameters and the Fill-method?
I would like something that adds the DESTINCT parameter the select command.
I have created all my select-commands in the designer.

I've got a class (MyClass) that has a DataSet (privateDataSet) as a private
property.  I'd like to give consumers of MyClass read-only access to a
couple of the DataTables in the privateDataSet, as DataTables.  What I'm
thinking of doing is creating a public property MyClass ...

I am using typed datsets in my application to persist user data.  The
problem I am coming across is how to map my business entities to the db
structure (about 8 tables with data relations).   I could create on typed
dataset to represent the whole structure or break it up.  What is ...

I have never been a fan of building Input SqlParameters dynamically. I know
ADO.NET does a pretty good job figuring out datatype and size. However, I
like having the control and knowing I can affect the performance by building
them myself.

I've got a C# strongly-typed DataSet that is being auto-generated from an
XSD schema I've created.  I see that I can change the access modifier for
the generated DataSet class to "internal".  However, it gets set back to

According to MSDN, the SqlDecimal.Null is applicable to the SqlMoney
class:
"Represents a null value that can be assigned to the Value property of
an instance of the SqlMoney class."

I just have a quick databinding question. I have 2 forms.....
Form1 is my main form containing all the controls i want to bind the results of my query to
Form2 contains a datagrid containing a list of guests in the database. The user can click on a row to select a guest. They ...

I get the following connectivity error. im trying to
conncet to MSAccess 2000
any suggestions ?
Server Error in '/EBtest' Application.

I am importing excel file Data into .NET, and it works fine for one
exception.
My connection string:
.Connection = "provider=microsoft.jet.oledb.4.0;"

I am trying to update a record in a SQL database through a web service but
am getting this error:
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint
'PK_Items'. Cannot insert duplicate key in object 'VideoProposalItems'.

Is there a property we can set that will return the dataset.getxml in an attribute format rather tham elemets
Please help
Thanks
Matt

What is the best way to manipulate data (insert and update) in a aspx page ?
I want to inset and update some data and I can't do it in SQL Server.
I have to scan some tables and insert (or update) data in another table.
I've tried something whith datasets but it haven't something ...

I have a MS Access 2000 database table which has a large number fields. I am
using the OleDbCommandBuilder to generate the SQL update command. The
problem I now have is that the auto generated update Command is too large
and fails with the following error "Query is too complex".

Dear reader
I'm having a problem.
'How can I bind a control when I have the name of the control, name of the dataset and name of the field in table
strControl = "txtCustomerName

I am using ODP.NET (Oracle Data Provider for .NET) in my asp.net application.
I have a table in my oracle database called "equipmentgroup". When the page loads for the first time i retrieve all the records from the table to a dataset and save it to viewstate. Later on any addition ...