Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact
A1VBCode Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      

Home » Visual Basic (VB 4/5/6) » Database Programming » DataGridView update problem


DataGridView update problemExpand / Collapse
Author
Message
Posted 8/31/2008 9:23:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/19/2008 7:21:17 AM
Posts: 2, Visits: 14
Hi,
(This post with pictures: http://www.ti.rs/problem/problem.html) - recomended for understanding

Short intro: Program is for managing supplies of the restaurant
There are simple items to sell or complex items with ingredients. This part of program manage complex items with ingredients.

There is DataGridView, on the form which is fill by: Me.MagacinSlozeniTableAdapter.Fillby(Me.KonobarDataSet.MagacinSlozeni, BrojID)

Using combobox in Datagridview I chose Items, if item is complex, already with ingredients I fill table with:
Me.MagacinSlozeniTableAdapter.ClearBeforeFill = False
Me.MagacinSlozeniTableAdapter.FillByMagacinID(Me.KonobarDataSet.MagacinSlozeni, BrojID, KolicinaID, MagacinID)

Problem is when I fill items with, ingredients, it is shown in DataGridView but NOT update to database
All items which are chosen manualy from combo box is updated, but programmatically added items NOT

Post #25630
Posted 9/17/2008 8:30:17 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 10/14/2008 12:47:36 PM
Posts: 17, Visits: 20
Not event is fired when you programmictaly add an items. After adding the items you need to tell the dataset to update to the database.
Post #25715
Posted 9/19/2008 7:27:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/19/2008 7:21:17 AM
Posts: 2, Visits: 14
Thanks Tommy

But I think I done that with:

Private Sub MagacinSlozeniBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MagacinSlozeniBindingNavigatorSaveItem.Click
Me.Validate()
Me.MagacinSlozeniBindingSource.EndEdit()
Me.MagacinSlozeniTableAdapter.Update(Me.KonobarDataSet.MagacinSlozeni)
End Sub

Problem is that something is updated something not
Look at http://www.ti.rs/problem/problem.html, last picture
Post #25720
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Brian, Peter

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 10:04am