I have a typed dataset as follows,which as you can see **Dose have a primary
key**.In the application when I try to use the Find mentod on it it says
that the table dosen't have the primary key,so I traced from the begining of
object creation and I noticed when I instanciate an ...

When I try to insert the second record I get the message "The Variable name
"@Parm1" has already been declared. What can I do to prevent this.  The code:
try
{

so i have a database schema, a .NET object library .dll, and an ASP
classic web application.
i'm wondering where in this setup i should place default values for
fields/columns of forms/objects/rows.

Is there a way to connect to oracle 9i database from c# WITHOUT installing
the Oracle Client Components on my machine?
Thanks
Arlef

I have an application reading data from an Excel file and filling a SQL
Server table.  When I read the Excel file, I want to be able to trim
trailing spaces off the data as it's read into the dataset.  I'm connecting
to the Excel file via an OleDbDataAdapter & OleDbCommand object ...

I am trying to create an excel file using ADO.NET (Can not use Excel
COM interop classes). Everything seems to be working fine except the
column header of the table sheet1 is also included in the output file.
Setting the HDR=NO doesn't seem to fix the problem. Could some one

I have a webservice which queries a table in SQLServer. The table has a
column, "Text", which is of datatype "image". When invoking the webmethod it
returns  dataset with the table included. The column is returned as a
base64binary as can be seen in the declaration excerpt below:

(Type your message here)
i am trying to create tables in sql server programmatically in vb.net.i can add fields and update them programmatically. i need to know how i can update the table records when displayed in datagrid.i want to update the datagrid/records as it is done in ...

When we retrieve data from a int field from a datatable and if I write
lValue = (long)dtTable.Rows[0]["Fld1"]
it generates an error at runtime. whereas it should be done because we are
converting int to long which should be possible.

I want to create a asp.net / winform application, which has a text box.
In the text box, the user will paste data (copied from another source), in
tab separated format.
Supposedly, all the columns are always in a predetermined order, how can I

I have designed a DataAdapter which reads data from a table.  The table has
an auto-incrementing Primary Key.  None of the columns in the table accept
Nulls although some of the columns do have defaults.
My question is - Is there an automatic method of filling these properties on

My application connects to an Access database when it is loaded, and
keeps the same connection open all the time.
There is logic in the code to ensure that the connection is
automatically opened the first time it is used:

What is the difference between GenerateDBDirect and the Insert/Update/Delete
sql commands that can be generated via the advanced button in the select
table section of the TableAdapter Wizard in Dot Net 2.0.

I am new to column mappings and can't seem to make them work. The following
is an example:
    DataTable table = new DataTable( "SYSTEM.Usernames");
    table.Columns.Add( "S1", typeof(decimal) );

It appears that the DA's Fill method does not grab the schema in situations
like this:
TasksCommandText = "SELECT * FROM \"tblTasks\" " + sTasksWhere +
sTasksOrderBy;