1. Welcome to PHCorner Forums. Take a moment to Sign up and gain unlimited access and extra privileges that guests are not entitled to, such as:

    All that and more! Registration is quick, simple and absolutely free. Join our community today!

(HELP)add, retrieve, delete code for database

Discussion in 'Coding, Programming' started by jaynner, Sep 29, 2015.

  1. jaynner

    jaynner Honorary Poster Established

    mga kaPhc pahinge naman code. and anong
    gagamitin na sql. mssql or mysql?

    tnx sa tutulong. like kita agad
     
  2. Yiskha

    Yiskha Forum Veteran Established

    depende yan sa gagamitin mo,,,meron akong mga codes nahapin ko mamaya
     
    jaynner and ShaneLee like this.
  3. penge din po ako .. PHP ba yan ?
     
  4. jaynner

    jaynner Honorary Poster Established

    ganito po gagawin ko master

    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. :):):)
     
  5. jaynner likes this.
  6. jaynner

    jaynner Honorary Poster Established

    MS SQL gamit ko ko sir. Pero mas maganda po ba ng my sql? thanks po
     
  7. idol pumunta ka dito na site oh marami ditong naka hilirang codes na ms sql w3schools.com
     
    jaynner likes this.
  8. jaynner

    jaynner Honorary Poster Established

    salamat saloysaloy . pero hinahanap ko yung code sa vb. yung pagconnect sa database tapos pag execute and read
    ng query. meron ka ba jan?:):):)
     
  9. MySQL nalang :)
     
    Last edited: Nov 7, 2015
    jaynner likes this.
  10. Code:

       Sorry you need to Register / Login to see this Codes!    

     
    jaynner likes this.
  11. panu mo ba eexecute ung code,sa php ba or sa gui?mas secured mysql boss at madali intindihin,
     
    jaynner likes this.
  12. -------------------------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

    With sqlcmd.Parameters
    .Add("@inVal1", SqlDbType.VarChar, 20).Value = val1
    .Add("@inVal2", SqlDbType.VarChar, 20).Value = val2

    sqlcmd.ExecuteNonQuery()
    End With

    Catch ex As Exception

    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

    Catch ex As Exception

    End Try
    sqlcon.Close()
    Return Nothing
    End Sub
     
    jaynner likes this.
  13. jaynner

    jaynner Honorary Poster Established

    salamat sainyo sir

    mga sir pano po ako magsisimula sa mysql?? hindi po ito sa php. Profiling po gagawin ko. salamat sa matulong
     
    Last edited by a moderator: Nov 6, 2015
  14. punta ka muna dito Please or Register to view links

    vb pala gagamitin mo dito,kailangan mo ng connector para sa mysql
     
    jaynner likes this.
  15. jaynner

    jaynner Honorary Poster Established


    maraming salamat sir bhokk062220bhokk062220.. sir pahinge na din po ng advice about sa paggawa ng ganito baka po kasi magkaron ng error na malupet baka masisante haha
     
  16. 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.
     
    jaynner likes this.
  17. jaynner

    jaynner Honorary Poster Established

    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

    maraming salamat :D
     
Tags / Keywords: