I have a strongly typed dataset generated by vs 2008. I am trying to fill in
one of the datatables in the dataset and then cerate a dataview from the
datatable. I have used the below code but it does not work.
   Public ds As MyDS

I am looking for a sample master-detail database winform application that
handles multi-user issues like concurrency violations to inspect its code
for good db development practices. Would appreciate link to any such app.
Many Thanks

(this is related to my previous post yesterday but I think i'm asking a
distinct question so it's a new post)
say I have a stored procedure that does 3 updates:
update table1 set  .... where ...

I am new to ADO.Net and trying to use DataAdapter & DataSet.
I read the data from database table into dataset using DataAdapter.
Do I have to use the same DataAdapter object to update and commit the
changes made to DataSet?

Say you have a SQL Server connection string in the following format,
where MySqlServer is a server connected a local network
"data source=MySqlServer; Initial Catalog=MyDatabase; Integrated
Security=FALSE; User ID=MyUserName; Password=MyPassword; Pooling=True;

Does the DataTable.Load() method do its operation in one database round-trip
when it is passed a DataReader?

I am looking for a sample database app that demonstrates how a reasonably
written database app should look like in code. Any recommendations would be
appreciated.
Many Thanks

I am trying to get (and transfer over ASP.NET) some encrypted data
from some MySQL fields. Since the data contains many unicode
characters, I tried to get the data as a series of ASCII values,
transfer those numeric values over ASP.NET. I had no problem doing

I have an application (that I wrote) that use ADO.NET to access an JET
(Access) database. My application was working fine, until I installed
and uninstalled a trial version of Microsoft Office 2007. I don't know
if it was working between the installation and uninstallation of ...

If I use a command that contains field name aliases, I get a different
result for _cmdBldr.GetUpdateCommand().CommandText, depending on
whether I am connected to SQL Server 2005 or Oracle 10g.
Here is the code in question:

in my .net application, I am using IDbCommand.ExecuteNonQuery() to update a
single row. as a matter of good programming practice, I check the "rows
affected" return value to verify that only 1 row was updated.
the problem comes if there is a database trigger on the table which ...

VB.net 2005 CLR 2.0
I have a dataset with a datatable...there is one datetime field, and about
30 double fields.
The datetime field is in UTC Time, but my client application needs to see

Beginner question:
Can anyone point me in the right direction for learning (url's, books, etc.)
how to connect to an sql or access database through code rather than using
typed datasets? What I am most interested in is sample code that would

I have an Oracle database running on Windows Server 2003, for which I have
created a System DSN named "MyDSN" in the ODBC Administrator tool. I can test
the connection without problems in the ODBC Administrator, however when I use
conn = gcnew OdbcConnection("DSN=MyDSN;UID=User ...

Is there a way to get an error that is raised from a sql server stored
procedure when executed from a sqlcommand object? thanks!