摘要：
private static string getPinYin(string text) { char pinyin; byte[] array; System.Text.StringBuilder sb = new System.Text.StringBuilder(text.Length); foreach (char c in text) { pinyin = c; array = System.Text.Encoding.Default.GetBytes(new ch... 阅读全文
摘要：
protected void Page_Load(object sender, EventArgs e) { string sql = "a|b|c|d| | |e|f|g|h|i|j|k"; System.Text.RegularExpressions.Regex ze = new System.Text.RegularExpressions.Regex("\\s"); sql= ze.Replace(sql,""); System.Text.RegularExpressions.Regex ze1 = new System.... 阅读全文
摘要：
ALTER proc [dbo].[pageing]( @tableName varchar(255), --表名 @showField varchar(1000), --显示的字段 @orderField varchar(255), --排序的字段 @pa... 阅读全文
摘要：
using System;using System.Data;using System.Configuration;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;/// <summary>///BasePage 的摘 阅读全文
摘要：
declare @t varchar(255),@c varchar(255)declare table_cursor cursor for select a.name,b.namefrom sysobjects a,syscolumns b ,systypes cwhere a.id=b.id and a.xtype='u' and c.namein ('char', 'nchar', 'nvarchar', 'varchar','text','ntext')declare @st 阅读全文
摘要：
using System.Net.Mail;private bool SendEmail(string astrEachEmail, string bt, string nr) { string strSendEmail = ConfigurationManager.AppSettings["fromMail"]; string strUserName = ConfigurationManager.AppSettings["mailAccount"]; string strPassWord = AllTableHelp.jieMi(Configu... 阅读全文
摘要：
using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Web.Caching;namespace SpaceTime{ /// <summary> /// VsC 阅读全文
摘要：
SqlParameter[] sps = new SqlParameter[] { new SqlParameter("@name", "%" + name + "%") }; 阅读全文
摘要：
private void DropDownListBind() { ddl.Items.Clear(); dt = Productmanage.Instance.GetAllProCate(); if (dt != null) bindTree(dt, 0, 0); ddl.Items.Insert(0, new ListItem("所有分类", "0")); } private void bindTree(DataTable dt, int parentId, int dep) ... 阅读全文
摘要：
convert(varchar(10),H_houseUpdateTime,23)=convert(varchar(10),getdate(),23) 阅读全文