godpreserve的专栏

底层SQL语句SELECT MAX(SUBSTRING(LineStopID, 9, 2)) AS LineStopMAXIDFROM L_StopInfoDetailWHERE (CONVERT(NVARCHAR(10), SUBSTRING(LineStopID, 3, 6), 112)       = SUBSTRING(CONVERT(NVARCHAR(10), GETDATE(),

namespace ROHSUI.ReportCenter{ //2009-7-21 上午 张锐 创建 public partial class Attachment : System.Web.UI.Page { string ReportNO; string ReportID; string HistoryP

如：以前的APPDIR目录中：UpdateRoHSDB.exe，Microsoft.Data.ConnectionUI.Dialog.dll，Microsoft.Data.ConnectionUI.dll其中后面两个DLL程序集是UpdateRoHSDB.exe程序中必须引用的。当时是把它们同时放在APPDIR目录中，程序运行正常。但后来把这两个DLL程序集放入APPDIR目录的子文件夹a

1.运行C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/aspnet_regsql.exe来引导一个注册界面，用来在现有数据库中新建提供程序所需用到的表或在已有数据库中加入这些表2.在你的网站程序的WEB.CONFIG中添加和节。

给访问WEB SERVICE加上一层安全性。1.新建一个WEB SERVICE项目。2.在项目中新建一个类MySoapHeader.cs public class MySoapHeader : SoapHeader { private string username; private string password;

 using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Runtime.Intero

            #region            //一个SQL TO LINQ 的CONTEXT对像            MYDCSDataContext myContext = new MYDCSDataContext();            //正常的LINQ语法，找出部门ID为1的部门信息            var dept = (from d in myContex

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" >    Untitled Page       function addElement()   {        var elementTag = document.createElement("textArea")

合并 GridView 的表头单元格

ORACLE数据库移植

asp.net 网站防攻击 安全

create or replace trigger TRIG_TBL_SYS_USER  before insert    on TBL_SYS_USER    for each rowbegin  select SEQ_TBL_SYS_USER.nextva

一，CommonDataAccessusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Collections;namespace CommonDataAccessLayer{ pub

 using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.Sql;using System.Data.SqlClient;public partial c

var currentpos,timer;function initialize(){    timer=setInterval("scrollwindow()",50);}function sc(){    clearInterval(timer);}function scrollwindow(){    currentpos=document.b

                                          C#中比较两个时间的时间差     DateTime lastLoginTime  = user.LastLoginDate;//最后一次的登录时间    DateTime nowTime  = DateTime.Now;//现在在时间    TimeSpan ts   = nowTime.Subtract

public class Setting    {        private Timer time;        private double _outinterval = 1.0;//用户输入的定时器间隔        private string _type = "h";//用户输入的定时器间隔类型,h为小时,m分,s秒        public double outinterva

  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)    {        if (e.Row.RowType == DataControlRowType.Pager)        {            return;        }        e.Row.Cells[0].Att

static public class MD5    {        ///         /// 返回MD5加密结果        ///         /// 需要加密的字符串        public static string GetMD5(string str)        {            if (str == null)            {          

客户端方法:function check(opt){    var chk = window.document.getElementById(opt);    if(chk.checked == true)    {        chk.checked = false;    }    else    {        chk.checked = true;    }}服务器端方法:

    客户端代码:function check(opt,id){    var chk = window.document.getElementById(opt);    if(chk.checked == true)    {        chk.checked = false;    }    else    {        chk.checked = true;    }    v

 Javascript代码:    function addFile()        {              var filebutton = ;            document.getElementById(FileList).insertAdjacentHTML("beforeEnd",filebutton);        } 页面中:     邮件附件列

  int[] count = null;//存放每一组考核标题中对应的考核项数量.它的Length就是标题数量    protected void Page_Load(object sender, EventArgs e)    {        DataSet2TableAdapters.ScaleTitleTableAdapter st = new DataSet2TableAdapters

 //文件流            FileStream fs = new FileStream("", FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);            byte[] b = new byte[1024];            int i = fs.Read(b, 0, b.Length)

using System.Runtime.InteropServices;public class useAPI{    public useAPI()    {        //        // TODO: 在此处添加构造函数逻辑        //    }    ///     /// 打开和关闭CD托盘.    ///     [DllImport("winmm.dll", En

提示框页面:    提醒                这是一个右下脚弹出的提示框        用来提醒用户用的          window.resizeTo(220,210);  var windowW=220  // wide  var windowH=210  // high  var Yoffset=0   // in pi

当拼接JS字符串的时候，双引号里面一定要是单引号，单引号里面要是双引号，如此循环！不过全部双引号也可以，就是双引号里面的双引号需要转义！