数据库连接字符串 ConnectionString

参考:https://www.devexpress.com/Support/Center/Question/Details/K18445/how-to-create-a-correct-connection-string-for-xpo-providers

AccessConnectionProvider: MSAccess
XpoProvider=MSAccess;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
DataSetDataStore: XmlDataSet
XpoProvider=XmlDataSet;Data Source=C:\mydatabase.xml;Read Only=false
InMemoryDataStore: InMemoryDataStore
XpoProvider=InMemoryDataStore;Data Source=C:\mydatabase.xml;Read Only=false
MSSqlConnectionProvider: MSSqlServer
XpoProvider=MSSqlServer;Data Source=(local);User ID=username;Password=password;Initial Catalog=database;Persist Security Info=true
AdvantageConnectionProvider: Advantage
XpoProvider=Advantage;Data Source=\myserver\myvolume\mypat\mydd.add;ServerType=local;User ID=ASSSYS;TrimTrailingSpaces=true
AsaConnectionProvider: Asa
XpoProvider=Asa;Uid=MyUsername;PWD=MyPassword;DBF=c:\mydatabase.db;Persist Security Info=true
AseConnectionPrvider: Ase
XpoProvider=Ase;Port=5000;Data Source=MyAseServer;User ID=MyUserName;Password=MyPassword;Initial Catalog=MyDatabase;Persist Security Info=true
DB2ConnectionProvider: DB2
XpoProvider=DB2;Server=MyAddress:MyPortNumber;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Persist Security Info=true
FirebirdConnectionProvider: Firebird
XpoProvider=Firebird;DataSource=localhost;User=SYSDBA;Password=masterkey;Database=MyDatabase.fdb;ServerType=0;Charset=NONE
MSSqlCEConnectionProvider: MSSqlServerCE
XpoProvider=MSSqlServerCE;Data Source=MyDatabase.sdf;Password=MyPassword
MySqlConnectionProvider: MySql
XpoProvider=MySql;Server=MyServerAddress;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Persist Security Info= true;Charset=utf8
ODPConnectionProvider: ODP
XpoProvider=ODP;Data Source=TORCL;User ID=MyUserName;Password=MyPassword
ODPManagedConnectionProvider: ODPManaged
XpoProvider=ODPManaged;Data Source=TORCL;User ID=MyUserName;Password=MyPassword
OracleConnectionProvider: Oracle
XpoProvider=Oracle;Data Source=TORCL;User ID=MyUserName;Password=MyPassword
PervasiveSqlConnectionProvider: Pervasive
XpoProvider=Pervasive;Server=MyServerAddress;UID=MyUserName;PWD=MyPassword;ServerDSN=MyDatabase
PostgreSqlConnectionProvider: Postgres
XpoProvider=Postgres;Server=127.0.0.1;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Encoding=UNICODE
SQLiteConnectionProvider: SQLite
XpoProvider=SQLite;Data Source=filename
VistaDBConnectionProvider: VistaDB
XpoProvider=VistaDB;Data Source=C:\mydatabase.vdb4
VistaDB5ConnectionProvider: VistaDB5
XpoProvider=VistaDB5;Data Source=C:\mydatabase.vdb5

laravel 笔记

1、blade 模板,模型关联为空值时,如何传值?

根据 $product->brand的值,显示对应名称

product.blade.php

productitem.blade.php

2、目录权限

在安装 Laravel 后,你可能需要配置一些权限。 storagebootstrap/cache 目录在你的 web 服务下应该是可写的权限,否则 Laravel 将无法运行。如果你用的是 Homestead 虚拟机,这些权限应该已经设置好了。

3、php 安装 fileInfo扩展


4、提示“The Mix manifest does not exist.”

参考:https://xueyuanjun.com/post/19944.html

检查 public目录下是否有mix-manifest.json 文件,没有的话,通过以下步骤生成

1)检查 node,npm是否正确安装。
2)运行 npm install,Windows系统运行 npm install --no-bin-links
3)运行 Mix,npm run production

Devexpress 笔记

GridView显示行号

Private Sub GridView1_CustomDrawRowIndicator(sender As Object, e As DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs) Handles GridView1.CustomDrawRowIndicator
     e.Info.DisplayText = e.RowHandle.ToString()
End Sub

 

CSS 笔记

引用外部CSS。注意是 href,不是src。

<link href=”img/divcss5.css” rel=”stylesheet” type=”text/css” />

float属性似乎对div更有效

<html>
    <head>
        <title>标题</title>
        <style type="text/css">
            body{
                padding:0px;
                margin:0px;
            }
            .container{
                position:relative;
                width:950px;
                margin-left:auto;
                margin-right:auto;
                height:100%;
                background-color:#FF0000;
            }
            .left{
                float:left;
                background-color:#DDD;
                width:80%;
                height:100px;
            }
            .right{
                float:right;
                background-color:#AAA;
                width:20%;
                height:100px;
            }
        </style>
    </head>
    <body>
        <div class="container">
            <div class="left">左边</div>
            <div class="right">右边</div>
        </div>
</body>
</html>

 

“清除”控件高亮色

-webkit-tap-highlight-color:rgba(0,0,0,0);