Comments by Mahendra Vishwakarma

Mahendra Vishwakarma 5-Mar-13 12:35pm View

Hello Sir, I tried but its not working!!

Mahendra Vishwakarma 4-Mar-13 9:53am View

Thanks for posting your answer but I dont think it will work as its not mandatory that user will select the filter, what if niether InternalContact nor MyContactActivity filter is selected. will above WHERE caluse will return the out put.

Mahendra Vishwakarma 2-Mar-13 13:56pm View

Please find the below sample data in tbl_Contacts having.

EmployeeID ContactName RoleType Email Location Office

12 A ATM A@gmail.com India Delhi

13 B ATM B@gmail.com US Montevale

14 C ATM C@gmail.com UK Londan

15 D AM D@gmail.com UK Englend

There can also aplly other filters like Location or Offcies and its not mandatory that InternalConatct and MyContactActivites filter will be applied.

Mahendra Vishwakarma 2-Mar-13 13:21pm View

Thanks for replying me! but this will not work because suppose we have selected both filter @InternalContact and @MyContactActivities from UI then it will not give you any result if both filter are having different employeeid, wehre as it should display both person details.

Mahendra Vishwakarma 4-Feb-11 11:11am View

Deleted

if you are working an application, we always have somthing in mind for readability and performance both so if you are in a sitution like you want choose one in that then I think you have to go with performance not with readability factor...

//if you are using this and facing performance issues,please do not use it just for readability factor.
if (!String.IsNullOrEmpty(someString)) {//do something with someString...}or:

Mahendra Vishwakarma 31-Jan-11 2:45am View

Deleted

@Deeksha Shenoy: The best practice is whenever your are using string variable, you have to initialize it with empty value...like someString="";

Mahendra Vishwakarma 21-Jan-11 2:23am View

Deleted

thease are the points which will improve your query performance specially point no 2, generaly we always ignore these things....these are minor but more importent as per my knowledge..

Mahendra Vishwakarma 18-Jan-11 5:09am View

Deleted

@Murrali...thanks for suggestion, I'll try to do it asap...

Mahendra Vishwakarma 18-Jan-11 4:59am View

Deleted

@Chris Hey....thanks for such comment...
Here we see how you can check for empty strings in the C# programming language and compare the performance of each approach.
Equality operator ==: 796 ms
string.Equals: 811 ms
string.IsNullOrEmpty: 312 ms
Length: 140 ms [fastest]
Instance Equals: 1077 ms

Comments by Mahendra Vishwakarma (Top 9 by date)