/**********************************************
C#代码部分
**********************************************/
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

namespace chushen_mcb
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TName;
protected System.Web.UI.WebControls.TextBox TChuSheng_RQ;
protected System.Web.UI.WebControls.TextBox TWenHua_CD;
protected System.Web.UI.WebControls.TextBox TXieYa;
protected System.Web.UI.WebControls.DropDownList LYouWu_BL;
protected System.Web.UI.WebControls.DropDownList LZhengZhi_CS;
protected System.Web.UI.WebControls.TextBox TBingYi_TD;
protected System.Web.UI.WebControls.TextBox TShenGao;
protected System.Web.UI.WebControls.TextBox TTiZhong;
protected System.Web.UI.WebControls.TextBox TZuoYan_SL;
protected System.Web.UI.WebControls.TextBox TYouYan_SL;
protected System.Web.UI.WebControls.DropDownList LXiuJue;
protected System.Web.UI.WebControls.TextBox TTianBiao_RQ;
protected System.Web.UI.WebControls.TextBox TMuCe_WHFS;
protected System.Web.UI.WebControls.TextBox TJiCeng_DWDH;
protected System.Web.UI.WebControls.DropDownList LJieLun;
protected System.Web.UI.WebControls.Button Btn_OK;
protected System.Web.UI.WebControls.Button Btn_Clear;
protected System.Web.UI.WebControls.TextBox TBingYi_BH;
protected System.Web.UI.WebControls.Button Btn_Giveup;

private void Page_Load(object sender, System.EventArgs e)
{

}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{

InitializeComponent();
base.OnInit(e);
}

private void InitializeComponent()
{
this.Btn_OK.Click += new System.EventHandler(this.Btn_OK_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion

private void Btn_OK_Click(object sender, System.EventArgs e)
{
if(TJiCeng_DWDH.Text!="" && TTianBiao_RQ.Text!="" && TBingYi_BH.Text!="" && TName.Text!="" && TChuSheng_RQ.Text!="" && TWenHua_CD.Text!="" && LYouWu_BL.SelectedItem.Text!="" && TBingYi_TD.Text!="" && LZhengZhi_CS.SelectedItem.Text!="" && TShenGao.Text!="" && TTiZhong.Text!="" && TZuoYan_SL.Text!="" && TYouYan_SL.Text!="" && LXiuJue.SelectedItem.Text!="" && TXieYa.Text!="" && TMuCe_WHFS.Text!="" && LJieLun.SelectedItem.Text!="")

{
OleDbConnection cn=new OleDbConnection("Provider=MSDAORA.1;User ID=orcl;Password=orcl;Data Source=zb");
string str="insert into chushen_mcb"+
"(JiCeng_DWDH,TianBiao_RQ,BingYi_BH,Name,ChuSheng_RQ,WenHua_CD,YouWu_bl,BingYi_TD,ZhengZhi_CS,ShenGAO,TiZhong,ZuoYan_SL,YouYan_SL,XiuJue,XieYa,MuCe_WHFS,JieLun)"
+ "VALUES('"
+ TJiCeng_DWDH.Text.Trim() +"',"
+ TTianBiao_RQ.Text.Trim()+",'"
+ TBingYi_BH.Text.Trim() +"','"
+ TName.Text.Trim() +"',"
+ TChuSheng_RQ.Text.Trim() +",'"
+ TWenHua_CD.Text.Trim() +"','"
+ LYouWu_BL.SelectedItem.Text.Trim() +"','"
+ TBingYi_TD.Text.Trim() +"','"
+ LZhengZhi_CS.SelectedItem.Text.Trim() +"',"
+ TShenGao.Text.Trim() +","
+ TTiZhong.Text.Trim() +","
+ TZuoYan_SL.Text.Trim() +","
+ TYouYan_SL.Text.Trim() +",'"
+ LXiuJue.SelectedItem.Text.Trim() +"','"
+ TXieYa.Text.Trim() +"', "
+ TMuCe_WHFS.Text.Trim() +",'"
+ LJieLun.SelectedItem.Text.Trim() +"')";

OleDbCommand com=new OleDbCommand(str,cn);
com.Connection.Open();
com.ExecuteNonQuery();
com.Connection.Close();
try
{

}
catch(Exception er)
{
Response.Write("错误异常!");
er.GetType();
}
}
else
{

Response.Write("您还有部分项没有填充，请填充完整!");
return;
}
}
}
}
/********************************************
Oracle表描述部分
*********************************************/
SQL*Plus: Release 8.1.6.0.0 - Production on 星期五 9月 6 09:01:54 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.

连接到:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> desc chushen_mcb;
名称 空? 类型
----------------------------------------- -------- -----------------------
JICENG_DWDH VARCHAR2(2)
TIANBIAO_RQ DATE
BINGYI_BH NOT NULL VARCHAR2(12)
NAME VARCHAR2(8)
CHUSHENG_RQ DATE
WENHUA_CD VARCHAR2(10)
YOUWU_BL VARCHAR2(2)
BINGYI_TD VARCHAR2(12)
ZHENGZHI_CS VARCHAR2(4)
SHENGAO NUMBER(3)
TIZHONG NUMBER(2)
ZUOYAN_SL NUMBER(3,1)
YOUYAN_SL NUMBER(3,1)
XIUJUE VARCHAR2(6)
XIEYA VARCHAR2(11)
MUCE_WHFS NUMBER(4,1)
JIELUN VARCHAR2(6)

SQL>

/***************************************************
请大家帮忙看看，谢谢了!
****************************************************/