I'm using SqlDependency quite a lot and really love it, but there are
two things I just can't seem to find anywhere on MSDN or elsewhere.
1. One of the SqlDependency constructors, allows you to pass a "string
options", which sounds great. But IntelliSense on this item is useless

I want to create a function which take a TablAdapter as parameter and return
a typed DataTable. Like:
DataTable GetDataTable(TableAdapter adp)
{

I have a directory on my site that I keep a bunch of text files in (this
directory is "/poetry/poems/"). The Application keeps the first line of each
of these files in an HttpApplicationState variable as a SortedList. When I
add or modify a file in this directory, I want to ...

I am coming from a shop that is historically is winforms and we work in our own workareas on network drives. Primarily so  the daily work gets backed up but also so it is easy to look at each other's work in progress. we aren't all in the same location.  The version control and ...

Hi, I am just beginning to learn to use the .Net framework and recently
I confront a problem with the datagrid.
I create an .asp file. There are two buttons, one datagrid on the
screen.

The problem I have is that a query string works if hard-coded but
if I pass a variable to it, it does not work as shown here.
Dim queryString, q1, q2 As String
This works:

I'm quite new to database development and am trying
Visual Studio with ADO.NET for the first time (Borland
user before). So please apologize my lack of experience
with the tool. (More precise, I'm using MS Visual C# 2005 Express)

I have a DataGridView with RowHeadersVisible = False.  When a user
clicks on a cell how do I highlight the entire row.  And secondly how
to (syntax) get the value of cells into variables.  I've looked at
SelectedRow, CurrentRow, but just dont' get it.

I use ADO.NET to develop my project.
(use SqlClient.SqlDataConnection object to conection SQL 2000)
It is stranger that Connection.Open() method spect 12 seconds to execute in
one of our servers, but it is faster in another server, not more than 1

When I try to update my data source using
DA_InstalledItems.Update(DS_InstalledItems)
I get this error:
Violation of PRIMARY KEY constraint 'PK_VehicleItems'. Cannot insert

I'm new in VS 2005.
I noticed that in the toolbox there is no dataadapter!!
In a previous version there was a data adapter icon in toolbox  and is was
easy to drag to a form, is it posible to add the data adapter icon to the

I need to set security for row level but not based on Database user's
login. It should be based on the user table login. For the particular
user I need to allow only the particular records to access insert,
update delete and select.

This is the most excruciating error I have ever had to deal with in 10 years
of programming with Visual Basic.  
I am getting an error albeit intermittent most of the time, but I am now
getting it consistently on one of my aspx pages.

I have a production environment where I have a 2-node SQL 2005 Cluster
running on boxes which are part of a domain "MyCompany". I have setup a
domain user account called "netasp" and then given it permissions to the
database. I then setup a new App Pool in IIS on my Web Server ...

Hi!,
Which is the default provider for ADO.NET??
Regards,
Baren