如何保存listview以便在C#中访问? [英] How to save listview to access in C# ?
本文介绍了如何保存listview以便在C#中访问?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何保存listview以便在C#中访问?请帮助
解决方案
试试这个
连接.Open()
foreach (ListViewItem Itm in Listview1.item)
{
cmd = new sqlcommand(将插入 TableName(ColumnName)值(' + Itm.subitem [0] .text +',' + Itm.Subitem [1] .text +' ))
}
connection.close();
希望这会帮助您
void LoadListView()
{
DataSet ds = new DataSet();
System.Data.OleDb。 OleDbConnection con = new System.Data.OleDb.OleDbConnection(@Provider = Microsoft.Jet.OleDb.4.0; Data Source = C:\ accessItem s.mdb;); // accessItems是数据库文件
System.Data.OleDb.OleDbDataAdapter adpt = new System.Data.OleDb.OleDbDataAdapter(select * from Items,con);
adpt.Fill(ds);
DataTable table = ds.Tables [0];
this.listView1.Items.Clear();
foreach(Table.Rows中的DataRow r)
this.listView1.Items.Add(new ListViewItem(r [Value]。ToString())); // value是名称值的字段
}
在列表视图中写一个新项目执行此操作:
void SaveItem(ListViewItem item)
{
DataSet ds = new DataSet( );
System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(@Provider = Microsoft.Jet.OleDb.4.0; Data Source = C:\ accessItems.mdb;);
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(insert into Items(Value)values(+ item.Text +),con); // item是列表查看项目
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
How to save listview to access in C# ?pls help
解决方案
try this
connection.Open() foreach(ListViewItem Itm in Listview1.item) { cmd=new sqlcommand(Insert into TableName (ColumnName) Value ('"+Itm.subitem[0].text+"','"+Itm.Subitem[1].text+"'")) } connection.close();
Hope this will Help you
void LoadListView() { DataSet ds = new DataSet(); System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\accessItems.mdb;");//accessItems is the database file System.Data.OleDb.OleDbDataAdapter adpt = new System.Data.OleDb.OleDbDataAdapter("select * from Items", con); adpt.Fill(ds); DataTable table = ds.Tables[0]; this.listView1.Items.Clear(); foreach(DataRow r in table.Rows) this.listView1.Items.Add(new ListViewItem(r["Value"].ToString()));//value is the field of name value } to write a new item in the list view do this: void SaveItem(ListViewItem item) { DataSet ds = new DataSet(); System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\accessItems.mdb;"); System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("insert into Items(Value) values(" + item.Text + ")", con);//item is the list view item con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
这篇关于如何保存listview以便在C#中访问?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文