Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

VB.NET Programming Corner!

Re: VB.NET Programming Corner! UPDATED!!!

sir tanong ko lang kung pano gumawa ng graphs sa vb.net.. kelangan bang mag -download ng control? tsaka sir d ako sigurado sa ilalagay kong module sa analysis part ng system ko..:help:
tama ba ito?
re-order level -
Safety Stocks -
Lead Time Analysis -
Variances -
EOQ computation -
Turn-Over Analysis -

ang plano ko kukuha ako ng data through query tapos sa query ko icocompute.. then i-didisplay ko na lang... kaso mahirap i-display sa isang query lang and matatagal ata ang pag process kasi d naman ako naka stored procedure...:help:
ang system ko ay inventory analysis and forecasting.... maraming salamat sa tutulong

ako basic graphics lang using lines at rectangles, medyo mabigat sa coding lang pero walang 3rd party na kelangan

pwede mo kunin sa query tapos kung kulang pa pwede mo naman galwain ang dataset na makukuha mo e, pwede mo yun i update parin bago mo i idsplay
 
Re: VB.NET Programming Corner! UPDATED!!!

sir pano po magfit ung datagrid view pag minaximize ung form?
 

Attachments

  • howtofit.png
    howtofit.png
    75.4 KB · Views: 14
Re: VB.NET Programming Corner! UPDATED!!!

Cnu poh my video tuitorial ng vb.net 10??? Pa mediafire nmn poh tanx poh ng mdme
 
Re: VB.NET Programming Corner! UPDATED!!!

off topic lng po...

mga sir,

panu mabubuhay ang programmer kung walang computer T_T .... ?

kawawa /sob... T_T

PS. pm me kung meron bargain dyan na medyo mabilis ... =)
 
Last edited:
Re: VB.NET Programming Corner! UPDATED!!!

off topic lng po...

mga sir,

panu mabubuhay ang programmer kung walang computer T_T .... ?

kawawa /sob... T_T

PS. pm me kung meron bargain dyan na medyo mabilis ... =)


check ka lang sa tipid pc...
hehehe
 
Re: VB.NET Programming Corner! UPDATED!!!

website i can download VB.NET??
 
Re: VB.NET Programming Corner! UPDATED!!!

mga boss...pano po automatic update ng datagridview matapos mong mag enter ng data??

ito po codes ko sa form ng pag-aadd ng Vendor .. pasenxa na po baguhan lang...



Code:
Imports System.Data.SqlClient
Public Class Vendor

    Dim connection As New SqlConnection("Data Source =TOBZ-PC\SQLEXPRESS; Initial Catalog =Glowb; Integrated Security =SSPI;")
    Dim adapter As New SqlDataAdapter("SELECT * FROM [Vendor]", connection)
    Dim dataset As New DataSet

    Private Sub Vendor_List_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        adapter.Fill(dataset, "Vendor")
        DataGridView1.DataSource = dataset.Tables("Vendor")
        TextBox1.Focus()
    End Sub

    Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click

        Dim cmd As New SqlCommand

        connection.ConnectionString = "Data Source =TOBZ-PC\SQLEXPRESS; Initial Catalog =Glowb; Integrated Security =SSPI;"
        connection.Open()
        cmd.Connection = connection
        cmd.CommandText = "INSERT INTO Vendor([Vendor Name], [Vendor Phone Number]) VALUES('" & TextBox1.Text & "',  '" & TextBox2.Text & "')"
        cmd.ExecuteReader()

        If MessageBox.Show("Vendor successfully added. Do you wish to add another Vendor?", "Vendor", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then
            TextBox1.Text = ""
            TextBox2.Text = ""
            TextBox1.Focus()
        Else
            Me.Close()
        End If
        connection.Close()
    End Sub

    Private Sub ExitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitButton.Click
        Me.Close()
    End Sub
End Class

salamat po...
 
Re: VB.NET Programming Corner! UPDATED!!!

mga boss...pano po automatic update ng datagridview matapos mong mag enter ng data??

ito po codes ko sa form ng pag-aadd ng Vendor .. pasenxa na po baguhan lang...



Code:
Imports System.Data.SqlClient
Public Class Vendor

    Dim connection As New SqlConnection("Data Source =TOBZ-PC\SQLEXPRESS; Initial Catalog =Glowb; Integrated Security =SSPI;")
    Dim adapter As New SqlDataAdapter("SELECT * FROM [Vendor]", connection)
    Dim dataset As New DataSet

    Private Sub Vendor_List_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        adapter.Fill(dataset, "Vendor")
        DataGridView1.DataSource = dataset.Tables("Vendor")
        TextBox1.Focus()
    End Sub

    Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click

        Dim cmd As New SqlCommand

        connection.ConnectionString = "Data Source =TOBZ-PC\SQLEXPRESS; Initial Catalog =Glowb; Integrated Security =SSPI;"
        connection.Open()
        cmd.Connection = connection
        cmd.CommandText = "INSERT INTO Vendor([Vendor Name], [Vendor Phone Number]) VALUES('" & TextBox1.Text & "',  '" & TextBox2.Text & "')"
        cmd.ExecuteReader()

        If MessageBox.Show("Vendor successfully added. Do you wish to add another Vendor?", "Vendor", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then
            TextBox1.Text = ""
            TextBox2.Text = ""
            TextBox1.Focus()
        Else
            Me.Close()
        End If
        connection.Close()
    End Sub

    Private Sub ExitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitButton.Click
        Me.Close()
    End Sub
End Class

salamat po...


gawa ka ng function para sa pag fill mo ng data sa datagridview tapos un ung call mo sa form load mo....

sample:
private function fill()
datagridview1.clear
adapter.Fill(dataset, "Vendor")
DataGridView1.DataSource = dataset.Tables("Vendor")
end function


tapos lagay mo ulit yang function na yan pagkatapos mo mag add....
 
Re: VB.NET Programming Corner! UPDATED!!!

mga sir pa help naman po ule... pano ko maseset ang line spacing sa string or sa richtextbox gaya sa microsoft word na pwede baguhin... tnx in advance..
 
Re: VB.NET Programming Corner! UPDATED!!!

mga sir pa help naman po ule... pano ko maseset ang line spacing sa string or sa richtextbox gaya sa microsoft word na pwede baguhin... naghanap hanap na ako sa google kaso wala ako nahanap e... tnx in advance..
 
Re: VB.NET Programming Corner! UPDATED!!!

gawa ka ng function para sa pag fill mo ng data sa datagridview tapos un ung call mo sa form load mo....

sample:



tapos lagay mo ulit yang function na yan pagkatapos mo mag add....

salamat boss ... :yipee:
 
Re: VB.NET Programming Corner! UPDATED!!!

sir pagdinock po sa parent controls natatakpan ña po ung mga buttons sa taas?:noidea:
 
Re: VB.NET Programming Corner! UPDATED!!!

sir pagdinock po sa parent controls natatakpan ña po ung mga buttons sa taas?:noidea:

use anchor instead of dock.

by default nka anchor yan TOP,LEFT idagdag mo lang ang RIGHT para pag nag maximize ang form lalaki din ang grid mo same distance ng design mo.

pwede mo din ianchor sa BOTTOM pero dapat pati yung ibang controls or buttons mo sa ibaba tangalin mo ang ancor sa TOP palitan mo ng BOTTOM.
 
Re: VB.NET Programming Corner! UPDATED!!!

Mga sir, paano ba i-zoom ang video at mag-capture ng screenshot gamit ang vb? Sana may nakakaalam.

:thanks:
 
Re: VB.NET Programming Corner! UPDATED!!!

mga boss nid help

panu ko gagawin ang listview ko ng ganitong format.
a1mqad.jpg


eto po kasalukuyan kong listview

30thyky.jpg

pa tulong nman po mga boss
 
Last edited:
Re: VB.NET Programming Corner! UPDATED!!!

mga boss pahelp

Bali meron po akong dalawang datagridview

yun isa source at yun isa destination

balak ko kasi is magkaroon ng drag and drop event ng datagridview

from datagrid1 to datagrid2

bali yun datagrid1 as source imported yun data from excel then
icocopy yun data ng datagrid1 then paste to datagrid2 then save to database.

as of now e2 yun code ko na my mali pa..


Private Sub DataGridView1_MouseDoubleClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseDoubleClick
Dim obj As DataGridViewSelectedRowCollection = DataGridView1.SelectedRows
If (obj.Count > 0) Then
DataGridView2.Rows.Add(1)
DataGridView2.Rows(0).Cells(0).Value = obj(0).Cells(0).Value
End I
 
Re: VB.NET Programming Corner! UPDATED!!!

@Rasta

pre mas ok yan kung idatagridview mo n lng yan kesa sa listview
 
Back
Top Bottom