- 博客(4)
- 资源 (1)
- 收藏
- 关注
原创 SQL Server 2005 中 ROW_NUMBER() 函数的简单用法
表名:d_ClientInfo语句作用:取出第100-120条数据 SELECT *FROM (SELECT ROW_NUMBER() OVER (ORDER BY ClientID ASC) AS ROWID, * FROM d_ClientInfo) AS tmpTableWHERE ROWID BETWEEN 100 AND 120 此函数
2010-01-12 13:41:00 246
原创 查询SQL服务器所有数据库名
String strServerName = "服务器名或IP";String strUserID = "数据库用户名";String strPSW= "数据库密码";DataTable DBNameTable = new DataTable();OleDbConnection Connection = new OleDbConnection(String.For
2010-01-12 13:39:00 684
原创 C# 窗体点击关闭按钮时最小化到托盘
private void form1_FormClosing(object sender, FormClosingEventArgs e){ if (e.CloseReason == CloseReason.UserClosing) { e.Cancel = true; this.Hide(); TaskIcon.BalloonT
2010-01-12 13:37:00 588
原创 C#2005 动态修改配置参数
DataSet dx = new DataSet();dx.ReadXml(Application.ExecutablePath + ".config", XmlReadMode.InferSchema);DataRow[] dtTmp = dx.Tables["setting"].Select("name = DepartName");dtTmp[0]["Value"] = t
2009-02-20 17:44:00 277
23设计模式简讲
2018-06-07
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人