Grid control with ms acess in asp.net using vb

Question

User-656010581 posted

hi,

 I m a begginer in asp.net. I hav connected the ms-access 2003 wit asp.net 2005 using vb. I can view the data by usin this code.

Dim msaccessconnect, query, databasecommunication, readdatabase
        msaccessconnect = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("db1.mdb"))
        msaccessconnect.Open()
        query = "SELECT * FROM `advertiser`"
        databasecommunication = New OleDbCommand(query, msaccessconnect)
        readdatabase = databasecommunication.ExecuteReader()
        GridView1.DataSource = readdatabase
        GridView1.DataBind()
        readdatabase.Close()
        msaccessconnect.Close()

But I dont know to update, delete options in tat. Can any one help Please???Reply me any one!!!!!

Answer 1

User-1199946673 posted

http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET
http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access 
http://www.mikesdotnetting.com/Article/68/An-ASP.NET-Search-Engine-with-MS-Access-for-optional-search-criteria
http://www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record

Answer 2

User-656010581 posted

Hi,

Thank you so much to help me. Your link is really helping to me.

-dharsini

Answer 3

User-656010581 posted

hello,

i used your links sir. It was really helpfull to me. Thank So much!!

-dharsini