hello,
i am doing a mini project in vb.net2010...BLOOD BANK MANAGEMENT...but i dnt knw how to connect vb.net2010 with ms access 2007..and how to code for add, delete,update records...plz help me

Google it...Lot of sample projects are already available... and then try it... If u have any problem then post your problem...

thnx both of u....was unable to complete my project work.....nw m reday to work on my blood bank management project in vb.net....if i get any doubts/error/problem,i will post it here....sry for late reply..
nadimfaz.

 Try
            Dim con As New OleDbConnection
            con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = " database name  ".accdb"
            con.Open()
            Dim cmd As New OleDbCommand
            cmd.Connection = con
            cmd.CommandText = "Insert into Employee (Employeename,DepID,Depname,pass) values ( '" & TextBox2.Text & "','" & TextBox4.Text & "', '" & ComboBox1.Text & "','" & TextBox3.Text & "')"
            If TextBox2.Text = String.Empty Then
                TextBox2.Text = String.Empty
            End If
            If TextBox3.Text = String.Empty Then
                TextBox3.Text = String.Empty
            End If
            If TextBox4.Text = String.Empty Then
                MsgBox("PLEASE enter a depname ")
            Else
                cmd.ExecuteNonQuery()
                con.Close()
                Fill()
            End If
            TextBox1.Text = String.Empty
            TextBox2.Text = String.Empty
            TextBox3.Text = String.Empty
            TextBox4.Text = String.Empty
            ComboBox1.SelectedIndex = -1
        Catch ex As Exception

        End Try

hope this will help you

Edited 3 Years Ago by elie.karkafy

Used a gridview to connect with your database, its easy search youtube for it, lots of sample.

Yousha@cn i get your email id...wanna mail some snapshots....with some coding...please chek it...plzzzzzzzzzzz.. :(

Yousha@cn i get your email id...wanna mail some snapshots....with some coding...please chek it...plzzzzzzzzzzz.. :(

extremly sorry sir
i didnt know abt this rule...my mistake...can sm1 tell me how can i use dataset tool in this project?

This article has been dead for over six months. Start a new discussion instead.