itneeds4u.blogspot.com

kennyshu.blogspot.com

Kenny Hsu's Blog: 2013.01

http://kennyshu.blogspot.com/2013_01_01_archive.html

My Net programming notes. DBF quick query tool. I created a simple tool for querying *.dbf files. Two ways to query *.dbf:. 1Free table directory (No *.dbc) (OleDb). Connection string will be like this:. Provider=vfpoledb;Data Source=C: temp WLAB32 ;Collating Sequence=machine;. 2Database container (.DBC). Connection string will be like this:. SourceDB=C: YourPath YourDbName.DBC;DRIVER={Microsoft Visual FoxPro Driver};SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes.

kennyshu.blogspot.com

Kenny Hsu's Blog: 2012.11

http://kennyshu.blogspot.com/2012_11_01_archive.html

My Net programming notes. Delete a specific DataRow from the DataTable. DataTable dt = BusinessLogic.GetTable(sqlCmd); dt.Rows.Remove(dt.Select("ColumnName1 = '12345' and ColumnName2 = '67890'")[0]); dt.AcceptChanges();. Blog uses new SyntaxHighlighter. I changed to use the latest SyntaxHighlighter. Recently and found that it causes many posts unreadable. If you found any post that you want to read is unreadable, please leave a message here. I will fix it ASAP. Subscribe to: Posts (Atom).

kennyshu.blogspot.com

Kenny Hsu's Blog: Convert xml to table in SQL 2005

http://kennyshu.blogspot.com/2007/12/convert-xml-file-to-table-in-sql-2005.html

My Net programming notes. Convert xml to table in SQL 2005. This is how I convert XML string into a Table in SQL 2005:. Tag： SQL 2005. Many thanks Kenny - I have been floundering with this for ages as have obviously many others. I spent time on this as well long time ago, and that's why I put it here so it can save others time on this. I am glad that I can help. :). Thank you Keeny Hsu.Good Work :). Thanx kenny,I happened to see ur blog while I was blogging for some other Info. Great keep up good work.

kennyshu.blogspot.com

Kenny Hsu's Blog: 2013.03

http://kennyshu.blogspot.com/2013_03_01_archive.html

My Net programming notes. Make Oracle Instant Client work. I installed Oracle Instant Client like others did, extract it at a folder, add the folder to path, change the folder's privilege, add some roles to that folder and have fully access. etc. None of them works. So the ultimate way to make it work that I found is:. Copy the following two files to your application folder " oci.dll. And it will work. At least it works for me in my case. C#] Dynamically load assembly (dll). Subscribe to: Posts (Atom).

kennyshu.blogspot.com

Kenny Hsu's Blog: 2015.08

http://kennyshu.blogspot.com/2015_08_01_archive.html

My Net programming notes. Add Tooltip to Html helpers. Use the "title" attribute to the html helper. For example:. HtmlCheckBoxFor(m = m.ForTest, new { title = "測試". Apply Enum onto @Html.DropDownListFor. Enum GenderType { male, femail, others }. HtmlDropDownListFor(model = model.Gender, new SelectList(Enum.GetValues(typeof(GenderType) ). Here is how to prevent @Html.LabelFor from rendering a new line:. HtmlLabelFor(m = m.Title, new { style = "display:inline" }). Subscribe to: Posts (Atom).

kennyshu.blogspot.com

Kenny Hsu's Blog: 2013.07

http://kennyshu.blogspot.com/2013_07_01_archive.html

My Net programming notes. Update app.config settings at runtime. Using System.Configuration; Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); KeyValueConfigurationCollection appSettings = config.AppSettings.Settings; appSettings["WorkingMinutes"].Value = numericUpDownWorkingPeriod.Value.ToString(); appSettings["RestMinutes"].Value = numericUpDownRestPeriod.Value.ToString(); appSettings["PhotoPath"].Value = textB...Same as above, different style. O; / Method 2.

kennyshu.blogspot.com

Kenny Hsu's Blog: Apply Enum onto @Html.DropDownListFor

http://kennyshu.blogspot.com/2015/08/apply-enum-onto-htmldropdownlistfor.html

My Net programming notes. Apply Enum onto @Html.DropDownListFor. Enum GenderType { male, femail, others }. HtmlDropDownListFor(model = model.Gender, new SelectList(Enum.GetValues(typeof(GenderType) ). Subscribe to: Post Comments (Atom). View my complete profile. TextBox, DataGridView, BindingSource] Search as you type. Convert xml to table in SQL 2005. IPv4 Address convert to Integer (and reverse) (updated). Doing some work after Response.End() (11/14/2013 updated). How DO I" videos for C#.

kennyshu.blogspot.com

Kenny Hsu's Blog: [C# 2.0] Get and Check Daylight Saving Time (DST)

http://kennyshu.blogspot.com/2009/12/c-20-get-and-check-daylight-saving-time.html

My Net programming notes. C# 20] Get and Check Daylight Saving Time (DST). Using System.Globalization; public static DataTable GenerateDST(int startYear, int endYear) { DataTable dt = new DataTable(); / get the current timezone TimeZone oTimeZone = TimeZone.CurrentTimeZone; DaylightTime oDST; dt.Columns.Add("Year"); dt.Columns.Add("Start Date"); dt.Columns.Add("End Date"); for (int i = startYear; i. PS:Don't forget to set your machine's timezone correctly. How to check the given DateTime is DST or not?

kennyshu.blogspot.com

Kenny Hsu's Blog: Update app.config settings at runtime

http://kennyshu.blogspot.com/2013/07/update-appconfig-settings-at-runtime.html

My Net programming notes. Update app.config settings at runtime. Using System.Configuration; Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); KeyValueConfigurationCollection appSettings = config.AppSettings.Settings; appSettings["WorkingMinutes"].Value = numericUpDownWorkingPeriod.Value.ToString(); appSettings["RestMinutes"].Value = numericUpDownRestPeriod.Value.ToString(); appSettings["PhotoPath"].Value = textB...Same as above, different style.