Infragistics.Excel. 

Workbook 

work = 

new 

Infragistics.Excel.

Workbook

();

                        Infragistics.Excel. 

Worksheet 

sheet1 = work.Worksheets.Add(

"sheet2" 

);

                        Infragistics.Excel. 

Worksheet 

sheet2 = work.Worksheets.Add(

"sheet1" 

);

                        

this

.ultraGridExcelExporter1.Export(dgdQueryData, sheet1);

                        

this

.ultraGridExcelExporter1.Export(dgdQueryData, sheet2);

                        Infragistics.Excel.

BIFF8Writer 

.WriteWorkbookToFile(work, Sfd.FileName);

 

System.Web.HttpUtility.UrlEncode("我是", System.Text.Encoding.Default)

//去除为空的

AND  

PATINDEX

(

'%[^0-9|.|-|+]%'  

,

ISNULL

(  

CONVERT

(

VARCHAR  

(

8000

),  

spp2

.

OVEN_VALUE  

),

spp2

.  

VALUE_S

))  

=  

0