您好填充从数据库下面的ListView我有麻烦的是我的代码到目前为止任何改动将不胜感激!
DataSet dtSet = new DataSet();
using (SqlConnection conn = new SqlConnection(WpfApplication4.Properties.Settings.Default.CalorieCounterConnectionString))
{
conn.Open();
SqlCommand command = new SqlCommand("SELECT Food_Name,Food_Calories,Food_Fat,Food_Protein,Food_Carbs FROM [Food]", conn);
SqlDataReader dr = command.ExecuteReader();
listView1.Items.Clear();
while (dr.Read())
{
_FoodDataCollection.Add(new FoodData
{
Food_Name = dr["Food_Name"].ToString(),
Calories = dr["Food_Calories"].ToString(),
Fat = dr["Food_Fat"].ToString(),
Protein = dr["Food_Fat"].ToString(),
Carbs = dr["Food_Carbs"].ToString()
});
}
}
XAML:
{C} <listview height="209" horizontalalignment="Left" margin="197,321,0,0" name="listView2" verticalalignment="Top" width="304" selectionchanged="listView2_SelectionChanged" selectionmode="Single">
<listview.view>
<gridview>
<gridviewcolumn header="Name" width="120" displaymemberbinding="{Binding Food_Name}" />
<gridviewcolumn header="Calories" width="62" displaymemberbinding="{Binding Calories}" />
<gridviewcolumn header="Fat" width="30" displaymemberbinding="{Binding Fat}" />
<gridviewcolumn header="Protein" width="50" displaymemberbinding="{Binding Protein}" />
<gridviewcolumn header="Carbs" width="40" displaymemberbinding="{Binding Carbs}" />
</gridview>
</listview.view>
</listview>
我的想法有没有什么问题的帮助,将不胜感激!| DanHodgson88