摘要:
在这里做个备注: public partial class XtraForm2 : DevExpress.XtraEditors.XtraForm { private LabelControl _labelControl; private int xpoint; private int yponit; public XtraForm2() { InitializeComponent(); _labelControl = new LabelControl(); ... 阅读全文
摘要:
创建用户与用户授权:--创建用户create user pmp identified by pmp;--分配权限grant create session,create table,create view ,create any index to pmp;grant unlimited tablespace to pmp;grant connect,resource to pmp; 阅读全文
摘要:
--排名函数 ROW_NUMBER() RANK(), DENSE_RANK(),NTILE() Over()函数 为排名函数生成排序顺序、 select ROW_NUMBER() over(order by OrderDate) as Romber,SalesOrderID,OrderDate from SalesLT.SalesOrderHeader ---创建一个单一的排序 SELECT ROW_NUMBER() OVER(partition by year(OrderDate),Month(OrderDate) order by orderdate) as rown... 阅读全文
摘要:
错误异常:Unable to update the EntitySet 'XXX' because it has a DefiningQuery and no <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation.解决方案在使用AdO.NET Entity Framework的时候,你可能会遇到这个问题,这个问题就是告诉你,你使用的“XXX”这张表在数据库没有定义主键,只要设置了主键,就不会 阅读全文
摘要:
using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Reflection; using System.Windows; using System.Windows.Controls; using System.Windows.Forms; using Mes... 阅读全文