Interview Questions Part 1

Q 1) MVC Means ? Ans) ASP.NET MVC is a part of the ASP.NET Web application framework MVC stands for multi view controller and this is a part of dot net framework. It has several versions.MVC application is created by using following 3 attributes namely: Model, View and Controller.Model: It tells the the core information of an application which includes data, validation rules and data access and aggregation logic.View: The view is used to encapsulate the presentation of the application.Controller: The controller contains of the control-flow [...]

Getting column values as comma seperated list using XML PATH()

select tc.customerid,stuff(( select ',' + convert(nvarchar(30),tct.Customer_TripId) from tollplus.TP_Customers tc inner join tollplus.TP_Customer_Trips tct on tc.customerid=tct.customerid and tc.customerid=60000252 for xml path('')),1,1,'')as usergroups from tollplus.TP_Customers tc where tc.customerid=60000252 [...]

SqlServer - Ordering result set with null values after non-null values

Order by with null values in sql server is a tricky. Normally it puts the result set like: NULL, NULL, 1,2,3...etcIf your want the result set like: 1,2,3,NULL, NULL,......etc there is not direct method for this. You have to use the below script to get the required output.declare @MaxId intselect @MaxId = max(code) + 1 FROM TableASELECT codeFROM TableAORDER by isnull(code, @MaxId) [...]

Sql Server 2008 Installation Process

For Sql server 2008 Installation Process. Check the below URL to get the Clear Information. http://www.sqlcoffee.com/SQLServer2008_0011. [...]

Filter data by using IN and NOT IN clause

In this post I am going to show some SQLqueries and LINQ queries, but not going to show images for all cases.Filter data by using IN and NOT IN clause Most of the developer who started working on LINQ queries gets confuse when they got requirement to write IN and NOT IN query using LINQ. SQL Query //IN SELECT [Id], [UserId], [IMEINo] FROM [UserClients] WHERE [UserId] IN (3, 4) or //NOT IN SELECT [Id], [UserId], [IMEINo] FROM [UserClients] WHERE [UserId] IN (3, 4) as you see above query use IN and NOT IN clause to filter from list of records. [...]

Linq to get the values with Comma seperated.

Here is the LINQ to convert your LINQ result into a comma separated value:string returnVal = (from a in b select a.StringValue).Aggregate(new StringBuilder(), (c, d) => c.Append(",").Append(@"""" + d + @""""), (c) => c.ToString().TrimStart(new char[] { ',' }) .TrimEnd(new char[] { ',' }))Example: customerTrips = (from a in dtReceiptAmountDetails.AsEnumerable() [...]

Difference between VS2008 & VS2010

Project Solution Extension in vs2008 is ".sln(Solution)"Project Solution Extension in vs2010 is " .suo(Solution User Options) [...]

Sql Server 2000,2005 & 2008 Version differences

I mention the the difference between all the sql server version difference Point's wise to understand easily.Sql Server 2000: 1.Query Analyser and Enterprise manager are separate. 2.No XML datatype is used. 3.We can create maximum of 65,535 databases.4.Nill 5.Nill 6.Nill 7.Nill 8.Nill 9.Nill 10.Nill 11.Nill 12.Nill 13.cant compress the tables and indexes. 14.Datetime datatype is used for both date and time. 15.No varchar(max) or varbinary(max) is available. 16.No table datatype is included. 17.No SSIS is included. 18.CMS [...]

Linq concepts

Linq Sum :If we want to implement the Linq Concepts must use "Systme.Linq" reference(using System.Linq;)Example with Description:decimal lineItems_SUM = 0;lineItems_SUM = (from "AliasName" in "IList Items" // List items. select "AliasName"."Property" ).Sum [...]

Asp Controls Rendering.

Example with an Asp Button Control.In Asp: asp:Button ID="btnCancel" runat="server" Text="CANCEL" ToolTip="Cancel" CssClass="submitbtn" TabIndex="9"After Rendering: <input type="submit"name="ctl00$ContentPlaceHolder1$ctl00$btnCancel"value="CANCEL" id="ctl00_ContentPlaceHolder1_ctl00_btnCancel"tabindex="9" title="Cancel" class="submitbtn" />Description:Ofcourse almost we know except "name" After Rendering.name -- This is used to maintain the view state.If we want to find the button using view state using the "name"tag we can identifi [...]

This Fry is latest and taste always

This Fry is latest and taste alw [...]