VB.NET Programming Corner!

[knives645]

Check the Size of your default printer, baka naka-set sa maliit.

 

[dhennehd]

Wow, galing mo talaga sir knives! thanks po!

 

[redph0enix]

mga sir sino po maruning mag set up ng pagconnect ng vb.net app sa sql server via wifi? paturo sana may project po kasi ako and required na via wifi ang connection. at least 5 units ang kailangan connected. nag search narin ako sa net at sinundan ko ung instructions nitong vid: Link. total newbie po ako dito sa setup na ganito. sana may makatulong ty

Kung nakapagsetup ka ng sa wired network pareho lang din yung sa wireless as long na may access yung mga client sa sql server,

Anong version at edition ng SQL Server ang gamit mo?

 

[abzxd]

Sir, Pano poh ba kunin yung VALUE ng selected listview papunta sa combobox

Private Sub frmEdit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = D:\Files\MySystem\Student Information System\StudentInfo.accdb;Persist Security Info = false"
Dim daGender As New OleDbDataAdapter("SELECT * FROM tblGender ", con)


con.Open()
daGender.SelectCommand = New OleDbCommand("select * from tblGender", con)
daGender.Fill(dt)

With cboGender
.DataSource = dt
.DisplayMember = "Gender"
.ValueMember = "GenderID"
.SelectedItem = frmMain.dataListView.SelectedItems(frmMain.dataListView.FocusedItem.Index).SubItems(4).Text
End With

End Sub

yung laman poh ng Combobox , 1 = female 2 = male
tapos pag naka display na yung combobox.. always siya 1 = female kahit male yung data na naka save sa MS access database ng student..

Pa help poh.. bago lang sa VB.net
sana matulungan poh niyo ako.. tanong lang poh pag may hndi na intindihan.. >_<

 

[nb200]

@redph0enix

thanks sa reply pre. SQL server 2008 r2. nakapag try nako 2 pc dati pero via utp cable (walang router) lang un tsaka matagal na un nalimutan ko na. hanggang ngayon di ko pa mapagana. paste ko nalang dito ung current progress ko galing dun sa thread na pinost ko sa vbforums.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

good afternoon. im trying to connect my vb.net app from 1 pc to another pc with sql server via wifi but i cant seem to make it work.

I have a computer with Windows 7 & SQL Server 2008 R2 with my database attached to it. (server). i also have another pc with my app installed in it (client. planning to make it at least 4 computers). they are both connected to a wireless router.

i already tried following these steps:

1) Install SQL Server Express edition in a machine which you want to act as server machine.

2) Allow TCP/IP connection in server machine. Open SQL Server Configuration Manager -> in left panel expand SQL Server [version] Network Configuration -> double click Protocols for SQLEXPRESS -> in right panel right click TCP/IP and select Enable.

3) Set exception for the port number which you're using for SQL Server in server machine.
I) Default port number is 1433. To find/set your port number, open SQL Server Configuration Manager -> in left panel expand SQL Server [version] Network Configuration -> double click Protocols for SQLEXPRESS, right click TCP/IP and select Properties -> Select IP Addresses tab -> scroll down to IP4 -> TCP Port (your port number).
II) Control Panel > Windows Firewall > Advanced settings -> Inbound Rules (in left panel) -> Select New Rule... (in Actions) -> Select Port -> Click Next -> Select TCP and Enter your SQL Server's port number (1433 default port number) -> Click Next -> Select Allow the connection -> Click Next -> Select the network types in which you want to allow set an exception -> Click Next -> Enter any name -> Click Finish.

4) Connect other computers to this server machine via your lan cable.

5) Assign unique IP address to all machines over this lan network including the server machine.

6) In your application's connection string line use Data Source as Server machine's IP Address (lan's IP address), Port Number.

i also used this connectionstring format (removed the username/password part since i did not set any, used the ip address i got in ipconfig in cmd):

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

any help will be appreciated. thanks.

 

[glaidcm]

Good Day to all,
Pwede pong magtanong?

Using VB.Net, paano po ang coding nung paghandle ng error message sa oracle application? I'm using sendkeys po kc sa pag-upload ng data to oracle, eh pag may nagpop-up po na error message ndi nadedetect ng VB.Net at tuloy tuloy pa din ang pag-aupload kaya in the end, nagkukulang po ung inapload na data. Hoping anyone can help.

Any suggestions will be very much appreciated. Maraming salamat po.

 

[nabil1975]

HELP PO sino po my sms grade inquiry system pahingi naman pang guide lang sa gagawing kung thesis ee sino po merun jan pahingi po pllllllleasee!

pahingi na rin po ng TUT pano gamitin ang at command .gusto ku kc i propos sa thesis ko sms grade inquiry pero diko aam pano makakarecve ng text at automatic repllllllly gamit ang broadband sana may tumuong .

 

[jhonz28]

guys tanong lng po. may idea po ba kayo kung pano mag auto refresh ung listview for every 5mins using timer.

salamat po

 

[zoombeee]

@redph0enix

thanks sa reply pre. SQL server 2008 r2. nakapag try nako 2 pc dati pero via utp cable (walang router) lang un tsaka matagal na un nalimutan ko na. hanggang ngayon di ko pa mapagana. paste ko nalang dito ung current progress ko galing dun sa thread na pinost ko sa vbforums.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

good afternoon. im trying to connect my vb.net app from 1 pc to another pc with sql server via wifi but i cant seem to make it work.

I have a computer with Windows 7 & SQL Server 2008 R2 with my database attached to it. (server). i also have another pc with my app installed in it (client. planning to make it at least 4 computers). they are both connected to a wireless router.

i already tried following these steps:

1) Install SQL Server Express edition in a machine which you want to act as server machine.

2) Allow TCP/IP connection in server machine. Open SQL Server Configuration Manager -> in left panel expand SQL Server [version] Network Configuration -> double click Protocols for SQLEXPRESS -> in right panel right click TCP/IP and select Enable.

3) Set exception for the port number which you're using for SQL Server in server machine.
I) Default port number is 1433. To find/set your port number, open SQL Server Configuration Manager -> in left panel expand SQL Server [version] Network Configuration -> double click Protocols for SQLEXPRESS, right click TCP/IP and select Properties -> Select IP Addresses tab -> scroll down to IP4 -> TCP Port (your port number).
II) Control Panel > Windows Firewall > Advanced settings -> Inbound Rules (in left panel) -> Select New Rule... (in Actions) -> Select Port -> Click Next -> Select TCP and Enter your SQL Server's port number (1433 default port number) -> Click Next -> Select Allow the connection -> Click Next -> Select the network types in which you want to allow set an exception -> Click Next -> Enter any name -> Click Finish.

4) Connect other computers to this server machine via your lan cable.

5) Assign unique IP address to all machines over this lan network including the server machine.

6) In your application's connection string line use Data Source as Server machine's IP Address (lan's IP address), Port Number.

i also used this connectionstring format (removed the username/password part since i did not set any, used the ip address i got in ipconfig in cmd):

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

any help will be appreciated. thanks.

..gawa ka muna sir ng login user. at user dun sa sql server pati dun sa database mo.. gumagana sya kahit adhoc lang gamit sa windows 7 wireless un..
ganito kc ginawa ko sa module sya nkalagay icocol ko lng sya sa form load sa connection.
Public cnstring As String
Public Sub ConnectonString(ByRef constring As String, ByRef UID As String, ByRef Pwd As String)
cnstring = "Server='" & constring & "';Database=VOHDBASE;User Id='" & UID & "';Password='" & Pwd & "';"
End Sub

 

[jc1714]

ask ko lang po.

visual basic 2005 po gamit ko.

pano po ba to.

pagkaload po ng unang form, say form 1, may button papuntang form2, sa form 2, may button na nakahide.

pero kapag nag log in ka(nasa form1 ang log in)

ung button na naka hide sa form 2, mag show na.

pano po ba un.

help po.

 

[orthodudz]

palink pi ng software ng vb.net.... gusto ko po kasi matoto

 

[leftright1]

ask ko lang po.

visual basic 2005 po gamit ko.

pano po ba to.

pagkaload po ng unang form, say form 1, may button papuntang form2, sa form 2, may button na nakahide.

pero kapag nag log in ka(nasa form1 ang log in)

ung button na naka hide sa form 2, mag show na.

pano po ba un.

help po.

Magset ka kuya ng variable na pwedeng i-validate dun sa form1. (ex: userlevel)

Example, admin yung value ng userlevel, i-visible = true mo yung button tapos i-show mo yung form.

Else, show mo lang yung form. Sorry 'di ko mabigay yung eksaktong code, pero ganyan yung process.

 

[third143]

palink pi ng software ng vb.net.... gusto ko po kasi matoto

http://www.visualstudio.com/en-us/products/visual-studio-express-vs.aspx

 

[naglasnats]

Help naman po mas maintindihan to sa vb.net.

Encoding, Encryption and Hashing

http://danielmiessler.com/study/encoding_encryption_hashing/

Sana with examples po. Thanks.

 

[xiiCharlZ]

for sharing

 

[dinuguanz]

give and share ng info... thank you thank you for this thread

tanong lang po
pwede po ba mag open ng word office sa web browser ng vb.net?

 

[RUNGORIO]

Mga Idol sino sa inyo na kagawa na ng program na nag eemail nakagawa ako thru vb.net pero binoblock xa ng antivirus pag sa sql2012 naman po ginamit ko un sp_send_dbmail kaso di ako makapag attach ng file ... pa help naman po thanks

 

[karloy]

pa help naman po, gusto ko kasi pag nagupdate ako ng user_information ang lalabas lang sa logs ay kung anong textbox ang binago ko

 

[puuts]

pa help naman po, gusto ko kasi pag nagupdate ako ng user_information ang lalabas lang sa logs ay kung anong textbox ang binago ko

may nagawa knb?
patingin ng code mo

 

[masker]

hello mga sir /madam patulong po sa pagpili ng biometrics reader pano po magprogram gamit ito..
lang: vb.net