how can I list the following things with ADO.NET in a generic way:
a) list all databases available in a DBMS
b) list all tables within a selected database
c) list the fields (and their type, constraint etc.) with in a table

I have an ASP.NET application. I am using a dataset for loading data (based
on user input month & company Name) from SQL database. I have the query as ::
SELECT CompanyName, Date , CEO from TABLE WHERE (CompanyName=@a &&
But how do I get the month part from the Date field in the ...

I've been working on the Mono Sqlite 2.x client
(http://www.go-mono.com/sqlite.html) in order to make it work with Sqlite
3.0. Note that I have nothing to do with Mono, but I find this code useful
for working with Sqlite in Microsoft .NET. I'm wondering what would be the

I've been seeing that sqldataadapter now can handle batch update in version
2.0.  Anyone who can provide some insights on how is it doing it internally?
Thanks!

Can I select DISTINCT rows by using Dataset.DefaultView.RowFilter = "Distinct Col1, Col2"

Hi,
I want a datacolumn expression which will work out a value depending on the
value of child records here is the expression that does not work. if any1 can
help me that would be great

Is there a simple way to take an ASP.NET application that is currently
working/running on one development machine (designed with UI, Business, and
Data layers) and move it to two machines (one web server in a DMZ and one
application server behind the firewall)?  

In ODBC the SQLGetInfo function retrieves information about a driver and a
data source. In OLEDB the OLE DB Properties return such information. What is
the equivalent functionality in ADO .NET.

How can I get the last datarow added in a table created from scratch, that
is, not related to any database whatsoever?

While wandering about one day writing some VB code, I came across an
ugly little error, as seen above. Further delving into my code tosee
whether I am a complete and utter fool, I managed to track downthis
ugly little error's source, which is as follows:

I'm working on a app which is suppossed to update an Access 2000
database through an Web Service.
So i have made an Windows App. which works on a disconnected DataSet.
It then Insert and Update this DataSet and sends it to the Web Service,

I am new to web programming and am using ASP .NET (C#) and ADO .NET to
develop a web based room booking application. I have been reading a lot of
books on ADO .NET and ASP .NET and I have a few basic question which I am
totally confused about.

For our .NET Windows Forms based distributed application, we are using ODP
.NET (R 9.2.0.4) to connect to Oracle 9i R 2. The query to fetch data from
the table is expected to return around 100, 000 rows. From the UI, we are
connecting to a production box to call a Web Service which, ...

I've recently started playing around with SQL 2000 and Stored procedures
and calling these stored procedures with a C# program.  I have the
following setup: 1 Windows 2003 server running SQL 2000 (SP3).  I have
created a small C# program to run a stored procedure called

I keep getting this error message and cannot find the solution for it.   I've
written the following stored procedure:
SELECT Username
FROM [User]