作者： 吴杰

查看SQL Server实际占用的物理内存

查看SQL Server实际占用的物理内存

SELECT
    object_name
   ,Counter_name
   ,cntr_value
   ,ROUND(( cntr_value * 8192.0 ) / 1048576, 0) AS cntr_value_MB
FROM
    sys.dm_os_performance_counters
WHERE
    object_Name LIKE '%Buffer Manager%'
    AND RTRIM(counter_name) IN ( 'Free pages', 'Total pages',
                                 'Database pages' )
UNION SELECT
    object_name
   ,Counter_name
   ,cntr_value
   ,ROUND(( cntr_value / 1024 ), 0) AS cntr_value_MB
FROM
    sys.dm_os_performance_counters
WHERE
    counter_name IN ( 'Target Server Memory (KB)',
                      'Total Server Memory (KB)' )

给软件加控制功能，可以随时中断使用

给软件加控制功能，可以随时中断使用

public void RemoteCtrl()
{
    WebClient web = new WebClient();
    web.Encoding = Encoding.UTF8;
    string json = web.DownloadString("http://softapi.ilinshu.cn/softinfo/query/1" );
    SoftInfo si = JsonConvert.DeserializeObject<SoftInfo >(json);
    if (si.State != 0)
    {
        MessageBox.Show(si.ErrorMessage, "内部错误" , MessageBoxButtons .OK, MessageBoxIcon.Stop);
        Environment.Exit(0);
        return;
    }
}

kindeditor获取不到内容的解决办法

kindeditor获取不到内容的解决办法

var editorMini = KindEditor.create('.editor-mini', {
    width: '98%',
    height: '450px',
    resizeType: 1,
    items: [
        'fontname', 'fontsize', '|', 'forecolor', 'hilitecolor', 'bold', 'italic', 'underline',
        'removeformat', '|', 'justifyleft', 'justifycenter', 'justifyright', 'insertorderedlist',
        'insertunorderedlist', '|', 'emoticons', 'link'],
        afterBlur: function() {
            this.sync();
        }
});

在 KindEditor.create中增加

afterBlur: function() {
    this.sync();
}

this.sync()说明：这个函数就是同步 KindEditor 的值到 textarea文本框。

官方解释：

sync()
将编辑器的内容设置到原来的textarea控件里。

SQL SERVER函数中使用SELECT 给变量赋值

SQL SERVER函数中使用SELECT 给变量赋值，注意函数中不能用SELECT INTO

SELECT @UserId= UserId FROM Tweet WHERE Id= @ReplyTo;

实例代码如下：

CREATE FUNCTION MyFun
(

)
RETURNS int
AS
BEGIN
        DECLARE @ReplyTo int
        DECLARE @UserId int
        DECLARE My_Cursor CURSOR --定义游标
        FOR (SELECT ReplyTo FROM Tweet WHERE ReplyTo<> 0) --查出需要的集合放到游标中
        OPEN My_Cursor; --打开游标
        FETCH NEXT FROM My_Cursor INTO @ReplyTo ; --读取第一行数据
        WHILE @@FETCH_STATUS = 0
        BEGIN                     
      SELECT @UserId= UserId FROM Tweet WHERE Id= @ReplyTo;
             FETCH NEXT FROM My_Cursor INTO @ReplyTo; --读取下一行数据
        END
        CLOSE My_Cursor; --关闭游标
        DEALLOCATE My_Cursor; --释放游标

        RETURN 0

END
GO

C#下载网页图片

C#下载网页图片

static void Main(string [] args)
{
    string url1 = "http://my.oschina.net/js/ke/plugins/emoticons/{0}.gif" ;
    for(int i=0; i<135; i++)
    {
        string url = string.Format(url1, i);
        WebRequest request = WebRequest .Create(url);
        WebResponse response = request.GetResponse();
        Stream reader = response.GetResponseStream();
        FileStream writer = new FileStream (@"E:\临时测试\ConsoleApplication2\新建文件夹\" + i.ToString() + ".gif", FileMode.OpenOrCreate, FileAccess.Write);
        byte[] buff = new byte[512];
        int c = 0; //实际读取的字节数
        while ((c = reader.Read(buff, 0, buff.Length)) > 0)
        {
            writer.Write(buff, 0, c);
        }
        writer.Close();
        writer.Dispose();
        reader.Close();
        reader.Dispose();
        response.Close();
    }
    Console.WriteLine( "下载完成.." );
}