0

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

5
Contributors
9
Replies
59
Views
4 Years
Discussion Span
Last Post by nadimfaz
0

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

0

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.

0
 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 by elie.karkafy

0

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

0

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

-1

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

0

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 topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.