2008年3月5日
摘要：
insert into dbo.BW_BasicData_PlantCode (code,Description) select [PlantNo],[PlantDesc] from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;IMEX=1;HDR=YES;DATABASE=D:\物料基本数据维护.xls','select * from [... 阅读全文
摘要：
string path = Server.MapPath("~\\BasicData\\"+name+".txt"); StreamReader sr = new StreamReader(path, System.Text.Encoding.GetEncoding("gb2312")); String line; if(name=="仓位" || name=="... 阅读全文
摘要：
public void ExportExcel(DataSet _dsTemp){StringWriter sw=new StringWriter(); string Title = "序号\t";foreach(DataColumn col in _dsTemp.Tables[0].Columns){Title+=col.ColumnName+"\t"; }//Title = HttpUtili... 阅读全文