VB6 HELP ME, Database

[lalanthakumara]

Sinhalenma Kivvoth Mekai

Mage Database ekak thiyenava host karala
eka accsess database ekak
eg : http://www.elakiri.com/data.mdb
mata ona vb6 form ehekata oya database eka link karaganna

Form eka thiyenne normal pc eheka
eke detabase eka thiyenne host karala
deka link karanne koomada?

Dannava nam kiyanna
Loku pinak
Project ehekata onamai

 

[lalanthakumara]

Please Help me

 

[lalanthakumara]

help me

 

[Myth]

pahadili madi bun . .

 

[Ranhiru]

Machan umba Visual Basic .NET walin karanawa nam udaw karanna puluwan... but VB6 nam danne naa

 

[lalanthakumara]

pahadili madi bun . .

machan
mama hadana exe eka thiyenne mage computer eke
namuth
eke database eka thiyenne mama kohehari host karala
ethakota database eke url eka wenne
eg: http://www.lalantha.com/database.mdb
mata ona coding thika

mage exe ekata liyanna
ara database eka connect karaganna kiyala
open database karanna

ethakota
mage exe eka umbage computer eke run kalath
database eka internet threw connect karagannava

mata ona e 2ka connect karana codeing eka

theruna madinam kiyapan.

 

[lalanthakumara]

Machan umba Visual Basic .NET walin karanawa nam udaw karanna puluwan... but VB6 nam danne naa

dot net lavata athapatha gaganna puluvan
vb6 tikak dannava
kamak nehe
mata karana heti kiyaladeela
dot net verson ekath kiyapan machan
mata download karaganna

 

[Myth]

http://searchwindevelopment.techtarget.com/generic/0,295582,sid8_gci1180416,00.html#

check weather its here . .

 

[Ranhiru]

dot net lavata athapatha gaganna puluvan
vb6 tikak dannava
kamak nehe
mata karana heti kiyaladeela
dot net verson ekath kiyapan machan
mata download karaganna

Visual Basic .NET 2008 thama machan use karanne

'first creating a Sql Connection ... put this in a module so it will be global
'Put any valid Sql Connection String.. Get Connection Strings from http://www.connectionstrings.com

Me thiyenne SQL Server walata...i think what you need for a connection string is
http://connectionstrings.com/access-2007

Public connection As New SqlConnection("Persist  Security Info=False;Data  Source="|DataDirectory|Database1.sdf")

Getting A set of data from a Sql Database

Dim dt As New DataTable()
Dim ds As New  DataSet
  
 Dim queryString As String = "SELECT * FROM  Country ORDER BY CCode"
Dim adapter As SqlCeDataAdapter = New  SqlCeDataAdapter(queryString, connection)
adapter.FillLoadOption =  LoadOption.OverwriteChanges

 adapter.Fill(ds, "Country")
  
 dt = ds.Tables("Country")

'Now DataTable dt contains all the rows from the table Country



Getting a Single Data from the Database

'This is a sample function written to get a Username when the User gives a UserID
'connection should be defined first in the module or somewhere

   Function  getUsername(ByVal UserID as Integer) As String
 
         Dim Username As String
  
 
        Try
 
        connection.Open()
  
         Dim Command As New  SqlCeCommand("SELECT Username FROM UserTable WHERE UserID=" & UserID,  connection)  
         Username=  Command.ExecuteScalar().ToString
  
          connection.Close()
  
         Return  Username

  
         Catch ex As  Exception
  
         End Try
 
 
     End Function

Adding Data to the Database

'This enters data in to a User Table

 Try
  
                  Dim stringAdd As String = "INSERT INTO UserTable (" & txtUserID.Text &  ",' " & txtUsername.Text & " ')"
  
                  MsgBox(stringAdd)
                  'MsgBox will display something like  "INSERT INTO UserTable (0001,'Pradeep ElaKiri') "
  
  
                  Dim obj As New SqlCommand(stringAdd, connection)
  
                  obj.Connection.Open()
                 obj.ExecuteNonQuery()
                 obj.Connection.Close()
  
                  obj.Dispose()
  
              Catch ex As Exception
 
                 MsgBox(ex.Message)
 End Try

Updating Data

    Dim  stringUPDATE As String = "UPDATE UserTable SET Username=' " &  txtNewUsername.Text & " '  WHERE UserID="  & txtUserID.Text 
         
          MsgBox(stringUPDATE)
         'MsgBox  should display something like "UPDATE UserTable SET Username='Naps' WHERE  UserID=1"
  
         Dim obj  As New SqlCommand(stringUPDATE, connection)
 
         
          Try
  
 
             obj.Connection.Open()
             obj.ExecuteNonQuery()
  
 
             
         Catch ex As Exception
 
             MsgBox(ex.Message)
             
  
         Finally
  
              obj.Connection.Close()
  
              obj.Dispose()
  
         End Try

 

[lalanthakumara]

http://searchwindevelopment.techtarget.com/generic/0,295582,sid8_gci1180416,00.html#

check weather its here . .

mama hithanne machan ethana eka nehe

 

[Ranhiru]

http://techbystep.blogspot.com/2009/03/how-to-connect-to-database-using-visual.html


menna mekath balapan... meke thiyena eken wenas wenne machan Connection String thama hogak welawata...and SqlDataAdapter -> OleDBDataAdapter wenawa i think

 

[lalanthakumara]

Visual Basic .NET 2008 thama machan use karanne

'first creating a Sql Connection ... put this in a module so it will be global
'Put any valid Sql Connection String.. Get Connection Strings from http://www.connectionstrings.com

Me thiyenne SQL Server walata...i think what you need for a connection string is
http://connectionstrings.com/access-2007

Public connection As New SqlConnection("Persist  Security Info=False;Data  Source="|DataDirectory|Database1.sdf")

Getting A set of data from a Sql Database

Dim dt As New DataTable()
Dim ds As New  DataSet
  
 Dim queryString As String = "SELECT * FROM  Country ORDER BY CCode"
Dim adapter As SqlCeDataAdapter = New  SqlCeDataAdapter(queryString, connection)
adapter.FillLoadOption =  LoadOption.OverwriteChanges

 adapter.Fill(ds, "Country")
  
 dt = ds.Tables("Country")

'Now DataTable dt contains all the rows from the table Country



Getting a Single Data from the Database

'This is a sample function written to get a Username when the User gives a UserID
'connection should be defined first in the module or somewhere

   Function  getUsername(ByVal UserID as Integer) As String
 
         Dim Username As String
  
 
        Try
 
        connection.Open()
  
         Dim Command As New  SqlCeCommand("SELECT Username FROM UserTable WHERE UserID=" & UserID,  connection)  
         Username=  Command.ExecuteScalar().ToString
  
          connection.Close()
  
         Return  Username

  
         Catch ex As  Exception
  
         End Try
 
 
     End Function

Adding Data to the Database

'This enters data in to a User Table

 Try
  
                  Dim stringAdd As String = "INSERT INTO UserTable (" & txtUserID.Text &  ",' " & txtUsername.Text & " ')"
  
                  MsgBox(stringAdd)
                  'MsgBox will display something like  "INSERT INTO UserTable (0001,'Pradeep ElaKiri') "
  
  
                  Dim obj As New SqlCommand(stringAdd, connection)
  
                  obj.Connection.Open()
                 obj.ExecuteNonQuery()
                 obj.Connection.Close()
  
                  obj.Dispose()
  
              Catch ex As Exception
 
                 MsgBox(ex.Message)
 End Try

Updating Data

    Dim  stringUPDATE As String = "UPDATE UserTable SET Username=' " &  txtNewUsername.Text & " '  WHERE UserID="  & txtUserID.Text 
         
          MsgBox(stringUPDATE)
         'MsgBox  should display something like "UPDATE UserTable SET Username='Naps' WHERE  UserID=1"
  
         Dim obj  As New SqlCommand(stringUPDATE, connection)
 
         
          Try
  
 
             obj.Connection.Open()
             obj.ExecuteNonQuery()
  
 
             
         Catch ex As Exception
 
             MsgBox(ex.Message)
             
  
         Finally
  
              obj.Connection.Close()
  
              obj.Dispose()
  
         End Try

sdf file type eka mokakda?
mdb connect karanna puluvanda?
mdb danavanam 2007 vershon ekada ona?

 

[lalanthakumara]

http://techbystep.blogspot.com/2009/03/how-to-connect-to-database-using-visual.html


menna mekath balapan... meke thiyena eken wenas wenne machan Connection String thama hogak welawata...and SqlDataAdapter -> OleDBDataAdapter wenawa i think

machan mata puluvan nam dot net 2008 torrent file ekak hoyala denavada?
piratebay eke vath nahe