首页 > 代码库 > ado.net工厂模式DbProviderFactories
ado.net工厂模式DbProviderFactories
DbProviderFactory f = DbProviderFactories.GetFactory(System.Configuration.ConfigurationManager.ConnectionStrings["ado"].ProviderName);DbConnection conn = f.CreateConnection(); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ado"].ConnectionString;conn.Open();DbCommand cmd = f.CreateCommand();cmd.CommandText = "select * from student";cmd.Connection = conn;DbDataReader re = cmd.ExecuteReader();while (re.Read()){ int id = (int)re["StuId"]; string name = (string)re["StuName"]; int age = (int)re["StuAge"]; ListViewItem item = new ListViewItem(); item.Text = id.ToString(); item.SubItems.Add( new ListViewItem.ListViewSubItem { Text = name } ); item.SubItems.Add( new ListViewItem.ListViewSubItem { Text = age.ToString() } ); listView1.Items.Add(item);}re.Close();conn.Close();
ado.net工厂模式DbProviderFactories
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。