private void button1_Click(object sender, EventArgs e) { string sql = "update yk_typk set YBDM = '" + textBox4.Text.Trim() + "' where ypxh = '" + textBox1.Text.Trim() + "'"; int i = dbConn1.GetSqlCmd(sql); if (i > 0) { MessageBox.Show("修改成功"); } }
private void Form11_Load(object sender, EventArgs e) { Dictionary <string, string> ls = new Dictionary <string, string>(); string commandString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=C:\\Users\\Administrator\\Desktop\\新建文件夹(1)\\201902更新三目\\广东1.17.09中成药全库.xls;" + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\""; string commandString1 = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=C:\\Users\\Administrator\\Desktop\\新建文件夹(1)\\201902更新三目\\广东1.17.10西药全库.xls;" + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\""; DataSet dataSet = new DataSet(); // 创建连接到数据源的对象 OleDbConnection command = new OleDbConnection(commandString); OleDbConnection command1 = new OleDbConnection(commandString1); // 打开连接 command.Open(); // Sql的查询命令,有关于数据库自行百度或者Google string sqlex = "select * from [中成药注册信息库$]"; string sqlex1 = "select * from [西药注册信息库$]"; OleDbDataAdapter adaper = new OleDbDataAdapter(sqlex, command); OleDbDataAdapter adaper1 = new OleDbDataAdapter(sqlex1, command1); // 用来存放数据 dataSet = new DataSet(); adaper.Fill(dataSet); // 填充DataTable数据到DataSet中 DataTable dt = dataSet.Tables[0]; foreach (DataRow r in dt.Rows) { ls.Add(r["药监局药品编码"].ToString(), r["中成药药品代码"].ToString()); } dataSet = new DataSet(); adaper1.Fill(dataSet); dt = dataSet.Tables[0]; foreach (DataRow r in dt.Rows) { ls.Add(r["药监局药品编码"].ToString(), r["西药药品代码"].ToString()); } hisDBConn hdb = new hisDBConn(); //foreach (var l in ls) //{ // string sql = "update yk_typk2 set YBDM = '" + l.Value + "' where sbdm = '" + l.Key + "'"; // hdb.GetSqlCmd(sql); //} Dictionary <string, string> nls = new Dictionary <string, string>(); string sqln = "select * from [YK_TYPK2] where ybdm is null"; DataTable dtn = hdb.GetDataSet(sqln).Tables[0]; foreach (DataRow n in dtn.Rows) { string ypxh = n["ypxh"].ToString(); string sbdm = n["sbdm"].ToString(); string sql = "update yk_typk2 set YBDM = '" + sbdm + "' where ypxh = '" + ypxh + "'"; hdb.GetSqlCmd(sql); } // 释放连接的资源 command.Close(); }