ADO.NET 2.0 操作实例
来源:互联网 发布:mac os 10.11怎么安装 编辑:程序博客网 时间:2024/06/08 09:22
基于基类的提供者模型
提供者程序
1.得到machine.config文件中所有注册的DbProvider
this.dataGridView1.DataSource = DbProviderFactories.GetFactoryClasses();
2.指定一个连接信息,知道某种数据库程序,来得到连接字符串
DbConnection conn = null;
string strConnectionString = ADODOTNET2.Properties.Settings.Default.NorthwindConnectionString;
DbProviderFactory f = DbProviderFactories.GetFactory("System.Data.SqlClient");
conn = f.CreateConnection();
conn.ConnectionString = strConnectionString;
this.label1.Text = conn.ConnectionString.ToString();
3.枚举所有网内的所有的Data Sourcesstring strConnectionString = ADODOTNET2.Properties.Settings.Default.NorthwindConnectionString;
DbProviderFactory f = DbProviderFactories.GetFactory("System.Data.SqlClient");
conn = f.CreateConnection();
conn.ConnectionString = strConnectionString;
this.label1.Text = conn.ConnectionString.ToString();
Cursor.Current = Cursors.WaitCursor;
try
{
// see this method in the example above
DbProviderFactory f = DbProviderFactories.GetFactory("System.Data.SqlClient");
// if our factory supports creating a DbConnection, return it.
if (f.CanCreateDataSourceEnumerator)
{
DbDataSourceEnumerator enu = f.CreateDataSourceEnumerator();
DataTable t = enu.GetDataSources();
// uses chooses a Data Row r
//DataRow r = t.Rows[0];
//string dataSource = (string)r["ServerName"];
//if (r[InstanceName] != null)
// dataSource += ("//" + r["InstanceName"]);
/**///// this method is defined below
//RewriteConnectionStringAndUpdateConfigFile(f, dataSource);
this.dataGridView1.DataSource = t;
}
else
Console.WriteLine("Source must be changed manually");
}
finally
{
Cursor.Current = Cursors.Default;
}
try
{
// see this method in the example above
DbProviderFactory f = DbProviderFactories.GetFactory("System.Data.SqlClient");
// if our factory supports creating a DbConnection, return it.
if (f.CanCreateDataSourceEnumerator)
{
DbDataSourceEnumerator enu = f.CreateDataSourceEnumerator();
DataTable t = enu.GetDataSources();
// uses chooses a Data Row r
//DataRow r = t.Rows[0];
//string dataSource = (string)r["ServerName"];
//if (r[InstanceName] != null)
// dataSource += ("//" + r["InstanceName"]);
/**///// this method is defined below
//RewriteConnectionStringAndUpdateConfigFile(f, dataSource);
this.dataGridView1.DataSource = t;
}
else
Console.WriteLine("Source must be changed manually");
}
finally
{
Cursor.Current = Cursors.Default;
}
- ADO.NET 2.0 操作实例
- c#经典编程实例(ado.net基本操作)
- 关于C# Ado.NET连接数据库操作基本实例模板
- 一个简单的ADO.NET C# 数据库操作实例
- ADO.NET实例代码
- ADO.NET数据操作
- ADO.NET数据操作
- ADO.NET常用操作
- 异步Ado.Net操作
- ado.net 操作
- ADO.NET --操作数据
- 【ADO.NET】数据库操作
- ADO.net的操作
- ADO.NET操作数据库
- ADO.NET操作数据库
- ADO.net操作数据
- ADO.NET相关操作
- Ado.Net Entities Framework实例
- 动态调用webservices
- 编码命名原则
- asp.net必须懂
- ADO.NET 2.0 Dataset和Datatable 新功能新特性
- 职场上六种最可怕的人
- ADO.NET 2.0 操作实例
- 创业之最忌讳五崇罪
- 一种情感,只能用心去储藏
- Reflexil v0.7
- 页面一postback,它就显示页面的最顶端,怎样让它定位在某一位置?
- 脱壳的艺术--7. 工具
- 数据加密和解密
- TD的noWrap属性使用注意事项
- Secure PHP Image Uploader