We have SQL Server Stored Procedures that use the "CURRENT_USER" variable.
We have SQL Server database fields that call "user_name()" as a default.
That has been fine in the use and storage of user names, in the context of
being called from IIS 5 and 6, from ASP 3.0 using ADODB.

I am somewhat new to .Net and currently working on an intranet site using C#
going against SQL Server 2k.  I am accepting personal information on a
single webform and trying to insert the information into three separate
tables (all in a single aspx page -- without using stored ...

I need to insert a new record in an access table with values for various
fields provided. In sql server you have an insert stored  procedure to which
you pass the field values as parameters. How do you do something like this
in access using oledb & vb.net? Whatever is easiest.

I have tried just about everything to get the dataview working, all I want
to do is loop through rows generated from the stored procedure and then
suppress some of them depending on the amount of columns returned, with a
table like structure.

What I'm trying to do is exectue a stored procedure that returns some
records along with an additional RETURN value. The code is below:
***
SqlConnection Conn = new SqlConnection

certainly know the good-old ado recordset with the capability of have
a server side cursor with it advantages ad disadvantages.
In some roadshow during this year someone has tell to me that 2.0
version on ADO.NET we would have had the server-side cursor come back

Is it possible to execute a complete script with different commands in one
execution under ADO.NET? If so, with which component and how? Do I have to
separate statements with 'GO'?
TIA,

Hi all, I've written a recursive stored procedure that will navigate one of my tables in a hierarchical fashion.
When I run the stored procedure within query analyzer it returns the proper data.
However, when I "fill" the DataSet with them - there only appears to be one row of data ...

I have the following code:
The following line is global
Dim sqlDS = New DataSet()
This is in a procedure

I have a DataView where I am trying to use “rowfilter” property to get a subset of base table rows. When my View gets created any rows which have “modified” or “added” row state are not returned in DataView although they satisfy my filter condition. I have tried to use all ...

I was browsing both the Amazon and Barnes & Noble websites
looking for some good books but there appears to be *so* many
and it's hard to tell which are going to be good or not.
I'm looking for one or two *good* books on the subjects of

I have a DataView set up as following:
DataView dv = new DataView();
dv.Table = twsDS1.twsContractHdr;
dv.RowFilter = "AgencyID = '" + agency + "' AND NeedsStatus = 'I'";

Hi friends,
Could you please tell me or assist me to get a suitable link describing the
difference between strong typed objects [datasets] and ordinay objects ?
[datasets]

Can anyone share any good source on multithreaded data
access please?  (Data access that run in separate thread
from UI)
Thanks.

Okay, I am doing the:
table.rows.add(NewRow)
thing, but now I decide I want to be able to find the row by primary key. Now the primary key for this table is an Ident, so that value will come from the database. I have all my update components in order. Every thing works, until of ...