VB.NET and MS Access - Binding (Data won't save to database) -

-

i have linked 1 of vb.net forms ms access database table, however, when save data entered vb form data set, data show in data set not appear in database table. there anyway can data have stored in data set appear in actual database.

i have bound form fields correctly database table , have added tables form via data grid.
![form & data grid][1]

can tell me why won't save database? or have alternative method binding forms database.

*note - database has password on (don't know if effects it)

*note - i'm new forum cant post image...

*note - let me know if need see more code

form loading code

public class cd_form

private sub cd_load(sender system.object, e system.eventargs) handles mybase.load     'todo: line of code loads data 'cdkingsdatabasedataset.cd' table. can move, or remove it, needed.     me.cdtableadapter.fill(me.cdkingsdatabasedataset.cd)  end sub

add button code

private sub button5_click(sender system.object, e system.eventargs) handles add.click     cdbindingsource.addnew()  end sub

save button code

private sub button6_click(sender system.object, e system.eventargs) handles sav.click     cdbindingsource.endedit()     cdtableadapter.update(cdkingsdatabasedataset.cd)   end sub

ah ok i've found solution comment jmcilhinney on "vb.net - .accdb database not saving changes" question made while back. changes database have been made database looking @ in wrong location.

the database stored changes in bin/debug folder.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more