Binding Example

[Miro]

I cant seem to find a proper example anywhere that binds a textbox by code.

I have created on the FormLoad a Dataset that has 1 record from my table.
I created a DataRow that holds that record. ( with my columns that were
specified from my commandText.

So what I have done now is I created a textbox on my form.
How do I bind that text box to my DataRow that holds all my columns?
-So It displays the data in the text field, and later so I can put a
"save" button on the form and update the data from the text field back
to the database.

Im using vb.net express and sqlExpress

Thanks

Miro

[Miro]

So far, the closest Ive got is this:
TextBox1.Text = CStr(dr("FirstName"))
TextBox2.Text = CStr(dr("LastName"))

its not really binding the value - just displaying it in the textbox.

Im assuming there is a better way however.
(Trying to stay clear of drag and drop wizard )
Miro wrote:

I cant seem to find a proper example anywhere that binds a textbox by code.

I have created on the FormLoad a Dataset that has 1 record from my table.
I created a DataRow that holds that record. ( with my columns that were
specified from my commandText.

So what I have done now is I created a textbox on my form.
How do I bind that text box to my DataRow that holds all my columns?
-So It displays the data in the text field, and later so I can put a
"save" button on the form and update the data from the text field back
to the database.

Im using vb.net express and sqlExpress

Thanks

Miro

[Jack Jackson]

TextBox1.DataBindings.Add("text", dr, "FirstName")
TextBox2.DataBindings.Add("text", dr, "LastName")

On Sun, 21 Oct 2007 12:54:37 -0400, Miro <mi******@beero.netwrote:

>So far, the closest Ive got is this:
TextBox1.Text = CStr(dr("FirstName"))
TextBox2.Text = CStr(dr("LastName"))

its not really binding the value - just displaying it in the textbox.

Im assuming there is a better way however.
(Trying to stay clear of drag and drop wizard )
Miro wrote:

>I cant seem to find a proper example anywhere that binds a textbox by code.

I have created on the FormLoad a Dataset that has 1 record from my table.
I created a DataRow that holds that record. ( with my columns that were
specified from my commandText.

So what I have done now is I created a textbox on my form.
How do I bind that text box to my DataRow that holds all my columns?
-So It displays the data in the text field, and later so I can put a
"save" button on the form and update the data from the text field back
to the database.

Im using vb.net express and sqlExpress

Thanks

Miro

[Miro]

Thanks Jack,

That got me on the right track.

I had to put the table name however into the
TextBox1.DataBindings.Add("text", dsStaff.Tables("StaffPerson"),
"FirstName")

Thanks for your help.

Miro

Jack Jackson wrote:

TextBox1.DataBindings.Add("text", dr, "FirstName")
TextBox2.DataBindings.Add("text", dr, "LastName")

On Sun, 21 Oct 2007 12:54:37 -0400, Miro <mi******@beero.netwrote:

>So far, the closest Ive got is this:
TextBox1.Text = CStr(dr("FirstName"))
TextBox2.Text = CStr(dr("LastName"))

its not really binding the value - just displaying it in the textbox.

Im assuming there is a better way however.
(Trying to stay clear of drag and drop wizard )
Miro wrote:

>>I cant seem to find a proper example anywhere that binds a textbox by code.

I have created on the FormLoad a Dataset that has 1 record from my table.
I created a DataRow that holds that record. ( with my columns that were
specified from my commandText.

So what I have done now is I created a textbox on my form.
How do I bind that text box to my DataRow that holds all my columns?
-So It displays the data in the text field, and later so I can put a
"save" button on the form and update the data from the text field back
to the database.

Im using vb.net express and sqlExpress

Thanks

Miro