为什么同样的sql就不执行呢?
private void button2_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode == null || Convert.ToInt32(treeView1.SelectedNode.Tag) > 15 || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || richTextBox1.Text == "")
{
MessageBox.Show("请选择一个根分类,同时请检查名称、释名、气味、内容项未添加数据");
}
else
{
if (pictureBox1.Image != null)
{
//通过时间生成文件名
DateTime now = DateTime.Now;
string TempPath = now.ToString();
TempPath = TempPath.Replace(" ", "");
TempPath = TempPath.Replace("-", "");
TempPath = TempPath.Replace(":", "");
TempPath = TempPath + ".jpg";
string DirPath = Application.StartupPath; //当前路径
DirPath = DirPath + "\\image\\";
newpath = DirPath + TempPath; //路径连接文件名
if (!File.Exists(oldpath))
{
MessageBox.Show("路径错误!");
}
else
{
ODA.CmdString = "insert into zyxx(pid,zymc,zysm,qw,zz)values(" + Convert.ToInt32(treeView1.SelectedNode.Tag) + ",'" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + richTextBox1.Text + "')"; //当选择pictureBox1控件后,下面复制文件那行执行了,但是这段sql没有执行,为什么?
ODA.OtherCommand();
File.Copy(oldpath, newpath, true);
}
}
else
{
ODA.CmdString = "insert into zyxx(pid,zymc,zysm,qw,zz)values(" + Convert.ToInt32(treeView1.SelectedNode.Tag) + ",'" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + richTextBox1.Text + "')";
ODA.OtherCommand();
}
// treeView1.Nodes.Clear();
//ODA.CmdString = "select id,pid,zymc from zyxx";
// DT = ODA.SelectCommand().Tables[0];
// CreateTreeView(treeView1.Nodes, DT, 0);
richTextBox1.Text = ODA.CmdString.ToString();
}
}