摘要:
private void btnCheck_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + txtPath.Text + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strC 阅读全文
摘要:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><title>jQuery+CSS打造的弹出层菜单</title><script src="http://ajax.goog 阅读全文
摘要:
select * from z_leave where z_id in -- 检索重复z_linkname的纪录(select max(z_id) from z_leave where z_linkname in -- 求重复z_id的其中一个z_id(select z_linkname from z_leave group by z_linkname having count(1) >= 1) -- 取出重复的z_linknamegroup by z_linkname) 阅读全文
摘要:
一次性删除数据库所有表和所有存储过程 SQL语句 1、删除所有的表:如果由于外键约束删除table失败,则先删除所有约束:--/第1步**********删除所有表的外键约束*************************/DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; 'from sysobjects where xtype = 'F'open c1declare @c1 阅读全文
摘要:
1、webservice中的去数据方法[WebMethod(Description = "读取数据")] public XmlDataDocument GetMenuData() { DataSet ds = new DataSet(); //dt.TableName = "Column"; SqlConnection conn = new SqlConnection(@"Data Source=WWW-A576DBF2758\SQL2005;AttachDbFilename=E:\gao\gaosc... 阅读全文
摘要:
快递查询接口 http://webservice.36wu.com/ExpressService.asmxip查询接口 http://webservice.36wu.com/ipService.asmx天气预报接口 http://webservice.36wu.com/weatherService.asmx身份证查询接口 http://webservice.36wu.com/IdCardService.asmx手机归属地接口 http://webservice.36wu.com/MobilePhoneService.asmx翻译接口 http://webservice.36wu.com/Tra 阅读全文
摘要:
1、执行下面代码创建表NZ_PowerCREATE TABLE [dbo].[NZ_Power]( [nz_id] [int] IDENTITY(1,1) NOT NULL primary key, [nz_column] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [nz_parentid] [int] NOT NULL,) 2、前台代码 1 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TreeView.asp 阅读全文