ADO.NET简单示例

现在的位置: 首页 > 综合 > 正文

2012年11月22日 ⁄ 综合 ⁄ 共 2477字 ⁄ 字号小中大 ⁄ 评论关闭

App.config文件

Code:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key ="provider" value ="System.Data.SqlClient" />
</appSettings>
<connectionStrings>
<add name ="AutoLotSqlProvider" connectionString ="Data Source =WIN-SM630IYY64V;Initial Catalog = AutoLot;Integrated Security = SSPI" />
<add name ="AutoLotOleDbProvider" connectionString ="Provider = SQLOLEDB ;Data Source =WIN-SM630IYY64V;Initial Catalog = AutoLot;Integrated Security = SSPI"/>
</connectionStrings>
</configuration>

Test.cs文件

Code:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.Odbc;
using System.Data.OleDb;
using System.Data.Common;
using System.Configuration;
class test
{
public class MyClass
{
public static void Main()
{
Console.WriteLine("**** Fun with Data Provider Factories ****/n");
//从config文件获取连接字符串和提供程序集。
string dp = ConfigurationManager.AppSettings["provider"];
string cnstr = ConfigurationManager.ConnectionStrings["AutoLotSqlProvider"].ConnectionString;
//得到工厂提供程序
DbProviderFactory df = DbProviderFactories.GetFactory(dp);
//得到连接对象
DbConnection cn = df.CreateConnection();
Console.WriteLine("your connection object is a :{0}", cn.GetType().FullName);
cn.ConnectionString = cnstr;
cn.Open();
//得到命令对象
DbCommand cmd = df.CreateCommand();
Console.WriteLine("your conmmend object is a : {0}", cmd.GetType().FullName);
cmd.Connection = cn;
cmd.CommandText = "Select * From Inventory";
//从数据读取器输出数据，因为我们指定了CommandBehacior.CloseConnection,所以不需要显示调用连接的close().
DbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Console.WriteLine("your data reader object is a {0}", dr.GetType().FullName);
Console.WriteLine("/n****** current Inventory ******");
while (dr.Read())
Console.WriteLine("->car #{0} is a {1}.", dr["CarID"], dr["Make"].ToString().Trim());
dr.Close();
}
}
}

今天开始学习ADO，里程碑，第一个代码小小纪念一下，本来要粘运行结果，但是发现查个图片好麻烦，就罢了！

【上篇】博客荣辱观的自鉴
【下篇】pku 2186

抱歉!评论已关闭.

学步园