VB.NET Programming Corner!

[lesterluma]

sir ganito po sana gusto ko mangyari.
salamat po sa sagot mo.

View attachment 779023

lagay mo sa frame lahat ng textbox at label .. then set mo visible property ng frame sa false..



sa button click event.

show mo yung frame..

frame1.show

 

[rasta_men07]

Patulong naman guys,

I've the sample image below , pa help naman pano isave multiple records sa datagrid to mysql database

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


I'm using vb.net 2008 with Navicat 8 Mysql

I know how to save and fetch records from database to datagrid pero di ko alam pano mag save ng multiple records sa datagrid to database pa help naman poh please

eto kaso c#

foreach(DataGridViewRow row in ggSample.rows)
{

string firstcolumn= row.Cells[0].Value.ToString(); // first column
string secondcolumn= row.Cells[1].Value.ToString(); // second column
//tapos lagyan mo nalng ng function para mag save sya sa database..

}

gawa ka ng function na save tapos lagay mo sa loop bale papasa mo lang un values sa fuinction

 

[iknowhtml]

lagay mo sa frame lahat ng textbox at label .. then set mo visible property ng frame sa false..



sa button click event.

show mo yung frame..

frame1.show

sir my shortcut po ba para d na ko magtype ng ganito kahaba..

label1.visible = false
label2.visible = false
label3.visible = false
textbox1.visible = false
textbox2.visible = false... etc..

pwed po pshare ng code. salamat po..

 

[lesterluma]

sir my shortcut po ba para d na ko magtype ng ganito kahaba..

label1.visible = false
label2.visible = false
label3.visible = false
textbox1.visible = false
textbox2.visible = false... etc..

pwed po pshare ng code. salamat po..

pwede ka pong gumamit ng WITH AT ENDWITH pampaikli ng codes..

kung ako sayo lagay mo nlng yan sa frame ,, sabay yung frame lang I HIDE mo .. tapos isang code line of code lang yan

 

[j0dieth]

panoo po pagchange nung name nung ballance

 

[sinigangnapork]

panoo po pagchange nung name nung ballance

Kung listview po ito, sa design time, pwede mo po i change using Edit Columns -> Text Property

Attached po ung screenshot dito.

 

[Karma_0]

pa help po about visual studio 2012.. yung database ko po is mdb ang file . ang gusto ko po sana gamit yung vb ma eedit ko yung database ..

 

[edmuezel]

Public Class clsWMI
Private objOS As ManagementObjectSearcher
Private objCS As ManagementObjectSearcher
Private objMgmt As ManagementObject
Private m_strComputerName As String
Private m_strManufacturer As String
Private m_StrModel As String
Private m_strOSName As String
Private m_strOSVersion As String
Private m_strSystemType As String
Private m_strTPM As String
Private m_strWindowsDir As String


Public Sub New()

objOS = New ManagementObjectSearcher("SELECT * FROM Win32_OperatingSystem")
objCS = New ManagementObjectSearcher("SELECT * FROM Win32_ComputerSystem")
For Each objMgmt In objOS.Get

undefined po ung managementobjectsearcher, ManagementObject
ano po gagawin ko jan? bago lang po kasi ako sa vs . patulong naman po. salamat,

 

[polens]

Public Class clsWMI
Private objOS As ManagementObjectSearcher
Private objCS As ManagementObjectSearcher
Private objMgmt As ManagementObject
Private m_strComputerName As String
Private m_strManufacturer As String
Private m_StrModel As String
Private m_strOSName As String
Private m_strOSVersion As String
Private m_strSystemType As String
Private m_strTPM As String
Private m_strWindowsDir As String


Public Sub New()

objOS = New ManagementObjectSearcher("SELECT * FROM Win32_OperatingSystem")
objCS = New ManagementObjectSearcher("SELECT * FROM Win32_ComputerSystem")
For Each objMgmt In objOS.Get

undefined po ung managementobjectsearcher, ManagementObject
ano po gagawin ko jan? bago lang po kasi ako sa vs . patulong naman po. salamat,

kaylangan mo ireference ung class library or dll niya...saan mo ba nakuha yang code?
"System.Management.dll"
http://msdn.microsoft.com/en-us/library/system.management.managementobjectsearcher.aspx

 

[iknowhtml]

pwede ka pong gumamit ng WITH AT ENDWITH pampaikli ng codes..

kung ako sayo lagay mo nlng yan sa frame ,, sabay yung frame lang I HIDE mo .. tapos isang code line of code lang yan

sir pwd po pasample ng code, mdyo nlilito po ko e, =D. Thanks po.

 

[edmuezel]

kaylangan mo ireference ung class library or dll niya...saan mo ba nakuha yang code?
"System.Management.dll"
http://msdn.microsoft.com/en-us/library/system.management.managementobjectsearcher.aspx

sa google po. thanks po sa pagsagot. try ko ts..

 

[j0dieth]

Kung listview po ito, sa design time, pwede mo po i change using Edit Columns -> Text Property

Attached po ung screenshot dito.

Thank uuu

 

[knives645]

sir pwd po pasample ng code, mdyo nlilito po ko e, =D. Thanks po.

With
.txtLastname.Visible = True
.txtFirstName.Visible = True
End With

Maganda gawa ka na lang ng Procedure to Switch your controls on/off

Ex.

Private Sub ShowButtons(ByVal bVal as Boolean)
txtLastName.Visible = bVal
txtFirstName.Visible = bval
''' Put all controls here.
End Sub

Then to hide your controls...
Call ShowButtons(False)


To Show...
Call ShowButtons(True)

 

[lesterluma]

Hello ka'symb. matagal na rin ako di nakakapost dito ah. hehe..

may nakaka alam ba nito ? see attached pix..


1. paano ko mapag sama sama sa isang row yung mga duplicate na items sa listview ??

Ex.

sa column 1
1000 - 1100 ------- first column
1000 - 1100 -------second column

paano siya magiging isa ? I mean blank nlng yung mga next item..

Expected Output..
1000 - 1100 ----------- first column lang hindi na kasama yung second column kasi same lang sila ng value eh.



thx ka symb .




HERES THE LINK of PICTURE..

http://www.symbianize.com/attachment.php?attachmentid=780739&d=1377823329

 

[Wintaburr]

Hello ka'symb. matagal na rin ako di nakakapost dito ah. hehe..

may nakaka alam ba nito ? see attached pix..


1. paano ko mapag sama sama sa isang row yung mga duplicate na items sa listview ??

Ex.

sa column 1
1000 - 1100 ------- first column
1000 - 1100 -------second column

paano siya magiging isa ? I mean blank nlng yung mga next item..

Expected Output..
1000 - 1100 ----------- first column lang hindi na kasama yung second column kasi same lang sila ng value eh.



thx ka symb .




HERES THE LINK of PICTURE..

http://www.symbianize.com/attachment.php?attachmentid=780739&d=1377823329

Select DISTINCT:
http://www.w3schools.com/sql/sql_distinct.asp

 

[lesterluma]

Select DISTINCT:
http://www.w3schools.com/sql/sql_distinct.asp

thnx.. KASI gumagamit ng VIEWS dito para maging ganun lang yung item sa listview eh.



eto naman...



eh.. paano naman kapag nag click ako ng button dapat mahihighlight yung next item ng listview tapos ma'kClick yung na highlight na next item tapos show yung next form.


see nyo yung attached picture..


View attachment 132741

ex.

once na knlick ko yung BUTTON dapat pupunta siya sa next item ng listview..


dapat mahihighlight yung next row.. then Click yung next row na yun.. then form.show... thanks ka SYMB .

 

[Wintaburr]

thnx.. KASI gumagamit ng VIEWS dito para maging ganun lang yung item sa listview eh.



eto naman...



eh.. paano naman kapag nag click ako ng button dapat mahihighlight yung next item ng listview tapos ma'kClick yung na highlight na next item tapos show yung next form.


see nyo yung attached picture..


View attachment 780747

ex.

once na knlick ko yung BUTTON dapat pupunta siya sa next item ng listview..


dapat mahihighlight yung next row.. then Click yung next row na yun.. then form.show... thanks ka SYMB .

Try mo to:

        ListView1.FullRowSelect = True
        Dim IndexOfSelectedRow = ListView1.FocusedItem.Index
        ListView1.Focus()
        ListView1.Items(IndexOfSelectedRow).Selected = False
        IndexOfSelectedRow += 1
        ListView1.Items(IndexOfSelectedRow).Selected = True

 

[lesterluma]

Try mo to:

        ListView1.FullRowSelect = True
        Dim IndexOfSelectedRow = ListView1.FocusedItem.Index
        ListView1.Focus()
        ListView1.Items(IndexOfSelectedRow).Selected = False
        IndexOfSelectedRow += 1
        ListView1.Items(IndexOfSelectedRow).Selected = True

okay na po papsi..


PROBLEM SOLVED na

 

[rhon6260]

Hello mga Developers

Meron po bang nakapag encounter na Exception


Meron kase pinapadagdag na module sakin e yung gamit nila na DLL e yung medyo kalumaan na AxInterop.MSFlexGridLib

yung gusto ng boss ko e mag add lang ako ng bagung module gamit yung DLL.

EDIT:

Panu po ba e register yung DLL? error kase yung pagregister ko
At RUN
Type regsvr32 AxInterop.MSFlexGridLib.dll error yung result.

EDIT:

Ok na po pala mga boss

 

[mickaboy72]

mga sir eto po prob ko.
matatapos na po kasi ako sa CALCULATOR ko..

ang prob ko po yung mga radio buttons ko.
gusto ko po sana kapag pinindot eh magcoconvert sa kani-kanilang assigned number system

Example:

nasa DEC(decimal) ako then lagay input then pag pindot dapat sa BIN(binary) eh yung txtbox ko dapat converted na sa binary.

attach ko po yung calc ko.

eto po skype ko.

micka_boy72

and I'm using Visual Studio 2010