Databinding Question

[gearbolt]

I have two text boxes that are bound to a dataset, there is also a Sqlconnection, SqlDataadapter in use. VB.Net generated the Insert, Update and Delete statements for the dataset but I cant figure out how to get the new data out of the textboxes and into the database. This is the code that was generated by Visual Studio. Thanks for the help.

 

'SqlInsertCommand1

'

Me.SqlInsertCommand1.CommandText = "INSERT INTO dbo.Users(UserName, UserPassword) VALUES (@UserName, @UserPassword); " & _

"SELECT UserName, UserPassword FROM dbo.Users WHERE (UserName = @UserName)"

Me.SqlInsertCommand1.Connection = Me.SqlConnection1

Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 20, "UserName"))

Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UserPassword", System.Data.SqlDbType.VarChar, 20, "UserPassword"))

[jfackler]

Do you want to databind the textboxes to the dataset?

Or, do you simply want to input the textbox.text into a field in your dataset?

 

The data adapter will take care of implementing the insert command. You simply call an update once you

have manipulated your dataset.

[Robby]

Since your textboxes are already bound, there's nothing else to do, simply call the Update method of the DataAdapter.

[gearbolt]

I have already databinded the textboxes to the dataset. When I hit the the command button to fill the textboxes I get the first record from the database. But know I want to enter some new information into the textbox and update the database. I am new to VB.Net and would not normally use databinding but I am trying to learn everything VB.Net offers.

[Robby]

Yes I know, that's why I said...

Since your textboxes are already bound, there's nothing else to do, simply call the Update method of the DataAdapter.

[gearbolt]

can you post the correct code I should use for the update method.

 

Thanks

[jfackler]

oledbdataadapter.update(dataset, "table")

[sizer]

the rowstate is changed only when u move off the current row. so if u change

the value in the textbox, move to the next row, and then examine the

rowstate property, u will find that it has indeed changed to "Modified"

 

To cause the rowstate to change without moving off the row, call the

EndCurrentEdit method on the underlying bindingcontext object that u create,

or if u've not specifically created a bindingcontext, use the following

syntax (possibly in the click event of the OK/Save button)

 

Me.BindingContext(dataset, "tablename").EndCurrentEdit