<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="id" type="xs:int" minOccurs="0" />
<xs:element name="name" type="xs:string" minOccurs="0" />
<xs:element name="age" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
This is not part of XML this a dataset schema you dont need it in XML this is what creating the issue
here somebdoy discussing about dynamic linq query against sql it's working perfectly with DataClassDataContext.dbml file, if we know the same format of dynamic query to xml then my problem is solved.
Any idea to write dynamic query to xml file.!
Thanks in advance.
Any doubts please feel free to ask me. If this post is answer of your question then don't forgot to Click "Mark As Answer".
J.Jeyaseelan
Mudassarkhan you are right they are using column names but they use the column names within " " means within string,
In my case while design time i dont know the column names but in run time i can find what are the columns need to display and i can form the column names into one string variable so, we can try this query but i dont know how to write this type of query to
xml file, could you please help me?
Any doubts please feel free to ask me. If this post is answer of your question then don't forgot to Click "Mark As Answer".
J.Jeyaseelan
jeyaseelan@a...
Contributor
5124 Points
2025 Posts
Re: bind records to datagridview using LINQ?
Jan 28, 2009 04:21 AM|LINK
Mudassarkhan thanks for your responses.
XDocument xdoc = XDocument.Load("Simple.xml");var query1 = from books in xdoc.Elements("NewDataSet").Elements("Table")
select books;
DataTable dttemp = new DataTable();dttemp = query1.CopyToDataTable();
dataGridView1.DataSource = dttemp;
If you execute this query then the Gridview output like this
HasAttributes
but actual xml file is
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="id" type="xs:int" minOccurs="0" />
<xs:element name="name" type="xs:string" minOccurs="0" />
<xs:element name="age" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<Table>
<id>1</id>
<name>mary</name>
<age>23</age>
</Table>
<Table>
<id>2</id>
<name>joseph</name>
<age>34</age>
</Table>
<Table>
<id>3</id>
<name>john</name>
<age>44</age>
</Table>
<Table>
<id>4</id>
<name>yova</name>
<age>23</age>
</Table>
<Table>
<id>5</id>
<name>yehova</name>
<age>32</age>
</Table>
<Table>
<id>6</id>
<name>mary</name>
<age>23</age>
</Table>
<Table>
<id>7</id>
<name>joseph</name>
<age>34</age>
</Table>
<Table>
<id>8</id>
<name>john</name>
<age>44</age>
</Table>
<Table>
<id>9</id>
<name>yova</name>
<age>23</age>
</Table>
<Table>
<id>10</id>
<name>yehova</name>
<age>32</age>
</Table>
</NewDataSet>
but the value in single column, i think now you cleared?
Now tell me how to bind the exact column names such as id, name, age alone.
Could you please help me?
J.Jeyaseelan
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: bind records to datagridview using LINQ?
Jan 28, 2009 04:28 AM|LINK
Remove all this
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="id" type="xs:int" minOccurs="0" />
<xs:element name="name" type="xs:string" minOccurs="0" />
<xs:element name="age" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
This is not part of XML this a dataset schema you dont need it in XML this is what creating the issue
Your XML shud look like this
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<id>1</id>
<name>mary</name>
<age>23</age>
</Table>
<Table>
<id>2</id>
<name>joseph</name>
<age>34</age>
</Table>
<Table>
<id>3</id>
<name>john</name>
<age>44</age>
</Table>
<Table>
<id>4</id>
<name>yova</name>
<age>23</age>
</Table>
<Table>
<id>5</id>
<name>yehova</name>
<age>32</age>
</Table>
<Table>
<id>6</id>
<name>mary</name>
<age>23</age>
</Table>
<Table>
<id>7</id>
<name>joseph</name>
<age>34</age>
</Table>
<Table>
<id>8</id>
<name>john</name>
<age>44</age>
</Table>
<Table>
<id>9</id>
<name>yova</name>
<age>23</age>
</Table>
<Table>
<id>10</id>
<name>yehova</name>
<age>32</age>
</Table>
</NewDataSet>
Contact me
jeyaseelan@a...
Contributor
5124 Points
2025 Posts
Re: bind records to datagridview using LINQ?
Jan 28, 2009 04:34 AM|LINK
Mudassarkhan thanks for your response but again it displays the same type of output.
HasAttributes
but one more thing if we delete schema this should raise problem in where clause.
Please help me to solve this problem
J.Jeyaseelan
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: bind records to datagridview using LINQ?
Jan 28, 2009 04:38 AM|LINK
Are you modifying the XML each time??
Contact me
jeyaseelan@a...
Contributor
5124 Points
2025 Posts
Re: bind records to datagridview using LINQ?
Jan 28, 2009 04:42 AM|LINK
mudassarkhan thanks for your immediate responses.
Are you modifying the XML each time??
I modified one time and read from code - behind.
One more doubt if we delete schema from xml file then problem will create in where clause.
Please help me to solve this problem!
J.Jeyaseelan
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: bind records to datagridview using LINQ?
Jan 28, 2009 04:57 AM|LINK
No is shud not to check create a copy of the XML renove schema and then read it
Contact me
jeyaseelan@a...
Contributor
5124 Points
2025 Posts
Re: bind records to datagridview using LINQ?
Jan 28, 2009 05:12 AM|LINK
yes mudassarkhan i created copy of that xml file now its seems
<?xml version="1.0" standalone="yes"?><NewDataSet><
Table> <id>1</id><
name>mary</name> <age>23</age></
Table> <Table><
id>2</id> <name>joseph</name><
age>34</age> </Table><
Table> <id>3</id><
name>john</name> <age>44</age></
Table> <Table><
id>4</id> <name>yova</name><
age>23</age> </Table><
Table> <id>5</id><
name>yehova</name> <age>32</age></
Table> <Table><
id>6</id> <name>mary</name><
age>23</age> </Table><
Table> <id>7</id><
name>joseph</name> <age>34</age></
Table> <Table><
id>8</id> <name>john</name><
age>44</age> </Table><
Table> <id>9</id><
name>yova</name> <age>23</age></
Table> <Table><
id>10</id> <name>yehova</name><
age>32</age> </Table></
NewDataSet>but return the same type of output.
Any solution please?
J.Jeyaseelan
jeyaseelan@a...
Contributor
5124 Points
2025 Posts
Re: bind records to datagridview using LINQ?
Jan 28, 2009 05:24 AM|LINK
mudassarkhan http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3703779&SiteID=1
here somebdoy discussing about dynamic linq query against sql it's working perfectly with DataClassDataContext.dbml file, if we know the same format of dynamic query to xml then my problem is solved.
Any idea to write dynamic query to xml file.!
Thanks in advance.
J.Jeyaseelan
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: bind records to datagridview using LINQ?
Jan 28, 2009 05:39 AM|LINK
Here they have used Column Names In your Case you say you dont know column names.
Contact me
jeyaseelan@a...
Contributor
5124 Points
2025 Posts
Re: bind records to datagridview using LINQ?
Jan 28, 2009 05:48 AM|LINK
Mudassarkhan you are right they are using column names but they use the column names within " " means within string,
In my case while design time i dont know the column names but in run time i can find what are the columns need to display and i can form the column names into one string variable so, we can try this query but i dont know how to write this type of query to xml file, could you please help me?
J.Jeyaseelan