how to fix Operation must use an updateable query.

Posted by Parthibansk under ASP.NET on 3/13/2013 | Points: 10 | Views : 624 | Status : [Member] | Replies : 1
inserting values in excel sheet works fine locally..but when i upload in sever and run i encounter dis error

System.Data.OleDb.OleDbException: Operation must use an updateable query.

OleDbCommand cmd = new OleDbCommand("Insert into [Sheet1$](Name,email,phoneno) values('" + txtName.Text + "','" + txtEMAIL.Text + "','" + txtPHONE.Text + "')", obj);

cmd.ExecuteNonQuery();




Responses

Posted by: Santhi on: 3/14/2013 [Member] Starter | Points: 25

Up
0
Down
Hi

Refer this link:
This may be usefulhttp://www.beansoftware.com/ASP.NET-FAQ/Operation-Must-Use-An-Updateable-Query.aspx

Thanks & Regards,
Santhi .V

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response