基本信息
源码名称:WPF的连接Oracle数据(入门级)
源码大小:0.22M
文件格式:.rar
开发语言:C#
更新时间:2018-12-27
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300

本次赞助数额为: 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();
            }
        }
    }
}