<ListView Name="listView" Grid.Row="1" Grid.ColumnSpan="2" Margin="20,50" SelectionChanged="listView_SelectionChanged" >
<ListView.View>
<GridView>
<GridViewColumn Header="姓名" DisplayMemberBinding="{Binding Path=CusName}" Width="40"/>
<GridViewColumn Header="地址" DisplayMemberBinding="{Binding Path=CusArea}" Width="130"/>
<GridViewColumn Header="电话" DisplayMemberBinding="{Binding Path=CusTel}" Width="118"/>
</GridView>
</ListView.View>
</ListView>
以上是xmal中的ListView控件代码.
class Customer
{
public string CusName { get; set; }
public string CusArea { get; set; }
public string CusTel { get; set; }
}
以上是新建类Customer.cs内的代码.
private void btnOk_Click(object sender, RoutedEventArgs e)
{
DataTable table = SqlHelper.ExecuteDataTable("select * from T_Test where CusName=@CustName",new SqlParameter("@CustName",txtName.Text));
List<Customer> ltCus=new List<Customer> ();
foreach (DataRow dataRow in table.Rows)
{
Customer cus = new Customer();
cus.CusName=(string)dataRow["CusName"];
cus.CusArea=(string)dataRow["CusArea"];
cus.CusTel=(string)dataRow["CusTel"];
ltCus.Add(cus);
}
listView.ItemsSource = ltCus;
以上是.xmal.cs内代码,就不贴SqlHelper.cs内的代码了.
这是效果图...