基本信息
源码名称:WPF的连接Oracle数据(入门级)
源码大小:0.22M
文件格式:.rar
开发语言:C#
更新时间:2018-12-27
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300
本次赞助数额为: 2 元×
微信扫码支付:2 元
×
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
源码介绍
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; using System.Data.OleDb; using System.Data.OracleClient; namespace WpfApp2 { /// <summary> /// MainWindow.xaml 的交互逻辑 /// </summary> public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); } private void BtnConntion_Click(object sender, RoutedEventArgs e) { //创建连接 string connString = "Provider=MSDAORA.1;User ID=system;Password=123456;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = CPCM)))"; OleDbConnection conn = new OleDbConnection(connString); string sql = ""; OleDbCommand com = new OleDbCommand(sql,conn); OleDbDataReader rd= com.ExecuteReader(); try { conn.Open(); MessageBox.Show(conn.State.ToString() "连接成功"); } catch (Exception ex) { // ShowErrorMessage(ex.Message.ToString()); } finally { conn.Close(); } } } }