Hi ;
I'm trying to figurer out a way to serialize the SqlCommand object:
Myu objective is to create a SqlCommand object set up the CommandText, all
needed Parameters with there values then Serialize the objet to binary format

I think this is a more architecturaly question but I couldn't find any news
group about this topic.
If you read Designing Data Tier Components and Passing Data Through Tires it
says that Data Access Logic Components should be used to fetch data from the

I have a webform with several TextBoxes. How can i bind the data to all the
fields without having to issue TextBox1.DataBind(); textBox2.databind() and
so on?
Also, when assigning data from the fields to the query or stored procedure

I am currently moving an old thick client solution to ASP.NET and I am
trying to replicate as much of the current UI as possible in an effort to
migrate users with a minimum of training.
On one particular form, there are DB navigate buttons which will allow for

I wish to create a small .NET app that will help an end user to create my
applications database. I wanted to provide them with a list of all SQLServers
on a network and then all databases on a chosen server. What is the best way
of getting these lists? Is it best to use ADO or ...

in my ASP.NET application I've a problem with an ODBConnection.
It is very slow (about 30 seconds) on first connection.
I've tryed differents DBMS, postgres and sql server.
Do you have any idea or suggestion?

Was wondering if you could shed any light on this:
Process - Load XSD into data set; Load data into tables; Write data out
in XML
Will paste in the XSD as the end of my post.

What is the difference (in usage) of the datatable events ColumnChanged and
ColumnChanging (the same applies to the rowchanged and row changing and
rowdeleted and rowdeleting)? It looks to me that one of the events:
ColumnChanged or ColumnChanging would suffice.

HI. I have a dataset with two tables. Table 1 is parent and table 2 is
child. Am populating a single datagrid with records from child table
derived from a single parent record. I am then allowing users to edit
child records in datagrid. Users have an update option for each row in

I have a table that I want to run a query on, and I'd ideally like a
"live" view of the data, so that I can add, delete, or modify rows, and
that stuff shows up in the original table.  Some more details about
what I want to do:

I have a database with quite a few tables which depends on each other. I
have defined relationships between the tables in the database.
Now my problem is when i use a dataset (c#) to access these tables, i dont
get any relationships/constraints in the table object.

I extended the DataGridTextBoxColmun to be able to color an individual cell
in my datagrid. It works fine, but when I click on a cell, all the colored
cells in that row get the default color again. That's not what I intended.
The colored cells should stay colored, even when I ...

I am trying to execute a time-consuming stored procedure in my application.
When I run the stored procedure through Query Analyzer, it takes some time
but returns results in about 15-20 secs. However, when I run the same
procedure by using ExecuteScalar/ExecuteNonQuery it seems to ...

Can anyone suggest why the following does not work?
-----------------
   Public Function SafeDbText(ByVal Value As Object) As String
       Try

I am trying to filter rows in a DataView, and I'm experimenting with
the .RowFilter and .FindRows members of the DataView class.  I
understand that .RowFilter re-builds the indices and hurts
performance, so I'd like to use .FindRows if possible.