Add row in ms access through asp.net vb?

Question

please heilp any one I am pulling my hear out.
I am using this below code to read from MsAccess. but i dont know how to add, delet or modify rows.
As Data.DataView = CType(AccessDataSource1.Select(DataSourceSelectArguments.Empty), Data.DataView)

help

I already used it to connect . but how can i add delete and modify

Answer 1

Here's one way..get rid of the & _ I used to split the statements

Using MyConnection1 As New SqlConnection(ConfigurationManager.ConnectionStrings & _ ("ESW").ConnectionString)
MyConnection1.Open()

MyQuery = New System.Text.StringBuilder

MyQuery.AppendLine("UPDATE AGENT ")
MyQuery.AppendLine("SET EMAIL_Address = @EMAIL")
MyQuery.AppendLine("WHERE AGENT_ID = @ID; ")

Using MyCommand1 As New SqlCommand(MyQuery.ToString, MyConnection1)
MyCommand1.Parameters. & _
Add("@ID", SqlDbType.Int).Value = Session("StudentId")
MyCommand1.Parameters. & _
Add("@EMAIL", SqlDbType.NVarChar).Value = CStr(Session("NewEMail"))

Id = MyCommand1.ExecuteNonQuery()
End Using
End Using

Answer 2

use the dataform wizard its easy to you