我寫了一個小軟件,實現對某張數據表的增刪改查,單擊修改按鈕會彈出一個窗口,窗口裏顯示的資料是從上一個窗口中獲取的,修改新窗口裏面的資料單擊保存按鈕進行保存。但是軟件運行後修改資料後點擊保存按鈕程序就像死機了,無響應,我的保存按鈕單擊事件如下:
string str = "server=.......";
using (OracleConnection conn = new OracleConnection(str))
{
try
{
string xg = "update tbl_autoplay_list set FACT_NO=" + textBox6.Text + ",";
//xg += "ITEM_NO=" + textBox1.Text+ ",";
xg += "device_id=" + textBox5.Text + ",";
xg += "interval=" + textBox2.Text + ",";
xg += "play_url=" + "'"+textBox3.Text+"'" + ",";
xg += "play_timerange1=" + "'"+textBox7.Text +"'"+ ",";
xg += "expect_timerange1=" +"'"+ textBox8.Text+"'" + ",";
xg += "memo=" + "'"+textBox4.Text+"'" + " where item_no="
+ textBox1.Text;
OracleDataAdapter oda = new OracleDataAdapter(xg, conn);
DataSet ds = new DataSet();
oda.Fill(ds, "tbl_autoplay_list");
//oda.Update(ds,"tbl_autoplay_list");
MessageBox.Show("保存成功!","提示!");
}
catch (Exception ex)
{
throw ex;
}
}
string str = "server=.......";
using (OracleConnection conn = new OracleConnection(str))
{
try
{
string xg = "update tbl_autoplay_list set FACT_NO=" + textBox6.Text + ",";
//xg += "ITEM_NO=" + textBox1.Text+ ",";
xg += "device_id=" + textBox5.Text + ",";
xg += "interval=" + textBox2.Text + ",";
xg += "play_url=" + "'"+textBox3.Text+"'" + ",";
xg += "play_timerange1=" + "'"+textBox7.Text +"'"+ ",";
xg += "expect_timerange1=" +"'"+ textBox8.Text+"'" + ",";
xg += "memo=" + "'"+textBox4.Text+"'" + " where item_no="
+ textBox1.Text;
OracleDataAdapter oda = new OracleDataAdapter(xg, conn);
DataSet ds = new DataSet();
oda.Fill(ds, "tbl_autoplay_list");
//oda.Update(ds,"tbl_autoplay_list");
MessageBox.Show("保存成功!","提示!");
}
catch (Exception ex)
{
throw ex;
}
}
解决方案 »
- c#项目中的小问题
- 主项目如何向子项目传值
- 2005控制台应用上如何让密码输入变成*?
- c#中如何冲指定的文件中读取某一段byte[],将一段byte[]写入到某个文件指定的byte段中
- (紧急求救)如何在客户端删除服务器端某文件夹下的文件
- 删除问题
- 请教DataGrid列的Format问题!
- 水晶报表使用问题
- 求推荐项目文档管理系统,不是用于开发团队,而是用于最终归档文件管理的
- MDI 窗口在打开一个子窗口同时关闭已经打开的子窗口时,子窗口上 datagridview 中的列标题刷新的问题
- dll是自己写的,dll项目和主项目在同一个解决方案下,我想点F12定义到dll源码,但他总是转到从元数据,很不方便,请问怎么设置能按f12是定位到dll源码
- WPF,请问Main函数的命令行参数?
OracleCommand myCommand = new OracleCommand(xg, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
MessageBox.Show("保存成功!","提示!");