怎样将一表中的某一字段下的数据作为列添加到另一表中?我用c#编的程序如下:
string conStr = "user id=system;password=manager;data source=popnose";
OracleConnection con = new OracleConnection(conStr);
con.Open();
string sqlStr = "select " + checkedListBox1.Text + " into hejiajian from " + treeView1.SelectedNode.Text;
OracleCommand cmd = new OracleCommand(sqlStr, con);
OracleDataReader dr = cmd.ExecuteReader();
con.Close();
发生了异常,我想应该是sql语句有问题,问题究竟是在哪啊 真是着急啊
string conStr = "user id=system;password=manager;data source=popnose";
OracleConnection con = new OracleConnection(conStr);
con.Open();
string sqlStr = "select " + checkedListBox1.Text + " into hejiajian from " + treeView1.SelectedNode.Text;
OracleCommand cmd = new OracleCommand(sqlStr, con);
OracleDataReader dr = cmd.ExecuteReader();
con.Close();
发生了异常,我想应该是sql语句有问题,问题究竟是在哪啊 真是着急啊
那是动态sql的写法.
....
String sqlStr=select " + checkedListBox1.Text + " from " + teeView1.SelectedNode.Text;
执行上面的sql,取得resultSet
在循化中把resultSet的记录insert到表中。
.....