bind gridview from 2 tables using xml linq query

vipin saini

16y10.3kLINQ

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();

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

vipin saini16y ago
not available i use it but donot support
0
Manikavelu Velayutham16y ago
Check whether this namespace available in your code
Namespace: System.Data.Linq
Assembly: System.Data.Linq (in System.Data.Linq.dll)
0
vipin saini16y ago
Error 3 The type or namespace name 'DataContext' could not be found (are you missing a using directive or an assembly reference?)
0
Manikavelu Velayutham16y ago
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.
0
vipin saini16y ago
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();
0
Manikavelu Velayutham16y ago

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);
0
vipin saini16y ago
i am using
StringReader sr = new StringReader("xmlstring");
DataSet ds2 = new DataSet();
ds2.ReadXml(sr);
then what will be
customers=ds2.Tables[11].AsEnumerable();

0
vipin saini16y ago
and what about binding gridview with custOrders
0
Manikavelu Velayutham16y ago
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 };

0
vipin saini16y ago
there is no value present
0
Manikavelu Velayutham16y ago
Have you seen what are all the values present in employeeinfo through quickwatch ?
0