Thu, 26 Feb 2009 11:09:00 GMThttp://blog.csdn.net/greatbag/http://blog.csdn.net/greatbag/archive/2009/02/26/3938642.aspxhttp://blog.csdn.net/greatbag/comments/3938642.aspx0http://blog.csdn.net/greatbag/comments/commentRss/3938642.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3938642<br />先到看一段代码 <br /><br />declare @a varchar(2000)<br />declare @b varchar(2000)<br />set @a='aa'<br />set @b=null<br />select @a+@b<br /><br />得到的结果是什么呢?结果大出意料,竟然是NULL!<br />在SQL中任何字符串跟NULL相加最终的结果是NULL,以后写SQL的时候要小心啦<img src ="http://blog.csdn.net/greatbag/aggbug/3938642.aspx" width = "1" height = "1" />Thu, 26 Feb 2009 19:09:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2009/02/26/3938642.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2009/02/26/3938642.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2009/02/12/3881235.aspxhttp://blog.csdn.net/greatbag/comments/3881235.aspx0http://blog.csdn.net/greatbag/comments/commentRss/3881235.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3881235Download source - 35.63 KBIntroduction<br />I am a huge fan of LINQ to SQL feature of the .NET Framework 3.5. If you don't know what LINQ to SQL is, please read the white paper here.<br />I like the way in which it makes database coding simple and easy. Developers do not have to use different programming models (CLR functions and SQL Stored Procedures) and switch between different programming languages (C#/VB.NET and T-SQL). LINQ to SQL designer in Visual Studio 2008 also makes our life even eas<img src ="http://blog.csdn.net/greatbag/aggbug/3881235.aspx" width = "1" height = "1" />Thu, 12 Feb 2009 20:37:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2009/02/12/3881235.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2009/02/12/3881235.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2008/12/21/3576538.aspxhttp://blog.csdn.net/greatbag/comments/3576538.aspx0http://blog.csdn.net/greatbag/comments/commentRss/3576538.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3576538<br />EntitySet)>) 成员<br />为 LINQ to SQL 应用程序中的一对多关系和一对一关系的集合方提供延迟加载和关系维护。 <br /><br /> LINQ to SQL 会自动跟踪EntitySet)>) 的状态<br /><br /><br />Untracked<br />LINQ to SQL 未跟踪的对象。示例包括：<br />未通过当前 DataContext 查询的对象（例如新创建的对象）。<br />通过反序列化创建的对象<br />通过其他 DataContext 查询的对象。<br />Unchanged<br />通过使用当前 DataContext 检索到的对象，并且尚未获知此对象自创建以来已被修改。<br />PossiblyModified<br />附加到 DataContext 的对象。有关更多信息，请参见 N 层应用程序中的数据检索和 CUD 操作 (LINQ to SQL)。<br />ToBeInserted<br />使用当前 DataContext 未检<img src ="http://blog.csdn.net/greatbag/aggbug/3576538.aspx" width = "1" height = "1" />Mon, 22 Dec 2008 06:53:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2008/12/21/3576538.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2008/12/21/3576538.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2008/12/15/3520958.aspxhttp://blog.csdn.net/greatbag/comments/3520958.aspx0http://blog.csdn.net/greatbag/comments/commentRss/3520958.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3520958<br />最近遇到带法文,德文等CSV上传到服务上读取乱码的问题<br /><br />解决办法如下:<br />  protected void btnUpload_Click(object sender, EventArgs e)    {        if (upExcel.HasFile)        {            string ext = Path.GetExtension(upExcel.FileName);            string saveFolder = Global.UploadTempFolder;            string fileName = Guid.NewGuid().ToString("N") + ext;            string savePath = saveFolder + fileName;            if (!Directory.Exists(saveFolder))                Directory.CreateDirectory(saveFolder);     <img src ="http://blog.csdn.net/greatbag/aggbug/3520958.aspx" width = "1" height = "1" />Mon, 15 Dec 2008 22:05:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2008/12/15/3520958.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2008/12/15/3520958.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2008/11/10/3265489.aspxhttp://blog.csdn.net/greatbag/comments/3265489.aspx0http://blog.csdn.net/greatbag/comments/commentRss/3265489.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3265489适用场景：分组数据，为我们查找数据缩小范围。说明：分配并返回对传入参数进行分组操作后的可枚举对象。分组；延迟1.简单形式：var q = from p in db.Products group p by p.CategoryID into g select g;说明：from p in db.Products 表示从表中将产品对象取出来。group p by p.CategoryID into g表示对p按CategoryID字段归类。其结果命名为g，一旦重新命名，p的作用域就结束了，所以，最后select时，只能select g。当然，也不必重新命名可以这样写：var q = from p in db.Products group p by p.CategoryID;如果想遍历某类别中所有记录，这样：foreach (var gp in q){ if (gp.Key == 2) { foreach (var item in gp)<img src ="http://blog.csdn.net/greatbag/aggbug/3265489.aspx" width = "1" height = "1" />Mon, 10 Nov 2008 18:18:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2008/11/10/3265489.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2008/11/10/3265489.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2008/08/18/2790017.aspxhttp://blog.csdn.net/greatbag/comments/2790017.aspx0http://blog.csdn.net/greatbag/comments/commentRss/2790017.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2790017<P>第一次发现ajax3.5也没那么容易配置的 - -</P><P>&nbsp;</P><P>首先是版本冲突:</P><P><STRONG>编译器错误信息: </STRONG><FONT face=Arial>CS0433: The type 'System.Web.UI.ScriptManager' exists in both 'c:\WINDOWS\assembly\GAC_MSIL\System.Web.Extensions\1.0.61025.0__31bf3856ad364e35\System.Web.Extensions.dll' and 'c:\WINDOWS\assembly\GAC_MSIL\System.Web.Extensions\3.5.0.0__31bf3856ad<img src ="http://blog.csdn.net/greatbag/aggbug/2790017.aspx" width = "1" height = "1" />Mon, 18 Aug 2008 23:12:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2008/08/18/2790017.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2008/08/18/2790017.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2008/05/24/2475665.aspxhttp://blog.csdn.net/greatbag/comments/2475665.aspx0http://blog.csdn.net/greatbag/comments/commentRss/2475665.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2475665SQL&nbsp;&nbsp;&nbsp; Server2005可以使用系统存储过程sp_changeobjectowner更改数据库对象的所有者。&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sp_changeobjectowner&nbsp;&nbsp;&nbsp; '对象名(包括架构名)','新架构名'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 批量修改请用：&nbsp;&nbsp;&nbsp;&nbsp;&am<img src ="http://blog.csdn.net/greatbag/aggbug/2475665.aspx" width = "1" height = "1" />Sat, 24 May 2008 08:30:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2008/05/24/2475665.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2008/05/24/2475665.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2008/02/28/2127377.aspxhttp://blog.csdn.net/greatbag/comments/2127377.aspx0http://blog.csdn.net/greatbag/comments/commentRss/2127377.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2127377全文索引——CONTAINS 语法 我们通常在 WHERE 子句中使用 CONTAINS ，就象这样：SELECT * FROM table_name WHERE CONTAINS(fullText_column,'search contents')。 <img src ="http://blog.csdn.net/greatbag/aggbug/2127377.aspx" width = "1" height = "1" />Thu, 28 Feb 2008 19:52:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2008/02/28/2127377.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2008/02/28/2127377.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2008/01/17/2049518.aspxhttp://blog.csdn.net/greatbag/comments/2049518.aspx0http://blog.csdn.net/greatbag/comments/commentRss/2049518.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2049518.net framework开源啦<img src ="http://blog.csdn.net/greatbag/aggbug/2049518.aspx" width = "1" height = "1" />Fri, 18 Jan 2008 00:14:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2008/01/17/2049518.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2008/01/17/2049518.aspxgreatbaghttp://blog.csdn.net/greatbag/archive/2007/12/12/1932206.aspxhttp://blog.csdn.net/greatbag/comments/1932206.aspx0http://blog.csdn.net/greatbag/comments/commentRss/1932206.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1932206ASP.NET 2.0 页面事件执行顺序<img src ="http://blog.csdn.net/greatbag/aggbug/1932206.aspx" width = "1" height = "1" />Thu, 13 Dec 2007 07:28:00 +0800greatbaghttp://blog.csdn.net/greatbag/archive/2007/12/12/1932206.aspx#Feedbackhttp://blog.csdn.net/greatbag/archive/2007/12/12/1932206.aspxgreatbag