vb.net - i want datagridview cell to be cleared and remain focused -

-

i have datagridview contains 4 columns item,qty,price,amount. user should enter item name in first column. have table in database item names stored. inserted name should checked if in database or not. if not in database want cell cleared textbox , focus remains in cell. user should not allowed continue until enters correct item name... far have tried this

private sub datagridview1_cellendedit(byval sender object, byval e system.windows.forms.datagridviewcelleventargs) handles datagridview1.cellendedit          connect()         sql = "select productname products productname = '" & me.datagridview1.rows(e.rowindex).cells(0).value.tostring & "' "         objcmd = new sqlcommand(sql, objcon)         objdr = objcmd.executereader         if objdr.read = false             messagebox.show("item name not in items list", "item name error", messageboxbuttons.ok, messageboxicon.error)                         ''clearing cell    '                 me.datagridview1.rows(e.rowindex).cells(0).value = ""             '' here want cell foucus , cursor remain textbox             datagridview1.currentcell = datagridview1.rows(datagridview1.currentcell.rowindex).cells(0)             ' datagridview1.beginedit(true)             exit sub         end if  end sub

here image of datagridview datagridview1

datagridview2

this datagridview displayed user types can pick item names it.it works combobox autocomplete.

finally got looking for. put code in cell validating event

private sub datagridview1_cellvalidating(sender object, e datagridviewcellvalidatingeventargs) handles datagridview1.cellvalidating        datagridview1.rows(e.rowindex)            if e.columnindex = 0                if not itemexists(.cells(e.columnindex).value)                    messagebox.show("item name not in items list", "item name error", messageboxbuttons.ok, messageboxicon.error)                    e.cancel = true                end if            end if        end    end sub 
function itemexists(byval itemname string) boolean       dim bresult boolean = true        connect()       sql = "select productname products productname = '" & itemname & "' "       objcmd = new sqlcommand(sql, objcon)       objdr = objcmd.executereader       if objdr.read = false           bresult = false       end if        return bresult   end function

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more