开发笔记 第555页

[转载]Filter ComboGrid – jQuery EasyUI.

The combogrid component has the same functionalities as the combobox component except that the drop down panel is based on a datagrid. The combogrid component can be filtered, paged and some other datagrid capabilities. This tutorial will show you how to filter data records in a combogrid component.

Create ComboGrid

The combogrid component should define ‘idField’ and ‘textField’ properties. The ‘idField’ property store the component value and ‘textField’ property display the text message on the input box. The combogrid can filter its records in ‘local’ or ‘remote’ mode. On remote mode the combogrid will post the ‘q’ parameter to remote server when users typeing chars in input box.

The Server Code

Download the EasyUI example:



[转载]jQuery.Easyui 1.2.4 CHM API 下载 – 疯狂秀才 – 博客园.

JQuery easyui 1.2. 4

ChangeLog

Bug

• menu: The menu position is wrong when scroll bar appears. fixed.
• accordion: Cannot display the default selected panel in JQuery 1.6.2. fixed.
• tabs: Cannot display the default selected tab panel in jQuery 1.6.2. fixed.

Improvement

• menu: Allow users to disable or enable menu item.
• combo: Add ‘delay’ property to set the delay time to do searching from the last key input event.
• treegrid: The ‘getEditors‘ and ‘getEditor‘ methods are supported now.
• treegrid: The ‘loadFilter‘ option is supported now.
• messager: Add ‘progress’ method to display a message box with a progress bar.
• panel: Add ‘extractor’ option to allow users to extract panel content from ajax response.

New Plugins

• searchbox: Allow users to type words into box and do searching operation.
• progressbar: To display the progress of a task.
  

[转载]Documentation – jQuery EasyUI.

TreeGrid

Extend from $.fn.datagrid.defaults. Override defaults with $.fn.treegrid.defaults.

Dependencies

• datagrid

Usage

Properties

The properties extend from datagrid, below is the added properties for treegrid.

Events

The events extend from datagrid, below is the added events for treegrid.

Methods

[转载]Mozilla Firefox 8.0 正式发布

Mozilla FTP的releases目录已经出现了Mozilla Firefox 8.0 正式版的身影，现在已经可以下载，本次发布包含全平台全语种，这意味着微软的蛋糕又要送出了。

• Add-ons installed by third party programs are now disabled by default
• Added a one-time add-on selection dialog to manage previously installed add-ons
• Added Twitter to the search bar
• Added a preference to load tabs on demand, improving start-up time when windows are restored
• Improved tab animations when moving, reordering, or detaching tabs
• Improved performance and memory handling when using <audio> and <video> elements
• Added CORS support for cross-domain textures in WebGL
• Added support for HTML5 context menus
• Added support for insertAdjacentHTML
• Improved CSS hyphen support for many languages
• Improved WebSocket support
• Fixed several stability issues

下载:Mozilla Firefox 8.0

[转载]注册SQLdmo.dll

.

在不安装客户端实用程序的情况下启用 SQL DMO 客户端
(http://support.microsoft.com/kb/248241/zh-cn)

概要
本文介绍在无需安装 SQL Server 客户端实用程序的情况下启用 SQL Server 分布式管理对象 (SQL-DMO) 客户端功能所需的步骤。

典型情况
您 编写一个利用 SQL Server 中的 SQL-DMO 对象模型的应用程序。您的应用程序在服务器计算机中能正常运行，而在安装 了 SQL Server 客户端实用程序的客户端计算机中也能正常运行。但是，该应用程序无法单独运行。此外，您还可能看到几个与此相关的错误。最常见 的错误是：
ActiveX can’t create object
Field is not bound correctly
Cannot find entry point
注意：安装  Microsoft 数据访问组件 (MDAC) 无法解决此问题。

MDAC 不 会安装 Sqldmo.dll 文件或与该文件关联的许多从属 DLL 中的任何一个。MDAC 所包括的是 SQL-DMO 客户端连接使用的许多相 关 DLL。无论如何，将 MDAC 与您的应用程序安装绑定都不是最理想的解决办法，因为要使您的 DMO 连接工作，您无需安装所有 的 MDAC DLL。另外，MDAC 还会在客户端计算机上安装许多您可能永远都不会用到的其他功能。这里的主要意思是，您不必安装所有 MDAC 来 获取您需要的功能，而是只安装必需的 DLL 即可。本文后面将介绍这些 DLL。

在讨论不同类型的 DLL 以及需要将它们放置在哪里 之前，让我们偏离一下主题，简要回顾一下基于 Win32 和 COM 的 DLL。在本文中，您只需了解如何区分这些 DLL 以及在识别它们之后如何 处理它们。了解这一点之后，看看以下您需要了解的内容： • 您需要通过 Regsvr32 实用程序注册基于 COM 的 DLL。
• 您需要将本机 Win32 DLL 放置在应用程序路径中。
• 可能还需要将本机 Win32 DLL 放置在 Win32 目录中。
有时候很难区分基于 COM 的 DLL 和非基于 COM 的 DLL；但是，通常情况下，基于 COM 的 DLL 始终具有以下入口点：
• DllGetClassObject
• DllRegisterServer
• DllUnregisterServer
• DllCanUnloadNow
要查看入口点，请右键单击 DLL，然后单击快捷菜单中的“快速查看”。所显示的信息记录在 DLL 信息的“导出表”部分中。

以下是您从客户端启用 DMO 所需的与 SQL-DMO 有关的 DLL 列表：
• Sqldmo.dll
• Sqldmo.rll
• Sqlsvc.dll
• Sqlsvc.rll
• Sqlwoa.dll
• Sqlresld.dll
• Sqlwid.dll
• W95scm.dll
在上面的 DLL 列表中，Sqldmo.dll 是唯一您需要在客户端计算机上注册的 DLL。但是，要成功注册 Sqldmo.dll 文件，Sqldmo.rll 文件必须存在于客户端计算机上的以下目录中：
（服务器端位置）：c:\Mssql7\Binn\Resources\1033
（客户端位置）：c:\Winnt\System32\Resources\1033
Sqldmo.rll 文 件总是会引发问题。.rll 文件是本地化的资源文件。资源目录会根据 SQL Server 和客户端安装上配置的国家/地区语言的不同而异。在本例 中，目录 1033 是语言标识符 0X0409 的十进制表示，代表美国英语。将该 .rll 文件放置在适当的位置之后，可以通过调 用 Regsvr32 实用程序来注册 Sqldmo.dll 文件。注册该文件的命令是： C:\Regsvr32 Sqldmo.dll

注册成功后，应收到以下消息：
SQLDMO.dll 中的 DLLRegisterServer 成功。
如果您希望在您的应用程序安装例行过程中自动进行此类注册，请参见与 Regsvr32 实用程序关联的各个开关。以静默方式注册该文件的命令是： c:\regsvr32 /s- sqldmo.dll

客户端计算机上包含 Sqldmo.dll 文件的目录必须具有特定的结构，否则您可能会收到类似如下的错误消息：
LoadLibrary(“C:\Winnt\System32\sqldmo.dll”) 失败。
GetLastError 返回 0x0000007e
该 错误意味着发生了错误 126（以十进制表示），该错误对应于“找不到指定模块”错误。在本例中，此错误与 Sqldmo.rll 文件有关。 即，Regsvr32 实用程序找到了 Sqldmo.dll 文件，但无法完成该文件的注册，因为 Sqldmo.rll 文件不在预期 的 1033 子目录中。

要避免该问题，请执行下列操作：
1. 在 Sqldmo.dll 所在的目录中添加名为“Resources”的目录。
2. 在“Resources”目录下添加名为“1033”的子目录。
3. 将 Sqldmo.rll 文件复制到该目录中。
完成后，目录结构应类似如下：
包含 Sqldmo.dll 的目录\Resources\1033
且该 1033 目录应包含 Sqldmo.rll 文件。

除了前面提到的 DLL，您还需要确保您安装了正确的网络库 DLL。您在此需要的主要网络库 DLL 为： • 命名管道：Dbnmpntw.dll
• 套接字：Dbmssocn.dll
• 多协议：Dbmsrpcn.dll
这些 DLL 都是基于 Win32 的 DLL，因此您不必注册它们。只需将这些 DLL 放入  Microsoft Windows NT 的 System32 目录中，或  Microsoft Windows 95/Windows 98 的 System 目录中。

完成前面的步骤之后，客户端应用程序应当能够正常启动，不会出现最初由于缺少必要文件而导致的任何问题。

2008/01/17
实际案例:
在一台机器上布置SQLWEBADMIN后发现运行时出现如下错误:

Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.
解决方案:
根据上面的文档,找到相应的文件,
将
Sqldmo.dll,Sqlsvc.dll,Sqlwoa.dll,Sqlresld.dll,Sqlwid.dll,W95scm.dll
复制到 %windir%\system32
将
Sqldmo.rll
Sqlsvc.rll
复制到 %windir%\system32\Resources\1033\
或(和)%windir%\system32\Resources\2052\
然后运行:regsvr32 Sqldmo.dll
成功注册,最终也解决了上述布署过程中遇到的问题.

[转载]Build CRUD Application with edit form in expanded row details – jQuery EasyUI.

When switch the datagrid view to ‘detailview’, users can expand a row to show any details below that row. This feature allows you to provide any possible layout for its edit form that placed in detail row panel. In this tutorial, we are using datagrid component to reduce the space occupied by the edit form.

Step 1: Create DataGrid in HTML tag

Step 2: Apply Detail View for DataGrid

To use the detail view for datagrid, include the ‘datagrid-detailview.js’ file to your page header.

We use the ‘detailFormatter’ function to generate the row detail content. In this case, we return the empty <div> that the edit form will be placed in. When users click the row expand button(‘+’), the ‘onExpandRow’ event will be triggered and we can load the edit form via ajax. Call ‘getRowDetail’ method to get the row detail container, so we can find the row detail panel. Create the panel in row details and load the edit form that returned from ‘show_form.php’.

Step 3: Create Edit Form

The edit form is loaded from server.

Step 4: Save or Cancel editing

Call the ‘saveItem’ function to save a user or ‘cancelItem’ function to cancel the editing.

Determine what is the URL to post to first and then find form object and call ‘submit’ method to post the form data. Collapse and update the row data while saving data successfully.

When cancel the editing action, if the row is new and not save yet, delete the row directly, otherwise collapse the row.

Download the EasyUI example:

[转载]使用Power Designer正反向数据库及生成设计报告 – shishanyuan – 博客园.

[转载]Form Validation – jQuery EasyUI.

This tutorial will show you how to validate a form. The easyui framework provides a validatebox plugin to validate a form. In this tutorial we will build a contact form and apply the validatebox plugin to validate the form. You can then adapt this form to your own requirements.

Build form

Let’s build a simple contact form with name, email, subject and message field:

We add a class named easyui-validatebox to input markup so the input markup will be applied the validation according the validType attribute.

Prevent the form to submit when invalid

When users click the submit button of form, we should prevent the form to submit if the form is invalid.

If the form is invalid, a tooltip message will show.

Download the EasyUI example:

[转载]easyui表单数据验证.

   <form id="ff" method="post">
        <div>
            <label for="name">
                Name:</label>
            <input class="easyui-validatebox" type="text" name="name" required="true" validtype="length[5,12]"></input>
        </div>
        <div>
            <label for="email">
                Email:</label>
            <input class="easyui-validatebox" type="text" name="email" required="true" validtype="email" invalidMessage="邮箱格式错误"></input>
        </div>
        <div>
            <label for="subject">
                Subject:</label>
            <input class="easyui-validatebox" type="text" name="subject" required="true" missingMessage="不能为空"></input>
        </div>
        <div>
            <label for="message">
                Message:</label>
            <textarea name="message" style="height: 60px;"></textarea>
        </div>
        <div>
            <input type="submit" value="Submit">
        </div>
        </form>

[转载]SQL Server插入记录后获取自动增长的列值 – Allen_Li – 博客园.

   1: CREATE PROCEDURE dbo.CustomerInsert

   2:   @Name varchar(15),

   3:   @Age int,

   4:   @Sex bit,

   5:   @id int OUT

   6: AS

   7: INSERT INTO Customer(Name,Age,Sex) VALUES(@Name,@Age,@Sex)

   8: SET @id = SCOPE_IDENTITY()

   1: /// <summary>

   2:     /// 插入一条Customer记录

   3:     /// </summary>

   4:     /// <param name="cus">要插入的Customer</param>

   5:     /// <param name="dt">要更新的数据表</param>

   6:     /// <returns>插入的Customer的id值</returns>

   7:     public int InsertCustomer(Customer cus, DataTable dt)

   8:     {

   9:         using (SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=test;Integrated Security=True"))

  10:         {

  11:             // 创建SqlDataAdapter

  12:             SqlDataAdapter adp = new SqlDataAdapter();

  13:

  14:             //创建InsertCommand命令

  15:             adp.InsertCommand = new SqlCommand("dbo.CustomerInsert", con);

  16:             //指定InsertCommand类型为存储过程

  17:             adp.InsertCommand.CommandType = CommandType.StoredProcedure;

  18:

  19:             //向InsertCommand加入参数

  20:             adp.InsertCommand.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 20, "Name"));

  21:             adp.InsertCommand.Parameters.Add(new SqlParameter("@Age", SqlDbType.Int, 4, "Age"));

  22:             adp.InsertCommand.Parameters.Add(new SqlParameter("@Sex", SqlDbType.Bit, 1, "Sex"));

  23:             SqlParameter parId = adp.InsertCommand.Parameters.Add(new SqlParameter("@id", SqlDbType.Int, 0, "id"));

  24:

  25:             //指定id为输出参数

  26:             parId.Direction = ParameterDirection.Output;

  27:

  28:             DataRow row = dt.NewRow();

  29:             row["Name"] = cus.Name;

  30:             row["Sex"] = cus.Sex;

  31:             row["Age"] = cus.Age;

  32:             dt.Rows.Add(row);

  33:

  34:             //更新数据库

  35:             adp.Update(dt);

  36:

  37:             //返回id值

  38:             return Convert.ToInt32(row["id"].ToString());

  39:         }

  40:     }