tag:blogger.com,1999:blog-6586937245882006432026-04-08T01:28:01.461-07:00DotNetPeopleOOPS Concepts, OOPS interview questions, C#.Net interview questions, .Net framework interview questions, Asp.Net interview questions, SQL server interview questions, WCF interview questions, WPF interview questions, Angular Js interview questions
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.comBlogger71125tag:blogger.com,1999:blog-658693724588200643.post-32786952094433230062017-11-03T11:07:00.000-07:002017-11-03T11:24:01.588-07:00Continue loop iteration after exception is thrown
One of my friend working on one project which has task and task has for loop inside.
Like this,
try
{
foreach (var item in collection)
{
if (item == null)
{
throw new Exception("item {0} is null" + item);
}
}
}
catch (Exceptionjatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-60834610235316816722017-11-02T09:33:00.004-07:002017-11-02T09:57:04.353-07:00Set Span value using Jquery
Using jQuery to set value on SPAN element
Let say we have below span element,
<Span id="spnTest" class="red"></span>
You can set value of span element using two ways,
1) By Using Class name of Span
$(".red").text("Hello");
$(".red").html("Hello");
2) By Using Id of Span
$("#spnTest").text("Hello");
$("#spnTest").html("Hello");
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-23466107811609361592017-11-02T09:24:00.001-07:002017-11-02T09:26:06.235-07:00stringbuilder clear
How to Clear stringbuilder string.
StringBuilder stringBuilder = new StringBuilder();
Just use Clear method on stringbuilder object to clear stringbuilder content.
stringbuilder.Clear();
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-72091352147499097012017-10-25T03:14:00.001-07:002017-10-25T10:32:03.080-07:00Change line height in Kendo UI Web editorChange line height in Kendo UI Web editorWe can do it by configuring the stylesheet property of the editor, and then configuring the tools that will apply the styles to the selected content.$("#editor").kendoEditor({
tools: [
{ name: "formatting", items: [
{ text: "Error", value: ".Error" },
{ text: "OK", value: ".OK" },
{ text: "Inline Code", value: ".inCode" }
] }
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-82701042835580731792017-10-11T10:02:00.001-07:002017-10-11T10:06:49.377-07:00line height CSS
What is Line Height in CSS?
- Line Height property defines amount of height in which text content is written in HTML.
Properties of Line Height:
Normal:
This is default Height line, generally around 100% to 120%.
e.g.: Default Height line in word document.
Number:
A number that will be multiplied with the current font size to set the line height.
Length:
&jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-9055454298435888732017-10-08T06:39:00.002-07:002017-10-08T06:39:39.886-07:00Application's path in a .NET console application
How can I get the application's path in a .NET console application? OR Get path for my assembly.
System.Reflection.Assembly.GetEntryAssembly().Location;
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-7681548840204260652017-10-05T11:05:00.003-07:002017-10-05T11:12:45.281-07:00Using Replace in Update statement SQL
Using Replace in Update statement SQL
Suppose you have following table 'MasterData' table in SQL,
You want to replace '!!' by '{{' and '||' by '}}' in data column of table. How would you do it.
=> You can do it by using Replace function in Update statement of SQL Server as below,
UPDATE dbo.MasterData
SET Value = REPLACE(REPLACE(Data, '!!', '{{'),'||','}}')
WHERE ID = 1
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-91395512315218189542017-09-25T01:25:00.000-07:002017-09-25T01:25:14.897-07:00How to assign default or null or empty parameter to Guid
One of my friend working on one project, and he wants to assign the null / Empty / default parameter to guid,
public void SampleFunction(Guid guidParameter = Guid.Empty)
{
}
But the compiler complains that Guid.Empty is not a compile time constant.
Solution
We can use,
public void SampleFunction(Guid guidParameter = new Guid()){
// when called without parameters this will be true
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-73779720041900801392017-09-16T05:13:00.005-07:002017-10-25T10:31:38.853-07:00Fiddler Wildcard AutoResponse For URL parametersSuppose you want to enable autoresponder for perticular URL like,
https://dotnetpeoples.blogspot.in/Employee/Login?id=12345
but every time id changes when we re-fresh this page, so autoresponder not considering it,
so just do below 2 steps it will work for you guys,
Step 1: Enable Automatic responses & unmatched request passthrough
Step 2: In Rule Editor Changed below URL as,
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-29958844120775727512017-01-05T23:39:00.000-08:002017-01-29T05:26:43.674-08:00How to set identity specification set to false globally in entity framework
We can globally turn off this feature by removing StoreGeneratedIdentityKeyConvention Convention as below,
public class OurContext : DbContext
{
protected override void OnModelCreating(DbModelBuilder modBuilder) { modBuilder.Conventions.Remove<StoreGeneratedIdentityKeyConvention>();
}
}
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-12436884070380106232016-12-22T22:39:00.001-08:002016-12-22T22:39:09.658-08:00microsoft visual studio can not set breakpoint in c# file
Microsoft visual studio can not set breakpoint in c# file
I was getting same error in one of my project, and after 15 to 20 mins of search & practical i found very simple solution as below,
BUILD > Clean Solution
BUILD > Build Solution
Hope it will help you guys.
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-61493502596509801572016-11-12T02:28:00.002-08:002016-11-12T02:33:34.715-08:00WCF InvalidOperationException: A binding instance has already been associated to listen URI
Here you missed the address attribute in your metadata endpoint.
A binding instance has already been associated to listen URI
Without it WCF thinks that you want to host the mex endpoint at the same address as other endpoints.
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-4888008121284603102016-06-26T06:40:00.000-07:002017-01-05T23:40:14.803-08:00Cannot insert the value NULL into column in ASP.NET MVC Entity Framework
Cannot insert the value NULL into column in ASP.NET MVC Entity Framework
One of my friend was trying simple MVC application [CRUD application] CRUD means
C - Create, R - Read, U - Update & D- delete
and he was getting error like "Cannot insert the value NULL into column in ASP.NET MVC Entity Framework" from almost more than half hour as below,
entity framework nulljatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-41877979703716297252016-06-13T08:43:00.000-07:002016-06-27T07:03:53.539-07:00Delegates in C# with examples
Delegate is type
safe function pointer.
Function pointer: points/holds referernce
to a method.
Type safe: return type and signature of method must be
same as signature and return type of method else you will get compilation error.
Syntax: Very
much similar to the method with the delegate keyword.
It is similar to a
class, we need to create instance of it and pass in the jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com1tag:blogger.com,1999:blog-658693724588200643.post-44313877137573997352016-06-11T20:15:00.004-07:002016-06-11T20:33:48.019-07:00.Net Framework interview questions and answers part2
6. What is Common Language Specification (CLS)?
This is a subset of the CTS, which all .NET languages are expected to support. It was always a dream of Microsoft to unite all different languages in to one umbrella and CLS is one-step towards that. Microsoft has defined CLS, which are nothing but guidelines that language should follow so that it can communicate with other .NET jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-75947475789908734262016-05-29T10:20:00.000-07:002016-05-29T10:20:30.363-07:00PermCheck Codility Solution in C#.Net
PermCheck Codility Solution in C#.Net
Check whether array A is a permutation.
Solution:
public static int PermCheck(int[] A)
{
int l = A.Length;
int Result = 1;
if (l == 0)
{
return Result = 1;
}
else
{
Array.Sort(A);
for (int i = 0; jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-25693500756871528902016-05-29T10:02:00.001-07:002016-05-29T10:02:18.866-07:00FrogRiverOne Codility C# solution
FrogRiverOne Codility C# solution
Find the earliest time when a frog can jump to the other side of a river.
Solution:
public static int FrogRiverOne(int X, int[] A)
{
bool[] leavesInPosition = new bool[X + 1];
int occupiedPositions = 0;
for (int i = 0; i < A.Length; i++)
{
int position = A[i];
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com1tag:blogger.com,1999:blog-658693724588200643.post-48415563427092611852016-05-28T00:34:00.001-07:002016-05-28T01:12:26.774-07:00Codility PermMissingElem C# Solution
Codility PermMissingElem C# Solution
Find the missing element in a given permutation.
Solution:
public static int MissingInt(int[] A)
{
if (A.Length != 0 && A.Length == 1)
return A[0] == 1 ? 2 : 1;
else if (A.Length != 0 && A.Length > 1)
{
Array.Sort(A);
if (A[0] != 1)
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-37823410460473837532016-05-20T08:25:00.000-07:002016-05-21T00:54:57.557-07:00Codility TapeEquilibrium Solution C#
Codility TapeEquilibrium Solution C#
Minimize the value |(A[0] + ... + A[P-1]) - (A[P] + ... + A[N-1])
Solution:
Here we need to add two namespaces,
using System;
//
you can also use other imports, for example:
using System.Collections.Generic;
using System.Linq;
public int solution(int[] A)
{jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-54023812169341520802016-05-17T10:05:00.001-07:002016-05-17T10:22:45.914-07:00Codility FrogJmp Solution C#
Codility FrogJmp Solution C# - Count minimal number of jumps from position X to Y.
Solution:
public int solution(int X, int Y, int D)
{
int distance = Y - X;
int div = (distance / D);
int mod = (distance % D);
if (mod != 0)
{
return div + 1;
}
else
{
jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-17560874353881768642016-05-15T10:59:00.003-07:002016-05-20T07:03:56.913-07:00Codility Odd Occurrences In Array Solution C#.Net
Codility Odd Occurrences In Array Solution C#.Net
[ Find value that occurs in odd number of elements.]
Solution:
public int solution(int[] A)
{
int unMatchNumber = A[0];
for (int i = 1; i < A.Length; i++)
{
unMatchNumber = unMatchNumber ^
A[i];
}
return unMatchNumber;
}
And here goes, gotjatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-63695331531706439212016-05-15T07:03:00.002-07:002016-07-01T05:53:04.165-07:00Codility Cyclic Rotation Solution C#
Codility Cyclic Rotation Solution C#
Solution:
public static int[] Solution(int[] A, int K)
{
int l = A.Length;
int start = l - K;
int [] jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com3tag:blogger.com,1999:blog-658693724588200643.post-27396997468376787622016-05-14T22:19:00.001-07:002016-05-20T07:04:33.181-07:00Codility binary gap solution C#
Codility binary gap solution C#
Find
longest sequence of zeros in binary representation of an integer.
Solution:
public int GetBinaryGap(int N)
{
string binaryValue = Convert.ToString(N, 2);
int jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com3tag:blogger.com,1999:blog-658693724588200643.post-69493868838793821182016-05-08T11:36:00.002-07:002016-07-06T06:25:08.577-07:00How to get difference of top 2 records of each group in SQL Server order by date
I went though today Codility online exam for one of the top investment banking client interview, and I found one interesting question on SQL as below,
Question:
Get top 2 records of each group /category in SQL Server, order by date and then get difference between them by category wise
In SQL Terms:
Retrieve difference between top 2 records of each group in sql serverjatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com0tag:blogger.com,1999:blog-658693724588200643.post-69886969397069261582016-04-26T05:11:00.000-07:002016-04-26T11:39:01.974-07:00YOU ARE USING SAFE UPDATE MODE AND YOU TRIED TO UPDATE A TABLE WITHOUT A WHERE THAT USES A KEY COLUMN
ERROR CODE 1175. TO DISABLE SAFE MODE, TOGGLE THE OPTIONS IN PREFERENCES --> SQL EDITOR --> QUERY EDITOR --> RECONNECT
You are Using SAFE UPDATE MODE AND YOU TRIED TO UPDATE A TABLE WITHOUT A WHERE THAT USES A KEY COLUMN
One of my LinkedIn friend got above error while truncating table in MY-SQL, so i suggested er very simplest solution as below,
Ans -
A. What is the jatinhttp://www.blogger.com/profile/12823525541194838677noreply@blogger.com1