Author: maisa | Posted on: 6/11/2009 1:00:51 PM | Views : 377

 Hi,, I'm new to Asp.net.. I am using visual studio 2005 and I created a new website with Asp.net c#.. I am trying to add records to Access 2003 DB through an add button that add values from a text box: This is what I got so far but I got some errors:
 protected void btnAdd_Click(object sender, EventArgs e)
    {
        OleDbConnection = cn;
        OleDbCommand = cmd;

       cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AccessDB\db1.mdb;User Id=admin;Password=;");
       cmd = new OleDbCommand;     
            cmd.CommandText = "insert into students (win) values (" & this.TRACK2.Text & ");
    &nb ...

Go to the complete details ...