如何在运行时使用从我的数据库中获取的数据填充Datagrid [英] How Do I Fill Datagrid At Runtime With Data I Fetch From My Database

问题描述

请帮助新手，



我是表'PersonnelDetails'的所有记录。我希望在运行时使用datagrid显示。

datagrid是WPF应用程序中dockpanel的子代。当我运行此代码时，我只看到一个没有任何标签或数据的数据网格：

 public void viewAllStaffMethod（object sender，RoutedEventArgs e）
 {
 var dGrid = new DataGrid {}; 
 
 
 DockPanel dockPanelmain = new DockPanel（）; 
 dockPanelmain.Children.Add（dGrid）; 
 string conString = @Data Source =（LocalDB）\ v11.0; AttachDbFilename = | DataDirectory | \MOICIDB.mdf; Integrated Security = True; 
 string cmdString = string.Empty; 
 using（SqlConnection con = new SqlConnection（conString））
 {
 cmdString =select * from PersonnelDetails; 
 SqlCommand com = new SqlCommand（cmdString，con）; 
 SqlDataAdapter sda = new SqlDataAdapter（com）; 
 DataTable dt = new DataTable（PersonnelDetails）; 
 sda.Fill（dt）; 
 dGrid.ItemsSource = dt.DefaultView; 
 
} 

请注意我不想使用WPF的数据绑定。我希望在运行时完全控制它。



MAJ

解决方案

只需改变最后一行代码。

 dGrid.DataSource = dt; 

谢谢&问候，

Anand。 ģ

Kindly help the novice man,

I am all records from table 'PersonnelDetails'. this i want to display using datagrid at run time.
the datagrid is a child of a dockpanel in a WPF app. When i run this code i only see one culoumn of the datagrid without any label or data:

public void viewAllStaffMethod(object sender, RoutedEventArgs e)
            {
                var dGrid = new DataGrid { };


                DockPanel dockPanelmain = new DockPanel();
                dockPanelmain.Children.Add(dGrid);
                string conString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\MOICIDB.mdf;Integrated Security=True";
                string cmdString = string.Empty;
                using (SqlConnection con = new SqlConnection(conString))
                {
                    cmdString = " select * from PersonnelDetails";
                    SqlCommand com = new SqlCommand(cmdString, con);
                    SqlDataAdapter sda = new SqlDataAdapter(com);
                    DataTable dt = new DataTable("PersonnelDetails");
                    sda.Fill(dt);
                    dGrid.ItemsSource = dt.DefaultView;

                }

plz note i dont want use databinding of WPF. I want to do it at run time with full control.

MAJ

解决方案

Hi, Just change the last line of code.

dGrid.DataSource = dt;

Thanks & Regards,
Anand. G

这篇关于如何在运行时使用从我的数据库中获取的数据填充Datagrid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！