I'm using a grid and when a user edits the grid, if they leave a field
null I get a system.formatException error (string not in correct
format).
The stored procedure allows nulls for this float field.

Can I pass a DataSet to a Stored Procedure (in Sql Server 2000)?
If yes, Do I just specify the parameters and let the SqlDataAdapter handle
passing the rows of data from the DataSet into the Stored Procedure?
Have you a good reference I can go to?

I am trying to loop throught the results of my query, my table has columns
that have colours and sizes with each colour have many sizes. Currently the
loop is just duplicating the colour size values for each colour. So for
instance if the colour has 2 of a particluar size the code ...

I have been trying to populate 2 or more controls from two *different*
(related) tables for the last week without success.
My latest try is: 2 simple SELECT statements in 2 adapters that populate the
*same* dataset and then i define a relation among the two tables.

Hi Gurus,
I have implemented a ColumnChange event handler for my Datatable. When one
of the column is modified by the user, in the columnchange event handler, I
am setting values for other columns of the same row of the same datatable.

I have a common Customer-Orders-OrderRows-Products hierarchy in my database.
Let's say I'd like to fetch a customer and all it's orders, rows and
products. Today we have methods on different DataAccessLogicComponents to
retrieve the data i.e:

I hope this is the right newsgroup.  I have written a program for a database
install.  I have a file that contains the T-SQL code to create the database
(I generated the file from SQL2000 Enterprise manager).  In the program I
break the file up based on the GO statments within ...

I would like some clarification on how I can use Datasets and ADO.NET
with Stored Procedures.  I have read various multi tier architecture
discussions on performing Object/ RDMS maintenance, and there seems to
be a concensous that Stored Procedures are the most effective means to

Dealing with large DataTables in a DataSet.  I want to setup indexes
on certain DataColumns in DataTables before I do any
selection/finding/filtering to speed things up.  How can I do that?
Thanks.

I am having a data disappearance problem.  On an edit routine, I have one
row of data being pulled into the dataset that is then displayed on a form.
The fields are bound to their respective controls.  At the time that the SQL
query is run and that one data row is displayed, I am ...

I have a typed dataset with a column GROSSWEIGHT defined as an INT in my
MySQL database. My strongly typed autogenerated DataSet defines the
GROSSWEIGHT column as datatype "long".
               <xs:element name="GROSSWEIGHT" type="xs:long" minOccurs="0"

I'm new to ADO.NET, and so far I am not too impressed.
After plowing through the pages and pages of fancy disconnected
relational blah blah, I find myself wanting to do something so simple
- that you wouldn't think twice about it in SQL.  But in ADO.NET it

Can anybody tell me, how to create DSN dynamically using ASP.NET
Thanks
Shibu

I've been working from the assumption that all connections within a
pool should behave the same, but I'm wondering how that is possible if
some properties of the connection can be set from both the connection
string and from a property.  For an example with minor effect, let's

If I have a dataset and ask:
If TypeOf ds.Tables(0).Columns(i).DataType Is System.String Then
 this returns FALSE
Typing