当前位置:首页 » 编程博文
开发技术指南» 文章正文
    引言:
 

 

    摘要:在实际编程工程中,常常遇到这样的情况:datatable并不是数据库中的,或者datatable尚未写到数据库,或者从数据库中读出的datatable已经在本地被改动,又没有写回数据库(可能还要作其他改动),在这些情况下,要查询datatable中的数据,强大的sql语言就派不上用场了。 有些.net程序员采取在数据库中建立临时表等方法来解决这类查询问题。而我觉得这种方法不可行,其实只要用.ne......
 ·cvs使用手册    »显示摘要«
    摘要:版权声明:可以任意转载,转载时请务必以超链接形式标明文章原始出处和作者信息及本声明http://www.chedong.com/tech/cvs_card.html 关键词:cvs cvsweb cvstrac wincvs cvsroot 内容摘要: cvs是一个c/s系统,多个开发人员通过一个中心版本控制系统来记录文件版本,从而达到保证文件同步的目的。工作模式如下: cvs服务器(文......


C#数据库连接字符大全
 sql server  odbc

【程序编程相关:DataSnap(MIDAS)三层架构编

【推荐阅读:用ActionMapping构建漂亮的S

 standard security: 【扩展信息:BCB和Delphi中Form的事件触发

"driver={sql server};server=aron1;database=pubs;uid=sa;pwd=asdasd;"

 trusted connection:

"driver={sql server};server=aron1;database=pubs;trusted_connection=yes;"

 prompt for username and password:

oconn.properties("prompt") = adpromptalways

oconn.open "driver={sql server};server=aron1;database=pubs;"

 ole db, oledbconnection (.net)

 standard security:

"provider=sqloledb;data source=aron1;initial catalog=pubs;user id=sa;password=asdasd;"

 trusted connection:

"provider=sqloledb;data source=aron1;initial catalog=pubs;integrated security=sspi;" (use servername\instancename as data source to use an specifik sqlserver instance, only sqlserver2000)  prompt for username and password:

oconn.provider = "sqloledb"

oconn.properties("prompt") = adpromptalways

oconn.open "data source=aron1;initial catalog=pubs;"

 connect via an ip address:

"provider=sqloledb;data source=190.190.200.100,1433;network library=dbmssocn;initial catalog=pubs;user id=sa;password=asdasd;" (dbmssocn=tcp/ip instead of named pipes, at the end of the data source is the port to use (1433 is the default))  sqlconnection (.net)

 standard security:

"data source=aron1;initial catalog=pubs;user id=sa;password=asdasd;"

   - or -

"server=aron1;database=pubs;user id=sa;password=asdasd;trusted_connection=false"

   (booth connection strings produces the same result)

 trusted connection:

"data source=aron1;initial catalog=pubs;integrated security=sspi;"

   - or -

"server=aron1;database=pubs;trusted_connection=true;"

   (booth connection strings produces the same result)

(use servername\instancename as data source to use an specifik sqlserver instance, only sqlserver2000)  connect via an ip address:

"data source=190.190.200.100,1433;network library=dbmssocn;initial catalog=pubs;user id=sa;password=asdasd;" (dbmssocn=tcp/ip instead of named pipes, at the end of the data source is the port to use (1433 is the default))  declare the sqlconnection:

c#:

using system.data.sqlclient;

sqlconnection osqlconn = new sqlconnection();

osqlconn.connectionstring="my connectionstring";

osqlconn.open();

vb.net:

imports system.data.sqlclient

dim osqlconn as sqlconnection = new sqlconnection()

osqlconn.connectionstring="my connectionstring"

osqlconn.open()

 data shape

 ms data shape


...   下一页
 ·如何配置apache    »显示摘要«
    摘要:? 1. 修改httpd.conf文件中的参数设定(相当于web共享) (sun) /etc/apache/httpd.conf (hp) /opt/apache/httpd.conf 设置documenroot,alias和scriptalias 修改参数配置之后需要重起apache。 重起的文件名和路径: (sun) /usr/apache/bin (hp) /opt/apa......
» 本期热门文章:

©2000-2007 All Rights Reserved. 最佳浏览:1024X768 MSIE