DOT NET ACADEMY: October 2010

Sunday, October 31, 2010

How to add attributes with controls in MVC2

this is how we can add attributes with HTML controls in MVC2 :< %: Html.TextBox("txtfind", null, new { @maxlength = "5", @class = "findInput" })% >in above sample we are setting max length property of textbox to 5 and adding its css class name "findinput".Solutions By:Rajesh Rol...

Disable Trigger

To disable the trigger use this syntex:DISABLE TRIGGER triggerName ON TableName;To disable all triggers of available server:DISABLE Trigger ALL ON ALL SERVERSolutions By:Rajesh Rol...

Rebuild index while insert/update is also available

Some times we face such a situation that we have data in GB of size and we want to rebuild our index which is applied on that table. but in previous editions from MS-Sql server2005 this was not possible to provide insert/update facility while performing rebuild index operation.but from sql server2005 we have got this very good facility to make insert/update available (working) while rebuild index is under progress.to do so the...

Remove interger values from string variable

To remove integer values from string you can use regular expression like this: string result = Regex.Replace(stringValue, @"\d", "");Solutions by: Rajesh Rol...

Import data from .csv to sql

to import data from .csv file to sql server you can use below query.BULK INSERT ZIPCodes FROM 'e:\yourCSVFileName.csv' WITH ( FIRSTROW = 2 , FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ...

Extract url from string

To extract URL from a string you can use below javascript functions:function parseUrl1(data) {var e=/^((http|ftp):\/)?\/?([^:\/\s]+)((\/\w+)*\/)([\w\-\.]+\.[^#?\s]+)(#[\w\-]+)?$/;if (data.match(e)) { return {url: RegExp['$&'], protocol: RegExp.$2, host:RegExp.$3, path:RegExp.$4, file:RegExp.$6, hash:RegExp.$7};}else { return {url:"", protocol:"",host:"",path:"",file:"",hash:""};}}function...

get All child controls/div using jquery

lets assume i have got a div and i want all its child div.you can do it using jquery:$("#ParentDivID > div").each(function(){//your operation on div}Solution by:Rajesh Rolen...

Partial Update in MVC2 (like update panel in classic asp.net)

Trigger Ordering in Sql Server

Many of times we face such issue that we have two triggers defined on same table which are set to fire on the same table actions (i.e. an INSERT, DELETE, UPDATE transaction). The second trigger that fires is dependent on the first fired trigger. So how can we make sure that they fire in the correct order to enforce my business logic.By default, multiple triggers on a SQL Server table for the same action are not fired in a guaranteed...

What is Link Server and what are its advantages in SQL Server/ How to write Queries on tables and database which are on seperate sql server instance

Basically it provides us facility of Distributed transactions.Some times we want to retrieve data from a sever and insert it in table of another server.or Some times we want to run sql queries and perform joins on tables of different database whose database are on different computer.Link server provides us all above facilityLinked Servers allow you to submit a TSQL statement on one SQL Server instance, which retrieves data from...

Invoke a Method when method name is in string format or stored in variable

Below is the code that will do the trick, wrapped in the method InvokeStringMethod. As you see, it takes only two lines to call another method given its name as a string, and its class name also as a string. Read the comments in the code to see how it works.public static string InvokeStringMethod(string typeName, string methodName){ // Get the Type for the class Type calledType = Type.GetType(typeName); // Invoke the...

Fulltext search in sql server

To set fulltext search in sql server follow below steps:EXEC sp_fulltext_database 'enable'goCREATE FULLTEXT CATALOG mycatalogNamegoCREATE NONCLUSTERED INDEX primaryKeyIndexName ON FAQ (pkColumnName);CREATE FULLTEXT INDEX ON dbo.TableName(QuestionLanguage 0X0)KEY INDEX PK_TableName ON mycatalogNameWITH CHANGE_TRACKING AUTO Solution By:Rajesh Rol...

Read config file using XML reader

The best way is to use System.Configuration.ConfigurationManager.AppSettings; to retrive values of webconfig but from xml reader you can also do that:private void loadConfig() { XmlDocument xdoc = new XmlDocument(); xdoc.Load( Server.MapPath("~/") + "web.config"); XmlNode xnodes = xdoc.SelectSingleNode ("/configuration/appSettings"); foreach (XmlNode xnn in xnodes .ChildNodes)...

What is use of “??”.

It's the null-coalescing operator. Essentially it evaluates the left-hand operand, and if the result is null (either a null reference or the null value for a nullable value type) then it evaluates the right operand.works something like this:Instead of doing:int? number = null;int result = number == null ? 0 : number;You can now just do:int result = number ?? 0;The result of the expression a ?? b is a if that's not null, or b...

Do Enum Supports Inharitence

Enums do not supports inheritance since they are value type and therefor are seale...

Value type polymorphism

.NET value types are objects descending from Object; but, they cannot inherit from other types. They can implement interfaces. Thus, primitives—such as Int32— can implement the IComparable interface, for example, making them comparabl...

How to detect browser using javascript

we can use navigator.userAgent to detect the type/name of current browser and perform compatibility operations according to it:below is javascript code so put it in script tagfunction DetectBrowser() { var val = navigator.userAgent.toLowerCase(); if(val.indexOf("firefox") > -1) { isFF = true; } else if(val.indexOf("opera") > -1) { isOP = true; }...

How to Detect the browser using asp.net and c#.net

Many of times we need to detect browser type/name and its capability in asp.netto do so below code can help you:These properties are exposed by the HttpBrowserCapabilities object indicate inherent capabilities of the browser, *but do not necessarily reflect current browser settings.so using Request.Browser.Browser we can find the name of browser and using if-else/switch-case we can perform desired operation for specific browser...

DOT NET ACADEMY