Hi all, I got this problem. I've got three table User, Group and
User_Group. These tables I have put into a typed dataset and added
relations to them. I also have a form in which it is possible to
insert, update or delete a user, including the related records in the

My project schema looks something like this:
ClassWidget
   SelectWidgetAsDataTableTable
   UpdateWidgetDataTable

I have a BO that must call 2 functions each function residing in 2 different
DO.
BO->DO1.Update1
BO->DO2.Update2

We have end-users doing a selection, the selection is copied into another
table (claimed) (we do this for them in a batch during the night)
To limit the endusers account balance we promote for example a max. of 500
records per month.

Are there any decent parsers around that can parse SQL? I'm looking for
something that can validate the syntax and also allow access to the columns
and tables from the select and where clauses?
Thanks for any help,

i try to execute a DDE command with an SQlClientSQLCommen object and i
obtain  "syntax error near "Then"  ":
dim sql as string
sql = "CREATE TRIGGER myTrigger " & _

I need help here.
I am converting an vb application to c#. The existing application connects
to the mainframe server using FTP and downloads a file (dataset).
Is it possible in .NET to avoid FTP and use any providers to connect to the

I am trying to call an oracle function using Visual Studio .Net 2003. The
function runs fine Stand Alone. Only when I call it using my C# Code I get
the following error: "ORA-06550: wrong number or types of arguments in call
to FUNCTIONNAME". Hence I am assuming it has something ...

I have a datagridview which bounded to a  datatable. When I tried the
to update the grid:
adapter.update(table)
I got the following error:

Using..
Visual Studio 2005 Team Edition for Software Developers
SQL Server 2000 sp4 (on same machine)
Net.Framework 2.0

If I have a parameter with a default value of empty string, the
sqldatasource won't even execute the command on sql server. Im using a
"like" clause so i want to include an empty string to retrieve all
records if desired.

Is there a way to get a list of all forms contained in another
solution/project?
Thanks in advance,
Roman

I am using XP Professional with Visual Studio 2003 & Office 2002, there is no
Jet OLE DB Provider listed yet if I download the latest Jet update or MDAC a
message states my PC is up to date.
Please can anyone shed light on how to make this provider appear with my

It seems I can't use this to get Guid from OracleDataReader
int iOid = oRdr.GetOrdinal("OID");
while(oRdr.Read())
{

I have a situation where I could
Try
   Open a Connection
   ExecuteReader