Question ? Binding Source AutoRefresh Problem

[jony_007]

hi all developer,

My all control on forms is connected through binding source,
but i am using sql statement from insert/update/Delete separately,
i don't used adpater for updating.

Main problem after updating record in database
binding source does not refresh while i write code for
for resets its after updating
like
for examples
me.bindingsource.datasource = sqlqry("select * from employee")
where sqlqry retunrs the new datatable

for inserting or deleting it work perfect

plz. .need help just
thanks for solution.

 

[jmcilhinney]

We'll have to assume that that code is going to get every record from the Employee table and return them as some sort of list. If the records you're trying to update are not being updated then there's presumably something wrong with the code you're using to update them. We know nothing about that code so we can't really say any more than that.

 

[cjard]

hi all developer,

My all control on forms is connected through binding source,
but i am using sql statement from insert/update/Delete separately,
i don't used adpater for updating.

Main problem after updating record in database
binding source does not refresh

Yep, that's what happens when you decide to use an architecture Microsoft invented in a completely different way than they intended

plz. .need help just
thanks for solution.

Why not.. wait for it.. do it the proper way?! (See the DW2 link in my signature, section Creating a Simple Data App)
It will solve all your problems and make your code better too