110,536
社区成员
发帖
与我相关
我的任务
分享
<ListView Name="lv" HorizontalContentAlignment="Center" Height="160" Margin="11,144,140,0" VerticalAlignment="Top" Width="770" ItemsSource="{Binding}">
后台数据:
DbHelper.GetConnectionString();
DataTable dt = DbHelper.LoadDataTable("select ID,名称,tel,mail from administrator");
lv.ItemsSource = dt.DefaultView;
public static string GetConnectionString()
{
return ("Data Source=.;Initial Catalog=test;User ID=sa;Password=sa");
}
public static DataTable LoadDataTable(string SqlText)
{
return LoadDataTable(SqlText, null);
}
DbHelper.GetConnectionString();
DataTable dt = DbHelper.LoadDataTable("select ID,名称,tel,mail from tab_StationInfo");
dataGrid1.ItemsSource = dt.DefaultView;
前台:
<DataGrid.Columns >
<DataGridTextColumn Header="ID" Binding="{Binding Path=ID}"/>
<DataGridTextColumn Header="公司名称" Binding="{Binding Path=名称}"/>
<DataGridTextColumn Binding="{Binding Path=tel}" Header="电话" />
<DataGridTextColumn Binding="{Binding Path=mail}" Header="Email"></DataGridTextColumn>
</DataGrid.Columns>
private void button2_Click(object sender, RoutedEventArgs e)
{
string connectionString = string.Format(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\LaboratoryDatabase.mdf;Integrated Security=True;Connect Timeout=30");
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter("select adminno,adminname,adminsex,adminage,admintel from administrator", connection);
DataTable dt = new DataTable();
sda.Fill(dt);
lvLeft.ItemsSource = dt.DefaultView;
connection.Close();
}
<ListView Name="listView1" MinWidth="280">
<ListView.ItemBindingGroup>
<BindingGroup />
</ListView.ItemBindingGroup>
<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;
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();
string ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\LaboratoryDatabase.mdf;Integrated Security=True;Connect Timeout=30";
Sqlhelper.GetConnectionString();
DataTable dt = Sqlhelper.LoadDataTable("select adminno,adminname,adminsex,adminage,admintel from administrator");
lvLeft.ItemsSource = dt.DefaultView;