6、测试代码,断点调试,正常获取数据,说明oracle数据操作成功@@@!!!
using Oracle.ManagedDataAccess.Client; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Mvc; namespace MvcApplication2.Controllers { public class HomeController : Controller { public ActionResult Index() { ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application."; //测试代码,引入“using Oracle.ManagedDataAccess.Client;”即可 string ConnectionString = "User ID=tests;Password=123;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.211)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))"; OracleConnection connection = new OracleConnection(ConnectionString); // connection.Open(); using (OracleConnection conn = new OracleConnection(ConnectionString)) { connection.Open(); string sql = "SELECT * FROM emp"; OracleDataAdapter oa = new OracleDataAdapter(sql, conn); DataTable dt = new DataTable(); oa.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { Response.Write(dt.Rows[i][1].ToString() + "<br>"); } } return View(); } public ActionResult About() { ViewBag.Message = "Your app description page."; return View(); } public ActionResult Contact() { ViewBag.Message = "Your contact page."; return View(); } } } |