vb.net - Error in saving record into MS Access database -

-

i have got couple of errors in code in vb , cant figure out how solve it.

first error in following part says value cannot null parameter name: data table

da.fill(dt, "order")     con.close()

the second error in part:

 dsnewrow = ds.tables(0).newrow()

and here whole code:

private sub form1_load(byval sender system.object, byval e system.eventargs) handles mybase.load     dbprovider = "provider=microsoft.ace.oledb.12.0;"     dbsource = "data source=c:\users\pao\desktop\projecto1.accdb"     con.connectionstring = dbprovider & dbsource     con.open()     sql = "select *from order"     da = new oledb.oledbdataadapter(sql, con)     da.fill(dt, "order")     con.close() end sub  private sub button1_click(byval sender system.object, byval e system.eventargs) handles button1.click      if name_.textlength > 0 , address_.textlength > 0 , key.textlength > 0         dim pizzaarr() = pizza.toarray()         dim spagarr() = spaghetti.toarray()         dim grindersarr() = grinders.toarray()         dim dsnewrow  datarow         each element string in grindersarr             msgbox(element)         next          dsnewrow = ds.tables(0).newrow()         dsnewrow.item(0) = key.text         dsnewrow.item(1) = name_.text         dsnewrow.item(2) = address_.text         ds.tables("order").rows.add(dsnewrow)         da.update(ds, "order")         msgbox("order added", msgboxstyle.information, "record")         maxrows = ds.tables("order").rows.count         ''     else         msgbox("complete form!", msgboxstyle.exclamation, "incomplete!")         exit sub     end if      '' dim cb new oledb.oledbcommandbuilder(da)     '' dim dsnewrow datarow      ''    dsnewrow = ds.tables("form").newrow()     ''  dsnewrow.item(0) = key.text     ''   dsnewrow.item(1) = name_.text     ''   dsnewrow.item(2) = address_.text      ''   ds.tables("form").rows.add(dsnewrow)      msgbox("record added", msgboxstyle.information, "record")     maxrows = ds.tables("form").rows.count   end sub


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more