没什么好说的,直接见代码:
private void btn_start_Click(object sender, EventArgs e)
{
OracleConnection conn = null;
try
{
//获取与数据库的连接对象
conn = new OracleConnection();
//绑定连接字符串
conn.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=**********)(PORT=****)) (CONNECT_DATA=(SID=******)));User Id=****;Password=*****;";
conn.Open();
//获取数据库操作对象
using (OracleCommand command = (OracleCommand)conn.CreateCommand())
{
command.CommandText = "mes_bs_sys_pub_pkg_b.LOGIN_USER";
command.CommandType = CommandType.StoredProcedure;
//这个中间包含了存储过程的参数变量,参数类型,及参数的输入输出类型 (为什么参数变量的名称需要和存储过程的定义一模一样,因为连接是以键值对的形式来赋值&#