06 2011 档案
摘要:--- 获取数据库表sELECT TABLE_CATALOG as "DataBaseName", TABLE_SCHEMA as "Table" , TABLE_NAME as "TableName" ,TABLE_TYPE as "表类型" FROM INFORMATION_SCHEMA.TABLES where TABLE_CATALOG=N'acdddC' order by TABLE_NAME ---- 获取指定表的字段SELECT * FROM acdddC.INFORMATION_SC
阅读全文
摘要:using System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Reflection;namespace WebLinq{ public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { User u = new User(); u.Age = 18; u
阅读全文
摘要:public partial class SystemManage_ModulePicture : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strModuleID=Request.QueryString["ModuleID"].ToString(); Module instance = new Module(); byte[] imgData = instance.GetOneModule(strModuleID)
阅读全文
摘要:契约:注意:所有传入的参数必须设置成字符串using System;using System.Collections.Generic;using System.ServiceModel;using Rhythmk.Model;using System.ServiceModel.Web;namespace Rhythmk.Contracts{ /// HTTP方法中: /// PUT相当于Update /// GET相当于Read /// POST相当于Create /// DELETE相当于Delete [ServiceContract] [DataContractFormat] public
阅读全文
摘要:--删除表exec sp_msforeachtable 'drop table ?' --- 删除存储过程DECLARE @STRING VARCHAR(8000)WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE TYPE='P' AND STATUS>=0)BEGINSELECT @STRING='DROP PROCEDURE '+NAME FROM SYSOBJECTS WHERE TYPE = 'P' AND STATUS>=0--SELECT @STRINGEXEC(
阅读全文
摘要:契约:using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.ServiceModel;namespace Rhythmk.Contracts{ /// <summary> /// 对象在每次调用前创建,在调用后回收 /// </summary> [ServiceContract] public interface IPerCall { [OperationContract] void Add(); [OperationContract]
阅读全文
摘要:契约:namespace Rhythmk.Contracts{ [ServiceContract(Namespace="http://wwww.wangkun.com")] public interface ICalculate { [OperationContract] [TransactionFlow(TransactionFlowOption.Mandatory)] void OperationTransaction(int i); /* TransactionFlow - 指定服务操作是否愿意接受来自客户端的传入事务 NotAllowed - 禁止事务。默认值 Al
阅读全文