I've got an app that retrieves a datatable from a third-party database
(the db is hosted by a partner company; we get the data via a web
service) containing around 100 rows of product SKUs.
I need to take those 100 SKUs, pass them to our SQL Server db to

I am looking for information on efficient use of ADO .Net.
I am totally new to this world (Unix/C++ background) and am looking for
rules-of-thumb regarding some basic concepts (note this is for WinForms app
in C#) -

Is there a limit to how many tables you can have in a dataset?  I have a
situation where it would really be advantageous to use one main dataset to
marshal various tables via a web service.  the problem is that we have a
group of about 50 tables that are all very closely related ...

In the returned records in a DataSet, all the VARCHAR() field values are
appended many spaces. When displaying each value, we have to use
.ToString().Trim(). This is really annoying. Do we have a way to do this more
efficiently, say, only trimmed VARCHAR() field values are ...

Hi there - this is driving me nuts...
I have a dataset that contains two datatables. One datatable
(SalesMainTable) contains the main crux of an SQL SPROC and I've had to
create another datatable (InvSalesTable) that is not the same shape or size

I have a checkbox, date time picker & few comboboxes bound to the same
dataset
I know checkbox, datetimepicker won't let me have null when I call AddNew()
Also because if I bind my combo boxes to the same dataset they all change

How do I search  row values in the dataset?
is there any function to do it? suppose i've two columns named 'item' &
'price'
I want to search a table which have been filled in the dataset for

Hello, All!
I have a Column object with String DataType, so when it's assigned with
Double value it gets converted to String. Convertion uses default locale
which in my case has "," as NumberDecimalSeparator.

I'm new to ADO.NET and I have 2 questions:
1. I need to programmatically create a copy of a table (say, 'table1'),
named something like 'table1_copy', containing only the structure of the
source table and no data.

I've read other posts concerning unsuccessful deletes, but I can't find
anything that tells me what is wrong
with my code.  After I delete() the row in the dataset, the dataset is empty
and I get 0 as the value for

I just started my first .NET program
I keep it very simple at the moment but have problems declaring somthing:
I have two projects : a webservice and a consoleapp to test some functions
of the webservice

I have tested a procedure in TOAD and it functions as expected, meaning for
this particular transaction it returns and error message and performs a
rollback within the procedure.
When I call this stored procedure from within ASP.Net with the same data,

I've read other posts concerning unsuccessful deletes, but I can't find
anything that tells me what is wrong
with my code.  After I delete() the row in the dataset, the dataset is empty
and I get 0 as the value for

I have a strongly typed dataset with 3 related tables:
 PayrollChecks (Parent)
 PayrollCredits (Child of PayrollChecks 1 to many)
 PayrollDeductions (Child of PayrollChecks 1 to many)

I am trying to use the PropertyGrid Control to display database schema.
So far so good. The property grid control displays the database field
properties in the property grid.
My Question is: