community profiling po gagawin. Encoding po ng data sa multiple computer papasok sa isang database
visual basic po gagamitin ko. wala pa po kasi ako experience jan. thank you po in advance.
baka po kasi magkamali ako eh tapos magback to zero.
yes bro mas maganda gamitin ang Mysql kc hindi sya masyado mahirap intindihin pro dpende kc yan syo bro kng san ka mas magaling.
Bro punta ka dito na site oh connectionstring.com jan makkita mu yung code kng pano e execute yung sa Ms.
-------------------------SAVE----------------------
Public sub SAVE_RECORD(ByVal val1 As String, ByVal val2 As String )
Try
Dim sqlcmd As New SqlCommand("StoredProcedure_Sa_DATABASE", sqlcon)
sqlcmd.CommandType = CommandType.StoredProcedure
End Try
sqlcon.Close()
Return Nothing
End Sub
-------------------------RETRIEVE----------------------
Public sub RETRIEVE_RECORD(ByVal parameterVAL As String)
Try
Dim sqlcmd As New SqlCommand("StoredProcedure_Sa_DATABASE", sqlcon)
sqlcmd.CommandType = CommandType.StoredProcedure
With sqlcmd.Parameters
.Add("@inVal1", SqlDbType.VarChar, 20).Value = val1
.Add("@inVal2", SqlDbType.VarChar, 20).Value = val2
End With
Dim sqldr As SqlDataReader = sqlcmd.ExecuteReader
If sqldr.HasRows Then
While sqldr.Read
textbox1.text = sqldr("value1")
textbox2.text = sqldr("value2")
End While
End If
maraming salamat sir bhokk062220.. sir pahinge na din po ng advice about sa paggawa ng ganito baka po kasi magkaron ng error na malupet baka masisante haha
anu ba gamit mo na vb? try mo gamitin yung latest na visual basic ultimate may connector na dun para sa mysql at oracle
advise ko lang sayo...kung sa company mo gagamitin yan
mag oracle ka pangcorporate kasi talaga yun,madali lang din pagaralan yun,secured din yun.
anu ba line of business ng company nyo?
may ibang branch ba na kailangan kumonek sa db nyo?
may website ba yan na kailangan maglogin?
pacomplete ng details pra maiguide kita ng maayos.
maselan yang gagawin mo.
sa goverment office lang po master. gagastusan kasi nila ng malaki kaya kinakabahan ako haha.
Community base profiling system po. irerecord po lahat ng tao at building at etc sa probinsya namin.
tapos sa encoding at processing daw po ay gagamit ng multiple computer na nakanetwork.
ok lang po experience ko sa vb. puro local database lang kasi ginamit ko sir nung nasa college pa lang ako haha
Since 2 years have passed since the last reply in this thread, I am locking it to prevent necroposting. Feel free to start a new thread or contact any forum staff if you want this to be reopened.