private void f_caplai_mabd(int i_nhom) { string user = m.user; LibDuoc.AccessData d = new LibDuoc.AccessData(); string sql = "update " + user + ".d_dmbd set ma='000000' where nhom=" + i_nhom;// +" and ma='BAN001'"; d.execute_data(sql); sql = "select id, ma, ten from " + user + ".d_dmbd where nhom=" + i_nhom + " order by ten, id ";//+" and ma='000000' DataSet lds = m.get_data(sql); string s_ma = ""; int i1 = lds.Tables[0].Rows.Count; int i2 = 0; foreach (DataRow r in lds.Tables[0].Rows) { s_ma = d.getMabd("d_dmbd", r["ten"].ToString(), i_nhom); sql = "update " + user + ".d_dmbd set ma='" + s_ma + "' where id=" + r["id"].ToString(); d.execute_data(sql); i2 += 1; lblma.Text = s_ma; lblma.Refresh(); lblten.Text = r["ten"].ToString() + " - " + i2.ToString() + "/" + i1.ToString(); lblten.Refresh(); } }