在数据库中保存Listview项的最佳方法 [英] Best way to Save Listview Items in Database
问题描述
我正在使用与SQL Server连接的WPF C#制作应用程序。我的应用程序中有一个列表视图,我想将listview中的每一行保存到数据库中。我的Listview包含4+列。那么告诉我一次保存数据库中所有行的最佳方法。通常我想在onclick事件中发生这种情况。
我试过这种方法:
for ( int i = 0 ; i < listview.Items.Count; i ++)
{
String abc = listview.Items [i] .Subitem [i] .Text;
// 其他可用性
}
但不工作。我用Listviewitem和for和foreach循环尝试了它。但是当我输入.Text或Subitem或item [i]时,下划线红色意味着错误。请告诉解决方案。
检查以下链接
[ how-to-export-data-from-listview-and-save-in -database ]
在sql数据库中存储listview数据 [ ^ ]
http://msdn.microsoft.com/en-us/library/system.windows.forms.listviewitem。 listviewsubitem(v = vs.110).aspx [ ^ ]没有 Text
属性。
另一种方式..
foreach (ListViewItem item in listView1.Items)
{
< span class =code-sdkkeyword> String abc = Convert.ToString(item.SubItems [ 1 ]。Text);
// 等等
}
I am making app in WPF C# which connects with SQL Server. There is a listview in my app and i want to save each row in listview to database. My Listview consist of 4+ Column. So tell me the best way to save all rows in database at once. Usually i want this to happen on onclick event.
I tried this method:
for (int i = 0; i < listview.Items.Count; i++)
{
String abc = listview.Items[i].Subitem[i].Text;
//other varables
}
But not working. I tried it with Listviewitem and with for and foreach loop. But underlined red color mean error is coming when i type .Text or Subitem or item[i]. Kindly tell the solution.
check below links
[how-to-export-data-from-listview-and-save-in-database]
Store listview data at sql database[^]
The http://msdn.microsoft.com/en-us/library/system.windows.forms.listviewitem.listviewsubitem(v=vs.110).aspx[^] does not have a Text
property.
Another way..
foreach (ListViewItem item in listView1.Items) { String abc = Convert.ToString(item.SubItems[1].Text); //etc etc }
这篇关于在数据库中保存Listview项的最佳方法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!