I am trying to find what is the best method to locate a row in a DataSet
Table, using a Primary Key.  I need to find the row and set focus on
that row.  I know of two methods, one is using Dataview and the other is
using Table.Rows.Find.

This is my connectionstring on a Oracle database:
con = New OdbcConnection("Driver={SQL server};Server=MyPC;Persist Security
info=False;Trusted_Connection=yes;DATABASE=FieldSup;")
When I want to connect I get exception error 42000 microsoft logon failed.

I understand it is possible to create a SQL server table (with primary keys,
default values, etc) using ado.net/c#.
Can someone point me in the right direction about how to do this please
(with a link to an example etc).

IŽm try to load a recordset from Oracle Strored Procedure, if the
procedure donŽt has input parameters i can do that, but if the
procedure need input parameter the webform fail.
This is my code

I remember the way I dealt with identity fields in my datasets that were a
updating sql 2000 table with an identity field was to set (I think)
autoincrement, and seed/increment to -1 and it worked fine.  I cannot find
the documentation on the proper syntax of how to do this now ...

I am using that code to execute SP that returns xml auto:
SqlConnection conn = new SqlConnection("Initial Catalog=manpower;Data
Source=devsrv01;uid=sa;pwd=;");
XmlReader xreader = SqlHelper.ExecuteXmlReader(conn,

Hey Group,
Could sombody possibly have a look at the following code for me please?
It all works fine but when I click on the btnUpdate_Click, after making
changes to the data, it just seems to load the old Dataset again, I checked

i want to build an application..my database is situated at
webserver.... can i acces data using vb.net windows form which architecture
is best ( I want to use all the vb.net windows forms features for this) can
u tell me how to connect a database situated at http://www.mydomian.com

What is the quickest way to read from a DataReader? Any properties I
can set to speed up the default behavior?

i wrote an application (scheduler / timeline ) like outlook calendar.
This app is bound to a sql database . Everything works fine, add,
update , etc.
Now, my problem is that from now on more than one guy will use this

How do you change the AllowNull  in a datagridTextbox programmatically? One of my columns is set to false and the others true, and i cant change
thanks

Can I load XmlReader into xml transformation with converting to any string
first?

I am learning how to use DAAB.
I need to execute a stored procedure and return the result as a stream.
Can someone help, please?

How would I use it to execute an SQL stored procedure that returns flat xml
What are good resources to learn how to use Data Access Application Block
Thank

Hi. I get a system.data.strongtypingexception error msg in my datarow columns where they have a null value.  Why and how should I address it?  This is the second post for this, the other disappeared.  Thanks