11 2012 档案

实现工厂模式下不同的数据库连接
摘要：首先是配置文件：其中的providerName就是指定的不同数据库类型<connectionStrings><addnameaddname="..."connectionString="..."providerName="System.Data.OleDb"/><addnameaddname="..."connectionString="..."providerName="System.Data.SqlClient"/></conne 阅读全文
posted @ 2012-11-20 20:59 yuloe2012 阅读(507) 评论(0) 推荐(0)
数据访问层的几种数据库连接方式
摘要：stringsql = "update Table1 set name = 'Pudding' where ID = '1'";//未采用SqlParameterSqlConnection conn = newSqlConnection();conn.ConnectionString = "Data Source=.\\SQLExpress;Integrated Security=true;AttachDbFilename=|DataDirectory|\\Database.mdf;User Instance=true"; 阅读全文
posted @ 2012-11-08 19:34 yuloe2012 阅读(334) 评论(0) 推荐(0)
sql server面试题
摘要：1.一道SQL语句面试题，关于groupby表内容：2005-05-09胜2005-05-09胜2005-05-09负2005-05-09负2005-05-10胜2005-05-10负2005-05-10负如果要生成下列结果,该如何写sql语句?胜负2005-05-09222005-05-1012------------------------------------------createtable#tmp(rqvarchar(10),shengfunchar(1))insertinto#tmpvalues('2005-05-09','胜')insertint 阅读全文
posted @ 2012-11-08 10:55 yuloe2012 阅读(382) 评论(0) 推荐(0)
连接字符串
摘要：<connectionStrings> <add name="ConnectionString"connectionString="server=.;database=bolgs;uid=sa;pwd=1"/> </connectionStrings> 阅读全文
posted @ 2012-11-04 20:01 yuloe2012 阅读(136) 评论(0) 推荐(0)
提交表单时验证
摘要：<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb23 阅读全文
posted @ 2012-11-02 10:09 yuloe2012 阅读(209) 评论(0) 推荐(0)