How to select data from xml file

Hi,

My requirement is that i upload an excel file then i need to validate that data.

Approach

1. Uploading file using using upload control saving binary in SqlServer

2. Then i am creating file from binary data  on Sql Server using below command and then using OPENROWSET to dump data to Sql table

3. Then reading Sql Table row wise and validating data.

Alter Procedure spUploadExcelFile
(
  @PKID int,
  @BatchID int
)
AS

BEGIN

	Declare @VarBin varbinary(max)
	Declare @FileName varchar(100)
	DECLARE @sql nvarchar(MAX)
                DECLARE @errMsg nvarchar(MAX)
	DECLARE @ObjectReturn INT
	DECLARE @ErrorSource VARCHAR(255)
	DECLARE @ErrorDesc VARCHAR(255)
	DECLARE @ObjectToken INT

	Select @VarBin  = Content , @FileName = [FileName] from MultilangBinaryData Where PKID = @PKID
	SET @FileName = 'C:\'  + @FileName
 
	EXEC sp_OACreate 'ADODB.Stream' @ObjectToken OUTPUT
	EXEC sp_OASetProperty @ObjectToken, 'Type', 1
	EXEC sp_OAMethod @ObjectToken, 'Open'
	EXEC sp_OAMethod @ObjectToken, 'Write', NULL, @VarBin
	EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @FileName, 2
	EXEC sp_OAMethod @ObjectToken, 'Close'
	EXEC sp_OADestroy @ObjectToken  
	
	SET @sql = 'INSERT INTO dbo.UserBulkData SELECT 0,NULL,'+ @BatchI

I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:

protected void BTN_RunReport_Click(object sender, ImageClickEventArgs e)
        {
            CrystalReportViewer_ClientLetter.Visible = true;

            ConnectionInfo con = new ConnectionInfo();
            con.ServerName = Constants.ServerIP;
            con.DatabaseName = Constants.DatabaseName;
            con.UserID = Constants.UserID;
            con.Password = Constants.Password;

            CrystalReportViewer_ClientLetter.ReportSource = Server.MapPath(Constants.ClientLetters);
            ParameterFields parameter = CrystalReportViewer_ClientLetter.ParameterFieldInfo;
            ParameterField batchdate = new ParameterField();
            batchdate.Name = "@BatchDate";
            ParameterDiscreteValue batchdate_value = new ParameterDiscreteValue();
            batchdate_value.Value = Convert.ToDateTime(txtBatchDate.Text);
            batchdate.CurrentValues.Add(batchdate_value);
            parameter.Add(batchdate);

            foreach (TableLogOnInfo tlf in CrystalReportViewer_ClientLetter.LogOnInfo)
            {
                tlf.ConnectionInfo = con;