Read .rdl file in ASP.Net

See more:

C#2.0

C#

ASP.NET

Hi Friends,
I have a .rdl file somthing like below.

<DataSets>
    <DataSet Name="HelpContents">
      <Fields>
        <Field Name="ApplicationID">
          <DataField>ApplicationID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="LanguageID">
          <DataField>LanguageID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="PageName">
          <DataField>PageName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PageDisplayName">
          <DataField>PageDisplayName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="HelpDescription">
          <DataField>HelpDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>ERPByNetDevDS</DataSourceName>
        <CommandText>SELECT        ApplicationID, LanguageID, PageName, PageDisplayName, HelpDescription
FROM            HelpContents
WHERE        (IsActive = 1) AND (IsDeleted = 0)</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
    </DataSet>
    <DataSet Name="Prerequisites">
      <Fields>
        <Field Name="StatusName">
          <DataField>StatusName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="StatusDescription">
          <DataField>StatusDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PrerequisiteName">
          <DataField>PrerequisiteName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="SequenceNo">
          <DataField>SequenceNo</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>ERPByNetDevDS</DataSourceName>
        <CommandText>SELECT        Statuses.StatusName, Statuses.StatusDescription, StatusPrerequisites.PrerequisiteName, Statuses.SequenceNo
FROM            HelpContents INNER JOIN
                         HelpStatusContents ON HelpContents.HelpContentID = HelpStatusContents.HelpContentID INNER JOIN
                         Statuses ON HelpContents.LanguageID = Statuses.LanguageID AND HelpStatusContents.StatusEntityID = Statuses.StatusEntityID LEFT OUTER JOIN
                         StatusPrerequisites INNER JOIN
                         StatusApplicablePrerequisites ON StatusPrerequisites.PrerequisiteID = StatusApplicablePrerequisites.StatusPrerequisiteID ON
                         Statuses.StatusID = StatusApplicablePrerequisites.StatusID
WHERE        (StatusApplicablePrerequisites.IsDeleted = 0 OR
                         StatusApplicablePrerequisites.IsDeleted IS NULL) AND (Statuses.LanguageID = 0) AND (Statuses.IsDeleted = 0)
ORDER BY Statuses.SequenceNo</CommandText>
      </Query>
    </DataSet>
    <DataSet Name="Actions">
      <Fields>
        <Field Name="StatusName">
          <DataField>StatusName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ActionName">
          <DataField>ActionName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ActionDescription">
          <DataField>ActionDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LanguageID">
          <DataField>LanguageID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>ERPByNetDevDS</DataSourceName>
        <CommandText>SELECT        Statuses.StatusName, StatusActions.ActionName, StatusActions.ActionDescription, Statuses.LanguageID
FROM            HelpContents INNER JOIN
                         HelpStatusContents ON HelpContents.HelpContentID = HelpStatusContents.HelpContentID INNER JOIN
                         Statuses ON HelpContents.LanguageID = Statuses.LanguageID AND HelpStatusContents.StatusEntityID = Statuses.StatusEntityID INNER JOIN
                         StatusApplicableActions ON Statuses.StatusID = StatusApplicableActions.StatusID INNER JOIN
                         StatusActions ON StatusApplicableActions.StatusActionID = StatusActions.ActionID
WHERE        (StatusApplicableActions.IsDeleted = 0) AND (Statuses.LanguageID = 0)</CommandText>
      </Query>
    </DataSet>
    <DataSet Name="Event">
      <Fields>
        <Field Name="StatusName">
          <DataField>StatusName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LanguageID">
          <DataField>LanguageID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="EventName">
          <DataField>EventName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EventDescription">
          <DataField>EventDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>ERPByNetDevDS</DataSourceName>
        <CommandText>SELECT        Statuses.StatusName, Statuses.LanguageID, StatusEvents.EventName, StatusEvents.EventDescription
FROM            StatusApplicableEvents INNER JOIN
                         StatusEvents ON StatusApplicableEvents.EventID = StatusEvents.EventID INNER JOIN
                         HelpContents INNER JOIN
                         HelpStatusContents ON HelpContents.HelpContentID = HelpStatusContents.HelpContentID INNER JOIN
                         Statuses ON HelpContents.LanguageID = Statuses.LanguageID AND HelpStatusContents.StatusEntityID = Statuses.StatusEntityID ON
                         StatusEvents.StatusEntityID = Statuses.StatusEntityID
WHERE        (Statuses.LanguageID = 0)</CommandText>
      </Query>
    </DataSet>
  </DataSets>

Can we read this file in C# (ASP.Net)?
I want to find out dataset name from it, and from dataset name, its related command text.
How can I get it?

Any help appreciated.

Regards,
Lok