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();

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。