I seem to get an error everything I create a query that includes CREATE PROCEDURE.
I'm using the JET4 OLE connection to my C# application.
Thanks,
John

I'm having trouble working this out and was wondering if anyone could help
me. I have a query:
SELECT
   1 AS Tag,

I was looking at this method within the SqlCommand class. It is the
SqlCommand.Parameter.Add(string, object) method.
My question is, how do I use this parameter within a stored procedure?
What i am really trying to do is dynamically change the ORDER BY method

A call of the Fill method of a OleDbAdaptor results in an exception: "Index
was out of range. Must be non-negative and less... Parameter name: index"
The error occurs sometimes after a fill after a 2nd update on a DataSet (ds
bound to a DataGrid and allocated once - the DataSet is ...

I have a test driver that is in my remoting service project and I am
able to use the following code to reference a particular field:
myDataSet.MYTABLE[0][myDataSet.MYTABLE.PERSON_IDColumn] = 5;
This is great because if my dataset column ever changes I will know

OK I have a web app that I built that makes MANY calls to the DB in each
request. The app wasn't tuned for scalability so this wasn't a problem, but
time is too short to redesign how the database is accessed because the data
that's being stored is time relevant and the web app will ...

Can anyone tell me what is wrong with the following code?  I get an error
message that states: An unhandled exception of type system.argumentexception
occurred in system.data.dll    these columns don't currently have unique
values

how can i make a rowfilter in adonet/c# that behave like the "select
distinct" statement in sql ??
thanks in advance, yoandy

Is there any preferred way to serialize an ADO.NET DataSet to a positionally
delimitted flat file (space filled) for use in a mainframe interface?
For example XSLT?

Hi. I posted a connection pooling question on Friday evening; I received some good answers, but I still have a final question
I would like to know if the OracleConnection class is safe for multi-threading applications. This is what MS has to say about OracleConnection wrt Thread ...

I have a dataset that is encapsulated inside a class where I use property
accessors for the outside world to retrieve the data.  The problem I am
running into is there are times when there are null values.  For example, I
have a Guid Column in a datatable that is a foriegn key that ...

For the last couple of days I have been stumped as to why my computer
decided to not allow me to either open or view asp.net pages.  I have not
added any programs or has any of my settings changed in the last few days.
Here are the steps I have gone through to try and restore my asp ...

Is it possible to create a progam to mimic the following action
a) drag oledbadapter to form1.cs
b) select my oracle ole connection
c) enter 'select * from mytable'

hi guyz
i want to print user friendly message to html page if there is no record in
database. i tried this code ..its working if there is no record.. but record
exists then i am getting error..

May I know if there is a foreach loop equivalent found in Sql Server? I
would like to use 1 in sprocs.