bert.zeng

摘要： //attachName:保存文件名//tab:表DataTable//sheetName:Excel sheet名//RowOfSheet:Excel每页sheet 大小public static void DataTable2Excel(string attachName, DataTable tab,string sheetName,int RowOfSheet) { string file = "d:\\"+attachName+".xls"; Workbook workbook = new Workbook(); int page = tab. 阅读全文

摘要： private Button button1, button2, button3; private TextView textView1; button1.setOnClickListener(new Button.OnClickListener() { @Override public void onClick(View arg0) { // TODO Auto-generated method stub // URLַ // String uriAPI = // "http://www.dubblogs.cc:8751/Android/Test/API/Post/index.ph 阅读全文

摘要： 数据库的Service Broker在通过备份/还原方式恢复数据库后，通过SELECT * FROM sys.transmission_queue 查到的错误信息：An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot 阅读全文

摘要： //服务器硬盘分区大小EXEC master..xp_fixeddrives//查询当前数据库为所有表名select Name from sysobjects where xtype='u' and status>=0//查询当前数据库为存储所有名称select name as 存储过程名称 from sysobjects where xtype='P' AND //获取表名所有字段SELECT c.nameFROM sysobjects tJOIN syscolumns cON t.id = c.idWHERE t.name = '表名' 阅读全文

摘要： public static class ExportExcel { public static void DataTable2Excel(string attachName, DataTable tab) { string file = HttpContext.Current.Server.MapPath("/uploads/export/" + Guid.NewGuid().ToString() + ".xls"); Workbook workbook = new Workbook(); Worksheet worksheet = new Worksh 阅读全文

摘要： URL:http://pydev.org/updates/ 阅读全文

摘要： CREATE PROCEDURE dbo.GetProductsPagedAndSorted( @sortExpression nvarchar(100), @startRowIndex int, @maximumRows int)AS-- Make sure a @sortExpression is specifiedIF LEN(@sortExpression) = 0 SET @sortExpression = 'ProductID'-- Issue queryDECLARE @sql nvarchar(4000)SET @sql = 'SELECT Produc 阅读全文

摘要： import pymssqlcon = pymssql.connect(host='192.168.13.122',user='sa',password='',database='tempdb')cur = con.cursor()query="select top 50 * from t_user_info" # 执行命令cur.execute(query) while 1:print cur.fetchall()if 1 == cur.nextset(): breakcon.commit()con.clos 阅读全文

该文被密码保护。 阅读全文

该文被密码保护。 阅读全文