WPF DataGrid绑定到数据源的方法

时间:2016-07-01 11:49:27   收藏:0   阅读:447
 1 string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["str"].ConnectionString;
 2             SqlConnection con = new SqlConnection(conStr);
 3             SqlCommand command = new SqlCommand();
 4             command.CommandText = "select * from test";
 5             command.Connection = con;
 6             command.CommandType = System.Data.CommandType.Text;
 7             try
 8             {
 9                 con.Open();
10                 SqlDataAdapter sda = new SqlDataAdapter(command);
11                 DataSet ds = new DataSet();
12                 sda.Fill(ds,"Test");
13                 DataTable dt = ds.Tables["Test"];
14                 this.data.ItemsSource = dt.DefaultView;
15             }
16             catch
17             {
18                 MessageBox.Show("error");
19             }

 

原文:http://www.cnblogs.com/zhaotianff/p/5632448.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!