Cannot bind a simple text box

[Lori Markle via .NET 247]

(Type your message here)
Hi,

I'm having a problem with binding a textbox to a dataset. Cananybody figure out what's going on here?

I simply want to update a record. Type in a permit number andsave it to the database. I get the "cannot bind to columnpermitnum ber on datasource" error, or if I add the tablename.colum n name into the binding, a permit number that alreadyexists pops up.

Here is my code:
Dim dbConn As NewOleDbConnect ion("Provider=M icrosoft.Jet.OL EDB.4.0;DataSou rce=C:\Projects \Tests\ParkingP Ermits.mdb")
Dim da As New OleDbDataAdapte r("select * from permits",dbConn )
Dim cb As New OleDbCommandBui lder(da)
Dim ds As New DataSet

da.UpdateComman d = cb.GetUpdateCom mand
da.DeleteComman d = cb.GetDeleteCom mand
da.InsertComman d = cb.GetInsertCom mand
da.Fill(ds, "permits")

txtPermits.Data Bindings.Clear( )
txtPermits.Data Bindings.Add("t ext", ds,"permits.per mitnumber")

da.Update(ds, "permits")

Do I have something in incorrect order?

Thanks,
--------------------------------

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>ibX1YBnxQEy TvHkI3D9avw==</Id>

[William Ryan eMVP]

You are calling update after adding the bind, but nothing has changed.
For the record, if your dataset .HasChanges = false, you can call update all
year and nothing will happen. You'll probably want to set up a
bindingcontext and you'll need to change the values before an update will
happen.
http://www.knowdotnet.com/articles/datasetmerge.html

For future reference, add this line before your update in testing, this way
you'll Know if update is actually going to get called (and just b/c it does,
doesn't mean it will work, but if you get a big ugly assertion box, you KNOW
nothing will happen with the Update)

Debug.Assert(Da taSetName.HasCh anges, "No Changes Detected")
"Lori Markle via .NET 247" <an*******@dotn et247.com> wrote in message
news:eV******** ******@TK2MSFTN GP09.phx.gbl...
(Type your message here)
Hi,

I'm having a problem with binding a textbox to a dataset. Can anybody figure
out what's going on here?

I simply want to update a record. Type in a permit number and save it to the
database. I get the "cannot bind to column permitnumber on datasource"
error, or if I add the table name.column name into the binding, a permit
number that already exists pops up.

Here is my code:
Dim dbConn As New
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=C:\Proje cts\Tests\Parki ngPErmits.mdb")
Dim da As New OleDbDataAdapte r("select * from permits", dbConn)
Dim cb As New OleDbCommandBui lder(da)
Dim ds As New DataSet

da.UpdateComman d = cb.GetUpdateCom mand
da.DeleteComman d = cb.GetDeleteCom mand
da.InsertComman d = cb.GetInsertCom mand
da.Fill(ds, "permits")

txtPermits.Data Bindings.Clear( )
txtPermits.Data Bindings.Add("t ext", ds, "permits.permit number")

da.Update(ds, "permits")

Do I have something in incorrect order?

Thanks,
--------------------------------

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>ibX1YBnxQEy TvHkI3D9avw==</Id>

[sparkle]

OK! Now I'm getting somewhere!

I'll try both answers out and see what happens.

Thanks, William...

[William Ryan eMVP]

My pleasure and I'm glad to hear progress is being made. If you have any
questions, let me know..

Cheers,

Bill

www.devbuzz.com
www.knowdotnet.com

"sparkle" <hr****@hra.co. santa-cruz.ca-dot-us.no-spam.invalid> wrote in
message news:40******** **@127.0.0.1...

OK! Now I'm getting somewhere!

I'll try both answers out and see what happens.

Thanks, William...