[LINQ]使用LINQ將Datatable轉成xml

使用LINQ將Datatable轉成xml

using System.Xml.Linq;


private string GetXmlByDt(DataTable dt)
{
XDocument Employee = new XDocument(new XDeclaration("1.0", "utf-8", "true"),
new XElement("MB1", from cust in dt.AsEnumerable()
select new XElement("A11", cust["No"]
)));

return Employee.ToString();
}


執行後結果如下

[SQL]在SQL裡下迴圈

想把另一個table的資料更新至此table裡，
用下迴圈的方式...目前想到比較好的解答就這樣了


declare @Start int
declare @End int
set @Start =1
set @End=3480
while (@Start < @End)
begin
update TABLE_A
set BirthDay =
(select BirthDay from TABLE_B where PtNo = @Start)
WHERE PtNo = @Start
set @Start=@Start +1
end

[C#]記錄程式執行時間

記錄程式執行時間
要先using System.Diagnostics;


using System.Diagnostics;
Stopwatch sw = new Stopwatch();
sw.Reset();
sw = Stopwatch.StartNew();
//要測時間的程式碼放這裡
sw.Stop();
TimeSpan e1 = sw.Elapsed;
long ms = sw.ElapsedMilliseconds;
MessageBox.Show(e1 + "秒 " + ms + "毫秒");