linq to BindingNavigator/BindingSource
-
Hi all, Here I am with my question again :) i am wondering how do I bind linq query to BindingNavigator or at least a BindingSource so I can bind it to BindingNavigator. say, I have go a BindingNavigator called bn (BindingNavigator bn) var query = from t in db.SOMETHINGS select t; I tried bn.BindingSource = query; and it was no help at all I also tried BindingSource bs = new BindingSource(); bs.DataSource = query; bn.BindingSource = bs that also return me errors. Basically I just wanted to achieve something like this with linq. Because I have started it with linq :( String strConn = "Data Source=DATASOURCE;Initial Catalog=DB;User ID=sa;Password=sa;"; SqlConnection conn = new SqlConnection(strConn); SqlDataAdapter da = new SqlDataAdapter("Select * From [TRANSACTION]", conn); SqlCommandBuilder cmd = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds, "trans"); BindingSource bs = new BindingSource(ds, "trans"); //I can't simply use linq query result here :(:(:( bnPrevTrans.BindingSource = bs; Again, thank you guys ....