VB.NET Programming Corner!

[ramnad31]

mga sir ano po kaya pwede ko gawin para pag nagsearch ako dun magshoshow yung nasearch ko sa datagridview.
salamat po sa mga sasagot

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim reader As MySqlDataReader

Try
mycon.Open()
Dim query As String
query = " select * from db_bis.resident where firstname='" & txt_search.Text & "' "
com = New MySqlCommand(query, mycon)
reader = com.ExecuteReader
While reader.Read

txt_id.Text = reader.GetInt32("id")
txt_fn.Text = reader.GetString("firstname")
txt_mn.Text = reader.GetString("middlename")
txt_ln.Text = reader.GetString("lastname")
txt_bd.Text = reader.GetString("birthdate")
txt_bp.Text = reader.GetString("birthplace")
txt_age.Text = reader.GetInt16("age")
gen = reader.GetString("gender")

End While

mycon.Close()

Catch ex As Exception

End Try

End Sub
View attachment 1220132

try mo add to after com = New MySqlCommand(query, mycon)

dim sqlDA=new mysqlDataAdapter(com)
dim dt as new datatable
sqlDA.fill(dt)
datagrid1.datasource=dt

 

[remoshed]

hehe..salamat sir..ok nato..atleast nka hide na sya pag print ko..hehe..

- - - Updated - - -

try mo add to after com = New MySqlCommand(query, mycon)

dim sqlDA=new mysqlDataAdapter(com)
dim dt as new datatable
sqlDA.fill(dt)
datagrid1.datasource=dt

- - - Updated - - -

sir hide mo nalang muna ung mga button tapos show mo nalang ulit

ex.
Button1.Visible=False
PrintForm1.PrintAction = Printing.PrintAction.PrintToPreview
PrintForm1.Print()
Button1.Visible=True

hehe..salamat sir..ok nato..atleast nka hide na sya pag print ko..hehe..

 

[shestheman]

Mga sir pwede ba mag send bulk sms using AT commands? sino mero sourcecode para po mapag aralan at ma lagay sa system na ginagawa ko salamat po

 

[kudeta21]

Mga sir pwede ba mag send bulk sms using AT commands? sino mero sourcecode para po mapag aralan at ma lagay sa system na ginagawa ko salamat po

iloop mo na lang

 

[cesscruz14]

Good afternoon po. Paturo naman po ng logic para sa tif to multi tif. Vb.net po gamit ko. Exe file lang.

 

[kamot37]

magandang Gabi mga Idol, ask ko lang po dahil balik study ako sa coding may mga sample codes ako na pinagaaralan noon, ngayon d ko na mabuksan lalo n ayong access ang mga data,.... ayaw nyang mag connect sa database...

OS ko po windows7 64bits
nag try ako office 2007 at office 2016 pero ayaw po talaga may driver na po akong nadownload kaso d rin gumagana... pa advice naman po dati naman gumagana mga ito sa windows 7 na 32b ko... salamat po mga boss..

 

[waggish]

Mga sir pano po gagawin ko kung ang vb6 project gusto ko ilagay o iconvert sa visual studio 2010 . Thanks po

 

[ACFUNELAS]

sir, thanks po sa thread na eto..eto hanap ko.. eto kasi programming namin ngayun..and i know nothing about it kasi java at c yung ginamit namin noon..
may i ask a noob question..
ano po ang kaibahan ng visual studio at visual basic??..

Hi!

Visual studio is the platform commonly used in making visual basic applications. Visual Basic is the programming language.

 

[imemew]

maraming salamat po sir .

 

[Elruu]

Mga sir papaturo po sana. Gumagawa po kami ng warehouse management system. May mga products kami na meron expiration date at iba iba sila. Ang gusto ko po sana is pag nagtransfer po ako sa outlet, e.g meron akong set ng itlog na magkakaiba expiration date. Sa unang set ko meron akong 50 then followed by 100. Then magtratransfer ako ng 90 so ang gusto ko mangyari is pag nagbawas siya doon sa una which is 50, ung tirang 40 kukunin niya sa susunod na set which is ung 100. Im using vb.net 2015 and mysql. Sana po may makatulong salamat po.

 

[Barbiebarbs]

Hi po, ask ko lang po kung paano ma save yung check sa datagridcheckboxcolumn, everytime kase na chinecheck ko sya. nag checheck naman kaso kapag na close na, nwwala na yung check. please help me. Thankyou so much!

 

[dreamreaper008]

Hi po, ask ko lang po kung paano ma save yung check sa datagridcheckboxcolumn, everytime kase na chinecheck ko sya. nag checheck naman kaso kapag na close na, nwwala na yung check. please help me. Thankyou so much!

add ka ng new column sa database table mo na boolean/bit yung type. so everytime na matick yung checkbox ng grid mo update mo yung record. para pag niload mo ulit yung record andun pa din yung check nya.

 

[4ter20]

mga sir pahelp po sa system ko. need po kasi mag print ng barangay clearance ano po kaya mali dito sa code ko .salamat po !

Private Sub btn_print_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_print.Click
Static wda As Microsoft.Office.Interop.Word.Application
Static wdd As Microsoft.Office.Interop.Word.Document
wda = New Microsoft.Office.Interop.Word.Application

wda.visible = True

wdd = New Microsoft.Office.Interop.Word.Document("C:\Users\tez\documents\visual studio 2010\projects\clearance.dot")
With wdd
.FormFields("w_name").Result = txt_fn.Text
.FormFields("w_mn").Result = txt_mn.Text
.FormFields("w_ln").Result = txt_ln.Text
End With

End Sub

 

[remoshed]

mga sir pahelp po sa system ko. need po kasi mag print ng barangay clearance ano po kaya mali dito sa code ko .salamat po !

Private Sub btn_print_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_print.Click
Static wda As Microsoft.Office.Interop.Word.Application
Static wdd As Microsoft.Office.Interop.Word.Document
wda = New Microsoft.Office.Interop.Word.Application

wda.visible = True

wdd = New Microsoft.Office.Interop.Word.Document("C:\Users\tez\documents\visual studio 2010\projects\clearance.dot")
With wdd
.FormFields("w_name").Result = txt_fn.Text
.FormFields("w_mn").Result = txt_mn.Text
.FormFields("w_ln").Result = txt_ln.Text
End With

End Sub

Same Problem sir..hehe
im using ms word 2013.
Legacy forms
Textbox tools
save as word template

View attachment 326394

Patulong naman po sa mga expert jan.. salamat

 

[4ter20]

View attachment 326530

mga idol patulong naman po ako sa system ko, yung laman po ng textbox pano po ilipat sa msword template
ito po yung code ko, pahelp po please

Private Sub btn_print_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_print.Click
Static wda As Word.Application


wda.Visible = True

wda.Documents.Open("C:\Users\Tez\Documents\Visual Studio 2010\Projects", , , True)

With wda

.formfields("w_n").result = txt_fn.Text
.formfields("w_mn").result = txt_mn.Text
.formfields("w_ln").result = txt_ln.Text

End With

End Sub

 

[rhonrsv]

eh dito po ??
http://www.symbianize.com/showthread.php?t=1445658
Chart VB.net Source Binding data from my SQL

 

[maskio]

View attachment 1224125

mga idol patulong naman po ako sa system ko, yung laman po ng textbox pano po ilipat sa msword template
ito po yung code ko, pahelp po please

Private Sub btn_print_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_print.Click
Static wda As Word.Application


wda.Visible = True

wda.Documents.Open("C:\Users\Tez\Documents\Visual Studio 2010\Projects", , , True)

With wda

.formfields("w_n").result = txt_fn.Text
.formfields("w_mn").result = txt_mn.Text
.formfields("w_ln").result = txt_ln.Text

End With

End Sub

use RDLC to print documents.

 

[asura098]

[SUP] salamat po dito . laking tulong [/SUP]

 

[tropitz]

patambay po mga boss, salamat po !

 

[rochelle04]

View attachment 327750

patulong naman ako dito sa rent, pag click ko ng lend date today malalgay dun sa date borrowed then ung due date 1 day lang ung tagal nya
simula dun sa date borrowed. pero pag lumampas ng 1 day may penalty sya ng 10 pesos per day. salamat