I thought I had done this before, but I'm apparently overlooking something.
All I want to do is set the alignment of the first column to the right. The
dataset gives me 5 columns and will auto-format the grid, but I really want
to align just one column. Thus the code below. However, ...

I have a quick question -
I have a table where the primary key is an autogenerated GUID via SQL Server
2k.  The table has just 2 fields, the PK and the ChangeDate.  When I do an
insert into the table w/ the date, the PK is generated, but I need to have

Howdy,
Here is what I have, I'm working on a search engine, where the results can be sorted, and paged through.  (This is for a Web app btw)
My results of the search from the database are stored in a DataTable.
From this DataTable I create a DataView, that sorts the datatable.

I've just finished a C# project that processes a file and inserts data to
database.
I used "typed dataset" and filled tables in this dataset during file
process. After processing, data sent to DB by using DataAdapter.Update.

I have a weird situation, working with some data from an old unix system.
There is a tree structure, where all nodes (i.e. non-leaf nodes) can have
values, as well as the leaf nodes.
Node 1 (Root Node) - Value 50.00

the job is the following:
given 2 databases I must recreate a table from one DB to another;
right now i'm using .getTableSchema, get a datatable with schema, loop
through all it's rows and build a "create table..." statement;

I've got an excel sheet in which i define some kind of matrix. This looks
this way
A                  B            C        D      E        F            G
ID                 12345

ADOX is the extension ADO. And I wonder if there is any extension for ADO.NET? I need a object model in C#, with which I could easily access the schema of a database.

when creating an SqlCommand do I use the name of a stored procedure :
'mytable'
Now, I've seen (working) code where that SP is preceded by the name of a
user :

    First create a typed-dataset with an integer ID primary-key field and a
string Name field.
     Then create a form with a datagrid and a reference to the dataset on
it. set the grids datasource to dataset1.table1.

Hi I am using the Microsoft .NET Provider for Oracle found in
System.Data.OracleClient.
For some reason OracleDataAdapter.Fill NEVER works (I tried it with
many different queries), it always throws an exception.

       Me.SqlDataAdapter1.Fill(Me.vdsVehicle)
       Dim dt As New DataTable
       dt = Me.vdsVehicle.Tables(0)
       Dim dv As New DataView(dt)

As I figured out, the recomended way to cancel editing of a column, or
deletion of a row is to create an event handler for ColumnChanging or
RowDeleting events, and to throw your own exception. Well, I did just
that, and the problem is that I do not know where to catch this

I am using a DataTable (dt) based on a SQL Server table containing a column of type varbinary(50) named descriptor. The DataTable column for this field is base64Binary, which seems to map to System.byte[]. I then defined a DataView (dv) with dv.Sort="descriptor". I find that if I ...

Hoping someone can provide some insight into what I'm doing wrong here.
I have a Win.Form with a bunch of text controls, bound to a Dataset
(DsCustomerInfo1), and a ComboBox bound to the ClientID Field of that
Dataset (DsCustomerInfo1.cw_clientinfo.ClientID) so that I can select a