1. I have a table in the database (SQL Server) that I created an
adapter for using Visual Studio 2005.  It has
select/insert/delete/update methods created, but not using stored
procedures, because I check the option that says:

I have a SQlDataSource that binds to a GridView. I am using a
parameterized FilterExpression to filter the results.
If i use MyField = '{0}' it works fine. But i need to do MyField !=
'{0}'. This breaks with an error: 'Cannot interpret token '!' at

i had just posted the following:
---------------------------------
i have ms sql server 2005 installed on my system (installed when i installed
2005) and it is running(i can see it is running as a service), but it does

I am sure this is going to be obvious, but I can't see it. I have a
strong typed dataset called "Clients" with two columns: ClientName ,
ClientCode. I want to attach a ComboBox to this dataset. Here is the
code:

I have a ADO.NET - Connection to an Excel file. UPDATE and INSERT works
fine. Now I want to DELETE lines, but it doesn't works (I get an error
message "Deleting data in a linked table is not supported by this ISAM.").
Microsoft says, that there is no way to to this

I'm currently writing a windows-forms based application in C# using
visual studio express.  It interfaces with an Access Database backend
and at the moment, I have a seperate connection for every function
(such as a button click) that I use.  This means that at the moment, my

I try to do the following thing:
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM test",new
SqlConnection(this.ConnectionString));
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

I rewrote an existing VB6 app in .NET as a learning tool.
Works good.
The problem is, it won't run in any folder except the folder
that it was build in.  I get an unhanded exception error

I am having problems using a datareaders within a transaction. I have
attached a stripped down version of my code that exposes the problem.
The problem occurs when I commit the transaction. I get an exception
"There is already an open DataReader associated with this Command which

Why? please tell me if you know
System.AccessViolationException: Attempted to read or write protected
memory. This is often an indication that other memory is corrupt.
  at System.Data.Common.UnsafeNativeMethods.IRowset.GetData(IntPtr

I've seen this ASP.NET tutorial: "Creating a data access layer". It worked
prefectly well in asp.net and vb.net 2005.  Now, i want to do the same with
VB 2005 Express Edition, but connected to an Oracle Database.
Can this be done?

I am attempting to send an email using ASP.NET 1.1's Mail.SmtpMail.Send()
method. My code contains all of the following:
Dim mailmsg As New Mail.MailMessage
Mail.SmtpMail.SmtpServer =

Folks,
What are the differences in terms of functionality and performance
regarding connections to a DB2 database using the OleDB provider <
IBMDA400.DataSource.1 > versus an ADO.NET or IBM provided class like <

i'd like to know the best practice for a utility i want to include in
my recent project. the requirements is like this,
There is a database (access or SQL Server 2005) we use as back-end. now
i do have some transaction table where i get 50-100+ records per

Not so long ago I accidentally noticed this new DataColumn.DateTimeMode
property.
I thought myself: what a cool concept! Perhaps data bound controls can use
this setting to automatically perform conversion to/from UTC time when