public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button Button1;
public OracleConnection fconn;
public OracleCommand ocmd;
public OracleDataReader odr;
private void Page_Load(object sender, System.EventArgs e)
{
fconn= new OracleConnection("user id=ffjt;data source=dzyjy_yanhao;password=tjff123");
fconn.Open();
ocmd=new OracleCommand("select 1 from dual",fconn);
}
private string mctobm(string m_str) //根据名称取得相应编码
{
try
{
fconn.Open();
ocmd.CommandText=m_str;
odr=ocmd.ExecuteReader();
string str;
if (odr.Read())
{
str=odr.GetValue(0).ToString();
}
else
{
str="0";
}
odr.Close();
return(str);
}
finally
{
}

}
。。。后面是打开excell表然后插入到oracle中。其中用到了上面的函数，
}