I have an ACCESS database, with 2 tables. The realtionship between tables is
set 1:1.
I put those tables into dataset and set up the foreign key constraints:
DataColumn parent = ds.Tables["Empl].Columns["AdvertisementID"];

I have a bunch of .xsd files some of which inherit from others, such that
there are elements that have attributes in one file and also inherts other
attributes from another file.  These schemas come from an external source (I
have no control over them).  We plan to store the .xml ...

Friend of mine asked me this, I'll try look at this later in the evening,
but hey feel free to take a stab --
lets say I have a table(table1) that looks like
Region,State,count

When I call a sybase stored proc from RapidSQL, I get back the value
-100 for some columns(which is correct).
However, when I call the procedure from an ASP or ASP.NET page, I get
back -1 instead of -100.

I have two applications one written in Access 2002 using ADO and the other
written in VB.NET using ADO.NET.  The Access application looks for files and
runs an associated process once the file is found.  The VB.NET application
actually searches folders and subfolders for the ...

Am using the VB.NET (Vis Studio 2002) Data Form Wizard.
As soon as I include a checkbox the data form just stops working.
Using SQL Server 2000 and the bit field type.
Any ideas? as am going round in circles :(

I'm getting there!
I'm using vs.net and have created a dataadapter and a recordset in a
component.
i'm able to reference the component to get data .Hey! i even created a

I have a typed DataSet populated from a SQL query. To the columns
returned by the query I have added a calculated column with an
expression of the form Quantity * UnitPrice, but after filling the
DataSet with a DataAdapter the expression column remains at the default

In ASP classic, I used to do something like this:
<%
Sub TestMDAC(pstrConnectionString)
Dim conn

Can someone please tell me the recommended best practice for loading a
subset of the columns from a single row of a database table?
Users can make fields come and go from the form, so a stored procedure
is not an option as I see it.

Hi;
I have to write custom data integrity utilities comparing files with table
data.
I've found that looping through an ado recordset will cause memory problems

I have built a database in Microsoft Access 2003 that has a number of links
that go out to the web. Does anyone know of a way I could set up my
database to check which links are active and which ones are inactive?
Because the links are added and removed, I would need to run this ...

I'm trying to incorporate a data tier into my asp.net web application (add,
update, delete, etc), as opposed to using spaghetti code.
So far my "getter" class, "CabinetSpec.vb", has Update, Add, and Delete
methods that

I'm trying to open a comma delimited text file using the following code, but
no luck...
Dim cn As OleDbConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data

Is there any way to get or estimate the memory being used by a dataset or a
datatable? I'm writing a caching class and trying to keep track of the size
of the data I'm keeping or at least an estimate, to make better decisions on
when and what to expire.