try
{
OleDbConnection mycon = new OleDbConnection("Provider=MSDAORA;Password=lj;User ID=lj;Data Source=lw");
mycon.Open();
int c5=int.Parse(textBox5.Text.Trim());
int c7=int.Parse(textBox7.Text.Trim());
int c9=int.Parse(textBox9.Text.Trim());
int c10=int.Parse(textBox10.Text.Trim());
int xh1=int.Parse(label7.Text.Trim());
DateTime time1=Convert.ToDateTime(System.DateTime.Now.ToShortTimeString());
string strInsert = "insert into main_lw (xh,rq,bz,cc,jch,zjdwh,zjh,dcdwh1,dch1,dcdwh2,dch2,gd,jcjl,tzry,zyrqj) values (" ;
strInsert += xh1 + ",";
strInsert += time1 + ",'";
strInsert += comboBox1.Text + "','";
strInsert += textBox2.Text + "','";
strInsert += textBox3.Text + "','";
strInsert += comboBox3.Text + "','";
strInsert += c5 + "','";
strInsert += comboBox4.Text + "','";
strInsert += c7 + "','";
strInsert += comboBox5.Text + "','";
strInsert += c9+ "','";
strInsert += c10 + "','";
strInsert += comboBox2 + "','";
strInsert += textBox12+ "','";
strInsert += comboBox6.Text + "')";
OleDbCommand inst = new OleDbCommand ( strInsert , mycon) ;
inst.ExecuteNonQuery() ;
mycon.Close();
MessageBox.Show("添加成功!!!!!!!!!!!1");
textBox2.Text="";
textBox3.Text="";
textBox5.Text="";
textBox7.Text="";
textBox9.Text="";
textBox10.Text="";
textBox12.Text="";
this.ActiveControl=textBox5;
}
catch ( Exception ed )
{
MessageBox.Show ( "保存数据记录发生 " + ed.ToString ( ) , "错误!" ) ;
}
{
OleDbConnection mycon = new OleDbConnection("Provider=MSDAORA;Password=lj;User ID=lj;Data Source=lw");
mycon.Open();
int c5=int.Parse(textBox5.Text.Trim());
int c7=int.Parse(textBox7.Text.Trim());
int c9=int.Parse(textBox9.Text.Trim());
int c10=int.Parse(textBox10.Text.Trim());
int xh1=int.Parse(label7.Text.Trim());
DateTime time1=Convert.ToDateTime(System.DateTime.Now.ToShortTimeString());
string strInsert = "insert into main_lw (xh,rq,bz,cc,jch,zjdwh,zjh,dcdwh1,dch1,dcdwh2,dch2,gd,jcjl,tzry,zyrqj) values (" ;
strInsert += xh1 + ",";
strInsert += time1 + ",'";
strInsert += comboBox1.Text + "','";
strInsert += textBox2.Text + "','";
strInsert += textBox3.Text + "','";
strInsert += comboBox3.Text + "','";
strInsert += c5 + "','";
strInsert += comboBox4.Text + "','";
strInsert += c7 + "','";
strInsert += comboBox5.Text + "','";
strInsert += c9+ "','";
strInsert += c10 + "','";
strInsert += comboBox2 + "','";
strInsert += textBox12+ "','";
strInsert += comboBox6.Text + "')";
OleDbCommand inst = new OleDbCommand ( strInsert , mycon) ;
inst.ExecuteNonQuery() ;
mycon.Close();
MessageBox.Show("添加成功!!!!!!!!!!!1");
textBox2.Text="";
textBox3.Text="";
textBox5.Text="";
textBox7.Text="";
textBox9.Text="";
textBox10.Text="";
textBox12.Text="";
this.ActiveControl=textBox5;
}
catch ( Exception ed )
{
MessageBox.Show ( "保存数据记录发生 " + ed.ToString ( ) , "错误!" ) ;
}
解决方案 »
- 如何让程序只可以运行一个?
- datagridview自动增加行的问题
- 日期提交到数据库问题
- 程序中定制的rss中图片不能显示
- ***stop:0x00000081(0xc0000005,0xb79f1,0xb5a20450,0x00000000)
- ******* 水晶报表相关,如何在程序运行期动态操纵,报表内的控件?(急,在线等!!!)
- 设想一下,如果让Word作为mdi窗口的子窗体直接编辑文档,美啊!
- 关于 DllImport 的问题?
- 还有个问题!!!为什么我在上面明明定义了count,counttrue,stop...等等,在 static public void IOCPThreadFunction(int iValue)却用不了,要求从新定意??????
- richTextBox怎样能够保持选择文字的状态呢
- 大家用什么UML建模工具?
- 如何把写的dll文件和.NET Framework1.1一起打包...
string sql = "insert into aa (rq_field) values (to_date("+Times+",'yyyy-mm-dd'))";
insert into aa (rq_field) values (to_date('2006-09-01','yyyy-mm-dd'))
http://blog.csdn.net/web_gus/archive/2004/10/13/134907.aspx
因为C# 中不支持 数字=null;
oracle里支持数字型为空;
当数字型不为空,插入数字,
当为空时,用 Sql语句插入 数字型字段=null(oracle支持,c#不支持)