刚学数据库strcmd = "UPDATE " + TABLENAME + " Set Name='" + MName.Text + "'";
                strcmd += ",HomePhone='" +HomePhone.Text + "'";
                strcmd += ",Mobile='" +MoPhone.Text + "'";
                strcmd += ",Web='" +Web.Text + "'";
                strcmd += ",MQQ='" +MQQ.Text+"'";
                strcmd += ",Province='" +Province.Text+"'";
                strcmd += ",City='" +City.Text+"'";
                strcmd += ",Street='" +Street.Text+"'";
                strcmd += ",Postalcode='" +Postalcode.Text+"'";
                strcmd += " Where Name='"+selectListName+"'";
conn = new OleDbConnection();
conn.ConnectionString = "provider=microsoft.jet.oledb.4.0;" + "data source=" + "Address Book.mdb" ;
comm = new OleDbCommand(strcmd,conn);
conn.Open();
comm.ExecuteNonQuery();strcmd ,conn,comm都是全局变量!
异常:
{"至少一个参数没有被指定值。"}
怎么回事???还有就是重命名 TABLE_NAME 语句怎么写?

解决方案 »

  1.   

    高手们帮我看看update里面的语句有没有错啊
      

  2.   

    strcmd = "UPDATE " + TABLENAME + " Set Name='" + MName.Text + "'";
                    strcmd += ",HomePhone='" +HomePhone.Text + "'";
                    strcmd += ",Mobile='" +MoPhone.Text + "'";
                    strcmd += ",Web='" +Web.Text + "'";
                    strcmd += ",MQQ='" +MQQ.Text+"'";
                    strcmd += ",Province='" +Province.Text+"'";
                    strcmd += ",City='" +City.Text+"'";
                    strcmd += ",Street='" +Street.Text+"'";
                    strcmd += ",Postalcode='" +Postalcode.Text+"'";
                    strcmd += " Where Name='"+selectListName+"'";
    // 在这句之后设置断点,看看 strcmd 是什么值,然后放到 Access 中去执行一下。