从数据库获取数据到Listview [英] Fetching Data from Database to Listview

问题描述

我需要在C＃windows应用程序中将数据库中的垂直数据添加到listview中？

I need to add vertical data from database to listview in C# windows application?

推荐答案

您好，尝试这样从数据库加载数据并绑定到Listview中asp.net

Hi, try like this to load data from database and bind to Listview in asp.net

protected void Page_Load(object sender, EventArgs e)
   {
       OleDbConnection con = new OleDbConnection("Your Connection String");
       con.Open();
       string str = "select * from test Query";
       OleDbCommand com = new OleDbCommand(str, con);
       OleDbDataAdapter oledbda = new OleDbDataAdapter(com);
       DataSet ds = new DataSet();
       oledbda.Fill(ds, "test Query");
       con.Close();
       DataTable dt = ds.Tables["test Query"];
       int i;
       for (i = 0; i <= dt.Rows.Count - 1; i++)
       {
           listView1.Items.Add(dt.Rows[i].ItemArray[0].ToString());
           listView1.Items[i].SubItems.Add(dt.Rows[i].ItemArray[1].ToString());
       }
   }

这篇关于从数据库获取数据到Listview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！