tag:blogger.com,1999:blog-88210782245939830742009-05-04T00:22:07.663-05:00.NET Interview QuestionNews, Components, Tutorials & Interview Question AnswersGurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-8821078224593983074.post-89577876193991697172009-01-20T11:28:00.001-05:002009-01-20T11:42:24.015-05:00ASP.NET 3.5 with VS 2008I found a good presentation on new features in Asp.NET 3.5 with VS 2008 and journey from Asp, Asp.NET 1.1 to Asp.NET 3.5 with Visual studio 2008. Visual studio 2008 completely replaces VS 2005. It provides new features like JavaScript intellisense, JavaScript debugging and new CSS editor, and also Unit test automation tools.NET 3.5 built on top of 2.0 and 3.0. In it, Membership, Role, and Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-10265323556044426812009-01-16T22:49:00.003-05:002009-01-16T23:50:24.883-05:00Difference between DataList and Repeater controlsAsp.Net Interview QuestionWhat is the difference between DataList and Repeater data binding controls?Answer: The DataList control is similar to the Repeater control. However, it has some additional properties and templates that you can use to display its data in a diverse fashion. The Repeater control does not have any built-in layout or style. We are forced to specify all formatting-related HTMLGurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com1tag:blogger.com,1999:blog-8821078224593983074.post-6946509874435925782009-01-06T12:30:00.004-05:002009-01-16T23:49:54.520-05:00Aggregate Functions in SQL SERVER 2008What are Aggregate functions? Explain Aggregate functions in SQL SERVER 2008 with example.Aggregate functions are applied to a group of data values from a column. Aggregate functions always return a single value.SQL SERVER 2008 / Transact-SQL supports following aggregate functions:AVG: Calculates the arithmetic mean (average) of the data values contained within a column. The column must contain Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-82448489566404340602009-01-05T12:39:00.003-05:002009-01-05T12:45:08.576-05:00SQL Server Basic DatabasesSQL Server Interview Question. Name the Basic or Default Databases of SQL SERVER and What are their functions and use.?Microsoft SQL SERVER Provides 4 default databases The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administerGurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-68617847709083830782008-12-18T11:52:00.007-05:002009-01-16T23:48:41.269-05:00SQL Server 2008 advantages for DevelopersMicrosoft has released a new version of its popular Database management system (SQL Server). It is Microsoft SQL Server 2008. So what are the benefits of SQL SERVER 2008 for Developers & Programmers. SQL Management Studio improvements including IntelliSense. New Data Types for just dates or times (no more storing time when you only need the date). New Hierarchical data support .IsDescendent(), Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com1tag:blogger.com,1999:blog-8821078224593983074.post-56351861188194691812008-11-13T11:30:00.006-05:002009-01-16T23:46:56.970-05:00Value types VS Reference types C#What is difference between Value types and Reference types in VB.NET or C# (Value types VS Reference types)C# provides two types—class and struct, class is a reference type while the other is a value type. Here is difference between Value types and Reference types.Value types directly contain their data which are either allocated on the stack or allocated in-line in a structure. Reference types Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com1tag:blogger.com,1999:blog-8821078224593983074.post-3261072550118333082008-04-22T10:20:00.003-05:002009-01-16T23:44:46.790-05:00Now you can ask interview questionA new portal for developer community has been launched. Where you can ask any tech question and get answer from tech experts. You can also discuss on any tech topic.See ASP.Net interview questions discussion athttp://www.techbaba.com/faqs/asp.net+interview+question+answers.aspxGurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com4tag:blogger.com,1999:blog-8821078224593983074.post-3816416104553075652007-06-26T03:22:00.001-05:002009-01-16T23:44:15.005-05:00All type .Net faqs, interview questions & answershttp://www.dotnetinterviewfaqs.com/ is a new .Net website having all Microsoft related faqs, interview questions & answersTo visit click http://www.dotnetinterviewfaqs.com/Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com2tag:blogger.com,1999:blog-8821078224593983074.post-54634812594097574132007-01-25T16:30:00.001-05:002009-01-16T23:42:21.361-05:00Multiple - Language Development in .NET Framework.NET Framework encourages cross-language development using multiple programming languages. To become a .NET language, any language should have a compiler that translates the source code written in different languages into Microsoft Intermediate Language (MSIL). MSIL code is called as Managed Code. Managed code runs in .NET environment.In .Net framework the Common Runtime Language (CLR) contains aGurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com3tag:blogger.com,1999:blog-8821078224593983074.post-54587666208727681832007-01-11T11:50:00.001-05:002009-01-16T23:41:37.527-05:00Explain the delegates in C#.Delegates in C# are objects which points towards a function which matches its signature. Delegates are reference type used to encapsulate a method with a specific signature. Delegates are similar to function pointers in C++; however, delegates are type-safe and secure.Here are some features of delegates:A delegate represents a class. A delegate is type-safe. We can use delegates both for static Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com2tag:blogger.com,1999:blog-8821078224593983074.post-52401777662063708822007-01-11T09:19:00.001-05:002009-01-16T23:40:46.488-05:00What is the purpose of connection pooling in ADO.NET?Connection pooling enables an application to use a connection from a pool of connections that do not need to be re-established for each use. Once a connection has been created and placed in a connection pool, an application can reuse that connection without performing the complete connection creation process.By default, the connection pool is created when the first connection with a unique Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com1tag:blogger.com,1999:blog-8821078224593983074.post-13465972017134361332007-01-10T11:48:00.001-05:002009-01-16T23:38:53.230-05:00What is the difference between classes and structs in Microsoft.Net?A struct is a value type, while a class is a reference type. When we instantiate a class, memory will be allocated on the heap. When struct gets initiated, it gets memory on the stack. Classes can have explicit parameter less constructors. But structs cannot have this. Classes support inheritance. But there is no inheritance for structs. A struct cannot inherit from another struct or class, and Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com3tag:blogger.com,1999:blog-8821078224593983074.post-1516869769833735772007-01-09T11:49:00.001-05:002009-01-16T23:37:45.380-05:00What is a Strong Name in Microsoft.Net?In Microsoft.Net a strong name consists of the assembly's identity. The strong name guarantees the integrity of the assembly. Strong Name includes the name of the .net assembly, version number, culture identity, and a public key token. It is generated from an assembly file using the corresponding private key.Steps to create strong named assembly:To create a strong named assembly you need to have Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-58479518801648456052007-01-09T11:13:00.001-05:002009-01-16T23:36:25.963-05:00What is the use of XSLT?XSLT stands for Extensible Stylesheet Language Transformations. This language used in XSL style sheets to transform XML documents into other XML documents.XSLT is based on template rules which specify how XML documents should be processed. An XSLT processor reads both an XML document and an XSLT style sheet. Based on the instructions the processor finds in the XSLT style sheet, it produce a new Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com2tag:blogger.com,1999:blog-8821078224593983074.post-24655393867379786732007-01-08T10:51:00.001-05:002009-01-16T23:35:21.228-05:00Explain ACID properties of the database?All Database systems which include transaction support implement ACID properties to ensure the integrity of the database. ACID stands for Atomicity, Consistency, Isolation and DurabilityAtomicity: Each transaction is said to be “atomic.” If one part of the transaction fails, the entire transaction fails. Modifications on the data in the database either fail or succeed. Consistency: This property Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com2tag:blogger.com,1999:blog-8821078224593983074.post-66291363293334664322007-01-08T10:00:00.001-05:002009-01-16T23:33:50.491-05:00What is the basic functionality of Garbage Collector in Microsft.Net?The Common Language Runtime (CLR) requires that you create objects in the managed heap, but you do not have to bother with cleaning up the memory once the object goes out of the scope or is no longer needed. The Microsoft .NET Framework Garbage Collector provides memory management capabilities for managed resources. The Garbage Collector frees objects that are not referenced and reclaims their Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-17821515449401620162007-01-07T09:26:00.001-05:002009-01-16T23:32:21.622-05:00What is a static class?We can declare a static class. We use static class when there is no data or behavior in the class that depends on object identity. A static class can have only static members. We can not create instances of a static class using the new keyword. .NET Framework common language runtime (CLR) loads Static classes automatically when the program or namespace containing the class is loaded.Here are someGurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com1tag:blogger.com,1999:blog-8821078224593983074.post-76121930502207200102007-01-07T09:04:00.001-05:002009-01-16T23:31:47.358-05:00What is static member of class?A static member belongs to the class rather than to the instances of the class. In C# data fields, member functions, properties and events can be declared static. When any instances of the class are created, they cannot be used to access the static member.To access a static class member, use the name of the class instead of an instance variableStatic methods and Static properties can only access Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-87824604802867939942007-01-07T05:28:00.001-05:002009-01-16T23:31:04.363-05:00What is the purpose of Server.MapPath method in Asp.Net?In Asp.Net Server.MapPath method maps the specified relative or virtual path to the corresponding physical path on the server. Server.MapPath takes a path as a parameter and returns the physical location on the hard drive. SyntaxSuppose your Text files are located at D:\project\MyProject\Files\TextFilesIf the root project directory is MyProject and the aspx file is located at root then to get Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-53725497372302403122007-01-05T11:41:00.001-05:002009-01-16T23:29:31.527-05:00What is the use of indexes and what are the types of indexes available in SQL Server?Indexes are used to find data quickly when a query is processed in any relational database. Indexes improve performance by 10 to 500 times. Index can improve the performance in following operations:Find the records matching with WHERE clauseUPDATE Books SET Availability = 1 WHERE SubjectId =12 DELETE FROM Books WHERE Price <10SELECT * FROM Books WHERE Price BETWEEN 50 AND 80Sorting the result Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com3tag:blogger.com,1999:blog-8821078224593983074.post-49354723590356195062007-01-04T10:42:00.001-05:002009-01-16T23:28:21.797-05:00What is the difference between abstract class and interface?We use abstract class and interface where two or more entities do same type of work but in different ways. Means the way of functioning is not clear while defining abstract class or interface. When functionality of each task is not clear then we define interface. If functionality of some task is clear to us but there exist some functions whose functionality differs object by object then we Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com1tag:blogger.com,1999:blog-8821078224593983074.post-38741967193984162422007-01-04T10:37:00.002-05:002009-01-16T23:43:01.413-05:00What is the use of Master Pages in Asp.Net?A master page in ASP.Net provides shared HTML, controls, and code that can be used as a template for all of the pages of a website.Every master page has asp:contentplaceholder control that will be filled by the content of the pages that use this master page. You can create a master page that has header and footer i.e. a logo, an image, left navigation bar etc and share this content on multiple Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-71312145394212647192007-01-03T11:43:00.001-05:002009-01-16T23:20:57.737-05:00What is the difference between .Net Remoting and Asp.Net Web Services? ASP.NET Web Services Can be accessed only over HTTP but .Net Remoting Can be accessed over various protocols like TCP, HTTP, SMTP etc. Web Services are based on stateless service architecture but .Net Remoting support for both stateful and stateless environment. Web Services support heterogeneous environments means interoperability across platforms but .Net remoting requires .Net on both server Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-1939896459264840032007-01-03T10:58:00.001-05:002009-01-16T23:19:14.305-05:00What would be the common layers in an n- tier architecture based web application?Common layers in an n- tier architecturePresentation GUI: Look & Feel ,Html, aspx file, JavaScript, window forms etc. Controller- Work flow layer: aspx.cs file, means event handlers and Data binding with controls etc. Business Logic: where we implement business rules like add book, search library etc. Data Access: SQLHelper.cs like create connection, get DataSet, Execute Query etc. Physical Data:Gurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com0tag:blogger.com,1999:blog-8821078224593983074.post-28152431638137164602007-01-03T10:55:00.001-05:002009-01-16T23:17:42.179-05:00What are the different state management techniques used in asp.net for web applications?In ASP.Net the state can be maintained in following waysServer-side state managementApplication objectsSession VariablesDatabaseClient-side state managementCookiesHidden input fieldsQuery StringViewStateGurjinder Singh Brarhttp://www.blogger.com/profile/11418457142219631635noreply@blogger.com2