There is an XML file, formed from dataset.
I want to see this in the RTF-document like a set of tables.
something like:
Table1 name

I am new in VS.net. We try to migrate our VB6 application to .net. In our
VB6 application, we have a middle tier data access object to handle the
connection and stored procedures' calls. Do we still do middle tier DO in
COM? or in just Assembly? why?

Language is C++ and my code is pretty much right out of the documentation
example, yet I'm not ending up with any generated commands. In the following,
assume the relevant objects are members of a form class and this is happening
on the form's load event:

When I create a typed dataset containing multiple relational tables using
Generate dataset, it creates a single set of records based on what was chosen
when setting up the data adapter. If I have an orders table, an orderItems
table, a customer table etc. set up in the ...

i've a question for this group: i've  developed a windows service that
every x minutes count records present in a sql table and if those
records are bigger than a fixed threshold start with clean operations.
Workflow is this:

How to retrieve all sql server errors on ADO.NET?
I have a stored procedure which will validate data and raiserrors when any
error value inputted?
Example from my stored procedure when running sample data.

I've created a relational group of tables using the designer for the Data
Adapter. It decided to cross join all the tables, so I manually did it using
Inner joins, nothing special just PK to FK.
When I click preview data, then try to fill a dataset created by the

I am using VS2005 standard edition. I have a database (MSACCESS) with a
Customer table.  On the main form (frmMain) of my windows application, I
have used the wizards to create a connection, a tableadapter, and a dataset.
frmMain has a datagridview for selecting a Customer (and ...

I'm attempting to call a stored procedure to delete a grouping of records
based on the GridView's DeleteCommand; however, I constantly receive an
error message from Oracle that, after searching through Google and Meta,
does not provide much insight:

Can someone please tell me how the following is possible?  When I do this:
  System.Data.DataSet addedAndModified =  myDataset.GetChanges(
DataRowState.Added | DataRowState.Modified );
some of the rows in the resulting dataset have a RowState of

What is the best approach for data access while developing applications
using Windows Forms ? Is it opening, working with and closing a new
SQLconnection and SQLcommand object everytime a DB access is needed , or
maintaining a single open connection/command object at the ...

I have an ASP.NET project with a typed dataset (with table adapters).  The
table adapters' connection string property was set to get the connection
strings out of the web.config file.  I was able to add new table adapters,
and all worked well for a while.

1.)How can i save the stored procedure in sql 2005 server, into server and
NOT in file location
2.)How can create folder in stored procedure to separate categories?
3.)How can view the created date and modify date of stored pro

I have a stored procedure that returns xml data (using For XML), it returns
about 9000 records. I use a datareader to write the data to a XML file.
For some reason, the datareader doesn't write all data, it seems like the
data returned has some size limit.

I know a lot has already been told about date/time fields in a database but
still confuses me, specif when dealing with SQLserver(Express).
It seems that sqlserver only accepts the date in a "yyyyMMdd" format?
(difference between Express and MSDE2000A ?)