There is already an open DataReader associated with this Command which must be closed first.

這個錯誤訊息常常發生在使用C#的datareader的時候使用同一個connection。

String currentcustomertb = ConfigurationManager.AppSettings["currentcustomertb"];
cmd.CommandText = "SELECT ip,mac FROM " + db +  ".dbo." + currentcustomertb;
SqlDataReader dr = cmd.ExecuteReader();

String replacecurrent = ConfigurationManager.AppSettings["replacecurrent"];

while (dr.Read())
{
 string ip = dr[0].ToString();
 string mac = dr[1].ToString();

 String execReplaceinto = "exec " + db + ".dbo." + replacecurrent + " @cmmac = '" + mac + "' , @cmip = '" + ip + "'";
 SqlCommand cmdexec = new SqlCommand(execReplaceinto, cn);
 cmdexec.ExecuteNonQuery();
 cmdexec.Dispose();
}

因為這個dr與內部的ExecuteNonQuery，所以就會出現這個錯誤訊息。所以有人建議使用不同的connection來避免這個問題。 或是在連線字串加入：MultipleActiveResultSets=True;

C# 字串切割小訣竅

通常C#字串切割大家都知道使用Split函數。 例如cr

 
string[] tokens = stringVariable.Split('\r');

那如果，可以試試以下的方法

 
stringVariable.Split(new string[] { "\r\n" }, StringSplitOptions.None);

SyntaxHighlighter Blogger 程式碼顯示外掛

SyntaxHighlighter 是一個簡單好用的外掛，但是要套用在Blogger不能使用html縮寫。

<link href='http://alexgorbatchev.com/pub/sh/current/styles/shCore.css' rel='stylesheet' type='text/css'/>

<link href='http://alexgorbatchev.com/pub/sh/current/styles/shThemeDefault.css' rel='stylesheet' type='text/css'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shCore.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushAS3.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushBash.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushColdFusion.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCSharp.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCpp.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCss.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushDelphi.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushDiff.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushErlang.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushGroovy.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushJScript.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushJava.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushJavaFX.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPerl.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPhp.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPlain.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPowerShell.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPython.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushRuby.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushScala.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushSql.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushVb.js' type='text/javascript'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushXml.js' type='text/javascript'/>

<script language='javascript'>

SyntaxHighlighter.config.bloggerMode = true;

SyntaxHighlighter.config.clipboardSwf = &#39;http://alexgorbatchev.com/pub/sh/current/scripts/clipboard.swf&#39;;

SyntaxHighlighter.all();

</script>