How to Bind Data in xaml using C# from sqlserver

Question

How can I bind data in xaml? I'm using the following logic:

SqlConnection conn = new SqlConnection("Data Source=mahendra;Initial Catalog=Win8App;User ID=sa;Password=*******");
conn.Open();
SqlCommand cmd = new SqlCommand("select * from tbl_Registration", conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
sda.Fill(dt);
cmd.ExecuteNonQuery();      
dataGrid1.ItemsSource = dt.DefaultView;
conn.Close();

My basic need is to show the same data as the gridview.

Andrew Sklyarevsky · Accepted Answer · 2012-11-05 11:18:59Z

1

It would make sense to use some ORM software rather than direct usage of SqlConnection/SqlCommand, which are, by the way, not disposed in your code. Consider reading this article: http://msdn.microsoft.com/en-us/library/ee340709.aspx , there is an example on data-binding in WPF using Entity Framework.

answered Nov 5, 2012 at 11:18

Andrew Sklyarevsky

2,13514 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

maralfol · Accepted Answer · 2012-11-05 11:16:29Z

0

You don't have to execute the command. The DataAdapter do it for you (in the 'Fill' method). To show your result you can use your DataTable as a source and set the Autopopulate colums to true in your DataGrid. I think you don't need the DataSet.

answered Nov 5, 2012 at 11:16

maralfol

1786 bronze badges

Collectives™ on Stack Overflow

How to Bind Data in xaml using C# from sqlserver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related