Hi, a simple question.
Say I have a connection object in a button event handler. I want to add a
message box that pops up to say the state of the connection has changed
whenever I open the connection by pressing the button in which the instance

I'm having a really simple problem - I can't seem to insert a null value
into the database. When I do it tells me that the procedure expects the parameter
and that I'm not providing it.
Well, I am, its just a null value!

I'm writnng a support routine which helps log on to instances of SQL Server.
Currently I populate a DropDownList with known names of SQL Server Instances.
What I would like is a simple way (if possible) to populate this control by
shouting into the network and listening for ...

my client sends a dataset with changes to my server. These changes have been
created by the GetChanges method of the dataset.
What's the easiest way to update the table on the server with these changes?
What a Stored Procedure look like to do this?

Just as we use RowFilter, to choose a subset of rows , i wish to get s
subset of the columns. The workaround i could think of was to read the
DataTable again with only required columns eg - SELECT COL1 FROM DT1 where
DT1 is the memory datatable.

I have a SQLExpress MDF file that I'm using for membership data, etc... in
my ASP.NET 2.0 website.
1.  If I want to use the website MDF during development on my local machine
can I simply copy the MDF from the website and replace the one on my dev

Where is the mapping designer in VS2005 DataSet designer? I cannot find it!
Thank you,
Alan

Appologies for cross posting this but languages.vb may not be the correct
place to have asked in hindsight.
Im creating a dotnet windows form app that will run a given TSL script
across a domain of sql servers with the same login credentials(for this

When I initialize my app, I put up a "splash" screen with a progress bar
while the app fills its datasets.  The fill takes longer sometimes than it
does other times.  Is there anyway to measure/determine the progress of the
fill operation?  I wish to know this so that I can ...

I konw Visual Studio Express Editions Visual Designers do not work with SQL
Server remote instances. But Are you violating the licence agreement if you
change the connection string in the configuration file to point to a remote
SQL Server instance when you deploy your ...

Is it possible to use a parameter in conjuntion with an IN statement?
For example, if  I have the following SQL,
select * from table where key in ('1','2','3')
How can I make the values in the IN be a param?  If I do the following.

I am trying to find a way to verify if a SQL server is available before I try
to make a connection to it. My process is pulling data from SQL into a
spreadsheet, but when the primary SQL server is unavailable, the sheet locks
up for long periods of time while it is waiting to ...

Okay, I've got my dataset, I've made updates to it, now how do I  update sql
from the revised dataset?

I'm writting a simpe application. User enters an SQL query, and he
receives the query result in report like table.
I have a question: can I solve this problem with Crystal Report?
If so, some code somples would be greate. For example I'd appreciate

This is my code, and nothing appears to happen.  The dataset has 3 rows, I
do an insert, and the dataset still has 3 rows.  What am I missing or doing
wrong?  There is nothing wrong with the query, or the connection, and I get
no errors, it just doesn't return the dataset with ...