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

[nadimfaz]

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

[ss125]

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

[Reverend Jim]

You can find connection strings here and a SQL tutorial here

[nadimfaz]

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.

[elie.karkafy]

 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

[Yousha]

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

[nadimfaz]

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

[nadimfaz]

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

[Reverend Jim]

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

[nadimfaz]

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