Is it possible to do run a select query on a dataset from a web method using
a dataadapter? A code example would be great. If not, how can we grab hold
of the remote dataset data in a local table?
Thanks

I have my data in a DataSet class. But the data could changed on the SQL
Server from an other user. How can I know, that the data is changed?
It will be very usefull, if I could define a trigger on the SQL Server, and
that could send me an event to my program, and the I can refill ...

I have a dataset from a web service. I want to use a dataadapter with the
dataset. What connection string should I use so the da knows that it is
acting on the remote db associated with the web service dataset?
Thanks

i have read a article :
"Als o remember that each .NET assembly gets a unique PID. This means that
each new assembly you run gets its own pool??regardless of the similarity of
function or the fact that their ConnectionString values are identical."

Once a user clicks on the "add" button it adds the new record to the DB but
i want at the same time to get the primarykey of the record i just added. Is
this possible without writing a new "SELECT * bla bla"? and if so, how 2?
thx in advance,

I have several apps that use a roll your own approach, but I am embarking on
a project which will not allow that with the time constraints.
I have gened up a little app to try the databinding approach.  Simply it is
a page to maintain the Territories table in Northwind (SQL Server).

I have opened a datset from an Oracle Database.
I am trying to  'Select' a non key column.
strFind = "INTERNAL_EMPL_ID = '" & provId & "'" - This yields :
    "INTERNAL_EMPL_ID = '0000015615'"

ADO.net using VB.net
I've written a simple application which will import data from one MS Access db
to another.  The file is on our 2K Server.
The application works fine when I run it from VB.net... but when I create an

For some reason I am having brain freeze and I am not even eating ice cream.
I know this is a very simple question for some.
I am filling a dataset with some information from a table off an AS400.
Some of the time this table might have 0 to 1 record.  Most times it will

I need to update one access table from another in a way that all new records
are inserted and all existing records are updated. Is there an example of
this that I can follow?
Thanks

I've got a puzzling situation.  I have a strongly-typed DataSet with 3
tables which I want to copy into a generic DataSet.  So I do this:
DataSet ds = null;
StrongDataSet dsStrong = new StrongDataSet();

I am having this problem with an application which seems to call
DBConcurrencyException when calling the Update Method to my DataAdapter.
It seems to happen only when I add a new record to my DataTable and this is
the first row, if I have 2 rows the exception is not thrown. I really ...

When running the .ASPX program, I recieved the following error
"Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'sa'."
I reinstalled Sql Server and issue is fixed. However, the issue occur again

I have the code below and for some reason when I run it, nothing shows
in the front end.
I put in a label and that does not show a value either.
Both pages are below; viewAccess.aspx (html) and viewAccess.aspx.vb

trying to add a new row by entering it directly in datagrid bound to dataview.
after typing in value, new row disappears.
primary key is set to autoincrement.
also how to assign another value to another column in datatable at the same time this datarow is being created through ...