private void button2_Click(object sender, EventArgs e) { if (thumuc.Text == "") { button1_Click(null, null); return; } if (!System.IO.File.Exists(thumuc.Text)) { MessageBox.Show("Không tìm thấy File !"); return; } string sql = ""; sql = " create table " + s_user + ".d_group (id numeric(7), generic1 varchar(255),generic2 varchar(255), group1 varchar(255), group2 varchar(255), severity numeric(3), mechanism text,actions text, s_effect text, mec_detail text)"; d.execute_data(sql); // dthc = d.get_data("select * from " + s_user + ".d_group ").Tables[0]; sql = "select * from group1 order by generic1"; string s_name = "", s_generic = "", s_group = "", s_exp = "", s_id = "0", s_severity = "0"; string s_ploai = ""; int i_loai = 0, i_stt = 0, i_id = 0, i_nhom = 1;//Khoa duoc long l_id = 0; ds = m.get_data_acc(sql, thumuc.Text); int jjj = 0; foreach (DataRow r in ds.Tables[0].Rows) { s_exp = "generic1='" + r["generic1"].ToString().Trim().Replace("'", "") + "' and generic2='" + r["generic2"].ToString().Trim().Replace("'", "") + "'"; DataRow dr = d.getrowbyid(dthc, s_exp); if (dr == null) { s_group = r["group1"].ToString().Trim().Replace("'", ""); s_generic = r["generic1"].ToString().Trim().Replace("'", ""); s_id = (r["id"].ToString().Trim() == "") ? "0" : r["id"].ToString().Trim(); s_severity = (r["severity"].ToString().Trim() == "") ? "0" : r["severity"].ToString().Trim(); sql = "insert into " + s_user + ".d_group (id, generic1, generic2, group1, group2, severity, mechanism, actions, s_effect, mec_detail) "; sql += " values(" + s_id + ",'" + s_generic + "','" + r["generic2"].ToString().Trim().Replace("'", "") + "','" + s_group + "','" + r["group2"].ToString().Trim().Replace("'", "") + "'," + s_severity + ",'" + r["mechanism"].ToString().Trim().Replace("'", "") + "','" + r["actions"].ToString().Trim().Replace("'", "") + "','" + r["s_effect"].ToString().Trim().Replace("'", "") + "','" + r["mec_detail"].ToString().Trim().Replace("'", "") + "')"; d.execute_data(sql); } jjj += 1; label1.Text = "Record " + jjj.ToString(); this.Refresh(); } thumuc.Text = ""; }