Demo Setup Problem: Operation must use an updateable query???

  •  09-29-2004, 4:44 PM

    Demo Setup Problem: Operation must use an updateable query???

    Hi, I'm a relative newbie trying to figure out what's wrong here.  I'm using Dreamweaver MX2004, IE 6.0.  I created a site using the asp.netv1.1 folder in IIS (for both the local site and the testing server). 
     
    When I attempt to update an entry in the DataGrid example page through localhost, I get the following error:
     

    Operation must use an updateable query.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

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

    Source Error:

    Line 141:		myCommand.Parameters.Add(new OleDbParameter("@EmpID", e.Item.Cells[1].Text ));
    Line 142:		conn.Open();
    Line 143:		myCommand.ExecuteNonQuery();
    Line 144:        MyDataGrid.EditItemIndex = -1;
    Line 145:		BindData();	
     
     
    Any thoughts???
     
    Thank you much!
     
     
    -George
View Complete Thread