Hi
I'm attempting to connect to my SQL Server DB get a dataset containing all
tables in the database, then for each table get the columns and access the
column definitions.

I have received an error message "Server Application Unavailable" when I
tried to use the DataGrid's DataBind method on web page.
The database connection had been successfully connected, however, the web
page failed when the line of code below was running.

 Is there a way to modify an SqlServer Stored Procedure using ado?
Thanks.

I installed oracle client 9.2.0.1 on winxp.But when I open a connection  to
oracle server, there is an exception:DllNotFoundException: Unable to load
DLL (oci.dll). I found oci.dll in "D:\oracle\ora92\bin".
Can anyone help me out?

I've got a dataset and a windows form I've bound my controls too.  I
have two fields that are True/False in the SQL server and wanted to
use checkboxes for those...  Everything looks fine, you can navigate
through existing records, etc, right up until you try to add a new

I' m quite new to this, so this will be a very common problem:
How can I read the contents of a XML file into a DataSet? Is there a
function for this? Can anyone provide source code?
Thanks a lot

When I run the following:
   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
       Dim strConnection As String = "data source=csql;initial

I have the following situation.
I have a parent table and a child table.
The parent table has an identity field which
is the primary key. This primary key is also a

Get Error "No value given for one or more required parameters."   
Code:
SELECT * from PatientSummary WHERE PatientSummaryDate=(SELECT
max(PatientSummaryDate) FROM PatientSummary  WHERE MasterPatientID=?) AND

Can anyone advise (or give example) on how I go about updating an sql tabel with that has an autoincrement field?
What I would like to do is make additions in my datagrid, and write them back and let sql2000 tae care of numbering the new rows using the autoincrementing ID column ...

okay so i have this
myCommand.CommandText = "INSERT into UserID
(UsrName, passwr, UsrID) VALUES ('Rik', 'pass',
9)";

I have a data table populated fron data adaptor. What I did was to delete
one row using DataRow.Delete(), then add the same rowagian. Now when I call
dataTable.RejectChange() got ConstraintException.
Any idea about how to get around this problem?

Hello anyone,
The last couple of days I have tried to find the best practice on updating
parent and child rows in a dataset. Ideally I want to allow the dataset to
consist of a mix of modified, deleted and inserted child and/or parent rows.

I'm looking for a way to query a DataSet without saving the dataset to
disk.
For queries that don't use joins, can I use a aggregate functions in a
DataView?

How can I get the rownumber and the first column value of the last visible
row in the Windows.Forms.DataGrid?
Thank you
Sincerely