hi..
i have 2 problems
if i create a table relationship  between 2 tables and define it as
nested in the "is nested" property schema it does not create any

I apologize for posting in this NG if this post is a better fit for some
other group, however I am up against the wall here.
My program uses free threaded COM.  Once in a while (depending on routines I
call)  I instantiate ADO, use it and release.

I need to implement a free text search on an asp.net page.
I need to search two columns based on a text entered in a tex box.
it should be possible to search any subsrting included in one of the two
columns.

Why can't I find a reference page for ADO.Net, you know, objects,
properties, methods...?
I can find all kinds of feel good stuff like: Best Practices, Migration,
ADO.Net & You...but no straight up, no b.s. reference. Kinda sucks :-S

I would like to ad Constraints to a database column, which only can have
unique values. The column can be empty only if the table is empty (no
records).
Im using the syntaxt:

Here is the simple test stored procedure:
<code>
CREATE  PROCEDURE pr_test
(

It keeps saying the stored procedure expects the parameter '@entity'
which was not suppplied, but I'm supplying it:
OdbcConnection cn = new OdbcConnection(CNSTR);
OdbcCommand cmd = new OdbcCommand("GetMyList", cn);

How can you you edit data in a datatable? I already have the datatables
created. I want to know how i can refer to the columns in the data table and
what commands do i have for editing info in the table. I want to be able to
move the values in one column to another in the same ...

I have been using this feature for a long time and it's worked like a
champ, but I've come across a time when it doesn't seem to work.
Typically (when it works) there is a parent table that has it's Primary
Key set with the AutoIncrement. There is then a Child table that has a

How might I return a current count of rows in a dataset table? I tried the
obvious:
DataSet.Tables("TableName").Rows.Count
However that returns the original number of rows, and not the number of rows

I've gotten the dataset.ReadXml() method to load XML from a remote source
but I was wondering since I plan on having multiple datatables in the
dataset, can you specify which table to read XML into?  I'm using ASP.NET 1.1
Thanks, Dave

Is there a way to reset the connection pool on a machine so that all cached
connections to a database are closed?
Cheers, Jon

I'm loading thousands of images into a SQL Server 2000 database. I have a
.NET windows application that I'm working on written in C# that retrieves the
fileinfo of the directory and then loads all of the images into an image
field in the database. The problem I'm having is that I ...

I have the following fragment of code which retrieves datarows from a data
table using the Select method.I want to add these rows into another data
table.But I get the Exception:
'Column "ReleaseDate" already belongs to another table'

I am trying to gather records from different databases into one dataset. I
can do the select statements and get the data into the datatables and then
into a dataset. The problem is then being able to get the data I need from
the dataset so that I can display it for a report. (I ...