I have about 10 dropdownlists that I need to fill when the page loads.
At the moment I am doing the following over and over for each dropdown:
*****************************************************************
Sub GetExperience(sender As Object, e As System.EventArgs)

I have an OLEDB DataAdapter and cannot create a Dataset to use with the
adapter because the SelectCommand contains a parameter.  Is there a work
around for this?
Any Help is appreciated.

I have a very simple page that has a dataadapter which in turn loads a
recordset.
This has been created using drag and drop (VS.NET). I am passing a URL
parameter to the page. This is retreaved with Request.QueryString("hedordID").

So I can find this when I google it again sometime because I've
forgotten the fix :)
       <Description("Wrapper class for Data Access block
ExecuteNonQuery")> _

On a form, I want the user to be prompted if he moves to a different record
to ask him if he wants to commit his changes.
They are moving from Access and very used to things saving on its own.
So I want to make sure they are prompted for information to be saved, if

Is there possible to connect to Oracle database
using ADO.NET without installing Oracle Client software
on client machine?
Maybe anybody knows easy way of distributing and configuring

I have designed an sql query to retrieve data from a table based on an
integer field which happens to be the primary key for the table.
The table looks like this:
tbl_players

Hi, there is a web app .net that a programmer who is no longer here wrote and
somehow a connection is currently left open so when the application tries to
open it an error is generated (connection is already open).
Just wondering if there is a remote way to close the connection as ...

I could not find this bug mentioned in the MSDN KB and only found one
mention in USENET after lots of searching:
  http://tinyurl.com/ckvt4
I could not get aggregate child column expressions to work when they

Thanks for any recommendations....
Especially needed:
*  Understanding of what to do to handle concurrency issues
*  Best practices overall.

OK, here's my situation.  I am an unemployed programmer with experience in
VC++ using DAO with an Access DB.  I am now learning .NET so that I can get a
job.  I have installed Windows XP Pro and Visual Studio .NET 2003 Academic.  I
also have Microsoft Office, which has Access 97.

I'm getting the following error when running my web app on my localhost web
server:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
I drag and dropped an sqlconnection1 object onto my web from from the server

I am using the WriteXml method to generate an XML doc.  The method adds the
xmlns = "http://mywebsiteaddress/myschema.xsd to my root element.  I also
have an XSL with a for-each loop that transforms my XML into HTML.  If I
manually delete the xmlns section from the XML' root ...

Small Design question - I want to express the data in a relational database
in xml to create many different "reports."
For example:
<Customers>

I'm getting there......
I can update using and oledbdataadapter by calling the
dataadapter1.update(rset) command, but i don't know how to call the delete or
insert