I am developing a SQL Server Query Analyzer replacement app to use in
the field to avoid having to purchase licensed copies for a vast
number of machines.
One of the things that Query Analyzer does is capture the output of

Does anyone know what benefits, if any, there are to using Oracle ODP.NET
from Oracle vs. .NET's built-in System.Data.OracleClient stuff? We are doing
pretty basic queries and stored procs, and unless there is some compelling
reason, I would rather not load yet another piece of ...

I have a form based on a single master record stored in a dataset table.
The master record references many other tables (about 12) in the dataset.
I use combo boxes to display the current values and to enable value lookup's for editing.  
Unfortunately, most of these references ...

I'm manipulating a dataset in code by deleting and adding records.  When I'm
done, the user has an opportunity to save or cancel the whole thing.  If he
says Save, I delete everything in the database and now want to write this
dataset to the database.

Hello. I need to store custom objects in a SQL Server 2000 table. Which is
the easiest way to do it? Do I need to write methods to store each attribute
separately from C# app to the table and the opposite as well?
Regards,

I have a form based on a single master record stored in a dataset table.
The master record references many other tables (about 12) in the dataset.
I use combo boxes to display the current values and to enable value lookup's for editing.  
Unfortunately, most of these references ...

I do not normally use JOINS in my queries these days, but I have some
instances where I am simply showing historical data in a grid, and it is
thus much more convenient to JOIN everything I need in one stored procedure.
Thus I might end up with data from 3, 4 or more tables -- some ...

lets say i have 3 datasets in my project and than i build it so i get a DLL
now i am working a second project that has an openfiledialog, where i choose
this DLL from my first project...now i want to get one of the three datasets
that are in this dll...how can i do that?

Pardon this newbie question: I have a user control with a bunch of
textboxes bound to a DataView drawing from a DataSet in a different
class. Data display works fine, but the changes don't seem to get
posted to the underlying table; hence, DataSet.HasChanges always

is there a way to change color on tabpage? tabls are always Control color?

I have written some proof of concept code that adds records to a table,
utilizing SqlServerCe, using a parameters in a insert statement.
I am forced to read data from a BinaryStream (in the form of a file), assign
values to the parameters and execute the sql insert statement from ...

I have a large table in Sql Server that I want to populate
from a VB.Net app.  I have 2 data sources that are exactly
the same structure but data from different geographic
locations.  I want to populate 2 separate dataTables in my

Is there a way to writeXML to a stream (MemoryStream maybe)? I don't want to
write to a xml file, just to the stream so I can convert it to a string.
Thanks for your help.

I have a dataadapter that I pass a sqlcommand to, which has paramters.
I have the following sqlcommand on my page:
SELECT *
FROM  tbl_Changes

I know ADO.Net recommand using disconnected update
(optimistic concurrency) for good reasons, but it's just
not an option for us. 99% of our client would rather  
seeing "record locked" kind of message up front when they