ultrawebgrid使用技巧

1.ultrawebgrid客户端行点击事件

   function Template_AfterRowActivateHandler(gridId, rowId) {
        CurrentRow = igtbl_getRowById(rowId);
        CurrentRowIndex = CurrentRow.getIndex();
        var aaa= CurrentRow.getCell(0).getValue();

        document.getElementById("<%= gamen.ClientID %>").value = strlegid;

   }

2．模板列的添加，及从后台取值

<CellTemplate>                   
                      <asp:Label ID="aa" Text="<%# Container.Text %>" runat="server" BorderStyle="None" ToolTip='<%#DataBinder.Eval(Container.DataItem,"fieldname") %>' ></asp:Label>
                     </CellTemplate>

3.pattern页面设置

Pattern="页码：[currentpageindex]/[pagecount]   每页: [pagesize]    [page:1:first]  [prev]  [default]  [next] [page:[pagecount]:last] "

4．hidden使用

<input type="hidden" name="pLegId" id="pLegId" title="LEG_ID"  runat="server"/>

5．数据保存

 UltraWebGrid1.DataSource = dt;
            UltraWebGrid1.DataBind();
            ViewState["data"] = dt;

6．数据库字段number转化为varchar

       convert(varchar, f.field)

 

7.数据库连接

     SqlConnection connection = new SqlConnection(constring);
            SqlCommand command = new SqlCommand();
            command.Connection = connection;
            DataTable dt = new DataTable();        
                connection.Open();
                command.CommandText = strSql.ToString();
                command.CommandTimeout = 6000;
                DataSet ds = new DataSet();
                SqlDataAdapter adp = new SqlDataAdapter(command);
                adp.Fill(ds);