Hi, all:
How to read/write binary data from/to SQL server? Could please give me an
example?
Thanks in advaince

Hi,
I need to have two DataReader in one connection, for example In DataReader one the Authors Info and DataReader two the Pubs. I read DataReader use exclusive the connection, i can do anything without use DataSet??? Thanks
---

My code:
string pdf = "0000000018334938.PDF";
Page.Response.ClearContent();
Page.Response.Clear();

Is there any page where the difference between the Output Parameter and the Return Parameter being sent back by an SP is discussed ? Also, how does one catch them in VB.NET and make use of them
Thanx in advance and Regards
Sanjay

How do I populate the DataColumn.DefaultValue property from SQLServer
i.e
I have a table in SQLServer. One of its columns has a default value. This column is populated with the default value when I insert a record and don't specifically set a value for the column
When I create a ...

I am having serious problems serializing DataTables and getting them
to preserve their column types.
I have a DataTable with column "AY" having a string, and all other
cols having doubles.

I found a bug in the SQLHelper.FillDataSet method. I googled it but didn't find it and I didn't see anyway to provide feedback to MS so I'm posting it her
When filling a typed dataset that has more than two tables the table mapping doesn't work for any tables after the second ...

I have a form with a number of textboxes.  These textboxes are all bound to
a field in a dataset, and in each of their TextChanged events I have code
that executes.  When the dataset is being filled, this code executes as each
textbox is filled.  This causes an error because not all ...

Is it possible to use ado.net with an MS Access FE? If so, how
My reason for inquiring is that I currently have Access FE with SQL server 2k BE and want to move the business logi
to a middle tier. I was advised to skip straight to .net classes
Thanks for any comments

I have a query that frequently (but not always) throws an "General Network
error".
SELECT DISTINCT Top 500 cl_prefix, cl_suffix, cl_company, cl_next_call_date,
null, null,  cl_contact_status, cl_acct_num, null, cl_last_name,

I'm sure this can be done but I just can't figure out how.  I have two
DataTables in a DataSet with a relation between the two.  Table 1 contains a
full list of product IDs and names and Table 2 contains the list of product
IDs a user has access to, how do I do an "inner join" type ...

I want to create a function that accepts the ServerName parameter, gets the connection to the server and returns the CONNECTION OBJECT to the calling function/procedure. How do I do this? I don't think it's as simple as writing a function like.... Public Function ...

Looking for some insight into using Persistent Data Objects instead of SQL
calls everywhere, but have a couple of arch. questions I don't
get/understand.
a) For each table (eg: Customers) one has a class called cCustomers. The

I'm trying to generate a typed dataset and it failed
That's what I'm doing
I'm dragging the table from the server explore into the new xsd file. the new class (typed dataset) is created (i see it in the folder)
when i try to add this class to the project nothing happens: neither ...

I am using one SP to perform updation as well as insertion on a table in SQLSvr2000. But somehow, the control seems to be going to the Insertion part of the procedure. This is how i have defined the SP (icode is defined as identity, primary key)
CREATE PROCEDURE dbo.[UpdtMaster]
 ...