• WPF 控件DataGrid绑定


    WPF 手动绑定 DataGrid 例子:
    前台:
    <DataGrid AutoGenerateColumns="False" Name="dataGrid1">
         <DataGrid.Columns>
            <DataGridTextColumn Header="商品名称" Binding="{Binding Path=GoodsName}"></DataGridTextColumn>
            <DataGridTextColumn Header="内容" Binding="{Binding Path=GoodsIntroduce}"></DataGridTextColumn>
         </DataGrid.Columns>
    </DataGrid>
    后台:
     private void button1_Click(object sender, RoutedEventArgs e)
            {
                string sql = "server=.;database=db_Tome1;uid=sa;pwd=123456";//连接字符串
                SqlConnection sqlcon = new SqlConnection(sql);//

                textBox1.Text = "AAAA";
                string date = datePicker1.Text;
                string sqlstr = "select GoodsName from tb_GoodsInfo";
                SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon);
                DataSet ds = new DataSet();
                ds.Clear();
                DataTable table1 = new DataTable();
                sqlcon.Open();
                da.Fill(ds, "table1");
                dataGrid1.ItemsSource = ds.Tables[0].DefaultView;
                sqlcon.Dispose();
                sqlcon.Close();
               
            }
    WPF 自动绑定 DataGrid 例子:加 ItemsSource
    前台:加 ItemsSource
     <DataGrid AutoGenerateColumns="True" Height="200" HorizontalAlignment="Left" Margin="37,63,0,0"

    ItemsSource="{Binding Path=table1}" Name="dataGrid1" VerticalAlignment="Top" Width="200"  ></DataGrid>
    后台:
    private void button1_Click(object sender, RoutedEventArgs e)
            {
                string sql = "server=.;database=db_Tome1;uid=sa;pwd=123456";//连接字符串
                SqlConnection sqlcon = new SqlConnection(sql);//

                textBox1.Text = "AAAA";
                string date = datePicker1.Text;
                string sqlstr = "select * from tb_GoodsInfo";
                SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon);
                DataSet ds = new DataSet();
                ds.Clear();
                DataTable table1 = new DataTable();
                sqlcon.Open();
                da.Fill(ds, "table1");
                dataGrid1.DataContext = DataContext = ds;
                sqlcon.Dispose();
                sqlcon.Close();
               
            }
    WPF 自动绑定 DataGrid 例子:不带ItemsSource的
    前台:
    <DataGrid AutoGenerateColumns="True" Height="200" HorizontalAlignment="Left" Margin="37,63,0,0"

    Name="dataGrid1" VerticalAlignment="Top" Width="200"  ></DataGrid>
    后台:
    dataGrid1.ItemsSource = ds.Tables[0].DefaultView;

  • 相关阅读:
    no match for call to ‘(std::__cxx11::string {aka std::__cxx11::basic_string
    一转眼,已四年
    线程或进程绑定到特定的cpu
    微信好友信息统计-图、词云和热图
    微信聊天机器人-存储好友分享消息
    Qt之加减乘除四则运算-支持负数
    windows粘贴板操作-自己的应用和windows右键互动
    Qt之QDomDocument操作xml文件-模拟ini文件存储
    Qt之表格控件蚂蚁线
    Qt之移动硬盘热插拔监控
  • 原文地址:https://www.cnblogs.com/zhaoliang831214/p/3532224.html
Copyright © 2020-2023  润新知