INSERT INTO 语句的语法错误

Question

来自网页的错误：各项代码已经定义--------------------------- string str2 = "select * from [user] ";
        da.SelectCommand = new OleDbCommand(str2 ,conn );
        scb = new OleDbCommandBuilder(da );
        da.Fill(ds );
        DataRow newrow = ds.Tables[0].NewRow();        //newrow["userID"] = "6";
        newrow[0] = TextBox1.Text;//"nname""pwd""zhiwei""wenti""dan""youx"
        newrow[1] = TextBox2.Text;
        newrow[2] = "普通用户";
        newrow[3] = TextBox4.Text;
        newrow[4] = TextBox5.Text;
        newrow[5] = TextBox6.Text;
        ds.Tables[0].Rows.Add(newrow );
        da.Update(ds);请教高手。。是哪儿的错误

Answer 1

da.Update(ds);前面加上一行：
ds.AcceptChanges();

Answer 2

da.Update(ds);后面加
ds.AcceptChanges();   
http://www.cnblogs.com/lizhang0101/archive/2008/11/10/1800597.html