I used the code for Retrieving, Inserting, Updating and Deleting in following method
protected void Button1_Click(object sender, EventArgs e)
{
string conn = "ConnectionString";
SqlConnection sqlcon = new SqlConnection(conn);
sqlcon.Open();
SqlCommand comm = new SqlCommand("Insert into table1 (field1,field2) values (@f1,@f2)", sqlcon);
comm.Parameters.AddWithValue("f1", int.Parse(txtid.Text.ToString()));
comm.Parameters.AddWithValue("f2", Txtname.Text.ToString());
comm.ExecuteNonQuery();
}
It is running good in my development system i.e. Visual Studio Installed System...
(I am Developing windows application,,,)(Created setup file by deployment process)
but when i install this project into another system by setup created,
It is able to retrieve the data from database but not inserting, updating , deleting
I am getting the following error,
Unhandled exception had occured in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit the application will close immediately.
Operation must use an Updatable Query.
I searched for the above error....
I found solution that to check the database property is set to Read Only..
But it is not set to Read Only
plz give me some solution