How to set variable from Dynamic SQL
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…
-
-
Telerik SL Gridview Cell Foreground color dynamically based on multiple binding
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…
-
Numeric textbox with javascript and cross browser compatible
I need to make a text box that does not allow the user to type any numeric key at all // function to only allow numeric key presses in a textbox // this doesn’t stop pasting…
-
Reflection GetProperty case sensitive issue
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…
-
Shrink all databases and Set it to Simple in SQL Server
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…
-
Compression in Silverlight Isolated Storage
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…
-
FormsAuthentication.GetRedirectUrl only get the first parameter of querystring
I found the issue with FormsAuthentication.GetRedirectUrl when it redirects then it redirects with the first querystring that you have while in fact you might have more than one querystring e.g http://localhost/myweb/login.aspx?returnurl=myview.aspx?viewID=123&viewname=abc&viewall=false then the standard FormsAuthentication will…
-
an activex control on this page might be unsafe to interact with other parts of the page. do you want to allow this interaction?
I keep getting this message “an activex control on this page might be unsafe to interact with other parts of the page. do you want to allow this interaction” when I try to access a page…