返回首页

您好填充从数据库下面的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

回答

评论会员: 时间:2
1