VB.NET Programming Corner!

[uctupus]

pwede po ba makahingi ng installer ng vb.net?

 

[marniel647]

HELP:
Crystal Report in VB 2010

Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

Ano po ibig sabihin nito?

I think la ka nakainstall na crystal report try mo download ng installer ng crystal report sa SAP

 

[glaidcm]

need help.
using vb.net 2008 codes, paano po macocopy or masesave automatically sa notepad ung aking code??
1 week ko na po yan gngawa,hanggang ngayon wla pa din.tsk.sana matulungan nyo ko. thanks in advance.

 

[marniel647]

need help.
using vb.net 2008 codes, paano po macocopy or masesave automatically sa notepad ung aking code??
1 week ko na po yan gngawa,hanggang ngayon wla pa din.tsk.sana matulungan nyo ko. thanks in advance.

gusto mo masave yung code mo sa notepad.? yung code nung program mo? Bakit hindi mo na lang i copy paste yung code mo sa notepad? Ano ba gamit ng program mo?

 

[glaidcm]

gusto mo masave yung code mo sa notepad.? yung code nung program mo? Bakit hindi mo na lang i copy paste yung code mo sa notepad? Ano ba gamit ng program mo?

hindi po pwede. gumagawa po kc aq ng sample compiler. kelangan po automatic masesave ung codes ng program q sa notepad. tapos sa program q may button na pag click lalabas sa multi-line textbox ung codes. posible po ba un?? by the way, thanks po sa reply.

 

[ninjamovers]

Hi po!!
mga sir patulong naman po kung panu magsave ng image sa database ? VB.NET/mysql po gamit ko .. tnx po

 

[forbizdenz]

 Sub fillData()
        sqlQRY = "Select * from BorrowersInfo Where BorrowersID = '" & txtid.Text & "'or Lname like '%" & txtid.Text & "%'"
        cmd = New OleDbCommand(sqlQRY, conn)

        dr = cmd.ExecuteReader
        dr.Read()
        txtid.Text = dr(0)
        txtfname.Text = dr(1)
        txtmname.Text = dr(2)
        txtlname.Text = dr(3)
        txtaddress.Text = dr(4)

        dr.Close()
    End Sub

mga sir ito po code ko para maview ko ang nasearch ko na records..kaso pang isa lng madisplay nya sa textbox..gusto ko sana pag makahanap siya ng dalawa o higit pa na records ai ilalabas nya sa ibang form na may listview at dito niya edidisplay..panu po ang code o "if condition" nito mga sir pahingi po ng hints..tnx..

 

[knives645]

 Sub fillData()
        sqlQRY = "Select * from BorrowersInfo Where BorrowersID = '" & txtid.Text & "'or Lname like '%" & txtid.Text & "%'"
        cmd = New OleDbCommand(sqlQRY, conn)

        dr = cmd.ExecuteReader
        dr.Read()
        txtid.Text = dr(0)
        txtfname.Text = dr(1)
        txtmname.Text = dr(2)
        txtlname.Text = dr(3)
        txtaddress.Text = dr(4)

        dr.Close()
    End Sub

mga sir ito po code ko para maview ko ang nasearch ko na records..kaso pang isa lng madisplay nya sa textbox..gusto ko sana pag makahanap siya ng dalawa o higit pa na records ai ilalabas nya sa ibang form na may listview at dito niya edidisplay..panu po ang code o "if condition" nito mga sir pahingi po ng hints..tnx..

Goto first page of this thread and you'll see an example...

 

[fuzzy06]

hindi po pwede. gumagawa po kc aq ng sample compiler. kelangan po automatic masesave ung codes ng program q sa notepad. tapos sa program q may button na pag click lalabas sa multi-line textbox ung codes. posible po ba un?? by the way, thanks po sa reply.

bakit di mo nalang i copy file yung code file mo. for example yung .vb class mo i File.Copy mo yung contents nya papuntang .txt then open mo yung .txt sa notepad edi autosave na sya.

 

[bob_frog]

pano po gumawa ng sideMenu sa VB.net???
Any suggesstions po??

 

[BlackOperationS]

Sir pede makahingi ng simple tutorial about or code sa sign in sign out with database? vb.net po

 

[marniel647]

hindi po pwede. gumagawa po kc aq ng sample compiler. kelangan po automatic masesave ung codes ng program q sa notepad. tapos sa program q may button na pag click lalabas sa multi-line textbox ung codes. posible po ba un?? by the way, thanks po sa reply.

Try to Read CODEDOM in MSDN Pero masyadong mhirap gawin yun pero try mo muna yung suggestion ni fuzz.

Hi po!!
mga sir patulong naman po kung panu magsave ng image sa database ? VB.NET/mysql po gamit ko .. tnx po

If your using my sql set mo datatype ng field mo to OBJECT tapos use byte to get the image.
Pde ring filepath na lang ilagay mo sa Database kaso mhina security nito.

Sir pede makahingi ng simple tutorial about or code sa sign in sign out with database? vb.net po

May nasimulan ka na po ba?

 

[yang26]

mga boss tanong ko lang sana kung pano icoconect ung sql database using module in vb.net
tapos ung concept lang po ng module medyo naguguluminahan lang po ako first time ko kasing mag sql backend sa vb.net thanks in advance po

 

[synyster]

mga kuya tanong lang, anu magandang gamiting database?SQL server o MySQL? at anung version nila. vb2010 gamit ko. kung anu yung ms flexible sknla, need ko kasi gumawa ng information system, na my report generation. TIA

 

[BlackOperationS]

Try to Read CODEDOM in MSDN Pero masyadong mhirap gawin yun pero try mo muna yung suggestion ni fuzz.



If your using my sql set mo datatype ng field mo to OBJECT tapos use byte to get the image.
Pde ring filepath na lang ilagay mo sa Database kaso mhina security nito.



May nasimulan ka na po ba?

la pa nga sir. Hindi ko kc alam panu sisimulan. Meron po ba kayo sample program jan kahit simple lng?

 

[forbizdenz]

mga boss panu po ba code sa na kada mouseclick ko ng item sa listview ay lalabas ito sa isang listview bali dalawa po ang listview ko sa isang form
ito po code ko ayaw po lumabas sa isang listview

  Private Sub ListView2_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles ListView2.MouseClick
        Dim con As New Odbc.OdbcConnection("DSN=library")
        con.Open()
        For Each item As ListViewItem In ListView1.SelectedItems
            sqlQry = "Select CONCAT(BorrowersInfo.Fname,' ',BorrowersInfo.Lname) as Name,LibTransaction.NoofCopy,Libtransaction.DateDue from BorrowersInfo,Libtransaction where BorrowersInfo.BorrowersId = Libtransaction.BorrowersId and Libtransaction.status = 'Borrow'"
            cmd = New OdbcCommand(sqlQry, con)
            dr = cmd.ExecuteReader()
            ListView1.Items.Clear()

            While dr.Read()
                With ListView1
                    .Items.Add(dr("Name"))
                    With .Items(.Items.Count - 1).SubItems
                        .Add(dr.Item("NoofCopy"))
                        .Add(dr.Item("DateDue"))
                    End With
                End With
            End While
        Next
    End Sub

 

[marniel647]

la pa nga sir. Hindi ko kc alam panu sisimulan. Meron po ba kayo sample program jan kahit simple lng?

Imports System.Data.OleDb
Public Class Form1
    Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\marniel647\Documents\Login.accdb")
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Try

            Using Command As New OleDb.OleDbCommand("Select COUNT(*) from Table1 Where Username = @Username", con)
                Command.Parameters.AddWithValue("@Username", TextBox1.Text)
                con.Open()

                If Command.ExecuteScalar() = 0 Then
                    MessageBox.Show("Login Failed")
                Else
                    MessageBox.Show("Login Success")
                    Form2.Show()
                End If
            End Using
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        Finally
            con.Dispose()
        End Try
    End Sub
End Class

 

[BlackOperationS]

Imports System.Data.OleDb
Public Class Form1
    Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\marniel647\Documents\Login.accdb")
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Try

            Using Command As New OleDb.OleDbCommand("Select COUNT(*) from Table1 Where Username = @Username", con)
                Command.Parameters.AddWithValue("@Username", TextBox1.Text)
                con.Open()

                If Command.ExecuteScalar() = 0 Then
                    MessageBox.Show("Login Failed")
                Else
                    MessageBox.Show("Login Success")
                    Form2.Show()
                End If
            End Using
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        Finally
            con.Dispose()
        End Try
    End Sub
End Class

ty dito sir

 

[jeranas]

Need ko po WPF and VB.net tutorial.. please help.. pwede po pa-pm? thanks in advance...

 

[marniel647]

Need ko po WPF and VB.net tutorial.. please help.. pwede po pa-pm? thanks in advance...

Anong Tutorial need mo sir. Maganda Tambay ka sa MSDN Library lagi ako nkatambay dun eh.