Let say I have an Sql statement like
UPDATE Customer SET name=@name WHERE customerId=@customerId
I see that one of the overloaded SqlParameter constructor got the following
signature:

This post is on behalf of a colleague.
VB.NET Windows Forms application.
Dataadapter,datagrid. Selecting from 2 tables with OUTER JOIN.
What is the easiest/best way to implement the UPDATE ?

When I click on Button1 than I load an xml file in a dataset.
The dataset table contains 5 rows
When I click on Button2 I want to write the dataset back to xml.
But it contains no data.

If I specify a type of parameter as varchar or decimal, etc, is there a time
when you are required to specify the size of that param as well.  Or is it
safe to simply specify name, direction, type and value?  To this point I
have used that and it works fine, but I'm wondering if ...

Hello,
I have a table with brand_code and brand_name, 2 columns. brand_code is PK.
I want to retrieve these values from the database and fill to select control.
I tried using datareader.

hi
I was wondering if someone could help me. I am developing a form in vb
which has a MS Access db running behind it. on the from i have a
datagrid which retrieves the information from that db and outputs it to

I want to use SqlParameter and SqlDataReader to get records somthing like
this:
Select * from Issues
where ProjectID in (3, 4, 17, 55)

I saw a review where you strongly endorsed the FarPoint spread control.
Pretty slick, so I bought a license too. However ....
When I want to bind a dataset to the control and not show all columns, I
have to hide the ID and timestamp columns in the initial layout, then bind

I want to do the following, but I can't seem to get it right.  It never
returns any data, even though rows do match.  What's the correct way to use
LIKE with parameters?
ie, the following is not working for me:

I am curious if it necessary or desireable to put [ ] around string data that
is stored in sql.  I need to create several varchar columns and one text
column.  Are there times when string data going into these fields requires
brackets?

In my web service application, I am very interested in minimizing the amount
of data that I have to transmit over the internet.  I have thousands of rows
so I am interested in minimizing unnecessary characters where ever possible.  
When I was first starting, it was easier to just ...

I have a data access dll developed using oledb ado.net to connect to
Sybase12 in c#.net frame work 1.1. It works in .net window application
or .net command line application. But a simple data query in asp.net
using iis5.1 fails with the following error message:

I'm looking for some guidance on filling multiple DataSet DataTables based on
a "complex" query.
Given 3 tables:   Parent,  ChildOne, and ChildTwo, where  ChildOne.ParentID
and ChildTwo.ParentID relate to Parent.ParentID.

What is the most efficient VB ADO.net method to pull read only data  from a
SQL Server database? My entire application reads / no writes to SQL Server
database. I want to display the results from stored procedures in a data
table.

Francois,
Will you check your date and time settings as well as your localization,
they seems for me wrong or you are somebody from the future,
Thanks