I have a dataset i need to insert new datarow in if the row is new and
doesn't exist in the dataset, other wise i will only need to update the
existing row.
for example, dataset with "ID" and "Name" fields can have a new row

When assigning values to DataSource in a connection string (say with the
SqlConnectionStringBuilder), I have generally used either the IP address or
the name of the SQL Server instance as a value.
With SQL Server 2005 I understand that a given computer can have multiple

Hello, friends,
We have a connection string in our .net app configuration file like the
follows:
"packet size=4096;data source=server349;persist security info=False;initial

Is there a way to know if a DataRow is hidden by an active
DefaultView.Filter of its DataTable? In other words, is there any way to
know if a specific DataRow will be iterated too ("visible") when iterating
the DataRowView collection of the filtered DataView?

I'm going to be using SQL Server (thanks for that advice) for a distributed
application and I'd appreciate any advice on architecture.
The application is similar to a membership management system at a multi-site
chain -- like a fitness center chain.  

hejdig.
Have anybody had any success with implementing TableAdapters together with
tables with an int PK that is set by the database?
The problem is that when the row is inserted into the dataset's datatable,

I have some code which takes a datatable, makes some changes to the
rows, and uses the dataadapter.update(datatable) command to write the
changes back to the db.  When I look at the changed rows in the
datatable (and export them out to xml), the updated fields are present.

If i am running a Windows Forms application from a remote PC, and the
application creates a dataset, am i right in assuming that the dataset will
reside in the memory of the remote PC ? And if the client is running the
application from his own PC, then the dataset would be in the ...

I have a Datarow()-Array !
Dim dvAuf As DataRow()
dvAuf = dtAuftrag.Select("artnr = 'xyz'")
while dvAuf.GetUpperBound(0) > 0

Is there a way to Memory Stream Information into a WebBrowser Control?
I have an SQL Image (could be any file type)  that I would like to
display in a WebBrowser Control, currently I have to File Stream this
to a temporary location and then display it in the WebBrowser.  I would

I can use the form designer to disable (any of the) BindingNavigator's items,
(i.e. the MoveFirst, MovePrev, Delete, Add, etc. items). In the designer the
items are greyed out and the properties say they are disabled. However, when
the program runs they are all enabled. If I ...

Using an asp:DataGrid on a per row basis is there a way to make a certain cell or row
have red, yellow, or white background based on the value of one column in the data row?
e.g.
if myvalue < 0.0

I need to store html formated email for a client in a SQL Server 2000
database.  First off, is it possible, and if so, can any one help with
finding the best way to save and retrieve it?
Any help would be greatly appreciated.

Using VC to write a small app that displays data extracted from a database
into a typed DataSet. That all works fine.
I have three tables - Parent, Child, and then each record in the Child table
also has children.

I'm developing a new .NET application but using the same stored procedures
(Sql Server 2000) that are in use by an old client server application. The
problem is that it is common when refactoring stored procedures, to change
the name of the parameters. It was not a problem since ...