VB.NET Programming Corner!

[ryu_shinobi]

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

nagawa po kasi ako ng information system ng patients.,

ok na po ung system.,printing nalang ng information ng patients kailangan ko.,

kailangan ko po makagawa ng report o history ng patients in detailed view.,.parang chart ng isang patient.,lahat po ksi ng napanood kong tutorial puro naka tabular o naka dategrid ung view.,.

xenxa na po kung maxado akong maraming tanong.,.beginner lang po talaga ako.,.,

tama po ba yung pagkakaintindi ko na kailangan mo sa report eh naka chart...
either pie, bar or line chart??

 

[jayrwafu]

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

sa lahat ng may problem sa crystal report ,pls read this first :

Crystal report 2008 for Dummies Ebook

DL : http://www.mediafire.com/?vf5y6glbpc6rn66

 

[ericgmejia]

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

sa lahat ng may problem sa crystal report ,pls read this first :



@sir eric , pls advice me kung idelete ko n toh...

thnx...

delete ang alin?
yung binigay kong files sayo?
di naman sa akin yan so wala ako rights dyan do as you please...

marami akong codes sa crystal dati, puro experiments hangang na master ko yung PUSH method using XML sa designing
mula noon yun na ang gamit ko

 

[ericgmejia]

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

salamat po.,.,nagawa ko na....



additional question po.,.panu po ba gumawa ng reports na naka details view???kasi po lahat po ng pinanood kong tutorial puro naka datagrid view e.,kahit po ung crystal reports.,ung preint form naman po form ung pnprint.,.may way po ba na pwd kong icustomize ung report as details view???help naman po.,

never naging effective sa akin ang mga video tutorials, ewan ko lang sa iba
i prefer na tignan ang codes at gawin or i simulate ko mismo ang steps

ang details view according sa kaibigan natin ay isang record ng naglalaman ng DETAILS ng personal info nf isang patient

iba yung term natin na details sa term nya.

 

[graffiti_alley]

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

@sir eric pano po mag execute ng code at a specific time?kunwari po 3 seconds after pinindot yung button?

 

[ryu_shinobi]

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

@sir eric pano po mag execute ng code at a specific time?kunwari po 3 seconds after pinindot yung button?

pwede ka po gumamit ng thread...

meron syang property na elapsed time..
pwede nyo pong gamitin yun...

 

[doorbreaker]

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

nagawa po kasi ako ng information system ng patients.,

ok na po ung system.,printing nalang ng information ng patients kailangan ko.,

kailangan ko po makagawa ng report o history ng patients in detailed view.,.parang chart ng isang patient.,lahat po ksi ng napanood kong tutorial puro naka tabular o naka dategrid ung view.,.

xenxa na po kung maxado akong maraming tanong.,.beginner lang po talaga ako.,.,

ano po gamit mong report na object? crystal? or yung default ng vb.net?

 

[ericgmejia]

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

@sir eric pano po mag execute ng code at a specific time?kunwari po 3 seconds after pinindot yung button?

bakit di mo nalang pindutin ang button after 3sec.

hehehe


timer is simplest
sa click button > enable time
sa Timer Event > disable time >run Command

isang trick yan na ginagawa ko sa pag load ng form
enable ko ang timer sa load event
then after 3sec, may code na i run
just to make sure properly loaded ang form bago mag run

pag thread yan make sure BLOCKING THREAD yan
at babalik ang control sa calling code after executing

 

[doorbreaker]

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

@sir eric pano po mag execute ng code at a specific time?kunwari po 3 seconds after pinindot yung button?

pwede ka din gumamit ng timer kung gusto mo bukod dun sa sinabi ni kuya ryu.

to start the timer

button_click
  timer.interval = 3000
  timer.start
end sub


timer_elapsed 
  <whatever you want to execute>
  timer.stop
end sub

*sorry nasagot na pala ni sir eric

 

[graffiti_alley]

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

bakit di mo nalang pindutin ang button after 3sec.

hehehe


timer is simplest
sa click button > enable time
sa Timer Event > disable time >run Command

isang trick yan na ginagawa ko sa pag load ng form
enable ko ang timer sa load event
then after 3sec, may code na i run
just to make sure properly loaded ang form bago mag run

pag thread yan make sure BLOCKING THREAD yan
at babalik ang control sa calling code after executing

salamat sir!pano po yung 3 seconds?sa interval po ba?sir baka pwede nyo na icheck yung system ko.hehee yung exe lng po, masyadong malaki pag yung source code..

 

[graffiti_alley]

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

pwede ka din gumamit ng timer kung gusto mo bukod dun sa sinabi ni kuya ryu.

to start the timer

button_click
  timer.interval = 3000
  timer.start
end sub


timer_elapsed 
  <whatever you want to execute>
  timer.stop
end sub

*sorry nasagot na pala ni sir eric

ayun na.hehee salamat sir!

 

[graffiti_alley]

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

panu naman po pala kapag every second eh nag-eexecute ng code?..

 

[doorbreaker]

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

Shared ko lang yung gamit ko naman na trick para sa loading aside sa sinabi ni sir eric na timer.
I use backgroundworker meron sya event na Do_Work and Work_Completed.

form_load
backgroundworker.runworkerasync
end sub

backgroundworker_do_work
<do whatever>
end sub

backgroundworker_WorkCompleted
btnsave.enabled = true
<or whatever buttons>
end sub

 

[doorbreaker]

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

panu naman po pala kapag every second eh nag-eexecute ng code?..

1000 ang interval then wag mo lagyan ng timer.stop sa loob ng elapsed/tick event para loop nlng ng loop yon.

*nga pala elapsed nilagay ko kanina system.timers.timer ang event na yun pag windows.forms.timer tick naman ang event

 

[graffiti_alley]

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

Shared ko lang yung gamit ko naman na trick para sa loading aside sa sinabi ni sir eric na timer.
I use backgroundworker meron sya event na Do_Work and Work_Completed.

form_load
backgroundworker.runworkerasync
end sub

backgroundworker_do_work
<do whatever>
end sub

backgroundworker_WorkCompleted
btnsave.enabled = true
<or whatever buttons>
end sub

ayos!salamat sa tips mga bossing!

 

[graffiti_alley]

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

1000 ang interval then wag mo lagyan ng timer.stop sa loob ng elapsed/tick event para loop nlng ng loop yon.

*nga pala elapsed nilagay ko kanina system.timers.timer ang event na yun pag windows.forms.timer tick naman ang event

salamat sir.tama po ba code ko sa restore database?kasi nagdelete ako ng table kanina sa may navicat tas try ko ni-restore di naman bumalik yung table..eto po code :

Private Sub BackupDatabaseToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BackupDatabaseToolStripMenuItem.Click
Timer2.Enabled = True
Timer2.Interval = 3000
Timer2.Start()
Process.Start("C:\xampp\mysql\bin\mysqldump.exe", " --host=localhost --user=root --password=walanaman slcsms -r ""C:\slcsms.sql"" ")
End Sub

Private Sub RestoreDatabaseToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RestoreDatabaseToolStripMenuItem.Click
Timer3.Enabled = True
Timer3.Interval = 1000
Timer3.Start()
Process.Start("C:\xampp\mysql\bin\mysqldump.exe", " --host=localhost --user=root --password=walanaman slcsms < ""C:\slcsms.sql"" ")
End Sub

Private Sub bakup()
MsgBox("Database successfully backed up!", MsgBoxStyle.Information)
End Sub

Private Sub restor()
MsgBox("Database successfully restored!", MsgBoxStyle.Information)
End Sub

Private Sub Timer2_Tick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer2.Tick
bakup()
Timer2.Stop()
End Sub

Private Sub Timer3_Tick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer3.Tick
restor()
Timer3.Stop()
End Sub

 

[ericgmejia]

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

salamat sir!pano po yung 3 seconds?sa interval po ba?sir baka pwede nyo na icheck yung system ko.hehee yung exe lng po, masyadong malaki pag yung source code..

of course sa interval, same lang sa code ni door breaker

click button >> START TIMER

WHEN TIMER GOES OFF > STOP IT THEN RUN COMMAND


dapay masanay kayong gumawa ng logic and codes based on simple english instructions, no need to elaborate instructions

 

[kenetox]

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

of course sa interval, same lang sa code ni door breaker

click button >> START TIMER

WHEN TIMER GOES OFF > STOP IT THEN RUN COMMAND


dapay masanay kayong gumawa ng logic and codes based on simple english instructions, no need to elaborate instructions

sir eric meron po ba kayong sample codes para sa SMS application? thesis po kasi eh.. kahit ung email to sms lng or kahit simple AT commands..

 

[ericgmejia]

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

salamat sir.tama po ba code ko sa restore database?kasi nagdelete ako ng table kanina sa may navicat tas try ko ni-restore di naman bumalik yung table..eto po code :

teka bakit ganyan ang code mo?
mali ang approach ng solution mo

ginamitan mo ng timer, e di mo naman alam kung kelan matatapos yung process

ang Process object ay meron properties para malaman kung tapos na to mag exectute

so pwede ka mag message pag nag exit na yung process

'---------------------------------------------
Dim myProcess As Process = Process.Start("C:\xampp\mysql\bin\mysqldump.exe", " --host=localhost --user=root --password=walanaman slcsms -r ""C:\slcsms.sql"" ")

Do While Not myProcess.HasExited Then
Tambay lang dito habang running ang process
Loop

pagdating dito tapos na yung process mo
'----------------------------------------------
mag message ka na

http://www.thedesilva.com/2010/01/using-cmd-exe-with-vb-net-process-start/

 

[ericgmejia]

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

sir eric meron po ba kayong sample codes para sa SMS application? thesis po kasi eh.. kahit ung email to sms lng or kahit simple AT commands..

try mo to, nakita ko lang kanina
http://electrofriends.com/projects/computer-programming/mticket-mobile-booking/