VB.NET Programming Corner!

[jayrwafu]

EDIT Again:

Pa help naman po I have this code below .

Ano po ang tamang code para sa InitialDirectory,

I mean like this my project located at,

 C:\Users\Mema\Documents\Visual Studio 2008\Projects\Inventory\

Then after clicking the button(w/ opendialog) automatic na po sya na dyan ang directory.

My point is kahit anong directory sya malagaay, pag iopen ulit dun lang din sa local directory.

With OpenFileDialog1
            .InitialDirectory = "C:\"
            .Filter = "All Files|*.*|JPEGs|*.jpg|Bitmaps|*.bmp|GIFs|*.gif"
            .FilterIndex = 2
        End With

        If OpenFileDialog1.ShowDialog() = DialogResult.OK Then
            With PictureBox1
                .Image = Image.FromFile(Me.OpenFileDialog1.FileName)
                .SizeMode = PictureBoxSizeMode.StretchImage
            End With
        End If

may property un opendialog

opendialog.RestoreDirectory = true

see reference here :
https://social.msdn.microsoft.com/F...-get-the-last-directory-after-open-filedialog

- - - Updated - - -

Paki sagot naman netong tanong ko sa stackoverflow mga ser

https://stackoverflow.com/questions/34264890/how-do-i-get-image-or-image-path-location-from-another-process

try mo gamitin un jetbrains decompiler

- - - Updated - - -

Hi Good day po,

Sino na po naka encounter nitong error na to?

kadalasan syang lumalabas after ko mag execute ng queries ko ng pag iinsert ng madaming records.
ang process ko, read text file, onload then iinsert sya sa database ko.
nag susuccess naman sya mag insert, pero after ng procedure lalabas yang error na yan.
SQL Problem kaya or sa memory ng mobile ko? madami pa naman ako extra space sa disk kaya sa tingin ko hindi ito sa disk space.

any comments or suggestion?

Public Sub ReadMaster()
        If File.Exists("\Application\SOROSORO\IMPORT\Master.txt") = True Then
            Dim strItems_Data() As String
            Dim strItem As String
            Dim sqlceconn As SqlCeConnection
            Dim sqlsr As StreamReader = New StreamReader("\Application\SOROSORO\IMPORT\Master.txt")
            sqlceconn = New SqlCeConnection("Data Source = \Application\SOROSORO\SQL_DATA\DB.sdf ;Max Database Size = 4000 ;")
            sqlceconn.Open()
            'Ignore the First Line - HEADER
            '   sqlsr.ReadLine()
            Do While sqlsr.Peek > -1
                strItem = sqlsr.ReadLine.Trim
                strItem = strItem.Replace(Chr(34), Chr(32))
                strItem = strItem.Replace(Chr(37), Chr(32))
                strItem = strItem.Replace(Chr(38), Chr(32))
                strItem = strItem.Replace(Chr(39), Chr(32))
                strItem = strItem.Replace(Chr(44), Chr(32))

                strItems_Data = strItem.Split(Chr(9))
                insertMaster(strItems_Data, sqlceconn)
                Loop
            sqlceconn.Dispose()
            sqlceconn.Close()
            sqlsr.Close()
        End If
    End Sub

 Public Sub insertMaster(ByVal _data() As String, ByVal _myConn As SqlCeConnection)
        Dim _sqlcecmd As SqlCeCommand
        Try

            _sqlcecmd = New SqlCeCommand
            _sqlcecmd = _myConn.CreateCommand
            _sqlcecmd.CommandText = "INSERT INTO tbl_Master(Itemcode,ItemName,UomCode,ItmsGrpNam,Barcode" + _
                          ")" + _
                            "VALUES(@Itemcode,@ItemName,@UomCode,@ItmsGrpName,@Barcode)"

            _sqlcecmd.Parameters.Add("@Itemcode", SqlDbType.NVarChar, 50)
            _sqlcecmd.Parameters.Add("@ItemName", SqlDbType.NVarChar, 250)
            _sqlcecmd.Parameters.Add("@UomCode", SqlDbType.NVarChar, 50)
            _sqlcecmd.Parameters.Add("@ItmsGrpName", SqlDbType.NVarChar, 100)
            _sqlcecmd.Parameters.Add("@Barcode", SqlDbType.NVarChar, 100)
            _sqlcecmd.Prepare()

            _sqlcecmd.Parameters("@Itemcode").Value = _data(0).ToString.Trim
            _sqlcecmd.Parameters("@ItemName").Value = _data(1).ToString.Trim
            _sqlcecmd.Parameters("@UomCode").Value = _data(2).ToString.Trim
            _sqlcecmd.Parameters("@ItmsGrpName").Value = _data(3).ToString.Trim
            _sqlcecmd.Parameters("@Barcode").Value = _data(4).ToString.Trim


            _sqlcecmd.ExecuteNonQuery()
            _sqlcecmd.Dispose()

        Catch ex As Exception
            MsgBox("Insert" & ex.Message)
        End Try
    End Sub

Ano un error message?

sa tingin ko un connection mo...
try mo toh :

Dim _sqlcecmd As New SqlCommand
_sqlcecmd .Connection = _myConn

- - - Updated - - -

Sirs..Good day!


VB.NET newbie here.. with C++ knowledge lang..

I am planning to create an APP just like a reviewer sana.. where in sa 1st Form mo pwd ka mkapili ng Topic(e.g. MATH,ENGLISH,SCIENCE and the like), then it will automatically generate random question as you go throughout, then lalabas dun ung mga questions continually unless i-end mo na ung session mo.. Then it will give you your score, correct items tsaka ung mga mali mo.

Then meron nman specific Form pra mkapag update ka ng questions mo, mkadagdag ng questions, mag load ng questions..






I have question/s:

1. Is it possible na pwd mkasave ng data entries(i.e. Questions) sa local lang na station?
2. Is it simply means po ba na kapag may Microsoft Visual Studio ka, need mo din ng SQL,mySQL?( dpends on how they called it.) Medyo nangangapa pa kc ako sa VB.Net at SQL(?)
3. Would you give me advice kung anung approach ang dapat kong gawin with these scenarios?
4. If i don't have an SQL installed sa station ko, mkakapag save po kaya ako ng entries dun sa APP?



Hoping for your kind feedbacks.

Sa vb pede ka gumawa ng text file.... dun mo i-save un data mo.. formatted by comma or kaw bahala na mababasa ng program mo...

- - - Updated - - -

help po kasi susubukan ko mag publis hng file and then nag publish naman sya kaso di makita ung accdb ko...

paano po kaya yun? i also need to publish a folder named image... di kasi makita pagtapos kong mag install

pag publish gagamitin mo.. mag online installation yan, ngsave yan sa temp data folder... try mo magset-up ng offline installation package, para pede magconfige un save path

- - - Updated - - -

guys pahelp naman panu paganahin eto sa vb .. sa sql kasi gumagana pag inaaply ko na sa vb ayaw na "insert into voidreport select * from orderrecord where OrderNumber= 'ORN0000079'" gusto ko sana madelete ung mismong laman taz mapunta sa kabilang table ung mismong record na yan.. sample code nga po thanks

paste mo un complete code mo.. bka may kulang sqlcommand, sqlconnection or try catch mo.. para makita mo un error message

 

[dhennehd]

ay sorry di ko pala nalagay yung error, yung error nya is "Not enough memory to perform this operation"
I'm developing a windows mobile app. at yan po yung lumalabas na error.

 

[jayrwafu]

ay sorry di ko pala nalagay yung error, yung error nya is "Not enough memory to perform this operation"
I'm developing a windows mobile app. at yan po yung lumalabas na error.

Check mo memory usage mo sa task manager... bka full na... or may setting un mobile app for required RAM

 

[zoombeee]

up ko lang sana may maka help, thanks in advance

pakitry po nitong code na ito..

    Dim someText As String = InputBox("Enter any key you want to search", "Search Data")
        If someText = Nothing Then MsgBox("There is no student matching with this value", vbInformation + vbOKOnly, "No Record") : Exit Sub
        Dim count As Boolean = False
        Dim gridRow As Integer = 0
        Dim gridColumn As Integer = 0
        For Each Row As DataGridViewRow In dgStudent.Rows
            For Each column As DataGridViewColumn In dgStudent.Columns
                Dim cell As DataGridViewCell = (dgStudent.Rows(gridRow).Cells(gridColumn))
                If cell.Value.ToString.ToLower.Contains(someText.ToLower) Then
                    'cell.Style.BackColor = Color.Yellow
                    cell.Selected = True
                    count = True
                End If
                gridColumn += 1
            Next column
            gridColumn = 0
            gridRow += 1
        Next Row

 

[masker]

mga master pano po magprint sa continous page sa c# gamit ang e.graphics or crystal report
sori po kung c# kahit vb.net nalang po thanks po

 

[zirjohn]

Pasali po, di pa aq maxado marunong sa coding ng vb.net. sa vb6 kasi ako maxado naexposed (pero di ganon kagaling,prng madami pa ako gusto malaman). My background nmn po ako sa vb.net pero napatigil ako eh kaya prang nangangapa parin ulit. Thanks!

 

[mizuki]

mga sir pa help naman gusto kosana mag lgay ng admin na account type tapos mkakacreate siya ng user at limited ang kaya nya magawa bali yung admin lang mkakaset msql workbench database ko

 

[Gamecore]

about sa problem ko gumamit na lang ako ng installshield wizard...

 

[shiapouf]

Mga master pwede nyo po ba bigyan ng ideas or any suggestion po, I want to create a LAN chat application na pede mag add/delete users, na mag didisplay sila as list then pede ko sila igroupchat based on sa mga sinelect ko sa list ko, then pede mag notifs sa isa sa mga users or groups users. parang Yahoo messenger, and pede po ba ito without using internetconnection just IP lang po to connect and send and upload files(file sharing) and concern ko lang po yung sa server hindni po ba baka mapuno yung server kung magsasave ako ng chat logs and file logs that send. sorry new lang ako sa vb.net thanks po and willing to explore more

 

[godsniper08]

Good afternoon mga idol

upon loading then form.show minsan po hindi nalabas sa front ng screen ung form, pag nagcclick ng ibang app (google chrome, notepad, calc, etc.) nasa likod lang sya. meaning hindi kita ng user kung nag open na..

Q: pano po ma fforce sa front ung appearance nung form upon form.show?

thanks po

 

[ezzel03]

Ts magpapatulong po sana ako. SMS Notification po kasi yung system namin.. Problema ko po hindi po nagreresponse yung AT Commands po. Nakakasend na po kaso po db dapat po pagkasend may lalabas na message box na may laman na At Commands response.. Yung samin po kasi blanko lang po..

Pahelp na din po ts kasi group message po kasi sana ts.. kaso d po namin alam kung pano po codes nun.. kung pano po mag multiselect sa listview po.. Thanks ts..

- - - Updated - - -

Good afternoon mga idol

upon loading then form.show minsan po hindi nalabas sa front ng screen ung form, pag nagcclick ng ibang app (google chrome, notepad, calc, etc.) nasa likod lang sya. meaning hindi kita ng user kung nag open na..

Q: pano po ma fforce sa front ung appearance nung form upon form.show?

thanks po

ts try niyo po yung form.ShowDialog()

 

[Gamecore]

pano po kaya mag auto refresh ung datagridview?

bale po pag edit ko ng data sa MS access mababasa agad na may changes... thanks

 

[macroboytron]

pano po kaya mag auto refresh ung datagridview?

bale po pag edit ko ng data sa MS access mababasa agad na may changes... thanks

sa ms access talaga? or dun sa system mo?

 

[Soichiro Jin]

Guy's patulong naman sa crystal report xD

Di ko to talaga makuha, two ways installer ginawa ko the Setup & Deployment and the ClickOnce

Working naman pud sya sa laptop ko after I installed and run the system, it can print.

But when I tried the other computer, actually vmware gamit ko to test the project.. ayaw gumana ang crystal report

Patulong naman guys..

 

[Gamecore]

bale kasi im adding data through form... tapos mag save sya sa ms access, di ako nag eedit through datagridview...

once na may idagdag ako na data sa ms access gusto ko ifefetch nya na agad...

 

[ThiefFudge]

Pa Help Po.
Gumawa ng Program na mag print ng single asterisk sa form na paDiamond gamit ang Nested For/Next Structures.


Salamat po ^____^

 

[Gamecore]

help lang konting idea.. kasi need ko mag insert ng mag insert users right(i.e number of brothers), kung ilan gusto nya.. paano ko kaya gagawin un... kasi di naman responsive si vb.net ee pag listview ba ako? paano pag may i eedit ako na nasa gitna ng listview and need ko ng button.. pano kaya?

 

[zoombeee]

Guy's patulong naman sa crystal report xD

http://i.imgur.com/HqOSGUH.png

Di ko to talaga makuha, two ways installer ginawa ko the Setup & Deployment and the ClickOnce

Working naman pud sya sa laptop ko after I installed and run the system, it can print.

But when I tried the other computer, actually vmware gamit ko to test the project.. ayaw gumana ang crystal report

Patulong naman guys..

Gamit ka third party software na magkecreate ng installer mo..dapat nakainclude dun lahat ng prerequisites mo like ung sa crystal report mo.. try mo advance installer..

- - - Updated - - -

help lang konting idea.. kasi need ko mag insert ng mag insert users right(i.e number of brothers), kung ilan gusto nya.. paano ko kaya gagawin un... kasi di naman responsive si vb.net ee pag listview ba ako? paano pag may i eedit ako na nasa gitna ng listview and need ko ng button.. pano kaya?

Mag Grid view ka sir mas madali..

 

[johndave9296]

Sino marunong gumawa ng OpenVPN GUI dito? Patulong po sana.

 

[jayrwafu]

Guy's patulong naman sa crystal report xD

http://i.imgur.com/HqOSGUH.png

Di ko to talaga makuha, two ways installer ginawa ko the Setup & Deployment and the ClickOnce

Working naman pud sya sa laptop ko after I installed and run the system, it can print.

But when I tried the other computer, actually vmware gamit ko to test the project.. ayaw gumana ang crystal report

Patulong naman guys..

yan ang aayusin ko ngayon... dahil windows update yan... see reference : http://support.waspbarcode.com/inde...oduces-an-error-operation-not-yet-implemented

hindi ko pa n try un solution dyan

update:
tried and tested... working ang pag install ng lumang font