I need to write my first vb.net/sql server app and I just need pointers as
to how pros do it. My app is a multi-user apps which needs to refresh from
what other users are adding to the backend sql server db.
My question is;

I am trying to create a parametrized query based on City on the customers
table in Northwind.mdb. The sql version on Northwnd.mdf works fine using
@City in the query, but when I try to create it for the access dataset, it
puts single quotes around the '@City'. Is there another ...

Say I have a procedure that returns a return code like the following...
CREATE PROCEDURE TestProc
AS
BEGIN

Hi, is there any underlying difference between loading a generic collection
from a reader using the two methods:
List<User> colUsers = new List<Users>();
           while (reader.Read())

When accessing a BLOB from a DB using getbytes, 0 bytes are returned. The
same thing worked with VS2003. The recent environmental change was from
VS2003 to VS2005 and also from .NET 1.1 to .NET 2.0.
/* Here is the function that reads the blob from the db */

Below is the piece of code i am using for my connection object &
database transaction.
private SqlConnection _mConnection;
       private SqlCommand _mCommand;

In ADO I could read the property .DefinedSize of a field of a recordset to
determine the max size of the field. This is very usefull to set the
maxlength property of a textbox. How can this value be determined in the
ADONET- Dataset or datatable.

I have developed the following logic to handle db concurrency violations. I
just wonder if someone can tell me if it is correct or if  I need a
different approach.Would love to know how pros handle it.
Thanks

As a newbie to ADO.NET I am struggling with the following:
I have an ODBC data table that I want to use a source for updates to a
SQL server table, I envisage the sql query having the following
structure:-

My company is building a multi-tenant internet-facing web app in ASP.NET
 / SQL 2005.  We can't therefore use NT authentication, and must use
our own web forms authentication, but still need to use SQL's "Database
User"-based security so that we can encapsulate security in ...

I can use the SqlDataSourceEnumerator to get a list of SQL Server instances.
How do I obtain a list of databases in a given SQL Server instance?

Hi Gang,
I'm curious if this is a bug in Studio or not.  Here's the background:  Our
system has SQL Server installed and our DBA's all create our databases.  We
are not DBOs in any of those databases.  We do have rights to create stored

Is it possible to compact and repair an external access 200 database via
code?
Thanks
Regards

I have a stored procedure that I let the wizard create a function in the
QueriesTableAdapter class. Some of the parameters to the stored procedure
clearly allow for nulls (AllowDBNull) but somehow the wizard refused to add
the Global.System.Nullable(Of String) to the generated ...

Hi,  i am using a list named ListaCombo to populate a combo box with a
query,  but when i execute the code,
               comboBox1.DisplayMember = "Display"; it thows a "The
connection is already Open (state=Open)" error messages.