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!
Good day po, ahmm ask ko lang po if paano macucustomize ung time sa vb.net bale may game po kasi kami tas every pagbukas ng game may magpaprompt tapos doon po nakalagay kung ilng minutes ang gusto niya. Thanks GODbless )
Mga Sir i need help. Gusto ko kasi gamitin yung mysql web server as database ko. paano po ba yun? May mga settings po ba na kailangan. Ok siya sa localhost pero pag sa web host ayaw eh.
I need it badly talaga.
mga sir/ma'am patulong naman po sa proposal namin sa SAD(system analysis and design) baka po may alam kayo na kung paano simulan yung proposal namin ang hirap po kc, hindi na kami kasi nagklaklase kasi busy ung mga teacher sa accreditation sa school namin.... kaya paano po simulan ito... kung mga questionnaire po kayo jan na pwede epangsurvey namin...... salamt po sa magrereply!!!!!!!!!
kung nakapag connect ka na using OLEDB same lang yun palitan mo lang yung OLEDB ng SQL.
EDIT : Devexpress pala yung 3rd party apps pra sa mas magagandang controls sa vb.net
naku sir thank you so much for the info! Tama po kayo parehas lng pero hindi ko pa din maconnect eh. Yung web server ko pala may prob. (toinks!) hindi pala siya pwede sa external access. Free lng kasi eh. Byethost yung server ko.
Mga master pa hingi nman po ng sample codes sa pag display ng data from mysql table2 and i insert po sya sa table1 using combobox po in vb.net, haLimbawa po may daLawa po akong database table
table1
ID(PK), Name, CourseID(FK)
table2
CourseID(PK), CourseName
then may isa pong textbox para sa name and ang isa po combobox, ang mag didisplay po sa combobox yong CourseName gaLing sa table2 and ang mag iinsert po sa table1 yong CourseID nya.,
wala po kac akong nakuhang malinaw na tutorial sa google and youtube. . .saka baguhan pLang po ako sa vb.net
thanx in advance po sa 22Long.
uhm..patulong po ...sa billing system po. ng vb.net-mysql project..
pano po ung command na kapag nag-input po ng mga prices..lahat po ng prices na naka-input sa column ng
datagridview ma-a-add tas lalabas sa text box ung sum....
pano po un?
uhm..patulong po ...sa billing system po. ng vb.net-mysql project..
pano po ung command na kapag nag-input po ng mga prices..lahat po ng prices na naka-input sa column ng
datagridview ma-a-add tas lalabas sa text box ung sum....
pano po un?
Mga master pa hingi nman po ng sample codes sa pag display ng data from mysql table2 and i insert po sya sa table1 using combobox po in vb.net, haLimbawa po may daLawa po akong database table
table1
ID(PK), Name, CourseID(FK)
table2
CourseID(PK), CourseName
then may isa pong textbox para sa name and ang isa po combobox, ang mag didisplay po sa combobox yong CourseName gaLing sa table2 and ang mag iinsert po sa table1 yong CourseID nya.,
wala po kac akong nakuhang malinaw na tutorial sa google and youtube. . .saka baguhan pLang po ako sa vb.net
thanx in advance po sa 22Long.
dataadapter.fill(dataset,"table")
combobox.datasource=ds.tables(0)
combobox.displaymember="name"
combobox.valuemember="id"
KATULAD NITONG CODE NA TO!!!
Imports MySql.Data.MySqlClient
Public Class Form1
Dim Sql as String
Dim conn As MySqlConnection
Dim cmd as MySqlCommand
Dim da As MySqlDataAdapter
Dim Table As DataTable
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn = New MySqlConnection()
conn.Connectionstring = "server=localhost;username=root;password=;database=school"
conn.Open()
MsgBox("Database Connection Successful!")
Sql = "select * from students"
cmd = New MySqlCommand(Sql, conn)
da = New MySqlDataAdapter()
da.SelectCommand = cmd
Table = New DataTable()
da.Fill(Table)
dgstudents.DataSource = Table
conn.Close()
CboGender.Items.Add("Male")
CboGender.Items.Add("Female")
dgstudents.Columns(0).HeaderText = "ID"
dgstudents.Columns(1).HeaderText = "LASTNAME"
dgstudents.Columns(2).HeaderText = "FIRSTNAME"
dgstudents.Columns(3).HeaderText = "GENDER"
dgstudents.Columns(4).HeaderText = "COURSE"
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conn.Open()
Sql = "insert into students(lastname, firstname, gender, course) values('" & TxtLname.Text & "','" & TxtFname.Text & "','" & CboGender.Text &
"','" & txtCourse.text & "',')"
cmd = New MySqlCommand(Sql, conn)
da.SelectCommand = cmd
da.Fill(Table)
MsgBox("New Record Added!")
conn.Close()
End Sub
End Class
BINIGAY NGA! HINDI NAMAN PINALIWANAG YUNG MGA MALALALIM NA CODES JAN.... ANG SAKIT SA ULO......
Imports MySql.Data.MySqlClient [B]''Ginagamit to to reference the class fof mysql.data kaya lang naman ito ginagamit para mabilis mag type for example nung mysqlconnection d mo na kailangan pang itype yung mysql.data.MySqlClient kasi ni reference mo na yung class niya[/B]
Public Class Form1
[B]'' This 5 line of code just declare the variable[/B]
Dim Sql as String
Dim conn As MySqlConnection
Dim cmd as MySqlCommand
Dim da As MySqlDataAdapter
Dim Table As DataTable [B]'' This is use to store data that you query [/B]
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn = New MySqlConnection() [B]'' This is to create a new instance of your MySQL Connection[/B]
conn.Connectionstring = "server=localhost;username=root;password=;database=school" [B]''Connection String kung san path ng Database mo[/B]
conn.Open()
MsgBox("Database Connection Successful!")
Sql = "select * from students" '[B]'This is the query you use to retrieve a data into your database you can search for sql kung gusto mo pa matuto ng ibang query[/B]
cmd = New MySqlCommand(Sql, conn) '[B]'MySqlCommand is just use to execute the query[/B]
da = New MySqlDataAdapter() [B]''Dataadapter is use a store location in the result of the query to fill the dataset or datable[/B]
da.SelectCommand = cmd [B]''dito mo lalagay kung anong query ang irun niya which is the cmd[/B]
Table = New DataTable() [B]''table basically store location rin ito which come from dataadapter na pde mong i bind sa control[/B]
da.Fill(Table) '[B]' it just fill the datable[/B]
dgstudents.DataSource = Table [B]''This set the datasource of the datagridview[/B]
conn.Close()[B] 'close the connection[/B]
[B]''This 2 lines just add an items into Combobox[/B]
CboGender.Items.Add("Male")
CboGender.Items.Add("Female")
[B]''this 5 lines basically change the Column name of the datagridview[/B]
dgstudents.Columns(0).HeaderText = "ID"
dgstudents.Columns(1).HeaderText = "LASTNAME"
dgstudents.Columns(2).HeaderText = "FIRSTNAME"
dgstudents.Columns(3).HeaderText = "GENDER"
dgstudents.Columns(4).HeaderText = "COURSE"
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conn.Open()
Sql = "insert into students(lastname, firstname, gender, course) values('" & TxtLname.Text & "','" & TxtFname.Text & "','" & CboGender.Text &
"','" & txtCourse.text & "',')" [B]''Query to insert data to your database[/B]
cmd = New MySqlCommand(Sql, conn)
da.SelectCommand = cmd
da.Fill(Table)
MsgBox("New Record Added!")
conn.Close()
End Sub
End Class
penge naman po ng codes magADD ng data sa database sa VB.net....