old fashion!

[leghalbon]

hi there,
well my problem might sound silly to many of you. When i write in vb 6 i used to write my own connection strings, define my own recordsets,etc... now in vb.net im completly unaware of it. what i need is an exple where u manually connect to a db, select some records to show in a datagrid ,update statement, and delete records from it. is that still possible?

thank you guys in advance, hope didnt sound like a really old grandpa

[dynamic_sysop]

here's a basic example of opening an access database in .net and adding the contents of a table to a DataGrid :

Imports System.Data.OleDb
'///^^^ top of your form's code window.
'////////
 
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim Connection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/bin.mdb"
        Dim Command As String = "SELECT * FROM binFrm"
        OpenAccessFile(Connection, Command)
    End Sub
 
    Private Sub OpenAccessFile(ByVal strConnection As String, ByVal strCommand As String)
        Dim objDbConnection As New OleDbConnection(strConnection)
        objDbConnection.Open() '///open a new connection.
 
        Dim objCommand As New OleDbCommand(strCommand, objDbConnection)
        Dim objAdaptor As OleDbDataAdapter
        objAdaptor = New OleDbDataAdapter(objCommand)
        Dim objDataSet As New DataSet()
        objAdaptor.Fill(objDataSet, "binFrm")
        DataGrid1.DataSource = objDataSet.Tables("binFrm") '///fill a datagrid with the recordset
 
        objDbConnection.Close()
        objCommand.Dispose()
        objAdaptor.Dispose()
        objDataSet.Dispose()
    End Sub

hope that helps to get you started

[leghalbon]

thank you for yr reply! it was really helpfull, but may i ask for one more thing.

str_sql="update tablename set fieldname=1"

how can i write a query like the above to update a certain record in VB .net.

thank you

[Shurijo]

Originally posted by leghalbon
thank you for yr reply! it was really helpfull, but may i ask for one more thing.

str_sql="update tablename set fieldname=1"

how can i write a query like the above to update a certain record in VB .net.

thank you

str_sql="update tablename set fieldname=1, fieldname2='aa' where id=25"

[leghalbon]

hehehe, oups i did it again, my question turned out wrong.
what i meant was whats the code, i mean how do i define the recorset, how do i excute the update in VB .NET , it's not about the query it self, its about executing an uodate or delete query

sorry for my honest mistake...

thank you

[Iamthewalrus15]

May I recommend ado.net core reference by MS Press ado.net has changed from ado enough, that you basically need to entirely re-educate yourself on the manner.

[DevGrp]

Originally posted by Iamthewalrus15
May I recommend ado.net core reference by MS Press ado.net has changed from ado enough, that you basically need to entirely re-educate yourself on the manner.

I second that advice. This is a great book, if you want to know the ins and outs of ADO.NET. Another great book is Pragmatic ADO.NET.

[Pirate]

Here is how to execute OleDbCommands .
http://www.vbforums.com/showthread.p...ghlight=update