110,535
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="provider" value ="System.Data.SqlClient"/>
<add key="cnStr" value ="Data Source=.\SQLEXPRESS;Initial Catalog=AutoLot;Integrated Security=SSPI"/>
</appSettings>
</configuration>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.Common;
namespace DataProviderFactory
{
class Program
{
static void Main(string[] args)
{
//从config文件获取连接字符串和提供程序
string dp = ConfigurationManager.AppSettings["provider"];
string cnStr = ConfigurationManager.AppSettings["cnStr"];
//得到工厂提供程序
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 command object is a :{0}", cmd.GetType().FullName);
cmd.Connection = cn;
cmd.CommandText = "Select * From Inventory";
//从数据读取器输出数据
DbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Console.WriteLine("Your 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();
Console.ReadLine();
}
}
}
value ="Data Source=.\SQLEXPRESS;Initial Catalog=AutoLot;Integrated Security=SSPI"
这句我改成这样了
value ="Data Source=.\SQLEXPRESS;SERVER=.;Initial Catalog=AutoLot;Integrated Security=SSPI"
<add key="ConnectionString" value="Database=ZLLOA0926;Server=192.168.0.222;uid=sa;pwd=sa;"/>
<add key="cnStr" value ="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AutoLot.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"/>