The designer does a great job of letting you map fields to a DataView but I
dont want to have to use the dataset it creates at runtime because I want to
be able to use my own dataset from my dataaccess layer. I want my display
components to be loosely coupled and more flexibly ...

I'm a bit new to ADO.net, so here's my setup.    I'm programming in vb.net I have a strongly typed dataset with sqlserver data in it. I want to edit a row in a table by referring to it by its' primary key. How the heck do I do that?    dataset.strongtablename.item(primary key) = ...

I have created some extended properties for my stored procedures in Sql
Server, like Description and Project. Can I use ado.net and vb.net to
read these extend properties and place them on a Listview? I dind't find
anything about this topic.

Estoy creando un datareader.... en una base ACCESS con el proveedor
Microsoft.Jet.OLEDB.4.0
la instrucci?n SQL es la siguiente:
Select * from CLIENTES where Apellido like '*Perez*'

Trying to find more info on sql-dmo
on my server box the help file said that there would be samples here...
C:\Program Files\Microsoft SQL
Server\80\Tools\Devtools\Samples\sqldmo\vb\explore

I have read Microsoft Desing Guides for the data tier and I'm trying to do a
User class to test it. I don't want to use directly dataset. I want to
isolate ADO.NET from outside the data tier.
I have do the user class:

I am returning a dataset object from a web service method to a subscribing web form application.  I create a dataset object and set the value equal to the passed dataset.  When I databind to a datagrid, nothing happens.  I have had luck doing this directly but not by passing the ...

Call someone tell me if it is possible to call Oracle Functions with System.Data.OracleClient classes?  I have a simple function that returns a varchar and it keeps telling me it isn't a valid proc, well of course it's not a proc, its a function.
I don't want to have to use OleDB. ...

How can I retrieve values from a dataset.
I want to store values from a dataset into some variables.

I am creating a dataset by using a stored procedure.  When I bind the
dataset to the datagrid I get the following Error "Cast from type
'DBNull' to type 'String' is not valid."  I used a sqlreader to verify
that the field was returning "", as per my stored procedure

How do you map an Access database on a webserver? It is only relative
to all my ASP.net webforms, and all my oledbconnections point to my
connectionstring in the web.config. But how do you map the URL in XML
to the localpath.

Designers are great, but they have limitations : Ergo...
* I am using a strongly typed dataset
* So I make my form and textfields A, B, C, D, E, F, G, H on it.
* I create an instance of my stongly typed dataset in the designer, lets

I am feeding a connection string and a query (stored procedure that uses a
temp table) to a MS Office Pivot Table control.  I have read the article
listed below
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/s
upport/kb/articles/q235/3/40 ...

Hi Al
  I am tryng to insert into SQL server image data type field using ADO.Ne
  The image data has some non ascii character
   So if I use System.Text.Encoding.GetBytes() it is not getting me proper byte

I use the following code to clear out a dataset (let's suppose the dataset
has been changed but not the back end, by design) after having once called
the .fill method of a data adapter:
       dspubpay.Tables(0).Clear()