c# winform 用OracleDataAdapter的来处理语句，非拼接语句，非SQL拼凑
OracleConnection conn = dbc.getConnection();//获得conn连接try{DataTable dt = new DataTable();//注：bz为违法行为字段OracleDataAdapter sda = new OracleDataAdapter("SELECT xh,hpzl,hphm,bz,larq,fdjh,clpp,cjh,jdcsyr,cllx,csys FROM kk.kkhmd WHERE 1 = 1" + hphm + " ",conn);//查询黑名单表if (checkBox1.Checked == true){sda.SelectCommand.Parameters.Add("textBox1", OracleType.VarChar).Value = textBox1.Text;//给hphm传参}else{}sda.Fill(dt);dataGridView1.DataSource = dt;}catch (Exception ee){MessageBox.Show(ee.Message.ToString());}黑色头发：http://heisetoufa.iteye.com
页:
[1]