Thursday, 22 August 2013

How to insert records in Access table using Asp.Net


 protected void Button2_Click(object sender, EventArgs e)
    {

        try
        {

            OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\NWIND2.accdb");
            con.Open();
//if you want selected columns :
//I have created student table having stud_name,stud_address,stid(autoincremented)
            String q = "insert into student(stud_address)  values(@ad)";
            OleDbCommand cmd = new OleDbCommand(q, con);
            cmd.Parameters.AddWithValue("@ad", "meerut");

            if (cmd.ExecuteNonQuery() > 0)
                Response.Write("inserted");
            else
                Response.Write("not inserted");

        }
        catch (Exception ee) { }
    }

0 comments:

Post a Comment