1.1.2 ADO.NET模型
源代码:13033480群共享
一、新建解决方案MyADOdotNET。
二、在解决方案中添加类库项目Data,设置属性。
三、在类库Data中添加类Data.cs。
四、在Data.cs中添加代码:
namespace WestGarden.Data { namespace SqlClient { public class SqlConnection { public string Information = "WestGarden.Data.SqlClient.SqlConnection"; } public class SqlCommand { public string Information = "WestGarden.Data.SqlClient.SqlCommand"; } public class SqlDataReader { public string Information = "WestGarden.Data.SqlClient.SqlDataReader"; } public class SqlDataAdapter { public string Information = "WestGarden.Data.SqlClient.SqlDataAdapter"; } } namespace OleDb { public class OleDbConnection { public string Information = "WestGarden.Data.OleDb.OleDbConnection"; } public class OleDbCommand { public string Information = "WestGarden.Data.OleDb.OleDbCommand"; } public class OleDbDataReader { public string Information = "WestGarden.Data.OleDb.OleDbDataReader"; } public class OleDbDataAdapter { public string Information = "WestGarden.Data.OleDb.OleDbDataAdapter"; } } namespace Odbc { public class OdbcConnection { public string Information = "WestGarden.Data.Odbc.OdbcConnection"; } public class OdbcCommand { public string Information = "WestGarden.Data.Odbc.OdbcCommand"; } public class OdbcDataReader { public string Information = "WestGarden.Data.Odbc.OdbcDataReader"; } public class OdbcDataAdapter { public string Information = "WestGarden.Data.Odbc.OdbcDataAdapter"; } } namespace OracleClient { public class OracleConnection { public string Information = "WestGarden.Data.OracleClient.OracleConnection"; } public class OracleCommand { public string Information = "WestGarden.Data.OracleClient.OracleCommand"; } public class OracleDataReader { public string Information = "WestGarden.Data.OracleClient.OracleDataReader"; } public class OracleDataAdapter { public string Information = "WestGarden.Data.OracleClient.OracleDataAdapter"; } } }
五、在解决方案中添加网站项目Web。
六、在Default.aspx.cs中添加代码:
using System;
using WestGarden.Data.SqlClient;
using WestGarden.Data.OleDb;
using WestGarden.Data.Odbc;
using WestGarden.Data.OracleClient;
namespace WestGarden.Web
{
public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Response.Write("SQLServer.NET数据提供程序核心类有4个,分别是:</br>");
SQLServer();
Response.Write("OleDb.NET数据提供程序核心类有4个,分别是:</br>");
OleDb();
Response.Write("Odbc.NET数据提供程序核心类有4个,分别是:</br>");
Odbc();
Response.Write("Oracle.NET数据提供程序核心类有4个,分别是:</br>");
Oracle();
}
void SQLServer()
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader rdr = new SqlDataReader();
SqlDataAdapter da = new SqlDataAdapter();
Response.Write(conn.Information + "</br>");
Response.Write(cmd.Information + "</br>");
Response.Write(rdr.Information + "</br>");
Response.Write(da.Information + "</br></br>");
}
void OleDb()
{
OleDbConnection conn = new OleDbConnection();
OleDbCommand cmd = new OleDbCommand();
OleDbDataReader rdr = new OleDbDataReader();
OleDbDataAdapter da = new OleDbDataAdapter();
Response.Write(conn.Information + "</br>");
Response.Write(cmd.Information + "</br>");
Response.Write(rdr.Information + "</br>");
Response.Write(da.Information + "</br></br>");
}
void Odbc()
{
OdbcConnection conn = new OdbcConnection();
OdbcCommand cmd = new OdbcCommand();
OdbcDataReader rdr = new OdbcDataReader();
OdbcDataAdapter da = new OdbcDataAdapter();
Response.Write(conn.Information + "</br>");
Response.Write(cmd.Information + "</br>");
Response.Write(rdr.Information + "</br>");
Response.Write(da.Information + "</br></br>");
}
void Oracle()
{
OracleConnection conn = new OracleConnection();
OracleCommand cmd = new OracleCommand();
OracleDataReader rdr = new OracleDataReader();
OracleDataAdapter da = new OracleDataAdapter();
Response.Write(conn.Information + "</br>");
Response.Write(cmd.Information + "</br>");
Response.Write(rdr.Information + "</br>");
Response.Write(da.Information + "</br></br>");
}
}
}
版权所有©2012,西园电脑工作室.欢迎转载,转载请注明出处.更多文章请参阅博客http://blog.csdn.com/yousuosi
posted on 2012-05-16 12:25 WestGarden 阅读(170) 评论(0) 编辑 收藏 举报