bind gridview from 2 tables using xml linq query

Question

i have a xml which contain 13 tables  i want to join two tables .to display 2 tables data in 1 gridview  i am using linq query but it is not working properly the code is below plz see it and tell me right suggestion. var employeeinfo = from p in ds2.Tables[11].AsEnumerable() join c in ds2.Tables[12].AsEnumerable() on p.Field int >( TPA_Extensions_Id ) equals c.Field int >( TPA_Extensions_Id ) into UP from c in UP.DefaultIfEmpty() select new { TPA_Extensions_Id = p.Field int >( TPA_Extensions_Id ) BasicPropertyInfo_Id = p.Field int >( BasicPropertyInfo_Id ) RPH = c.Field int >( RPH ) }; GridView1.DataSource = employeeinfo; GridView1.DataBind();

vipin saini · Answer

not available i use it but donot support

Manikavelu Velayutham · Answer

Check whether this namespace available in your code Namespace: System.Data.Linq Assembly: System.Data.Linq (in System.Data.Linq.dll)

vipin saini · Answer

Error 3 The type or namespace name 'DataContext' could not be found (are you missing a using directive or an assembly reference?)

Manikavelu Velayutham · Answer

Because employeeinfo is still in var datatype. you need to convert it to datatable before assigning it to the datasource. To convert use the above code.

vipin saini · Answer

System.InvalidCastException: Specified cast is not valid. My code give this error on the position select new StringReader sr = new StringReader (ab); DataSet ds2 = new DataSet (); ds2.ReadXml(sr); var ordersQuery = ds2.Tables[11].AsEnumerable(); var orderLinesQuery = ds2.Tables[12].AsEnumerable(); var employeeinfo = from p in ordersQuery join c in orderLinesQuery on p.Field int >( TPA_Extensions_Id ) equals c.Field int >( TPA_Extensions_Id ) select new { TPA_Extensions_Id = p.Field int >( TPA_Extensions_Id ) BasicPropertyInfo_Id = p.Field int >( BasicPropertyInfo_Id ) RPH = c.Field int >( RPH ) }; GridView1.DataSource = employeeinfo; GridView1.DataBind();

Manikavelu Velayutham · Answer

Below code will help you in converting var to datatable finally you can assign it to the gridview DataContext context = new DataContext(User ID=sa;Initial Catalog=ForeignKeyTest;Data Source=localhost;); var linqQuery = context.GetTable ().Where(s => s.LastName != Griffin) .OrderBy(s => s.LastName); SqlCommand cmd = context.GetCommand(linqQuery) as SqlCommand; DataTable dataTable = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dataTable);

vipin saini · Answer

i am using StringReader sr = new StringReader (xmlstring); DataSet ds2 = new DataSet (); ds2.ReadXml(sr); then what will be customers=ds2.Tables[11].AsEnumerable();

vipin saini · Answer

and what about binding gridview with custOrders

Manikavelu Velayutham · Answer

Following is a sample code of LINQ & Lambda Expression to Join a two tables and to return the values. Try with this and let me know if you still find any issues. var custOrders = customers. Join(orders c => c.CustomerID o => o.CustomerID (c o) => new { c.Name o.OrderDate o.Total } ); var custOrders = from c in customers join o in orders on c.CustomerID equals o.CustomerID select new { c.Name o.OrderDate o.Total };

vipin saini · Answer

there is no value present

Manikavelu Velayutham · Answer

Have you seen what are all the values present in employeeinfo through quickwatch ?