vb.net - Visual basic 2010, database – how to fill specific field -

-

i'm creating database connection in visual basic. when user click on "borrow book" transfer chosen data table used lent books. works alright, need last thing. in database in lent table have attribute "end date of lent" , want fill everytime when user borrow book date today + 1 month (for instance, if 19/04/2016, end date 19/05/2016). created method "borrowtime" this, don't know should type , how can value of inserted row "row". , sorry horrible of code , form...

public class frm_userview     dim bookssource new bindingsource     dim borrowsource new bindingsource      dim booksview new dataview     dim borrowview new dataview      dim ds new dataset      dim borrow byte       private sub frm_userview_load(sender system.object, e system.eventargs) handles mybase.load         tmr_timer.start()         me.loanerbookstableadapter.fill(me.gmitlibrarydataset1.loanerbooks)         me.bookstableadapter.fill(me.gmitlibrarydataset.books)          bookssource = dgd_userbookview.datasource         booksview = ctype(bookssource.list, dataview)          ds = booksview.dataviewmanager.dataset.clone          borrowsource.datasource = ds         borrowsource.datamember = "books"          borrowview = ctype(borrowsource.list, dataview)         dgd_user_borrow_view.datasource = borrowsource        end sub      private sub btn_borrow_click(sender system.object, e system.eventargs) handles btn_borrowbook.click         borrow = 1         movebooks(dgd_userbookview, borrowview, borrow)          dgd_user_borrow_view.sort(dgd_user_borrow_view.columns(0), system.componentmodel.listsortdirection.ascending)          borrowsource.movelast()         borrowsource.movelast()     end sub     private sub movebooks(byref source datagridview, byref target dataview, byref borrow byte)         = 0 source.selectedrows.count - 1             dim numberofrow integer             dim row datarowview             row = target.addnew()             dim col int16 = 0             each cell datagridviewcell in source.selectedrows(i).cells                 row.item(col) = cell.value                 if borrow = 1                     numberofrow = 0                     borrowtime(numberofrow, dgd_user_borrow_view)                 end if                 col = col + 1             next         next          dim count int16 = source.selectedrows.count          = 0 count - 1             source.rows.removeat(source.selectedrows(0).index)         next     end sub     private sub borrowtime(byref row integer, byref dgd_table datagridview)         'code adding date     end sub      private sub btn_returnbook_click(sender system.object, e system.eventargs) handles btn_returnbook.click         borrow = 0         movebooks(dgd_user_borrow_view, booksview, borrow)          dgd_userbookview.sort(dgd_userbookview.columns(0), system.componentmodel.listsortdirection.ascending)          bookssource.movelast()         bookssource.movelast()     end sub      private sub btn_userlogout_click(sender system.object, e system.eventargs) handles btn_userlogout.click         frm_login.show()         me.hide()     end sub      private sub timer1_tick(sender system.object, e system.eventargs) handles tmr_timer.tick         dim countbooks integer         dim countlent integer         countbooks = bookssource.count         countlent = borrowsource.count          lbl_bookcounter.text = "there " + countbooks.tostring + " books"         lbl_borrowcounter.text = "you have lent " + countlent.tostring + " books"     end sub end class

i need put code here:

 private sub borrowtime(byref row integer, byref dgd_table datagridview)        'code adding date  end sub

my form

enter image description here

public class frm_userview dim bookssource new bindingsource dim borrowsource new bindingsource

dim booksview new dataview dim borrowview new dataview  dim ds new dataset  dim borrow byte   private sub frm_userview_load(sender system.object, e system.eventargs) handles mybase.load     tmr_timer.start()     me.loanerbookstableadapter.fill(me.gmitlibrarydataset1.loanerbooks)     me.bookstableadapter.fill(me.gmitlibrarydataset.books)      bookssource = dgd_userbookview.datasource     booksview = ctype(bookssource.list, dataview)      ds = booksview.dataviewmanager.dataset.clone      borrowsource.datasource = ds     borrowsource.datamember = "books"      borrowview = ctype(borrowsource.list, dataview)     dgd_user_borrow_view.datasource = borrowsource    end sub  private sub btn_borrow_click(sender system.object, e system.eventargs) handles btn_borrowbook.click     borrow = 1     movebooks(dgd_userbookview, borrowview, borrow)      dgd_user_borrow_view.sort(dgd_user_borrow_view.columns(0), system.componentmodel.listsortdirection.ascending)      borrowsource.movelast()     borrowsource.movelast() end sub private sub movebooks(byref source datagridview, byref target dataview, byref borrow byte)     = 0 source.selectedrows.count - 1         dim numberofrow integer         dim row datarowview         row = target.addnew()         dim col int16 = 0         each cell datagridviewcell in source.selectedrows(i).cells             row.item(col) = cell.value             if borrow = 1                 numberofrow = 0                 borrowtime(numberofrow, dgd_user_borrow_view)             end if             col = col + 1         next     next      dim count int16 = source.selectedrows.count      = 0 count - 1         source.rows.removeat(source.selectedrows(0).index)     next end sub private sub borrowtime(byref row integer, byref dgd_table datagridview)     'code adding date end sub  private sub btn_returnbook_click(sender system.object, e system.eventargs) handles btn_returnbook.click     borrow = 0     movebooks(dgd_user_borrow_view, booksview, borrow)      dgd_userbookview.sort(dgd_userbookview.columns(0), system.componentmodel.listsortdirection.ascending)      bookssource.movelast()     bookssource.movelast() end sub  private sub btn_userlogout_click(sender system.object, e system.eventargs) handles btn_userlogout.click     frm_login.show()     me.hide() end sub  private sub timer1_tick(sender system.object, e system.eventargs) handles tmr_timer.tick     dim countbooks integer     dim countlent integer     countbooks = bookssource.count     countlent = borrowsource.count      lbl_bookcounter.text = "there " + countbooks.tostring + " books"     lbl_borrowcounter.text = "you have lent " + countlent.tostring + " books" end sub

end class


Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more