在网上弄个SQLHepler.cs文件;然后 List<aaa> list = new List<aaa>(); SqlDataReader dr = SQLHepler.ExecuteReader("select * from Tab"); while (dr.Read()) { aaa a = new aaa(); a.ID = Convert.ToInt32(dr["ID"]); a.Name = dr["Name"].ToString(); list.Add(a); } dr.Close();
public class aaa { public int ID { get; set; } public string Name { get; set; } }
<ListView.View> <GridView x:Name="gridView1"> <GridViewColumn Header="用户名" DisplayMemberBinding="{Binding Path=yhm}"></GridViewColumn> <GridViewColumn Header="密码" DisplayMemberBinding="{Binding Path=mm}"></GridViewColumn> <GridViewColumn Header="代码 " DisplayMemberBinding="{Binding Path=bmdm}"></GridViewColumn> <GridViewColumn Header=" ID" DisplayMemberBinding="{Binding Path=id}"></GridViewColumn> </GridView> </ListView.View>
</ListView>
SqlDataAdapter sda;
DataTable dt;
public MainWindow()
{
InitializeComponent();
getData();
}
void getData()
{
string connectionString = string.Format("Data Source=192.168.0.250;Initial Catalog=IBMS;user=sa;password=password;timeout=30;Max Pool Size=75;Min Pool Size=5");
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
sda = new SqlDataAdapter("select yhm,mm,bmdm,id from yhxxb", connection);
SqlCommandBuilder commbuilder = new SqlCommandBuilder(sda);
sda.UpdateCommand = commbuilder.GetUpdateCommand();
dt = new DataTable();
sda.Fill(dt);
listView1.ItemsSource = dt.DefaultView;
connection.Close();
}
百度上,只有绑定,好像没有绑定到SQL的吧?
如果不用DataTable 和 SqlDataAdapter 是不是会比较复杂点?
我比较菜鸟。。可能有些问题问的比较傻望不要见笑。
SqlDataReader dr = SQLHepler.ExecuteReader("select * from Tab");
while (dr.Read())
{
aaa a = new aaa();
a.ID = Convert.ToInt32(dr["ID"]);
a.Name = dr["Name"].ToString();
list.Add(a);
}
dr.Close();
public class aaa
{
public int ID { get; set; } public string Name { get; set; }
}
百度上,只有绑定,好像没有绑定到SQL的吧?
如果不用DataTable 和 SqlDataAdapter 是不是会比较复杂点?
我比较菜鸟。。可能有些问题问的比较傻望不要见笑。
都是一样的 自己觉得怎么用习惯就好了 你也可以按照6楼的 弄个help类库来帮助你解决数据查询
这个,前台绑定如果用这个: <ListView.View>
<GridView>
<GridViewColumn Header="ID" Width="50"
DisplayMemberBinding="{Binding Path=ID}"/>
<GridViewColumn Header="Name" Width="50"
DisplayMemberBinding="{Binding Path=Name}"/>
<GridViewColumn Header="Num" Width="50"/>
</GridView>
</ListView.View>没有数据显示啊,很奇怪。。
这个,前台绑定如果用这个: <ListView.View>
<GridView>
<GridViewColumn Header="ID" Width="50"
DisplayMemberBinding="{Binding Path=ID}"/>
<GridViewColumn Header="Name" Width="50"
DisplayMemberBinding="{Binding Path=Name}"/>
<GridViewColumn Header="Num" Width="50"/>
</GridView>
</ListView.View>没有数据显示啊,很奇怪。。给ListView起个名字叫listView1;然后再后台listView1.DataSource=list;
这个,前台绑定如果用这个: <ListView.View>
<GridView>
<GridViewColumn Header="ID" Width="50"
DisplayMemberBinding="{Binding Path=ID}"/>
<GridViewColumn Header="Name" Width="50"
DisplayMemberBinding="{Binding Path=Name}"/>
<GridViewColumn Header="Num" Width="50"/>
</GridView>
</ListView.View>没有数据显示啊,很奇怪。。给ListView起个名字叫listView1;然后再后台listView1.DataSource=list;ListView 不带DataSource 这个属性啊,我尝试用ListView_De.ItemsSource = list;结果,报错。