摘要:
通过Oracle中的user_tab_cols, user_col_comments, user_constraints, user_cons_columns表联合查询。 user_tab_cols用来获取对应用户表的列信息; user_col_comments用来获取对应用户表列的注释信息; user_constraints用来获取用户表的约束条件; user_cons_columns约束中用户可访问列。selecta.column_idas列号,a.column_nameas列名,a.data_typeas类型,decode(a.data_type,'NUMBER',a.d 阅读全文
摘要:
switch (rowData.ISREGISTERTASK) { case 0: 显示north分割线 $('#RightContent').layout('panel', 'north').panel('panel').addClass('layout-split-north'); $('#RightContent').layout('panel', 'north').panel('resize'); //激活拖动 $('#RightCon 阅读全文
摘要:
//清空原有数据方法1:var item = $('#filegrid').datagrid('getRows'); if (item) { for (var i = item.length - 1; i >= 0; i--) { ... 阅读全文
摘要:
create table r_register_company as select companyid,companyname,from grdata.r_register_company insert into r_register_company (companyid, companyname) select companyid, companyname from grdata.r_register_company 阅读全文
摘要:
[WebMethod] public static string CheckLogin(string user, string pwd) { pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5"); University.BLL.Student bll = new University.BLL.Student(); DataSet ds = bll.Login(user, pwd); if... 阅读全文
摘要:
ReportViewer1.LocalReport.EnableHyperlinks = true;中文乱码解决:="javascript:display(escape('中华人民共和国'));" 阅读全文
摘要:
SQL> drop user test cascade;drop user test cascade*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-04098: trigger 'TEST.AW_DROP_TRG' is invalid and failed re-validationsysdba登录查看这个参数配置: _system_trig_enabled为enable, 需要设置为false. 8i and 9i有不同的设置方法SQL> select KSPPITY, 阅读全文
摘要:
RDLC报:错误号加上val()就好了。=IIF(Val(Sum(Fields!OILRESERVEM1.Value))<>0,CStr(Round(Val(Sum(Fields!OILRESERVEM1.Value))/Val(Sum(Fields!OILRESERVEM1.Value)+Sum(Fields!OILRESERVEM2.Value)+Sum(Fields!OILRESERVEM3.Value))*100,2))+"%","") 阅读全文
摘要:
<div contentEditable="true" onkeyup="alert(this.innerText);"> 阅读全文
摘要:
public static DataTable ExcelToDataTable(string strExcelFileName, string strSheetName){ string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFileName + ";" +"Extended Properties=Excel 5.0;"; string strExcel = string.Format("sele 阅读全文