One or more errors occurred during processing of commandORA-00971missing SET keyword

[geeteshss]

i am pasting the code in which i am finding the error
this is happening when i click on the update button of the datagrid which is fired when i click the edit button

        public void BindData()
        {
            OleDbDataAdapter da = new OleDbDataAdapter("SELECT *FROM CMRS_BUSINESSAREA_MASTER","Provider=MSDAORA.1;User ID=meter_reading;Password=colony;Data Source=windev;OLEDB.NET=true;" ); 
            DataSet ds = new DataSet(); 
            da.Fill(ds);
 
            DataGrid1.DataSource = ds.Tables[0].DefaultView ;
            DataGrid1.DataBind();
 
 
        }
        public void Edit_DataGrid1(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) 
        { 
            // We use CommandEventArgs e to get the row which is being clicked 
            // This also changes the DataGrid labels into Textboxes so user can edit them 
            DataGrid1.EditItemIndex = e.Item.ItemIndex; 
            // Always bind the data so the datagrid can be displayed. 
            BindData(); 
        } 
        public void Cancel_DataGrid1(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) 
        { 
            // All we do in the cancel method is to assign '-1' to the datagrid editItemIndex 
            // Once the edititemindex is set to '-1' the datagrid returns back to its original condition 
            DataGrid1.EditItemIndex = -1; 
            BindData(); 
        } 
        public void Update_DataGrid1(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            //try
            //{
 
                string str = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
                  OleDbConnection con1 = new OleDbConnection();
                    con1.ConnectionString = str;
 
 
                TextBox txtAREADESCRIPTION =(TextBox) e.Item.Cells[1].Controls[0];
                string strUpdateStmt;
 
                strUpdateStmt = "UPDATE CMRS_BUSINESSAREA_MASTER SET" + "CBM_BUSAREA_DESC = '" + txtAREADESCRIPTION.Text + "' " + "WHERE CBM_BUSAREA_CODE = " + e.Item.Cells[0].Text;
                Response.Write("strUpdateStmt");
                cmd = new OleDbCommand(strUpdateStmt,con1);
                con1.Open();
                cmd.ExecuteNonQuery();         
                DataGrid1.EditItemIndex = -1;
                BindData();
            }
            //catch(Exception e)
            //{
            //    Console.WriteLine(e.Message.ToString());
            //}
            //}
 
 
        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
 
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
            this.cmd = new System.Data.OleDb.OleDbCommand();
            this.con1 = new System.Data.OleDb.OleDbConnection();
            this.addbtn.Click += new System.EventHandler(this.addbtn_Click);
            this.updtbtn.Click += new System.EventHandler(this.updtbtn_Click);
            this.delbtn.Click += new System.EventHandler(this.delbtn_Click);
 
            this.Load += new System.EventHandler(this.Page_Load);
 
        }
        #endregion
 
        private void addbtn_Click(object sender, System.EventArgs e)
        {
            string str = ConfigurationSettings.AppSettings["ConnectionString"].ToString();  
 
            OleDbConnection con1 = new OleDbConnection();
            con1.ConnectionString = str;
            OleDbCommand cmd = new OleDbCommand("Insert into cmrs_businessarea_master values('"+TextBox1.Text+"','"+TextBox2.Text+"')",con1);         
            con1.Open();
            cmd.ExecuteNonQuery();
            con1.Close();
            BindData();
 
 
        }
 

[radcaesar]

Syntax error in append statement, ur append statement should start like this

strUpdateStmt = "UPDATE CMRS_BUSINESSAREA_MASTER SET CBM_BUSAREA_DESC =" + strUpdateStmt +..........

[Plater]

Actually I believe it is complaining because there is not a space after SET
so you get
..."SETCBM_BUSAREA_DESC"... instead of
..."SET CBM_BUSAREA_DESC"...