Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 12263
Home > Interviews > .NET Framework

.NET Framework Interview Questions and Answers (547) - Page 23

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

547 records found.

Post | Interview Experiences | Interview FAQs | Online Interviews | Exclusive Questions

Get 650+ Questpond's Interview videos on discount

What is the main difference between the Button server control and the Button Html control?

when clicked the Button server control triggers are asp.net click event procedure on the server.The Button HTML control triggers the event procedure indicated in the buttons onclick attribute,which runs on the client.
Why can't you open a new browser window from within server code?

Server code executes on the server, where as the new window is created on the client.You need to use the client-side code to do things that affect the client,such as upload files,display new windows or navigate back in history.
How to Delete the Duplicate values in sql table?

create table:

Create table emp (Eno int ,EmpName varchar(10),Dept varchar(10))


Insert Values:


insert into emp values(1,'John','IT')

insert into emp values(1,'John','IT')

insert into emp values(2,'Maxx','CSE')

insert into emp values(3,'Cany','AUTO')

insert into emp values(2,'MAXX','CSE')

insert into emp values(1,'SONY','IT')


Select * from emp

Eno EmpName Dept
1 John IT
2 Maxx CSE
3 Cany AUTO
2 MAXX CSE
1 SONY IT
1 John IT

Find the duplicate values from the table:



WITH tempTable as(

SELECT ROW_NUMBER() Over(PARTITION BY eno,empname ORDER BY eno) As RowNumber,* FROM emp

)

select * from tempTable where RowNumber >1


Delete duplicate Rows with CTE 

WITH tempTable as(

SELECT ROW_NUMBER() Over(PARTITION BY eno,empname ORDER BY eno) As RowNumber,* FROM emp

)

DELETE FROM tempTable where RowNumber >1


---After Deleting the duplicate values
select * from emp

Eno EmpName Dept
1 John IT
3 Cany AUTO
2 MAXX CSE
1 SONY IT
How to import Excel into Sql table by using Store Procedure?

Exec SP_Excel 'Report.XLSb' 

Create PROC SP_Excel 

(

@ExcelName VARCHAR(100)

)

As 

Begin

Declare @SQL VARCHAR(1000)

if OBJECT_ID('Table1') is not null

drop table Table1 



SET @SQL= 'select * INTO Table1 from openrowset (''Microsoft.ACE.OLEDB.12.0'',''Excel 12.0;Database=d:\Sharedd\'+@ExcelName+''',[Sheet1$])'

EXEC(@SQL)



End

Your developed asp.net application contains master page named ProductMaster.master which contain public method. You want to access this method from content page. How you would achieve this thing ?

NOTE: This is objective type question, Please click question title for correct answer.
Your are developing asp.net application which require attribute add to class named Person whose instance save into session variable. developer set session state mode is StateServer. Which attribute should you use ?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing large desktop application which have a lot of classes that need to be processed. For each class, you need to perform a complex calculation. Which technique should you use?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing web application using linq to sql as data access technique. you need to write complicated query which must run it in parallel. Which method should you use?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing an ASP.NET application that retrieves data from using web service and then insert the response data to the database. Should you use async/await ?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing web application using Task parallel library concept. you need to implement cancellation feature for a long running task. Which object do you pass to the task ?

NOTE: This is objective type question, Please click question title for correct answer.
You need to iterate over a collection (of string data Type). You need to remove certain data from that collection. Which statement do you use ?

NOTE: This is objective type question, Please click question title for correct answer.
Your present code contains lots of if..else statement for checks null value your application. On basis of that condition you want to invoke a method if value is not null. You want to simplify your code. how would you achieve this task ?

NOTE: This is objective type question, Please click question title for correct answer.
You are creating a generic class that should work only with value types. Which type constraint should you add?

NOTE: This is objective type question, Please click question title for correct answer.
You pass a integer type variable into a method as an argument. The method do some complex calculation and change the variable's value. But when the method returns, the variable has not changed. What happened?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing web application and have requirement for easily accessed elements of collection type Product. What should you add to the type?

NOTE: This is objective type question, Please click question title for correct answer.
You want to declare an string type variable called _productName and assign it the value TV using C#. How can you accomplish this?

NOTE: This is objective type question, Please click question title for correct answer.
Your are developing web application in which user needs to enter a DateTime in a text field. You need to parse that value in code. you need to write code in such way it don't throw exception if use enter invalid date. Which method do you use?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing web application in which you need to encrypt a large amount of data. Which algorithm do you use ?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing web application which need to send sensitive data to another party and you want to prevent data tampering. Which method do you use?

NOTE: This is objective type question, Please click question title for correct answer.
You are developing new web application in which need to store exception data. Each time a new log entry is write to the file. Which method do you use?

NOTE: This is objective type question, Please click question title for correct answer.
More .NET FRAMEWORK Exclusive Interview Questions & Answers here
Found this useful, bookmark this page to the blog or social networking websites. Page copy protected against web site content infringement by Copyscape
Bookmark It

 Interview Questions and Answers Categories

.NET Certifications
.NET Core
.NET Framework
ADO.NET
AI ML
Android
Angular
AngularJS 1x
Aptitute Test
ASP.NET
ASP.NET AJAX
ASP.NET Core
ASP.NET MVC
ASP.NET Web API
Aurelia
Azure
Best Practices
BizTalk Server
Bootstrap
C#
Cloud
CMS
CSS 3
Data Structures & Algorithms
Design Pattern & Practices
DotNetFunda.Com
Entity Framework
Error and Solution
F#
Function Points (FPA)
HR
HTML 5
IIS
Interview Questions
JavaScript
jQuery
Kinect
LightSwitch
LINQ
Management
Mobile Development
MSBI (SSIS, SSRS, SSAS)
Mule
Networking
News and Community
Node.js
NoSql
OOPS
Oracle
Others
PostgreSQL
PowerShell
Product Reviews
Project Management
Python
QA (Testing)
R Language
Regular Expressions
SEO
SharePoint
SignalR
Silverlight
Sql Server
TypeScript
UML
VB.NET
Visual Studio
WCF
Web Analytics
Web Services, Remoting
Windows 8
Windows Forms
Windows Metro
Windows Phone
WPF
WWF
XML