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