I'm hoping someone can tell me the best way to test for null values in a
DataRow object before accessing the field in question. I have found one
example, but it seemed quite verbose and I'm sure in the past I've seen more
elegant solutions

I've got a Command that has a parameter. Sometimes it will be a
uniqueidentifier (Guid) but there is also the case of looking for the column
being null.
How do I tell the Parameter that I'm looking for NULLs?  If I set .Value =

Folks,
I'd like to be able to read and display graphics stored inside an
IMAGE field in SQL Server.
How to read that stream of bytes is not the problem - but how can I

I'm having an issue accessing fields in a typed dataset while using data binding.  I'm using a BindingManagerBase and binding context with the .AddNew() (which is supposed to automatically create new row on datatable and go there) method on BMB and then EndCurrentEdit().  The ...

I am trying to develop a fairly complex application using Visual Studio, (2003)
the .net framework 1.1, and Oracle 9i as the database.  I'm using VB.NET
We found problems with the OLEDB Data Provider that were serious, and
so we took the time to switch our code to the OracleClient ...

H
In our application we use stored procedures to insert,update, delete and select rows from the database.  I am using a dataset object to manipulate rows returned from the database
If I do an update or delete using the stored procedures, I want the dataset to refresh to see these ...

I'm connecting to and trying to read a fixed width text file.  The problem
I'm having is when there is a column with % data in in (like 12.5%).  I
would like to read this in as .125, but if I could even get it in as 12.5 I
would be happy.   If I specify Text (in the Schema.ini) for ...

i need to loop through a table in a dataset, how do i do that useing for
each statement?

I'm just starting to work with C# and the ADO.NET.
As a test project i've choosen a simple Customer-Management Application.
So here's my problem:
In my main form I have a DataGrid that should display all my Customers.

Can someone point me an example for using Ado .Net in a C/S applicaiton in a
connected mode ?
I want to achieve something like Ado's server side cursor.
Thanks

I have an access database and
1. Do I need a new connection to a database for each dataset I create?
2. do I need to close the connection afterm creating the dataset? I believe
I don't need because when I want to save changes to the dataset I need the

Situation:
Using a dataset's UpdateCommand, when a decimal type field changes from
integer to decimal, the update goes through. When the field changes from
decimal to integer or another decimal, I get a Concurrency violation: the

How do I convert a date (mm/dd/yy) entered into a textbox into a SQL Server
DateTime field?
I've tried this:
SqlTypes.SqlDateTime.op_Implicit(editText0.Text)

I have a DataSet1 which I want to use as a source to create another DataSet2 using a sql like "Select Distinct a, b from DataSet1 ".  Is this possible, and if so, can you point me in the right direction on how it should be done
Thanks

I am using Windows 2003 and SQL Server 2000. I am testing a new like e-commerce website, but during my testing for a few days now I'm having problem that sometimes I can login to my website (using the login page) but sometimes I can't - using the same username and password
This ...