高手救命!!

Question

string strFileName = @"c:\材料方案表.xls";
            string strConnString = RecoFunction.GetExcelConnString(strFileName);
            OleDbConnection conn = new OleDbConnection(strConnString);
            conn.Open();
            DataSet dd = this.FillDataSet(conn, "Select 电算代号,材料名称,单位,基价,编制期价 from [材料方案$]", "材料方案");
            DataRow dr = dd.Tables["材料方案"].NewRow();
            dr.BeginEdit();
            dr["电算代号"] = "111";
            dr["材料名称"] = "111";
            dr["单位"] = "111";
            dr["基价"] = 22;
            dr["编制期价"] = 11;
            dr.EndEdit();
            dd.Tables["材料方案"].Rows.Add(dr);            OleDbDataAdapter save = new OleDbDataAdapter"Select 电算代号,材料名称,单位,基价,编制期价 from [材料方案$]", conn);
            OleDbCommandBuilder cmdbuilder = new OleDbCommandBuilder(save);
            save.Update(dd, "材料方案");--------这句报错，insert into 语法错误

Answer 1

cmdbuilder.QuotePrefix="[";
cmdbuilder.QuoteSuffix="$]";
试试