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

Re: How to code to add data in ms access by vb.net form application? 80 80

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

Re: How to code to add data in ms access by vb.net form application? 80 80

You can find connection strings here and a SQL tutorial here

Re: How to code to add data in ms access by vb.net form application? 80 80

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.

Re: How to code to add data in ms access by vb.net form application? 80 80
 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

Re: How to code to add data in ms access by vb.net form application? 80 80

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

Re: How to code to add data in ms access by vb.net form application? 80 80

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

Re: How to code to add data in ms access by vb.net form application? 80 80

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

Re: How to code to add data in ms access by vb.net form application? 80 80

That is against the rules. One of them states Do not ask anyone (member or moderator) for help by email or private message

Re: How to code to add data in ms access by vb.net form application? 80 80

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.