///先引入Oracle.DataAccess.dll文件的命名空间
using Oracle;
using Oracle.DataAccess;
using Oracle.DataAccess.Client;
class Test
{
private const string SqlStr = "select * from Table_Name Where Rownum<2";
private void But_WriteToXml(object sender, EventArgs e)
{
try
{
///创建连接字符串
string ConnectionString10GUp = "Data Source=q103; User Id=jtdata; Password=jtdata"; //此连接方式是10G、或11G的连接方法。
string ConnectionString10GD = "Data Source=q103;Persist Security Info=True;User ID=jtdata;Password=jtdata";//此为10G以下。
OracleConnection conn = new OracleConnection(ConnectionString10GD);
OracleCommand cmd = new OracleCommand(SqlStr, conn);
DataSet ds = new DataSet();
OracleDataAdapter oda = new OracleDataAdapter(cmd);
oda.Fill(ds, "Table");
ds.WriteXml("jtdata.xml", XmlWriteMode.WriteSchema);
MessageBox.Show("Write To Xml Succeed");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
//DbProviderFactory fa = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
//DbConnection con = fa.CreateConnection();
//con.ConnectionString = ConnectionString;
//DbCommand dbc = con.CreateCommand();
//dbc.CommandText = "select * from JT_X_KHDDMX where rownum<2";
//DbDataAdapter ada = fa.CreateDataAdapter();
//ada.SelectCommand = dbc;
//DataSet ds = new DataSet();
//ada.Fill(ds);
//ds.WriteXml("txt.xml", XmlWriteMode.WriteSchema);
//Console.WriteLine("读取完成");
}