DataBinding to a DataRow?

  • Thread starter Thread starter Software Department
  • Start date Start date
S

Software Department

Greetings,

Is it possible to DataBind to a DataRow using a control such as a TextBox?
If so, what would be the correct syntax? A typed DataSet provides the means
to perform DataBinding with a DataRow, but what about an untyped DataSet?

Thanks,
 
Hi Eric,
Is it possible to DataBind to a DataRow using a control such as a TextBox?
If so, what would be the correct syntax? A typed DataSet provides the means
to perform DataBinding with a DataRow, but what about an untyped DataSet?
Click to expand...

Even easier
textbox1.DataBindings.Add(New Binding("Text", ds.Tables(0), "MyField"))
cma = DirectCast(BindingContext(ds.Tables(0)), CurrencyManager)

(the second is for your next question it has to be declared as Private cma
as CurrencyManager)

I hope this helps?

Cor
 
Cor,

This example binds the column from a DataTable to a TextBox, not a DataRow
(subtle difference). I was considering using the NewRow() method of the
DataTable to get a DataRow to bind to controls on a Windows Form (displays
only one row at a time, no grids). I could use the DataRow to display an
existing record for edit or a new row. I am not opposed to binding through
the DataSet/DataTable. I am looking for input on technique... especially
since a typed DataSet provides rich properties to bind to (column names from
the table).

Thanks
 
Hi,

Yes that goes perfectly fine when you use the method I did give above and
add a row to the datatable. Everything what goes with a typed dataset goes
as well with a untyped dataset, which is the base of the typed dataset.

The new row is (when added, and therefore binded in my sample)
dataset.tables(0).rows(dataset.tables(0).rows.count-1)

Cor
 
Back
Top