http://fransiscuss.com My notepad to share knowledge with others Tue, 17 Aug 2010 05:28:50 +0000 http://backend.userland.com/rss092 en This article is demonstrating how to wire up an enter key into a textbox. For example you have a search text box where you press enter then it will click go button and at the same page you have another textbox where you want to do another button click when ... http://fransiscuss.com/enter-button-in-textbox-aspnet/ I've a case where I have an ASP.NET calendar that has a page load method that automatically select a date when it's loaded. I also have an event defined for Selected_Changed which will be triggered only when the user select any other date other than pre-selected date on the load Private ... http://fransiscuss.com/aspnet-calendar-selected-day-on-click-method/ I have this date column and it has DateConverter that i created to apply the current thread culture. The problem that I have is -On load it display the date format perfectly based on the current culture -The problem is when i double click the cell/edit mode then it applies different format ... http://fransiscuss.com/setting-the-silverlight-telerik-radgrid-culture/ Select Node value This is a simple explanation on how to select a particular node from xml data type of a record in SQL server. Sample XML 00003479 Brodie's HomeSton NULL AU941170 2010-07-22T09:42:20 vcAuditorDesc,chUpdateStaffCode,dtUpdateDateTime,dtUpdateDateTime So what I want to do is basically to ... http://fransiscuss.com/read-and-update-xml-node-of-xml-datatype-in-sql-server/ Here is the scenario, You have a stored procedure that builds dynamic insert SQL which means the "INSERT" statement is being composed on the fly based on the table name but at the same time you need to get SCOPE_IDENTITY or the last identity number inserted for further processing (e.g ... http://fransiscuss.com/how-to-set-variable-from-dynamic-sql/ I had a problem before where I build dynamic system (light dataset) for doing CRUD (Create, Read, Update and Delete) and I need to store the history of previous record before Update/Delete and at the same time I also need to indicate the column(e.g changing the color of the column) ... http://fransiscuss.com/telerik-sl-gridview-cell-foreground-color-dynamically-based-on-multiple-binding/ I need to make a text box that does not allow the user to type any numeric key at all ... http://fransiscuss.com/numeric-textbox-with-javascript-and-cross-browser-compatible/ Reflection on .NET by default is case sensitive for the class member. To make it case insensitive you need to pass BindingFlags.IgnoreCase . I've passed the ignorecase flag and now it doesn't return anything!!! Dim pi As PropertyInfo = Me.[GetType]().GetProperty(fieldname, BindingFlags.IgnoreCase) Basically, if you pass one flag then the other ... http://fransiscuss.com/reflection-getproperty-case-sensitive-issue/ Normally, I need to run this script against dev sql server in order for me to free up some space create table #temp_dbs_table ( [db_name] sysname not null primary key, [mod] tinyint not null default 1 ) insert into #temp_dbs_table ([db_name]) select name from master..sysdatabases where dbid > 4 --- skip master, tempdb, model and msdb databases declare @db_name sysname set @db_name = '' while ... http://fransiscuss.com/shrink-all-databases-and-set-it-to-simple-in-sql-server/ Isolated storage in silverlight is used to store information or object therefore we don't need to go to database to get all the information over and over again but again to use isolated storage or not should be based on case by case. Based on the implementation of the code ... http://fransiscuss.com/compression-in-silverlight-isolated-storage/