I have a strongly typed dataset.  It seems as though all of my sql chars and
varchar fields come through from mssql server padded out to the length of
the field.  Anything I can do about it in Ado.net?
Thanks,

Hi
I am trying to access a row of data from an Access database based on info
entered into a textbox.
I "int.Parse" the textbox name so that I could use it in the "WHERE"

Does anyone know how multiple resultset stored procedures are executed when
using data readers?  It appears that the sp is paused after each select until
the client requests the next resultset.
Also, does the command timeout apply to the intial query time or for the

Using VS 2003 (VB), what's the best way to us the DataLinks object in your
application. Is it by including oledb32.dll in your references?

I have a memory stream that i would like to save to an sql2000 database and
then retreave it later on.  I currently have the field set as an sql2000 ->
VarBinary type of field.  Any suggestions in vb.net???  When i run the
current code i get an: "An unhandled exception of type

I found another issue with this same heading, but mine is different so please
read on...
I have the following table:
CREATE TABLE [UsersSF] (

I have an application and Access DB that i deployed. the machine that the app
and db are installed on is about 5 hours away and i don't have Access to it.
I have to update one of the stored queries that i created in the DB itself
and i am trying to come up with a simple way to ...

We currently store a central database in C:\Documents And Settings\All
Users\Application Data\<Company Name>\
This database needs to be written to by anyone that logs into the
computer and runs our app. The problem is that Restricted Users only

Im recently implementing some app that provides connectivity with asp.net
and unify dataserver, these transactions reports sintax errors, so I wanna
see these error verbose, the connectivity is only possible throw odbc im
using ado.net objects for odbc, I put the odbc tracer on ...

I'm accessing a DataRow through a DataView using "dv[i]", how can I find
which index this dataRow has in it's DataTable's Rows collection?
-NorCan

How can I udpate a colum?
I like to update a column with a date. Every row in this column should have
the same value that i set.
Thanks alot

I am emulating the old connected recordset of the ado days using a
static connection to the db and a cursor in my vb.net application.  The
cursor is opened as a "scroll keyset" because I need to be able to jump
around to any record at any time and the "cursor threshold" is set to

To get a XmlNode from an untyped DataSet with Path is no problem at all. It
works fine and gives you the expected node a long you use the rigth XPath
exprssion with SelectSingleNode. I've done that in many projekts succesfully
with untyped DataSets!

I wanted to insert a record in to a database and then get the autonumber of
the row that is inserted using AdoDotnet.
this can be easily done in ADO like below.
TCHAR* szSQL = { _T( "select processid,identifier,emailid,statusmsg from

Can I change my default schema in oracle connection string ?
Thank you,
Alan