Everyone Has Problems

One may use XmlTextWriter (XmlTextReader) to write to (read from) an XML file. In .NET Framework 2.0, the recommended practice is to create XmlWriter instances using the System.Xml.XmlWriter.Create method and the XmlWriterSettings class. The reason of the replacement can be found in http://msdn2.microsoft.com/en-us/library/system.xml.xmltextwriter.aspx.
However, it is hard to read and write to an XML file at the same time. Thus in order to read and write a configuration XML file, one needs to use ConfigurationManager class that allows you to access machine, application, and user configuration information, such as “app.config”. The class allows you to read/write the configuration file at the same time. While using OpenExeConfiguration to open a configuration file, an issue about using mock .exe file is discussed in http://msdn2.microsoft.com/en-us/library/ms224437.aspx. To access configuration information, call the GetSection method, for example “TestConfigurationSection testSettingSection = (TestConfigurationSection)testConfig.GetSection(“microsoft.visualstudio.testtools”);”. If you want to update the file, use “testConfig.Save(ConfigurationSaveMode.Modified);”. Please note that Microsoft.VisualStudio.TestTools.UnitTesting namespace provides a TestConfigurationSection type. A good reference on this topic can be found at http://www.codeproject.com/csharp/ReadWriteXmlIni.asp.

To access data in a database, you can use ADO.NET. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. It provides 3 types of data access objects for MS SQL Server, OLD DB and ODBC. The ADO.NET architecture can be found in http://msdn2.microsoft.com/en-us/library/27y4ybxw(VS.80).aspx.

After establishing a connection to a data source, you can choose one of 3 methods to retrieve data: using Command, using DataReader or DataAdapter. However, if want to modify data in the database, you have to use DataAdapter or Command with DataSet objects. You can find some help from: http://msdn2.microsoft.com/en-us/library/ms254950(VS.80).aspx. And here is an example on how to implement a DataSet CREATE TABLE helper class in C# .NET: http://support.microsoft.com/kb/325938.

If using Access database, when creating a new table using SQL statement, [IF NOT EXISTS] doesn’t work. Also a new Microsoft Jet data type is introduced in http://support.microsoft.com/kb/q275561/.

When renaming a data table, Access doesn’t support “RENAME TABLE old_table_name TO new_table_name”. Instead you have to do this way: “SELECT * INTO new_table_name FROM old_table_name”, then “DROP TABLE old_table_name”.

Here is a great tutorial on how to save embedded multimedia files using Firefox: http://inner.geek.nz/archives/2005/05/15/howto-save-nearly-any-multimedia-file-in-your-web-browser-to-your-hard-drive/. However, it doesn’t work for streaming multimedia files.

In order to rip streaming audio or video files, you definitely need help from some tools, such as: StreamBox VCR. Here is a good website where you can find almost all the information on this topic: http://all-streaming-media.com/faq/

However, some streaming media is encrpted, and cannot be recorded, even with the tools mentioned before. If anyone can record this: mms://windows.stream.yorku.ca/mediaserverupload/c93b67ef-f26b-4850-8e9f-2da37091519d.wmv, PLEASE LET ME KNOW! Thanks in advance!

I have a MSSQL 2005 database backup file done by SQL-Server Management Studio. In order to restore it into MSSQL 2005 Express, I have to first restore it into MSSQL 2005, and then “export data” to MSSQL 2005 Express.

When restoring database using SQL-Server Management Studio Express, it is required the file path to the database is the same as on the original machine where you backup the database. However, you can modify that in the “options” page when restoring a database.

Please refer to http://msdn2.microsoft.com/en-us/library/ms404700(VS.80).aspx for troubleshooting data-driven unit tests.

In summary, one may need to take extra care of these points:
1. Access 2007 database file may stop working after a while – I don’t know the exact reason (maybe driver’s problem). Converting to Access 2000-2003 is safe.
2. In connection string, an absolute path to the database file is required. I haven’t figured out how to use relative path in writing connection strings.
3. Using the App.config file to specify a data source for your test is a better way (please refer to http://msdn2.microsoft.com/en-us/library/ms243192(VS.80).aspx). This lets you change data-source attributes, such as the server, table name, and so on, without recompiling the test assembly.
4. When the data-driven test runs, Unit Test Adapter connects to your data table and builds a list of data rows. Then for each row it executes the methods TestInitialize, TestMethod, and TestCleanup. If you change data rows in TestInitialize, the Unit Test Adapter will not see that change. Therefore, if you want to change your data table for a data driven test, do so in the ClassInitialize or AssemblyInitialize method.

Extraction rules are used to extract a value from a response and which can then be used in another request. This is useful if you have some dynamic data that changes for each iteration of a webtest. You can use an extraction rule to pull this value from one response and then bind it to another request. Check out this help link for more info: http://msdn2.microsoft.com/en-us/library/ms404703.aspx

The context parameter name is the name that the extracted value will be stored in the context with. The match attribute name is used to determine which tag to extract the value from. So if you page has 5 anchor tags and you want to extract the href value from one of the tags, you need a way to indicate which of the tags you actually want to pull from, For example, to extract href from the following I would use:

<a id=”Menu1_MyList__ctl1_HyperLink1″ class=”MenuUnselected” href=”productslist.aspx?CategoryID=15&selection=1″ mce_href=”productslist.aspx?CategoryID=15&selection=1″>

Tag Name: a
Attribute Name: href
Match Attribute Name: id
Match Attribute Value: Menu1_MyList__ctl1_HyperLink1
Context Parameter Name: ExtractedHref

Now if my page has multiple anchor tags, it will look for the one the id that I specified. Once the value is extracted, I can reference it by the context parameter name, which in this case is ExtractedHref.

The NUnit testing framework has an executing process shown as the following diagram. The point of having a separate setup and teardown for a suite of tests is primarily for performance reasons – repeatedly setting up and tearing down objects for each method is much less efficient than setting up and tearing down once, for a collection of objects.

In Microsoft VSTS testing framework, it has a similar executing process. However, the annotations have been changed as follows:

When applying data-driven testing, DataSource attribute seems not working for ClassInitialize method. This is because ClassInitialize method is a static method that gets called once when the code for the test is first loaded. If DataSource attribute is put with TestInitialize, it will force every test method to be driven by this data source. Thus it is recommended that DataSource attribute is with [TestMethod]. With private initialization methods, it is flexible for each test method to have their own initializing code.

Here is a good source: http://blogs.msdn.com/nnaderi/archive/2007/02/17/explaining-execution-order.aspx , which talks about 3 specific things which often confuse users of MSTest:

1. ClassInitialize and ClassCleanup: Since ClassInitialize and ClassCleanUp are static, they are only executed once even though several instances of a test class can be created by MSTest.  ClassInitialize executes in the instance of the test class corresponding to the first test method in the test class. Similarly, MSTest executes ClassCleanUp in the instance of the test class corresponding to the last test method in the test class.
2. Execution Interleaving: Since each instance of the test class is instantiated separately on a different thread, there are no guarantees regarding the order of execution of unit tests in a single class, or across classes. The execution of tests may be interleaved across classes, and potentially even assemblies, depending on how you chose to execute your tests. The key thing here is – all tests could be executed in any order, it is totally undefined.
3. TextContext Instances: TestContexts are different for each test method, with no sharing between test methods.

1. Insert audio files
   You can easily insert an audio file into PowerPoint by clicking “insert -> movie and sound -> sound from file”. This allows you to link an external audio file inside a slide. Thus when transferring slides to another computer, you need to copy the audio file as well keeping at the same location with the slides.In order to embed an audio file within a slide, you need to do two things:
   a) click “tools -> options -> general tab”, change the “link sounds with file size greater than xxx kb” and make it bigger (maximum 50M);
   b) convert the audio file into .wav format. You will get a huge file, however, you still can use Microsoft compressed wav file format to get a fairly small wav file. Then embed it into your slides. Done!
2. Insert video files
   Remember, video files cannot be embedded, but always linked.
   PowerPoint can only handle avi/mpeg/wmv/asf files as Windows Media Player can handle. If you want to insert a video file from YouTube(http://www.youtube.com), You need to follow the following steps:
   a) download the .flv file from YouTube by using online downloader website: www.youtubex.com;
   b) convert .flv file to .avi/.mpeg/.asf by using SUPER (http://www.erightsoft.com/SUPER.html#Dnload). I suggest you convert it to .mpg (MPEG-I) or .asf formats, because the converted video can be easily inserted into PowerPoint. Avi format is a bit tricky since it uses MPEG-4 codec. Powerpoint cannot play it if the codec is absent, and you cannot guarantee another computer will have the codec installed.
   c) if converting .flv to .swf (still using SUPER), you need to insert an shockwave flash object from the control toolbox toolbar. Then you can specify the path of the .swf file in the properties dialog box, and change “EmbedMovie” to “true” if you want the flash movie embedded.

1. 番茄炒饭便当

材料：
白饭 1碗
小黄瓜丁 1/2条
蛋 1个
综合豆 2大匙
烧肉丁 1/4杯
葱花 1大匙
香蕉 1/2根
茶冻粉 20公克
布丁模 1只
水 100㏄
腌料：
蕃茄酱 2大匙
盐 1小匙
盐水 少许
糖 2小匙
香油 1小匙
作法：
(1)起油锅，蛋先打散，入锅炒散到熟，再依序放入小黄瓜、青豆及红烧肉，略炒后把白饭倒入炒匀，再倒蕃茄酱及少许盐拌炒一下起锅放入便当中。
(2)香蕉半根切片，用盐水淋过即可将水份滤乾放入便当隔层中。
(3)茶冻作法，先将水加热煮沸后倒入茶冻粉，搅拌均匀后再稍煮沸，立即熄火，倒入模型杯中，冷却后即可成为茶冻，再放入冰箱冷藏。

2. 珍珠丸便当

材料：
四季豆 15条
绞肉 1大匙
长糯米 1/3杯
猪绞肉 1/2杯
虾米 1/2大匙
腌料：
(1)酱油 1/2大匙
豆瓣酱 1小匙
糖 1小匙
香油 1/2小匙
蒜泥 1小匙
(2)盐 1/2小匙
胡椒粉 1/2小匙
香油 1小匙
葱花 1大匙
糖 1/2小匙
太白粉 1小匙
作法：
(1)先将四季豆洗净并沥乾水份，起油锅炸至扁软即起锅，再以少许油加绞肉及调味料(1)略炒拌均匀，即可放入便当中。
(2)要做珍珠丸子之前，要先将长糯米洗净泡水约4小时，后沥乾水份备用。
(3)虾米用水泡过至软，取出剁碎，再与猪绞肉及调味料(2)拌匀，搓成小圆球，再滚上泡好的糯米。
(4)蒸?#092;\水加热后，盘子先涂上少许油，再放入珍珠丸子，加盖蒸约20分钟，至熟就可放入便当中，这样就大功告成了。

3. 滑蛋虾仁便当

材料：
虾仁 10尾
蛋 1/2个
综合豆 少许
青豆 少许
甜黑豆 酌量
蘑菇 3朵
白饭 1碗
腌料：
(1)盐 1/3小匙
太白粉水 1小匙
香油 1/3小匙
白胡椒粉 1/3小匙
糖 1/2小匙
蒜末 1/2小匙
(2)盐 1/3小匙
糖 1/3小匙
香油 1/2小匙
蒜末 1/2小匙
作法：
(1)起油锅将虾仁爆炒一下，再加入综合豆拌炒，以调味料(1)调味芶芡后，再打入半颗蛋，烩一下即可熄火盛起。
(2)将青豆、蘑菇用少许油加热拌炒，加入调味料(2)炒至熟即可盛起，放入便当。
(3)於另一层便当将白饭铺平，再放上甜黑豆即大功告成了。

4. 鳗鱼饭便当

材料：
(1)鳗鱼 1片(8公分宽)
蜂蜜 1小匙
黑芝麻 适量
(2)豆芽菜 1/2杯
红萝卜丝 少许
蒜末 1小匙
(3)茄子 1//2条
葱末 1/2大匙
辣椒 1小匙
蒜末 1小匙
(4)白饭 1碗
黑甜豆 少许
调味料：
鳗鱼腌料：黄砂糖 1/2大匙
酱油 1/2大匙
姜汁、米酒 各1小匙
腌料：
盐 1/3小匙
香油 1/2小匙
糖 1/2小匙
蒜末 1小匙
作法：
(1)将鳗鱼洗净，用刀面略刺几刀，再加入腌料腌20分钟使其入味。(腌汁留著，炒茄子时用)。
(2)将鳗鱼放入烤箱约200℃烤6～8分钟，取出后刷上蜂蜜汁，再撒上黑芝麻，放在白饭上，烤时如有余下酱汁，可以在此时淋上即可，最后在白饭上装饰黑甜豆即完成。
(3)将蒜末爆香，再放入豆芽菜及红萝卜丝略炒后，再加入调味料炒均匀即可熄火盛入便当隔层的一边。
(4)茄子切成约1公分段，用热油炸熟到茄子软化，捞起将油滤乾，再加入葱末、辣椒、蒜末及腌鳗鱼的酱汁，一起炒熟入味至沸且汁收乾，即可盛起放入便当中，这个便当就完成了。

5. 白菜卷便当

材料：
(1)大白菜 2叶
四季豆 4条
红萝卜 1段
(2)海蜇皮丝 2大匙
红萝卜丝 1大匙
白萝卜丝 1/2大匙
小黄瓜丝 1/2大匙
(3)鸭赏 1/2杯
青蒜 3片
(4)白饭 1碗
青豆 1颗
腌料：
(1)盐 1小匙
(2)香油 1小匙
糖 1小匙
蒜泥 1小匙
(3)香油 1小匙
糖 1/2小匙
作法：
(1)将所有菜洗净切好备用，大白菜不切，整叶用热水加1小匙盐川烫至软后，同时放入材料(1)的四季豆和萝卜川烫至熟，起锅冲冷水至凉，再沥乾水份。
(2)铺平大白菜，在叶子厚叶茎部放入烫熟的蔬菜，卷起，压密紧合，再用刀切成4等份，立起放入便当内即可(菜卷内要放任何食物均可以，依照以上步骤即可)。
(3)海蜇皮用清水多洗几次，因为其内藏有盐分及沙子，洗好后，将水份压乾，再将材料(2)及调味料(2)一起拌匀即可放入便当内。
(4)将鸭赏切片与青蒜同炒，并加入调味料(3)拌炒均匀，即可放入便当内(不须加盐)。
(5)将饭盛入蛋糕模型(或布丁盒)，再倒扣入便当中，上面放一颗青豆装饰，就大功告成了。

6. 黑胡椒猪肉便当

材料：
猪肉片 2两
红萝卜片、四季豆 各少许
芥兰菜 1/3株
红豆枝 2大匙
白饭 1碗
黑芝麻 少许
腌料：
(1)酱油 2小匙
糖 1小匙
粗黑胡椒 1大匙
香油 1小匙
蒜泥 1/2小匙
盐 1/2小匙
香油 1小匙
米酒 1小匙
(2)盐 1/2小匙
香油 1小匙
米酒 1小匙
(3)太白粉 1小匙
水 1/2大匙
作法：
(1)将猪肉片与调味料(1)一起略炒至熟后，再加入调味料(3)芶芡即可盛起放便当。
(2)将芥兰菜洗净切段，起油锅，以热油将芥兰菜略炒至软，再放入调味料(2)炒至熟后，即可盛起放入便当(汤汁去除不要加入)。
(3)再将红豆枝放入便当中。
(4)白饭铺平上面装饰红豆枝及黑芝麻即成。

7. 烤鸡腿便当

材料：
鸡腿 1只
小蕃茄 5粒
小黄瓜 1/3条(切丁)
蛋 1/2个(切丁)
白饭 1碗
绿海苔丝 少许
调味料：
酱油 1/2大匙
胡椒粉 1/2小匙
香油 1小匙
腌料：
烤肉酱 1大匙
盐 1/3小匙
糖 1/2小匙
香油 1/3小匙
作法：
(1)将鸡腿洗净擦乾，肉表面用尖刀划2刀，再用腌料均匀涂抹在上面。
(2)腌好的鸡腿先用热油炸3分熟，快速捞起沥乾，再将整只涂上烤肉酱，在炭上烘烤，中间需不停重覆涂上烤肉酱。(也可以整只鸡腿放入烤箱烘烤至熟)。
(3)将白饭铺平在便当中；蛋煎成蛋皮再切丁，加上蕃茄黄瓜一起略炒后盛起放在白饭上。
(4)烤过的鸡腿切块后，排放在白饭上，於便当边装饰绿海苔丝，即大功告成了。

8. 排骨饭便当

材料：
猪排 1片(里肌肉约1公分厚)
芥兰菜 1株
茄子 1/2条
葱花 1/2大匙
辣椒 少许
白饭 1碗
黑胡椒粒 少许
调味料：
味噌 1/2大匙
酱油 1/2大匙
酒 1/2大匙
糖 1/3大匙
香油 1小匙
腌料：
(1)盐 1/2小匙
米酒 2小匙
糖 1/2小匙
油 1/3大匙
(2)酱油 1/3大匙
香油 1小匙
糖 1小匙
作法：
(1)先将猪排肉用肉鎚拍松，以腌料腌渍约10分钟左右。
(2)再用1大匙油热锅煎猪排，将两面煎成金黄色熟透，取出切片备用。
(3)将芥兰菜洗净切段，与调味料(1)一起翻炒至熟，起锅放入便当中，上面排放煎好之排骨片，再撒上黑胡椒粒即可。
(4)将茄子洗净切段，用热油炸熟，捞起后沥乾余油，再与调味料(2)一起拌均匀，放入隔层便当中即可。

9. 烤虾便当

材料：
草虾 2尾
油豆腐 2个
豆芽菜 1/3杯
小黄瓜 1/4条
青江菜 少许(切碎)
白饭 1碗
腌料：
(1)酱油膏 1/2大匙
胡椒粉 1/2小匙
蒜泥 1/2小匙
(2)酱油 1小匙
糖 1小匙
香油 1/2小匙
(3)蒜泥 1/2小匙
辣椒 1/2小匙
盐 1/3小匙
香油 1/3小匙
(4)盐 1/2小匙
糖 1/2小匙
作法：
(1)将所有蔬菜洗净切好备用。
(2)草虾去背砂，以调味料(1)腌15分钟，用150℃的烤箱烤6～8分钟即可，与小黄瓜片一起排入便当中。
(3)油豆腐炸至金黄色，取出切片，加入调味料(2)拌匀即可。
(4)豆芽菜用少许油，再加入调味料(3)略炒一下即可放入便当内。
(5)将白饭加上切细的青江菜及调味料(4)拌匀，放入微波炉加热2～3分钟，取出，放入便当中铺平就大功告成了

10. 三色蛋餐盒便当
材料：
蛋 3个
香肠 3条
韭菜(切段) 少许
黃果、青豆 各少許
白饭 1碗
芋头丸子 1个
辣罗卜干 2条
盐 糖 适量
芥末醬 1/2小匙
蕃茄醬 2小匙
胡椒粉 1/2小匙
香油

做法：
(1) 先将菜洗净分别切好备用，将香肠煎熟备用。
(2) 蛋分成三份，先用2个蛋白加入盐糖适量拌匀，煎成白色蛋皮；用2个蛋黄加芥末酱、糖拌匀，煎成黄色蛋皮；将1个全蛋加入蕃茄酱 胡椒粉拌匀，煎成橘红色蛋皮，最后三种蛋皮各包入1条香肠，再切成3等份，以上材料再依序排入餐盒中。
(3) 将韭菜洗净切成小段，用少许油加热与盐 香油一起略炒至熟，即可盛在放入餐盒中。
(4) 将黄果及青豆用水煮沸，加盐调味即成。
(5) 将白饭铺平，中间放上芋头丸子，在丸子两边摆上辣萝卜干即完成了。

Taken from http://www.sinoarch.cn/forum/viewthread.php?tid=1153

***北京、上海、天津、重庆***
mms://202.108.248.145/am603 北京电台首都生活
mms://202.108.248.145/fm974 北京电台音乐广播
mms://202.108.248.145/am774 北京电台外语广播
mms://202.108.248.145/fm1006 北京电台新闻广播
mms://202.108.248.145/am927 北京电台体育广播
mms://202.108.248.145/fm1039 北京电台交通广播
mms://202.108.248.145/fm1073 北京电台经济广播
mms://listen1.bjradio.com.cn/cfm986 北京电台古典音乐
mms://alive.bjradio.com.cn/fm1073 北京电台城市管理
mms://listen1.bjradio.com.cn/cfm1043 北京电台文学影视
mms://listen1.bjradio.com.cn/cfm970 北京电台通俗音乐
mms://listen1.bjradio.com.cn/cfm994 北京电台北京教学
mms://alive.bjradio.com.cn/fm876 北京电台文艺广播
mms://listen1.bjradio.com.cn/cfm1051 北京电台戏曲曲艺
mms://listen1.bjradio.com.cn/cfm1065 北京电台亚洲流行
mms://listen1.bjradio.com.cn/cfm1075 北京电台轻音乐
mms://listen1.bjradio.com.cn/DAB 北京电台 DAB广播
http://www.stv.sh.cn/classic.asx 上海人民广播电台经典947
http://www.stv.sh.cn/103.asx 上海人民广播电台魅力音乐103
http://www.stv.sh.cn/990.asx 上海人民广播电台新闻频率
http://www.stv.sh.cn/648.asx 上海人民广播电台交通频率
http://www.stv.sh.cn/1045.asx 上海人民广播电台东广新闻
http://www.stv.sh.cn/792.asx 上海人民广播电台都市792
http://www.stv.sh.cn/popmusic.asx 上海人民广播电台动感101
http://www.stv.sh.cn/977.asx 上海人民广播电台第一财经
http://www.stv.sh.cn/977.asx 上海人民广播电台开心调频
http://www.stv.sh.cn/1197.asx 上海人民广播电台海上戏剧
mms://218.1.74.225/940 上海人民广播电台体育频率
mms://61.136.19.228/live1 天津广播电台新闻频道
mms://61.136.19.228/live2 天津广播电台音乐频道
mms://61.136.19.228/live3 天津广播电台经济频道
mms://61.136.19.228/live4 天津广播电台文艺频道
mms://61.136.19.228/live5 天津广播电台交通频道
mms://61.136.19.228/live6 天津广播电台生活频道
mms://61.136.19.228/live7 天津广播电台滨海频道
mms://61.136.19.228/live9 天津广播电台古典音乐频道
mms://211.158.10.48/fm881 重庆音乐广播电台***香港、台湾、澳门***
mms://210.59.227.130/heart32k 台北真心之音电台
mms://202.177.192.108/radio5 香港电台第5台
mms://202.177.192.108/radio2 香港电台第2台
mms://202.177.192.108/radio1 香港电台第1台
mms://202.177.192.108/radio3 香港电台第3台（英语）
mms://202.177.192.108/radio4 香港电台第4台（英语）
rtsp://www.am873.net/encoder/news 海峡之声新闻时政频道
http://metromedia.104metrofinance.com/LiveAM1044 新城采讯台（英语）
mms://203.129.68.232/fmselect 新城财经台104
mms://203.129.68.232/hit997 新城娱乐台
mms://202.177.192.223/cr1 香港商业电台一台雷霆881
mms://202.177.192.223/cr2 香港商业电台二台叱吒903
mms://203.187.31.160/khkiss KISSRADIO
mms://203.187.31.160/fm917 台北之音音乐电台
mms://203.187.31.160/fm1077 台北之音都会台
mms://media.family977.com.tw/live 台湾好家庭电台
mms://61.218.197.178:8080 台湾云嘉广播电台
mms://media.iwant-in.net/pop 台湾银河流行音乐台
mms://61.220.226.218:8080 台湾桃园广播电台
mms://61.221.98.46:8080 台湾省都广播电台
mms://203.71.144.133:8080 教育广播-台东台
mms://203.71.142.50:1029 教育广播-高雄台
mms://220.132.146.146:8080 新竹劳工之声客家电台
mms://202.175.80.10/liveaudio 澳门电台