C#连接Oracle数据库实现简单登录

创建一个登录界面，label,TextBox,Button,注意提交按钮需要在事件也就是闪电标志这里的Click选择button_click，不然就提交不了.


在app.config文件配置

<connectionStrings>
		<add name="OracleDosConn" providerName="Dos.ORM.Oracle"
      connectionString="Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 数据库ip)(PORT = 1521)))(CONNECT_DATA = (SID = 数据库名称)(SERVER = DEDICATED)));User Id=用户名;Password=密码;"/>
	</connectionStrings>

创建三层架，并相互引用
DAL引用Model
BLL引用DAL和Model
UI层引用BLL和Model


在Model中创建实体类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Model
{
   
   public class userInfo
    {
   
        private string _username;
        private string _psw;

        public string username
        {
   
            set {
    _username = value; }
            get {
    return _username; }
        }
        public string psw
        {
   
            set {
    _psw = value; }
            get {
    return _psw; }
        }
    }
}

DAL层引用System.Data.OracleClient