tag:blogger.com,1999:blog-52750432481535553962024-02-21T04:23:15.678-08:00CSHARPOCEANAmrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-5275043248153555396.post-68584424043375145442015-06-25T06:16:00.002-07:002015-06-25T06:16:09.193-07:00The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<b>Please click on below URL and execute file on your system.</b><br />
<br />
<br />
<div class="WordSection1">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Segoe UI",sans-serif; font-size: 10.0pt;"><a href="https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734">https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734</a></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Segoe UI",sans-serif; font-size: 10.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Segoe UI",sans-serif; font-size: 10.0pt;">Your welcome in advance :)</span></div>
</div>
</div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-24706771331762464902014-12-15T08:07:00.004-08:002014-12-16T01:50:41.092-08:00Re-sharper 9.<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: 'Times New Roman', serif; font-size: 13.5pt;"><a href="http://2.bp.blogspot.com/-1FVBklUukYo/VI8I-s6_BzI/AAAAAAAAJqw/eVURaUM_xVo/s1600/resharper-8x6.png"><span style="color: blue; text-decoration: none; text-underline: none;"><!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" alt=""
href="http://2.bp.blogspot.com/-1FVBklUukYo/VI8I-s6_BzI/AAAAAAAAJqw/eVURaUM_xVo/s1600/resharper-8x6.png"
style='width:240pt;height:171.75pt' o:button="t"/><![endif]--><!--[if !vml]--><!--[endif]--></span></a><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-1FVBklUukYo/VI8I-s6_BzI/AAAAAAAAJqw/eVURaUM_xVo/s1600/resharper-8x6.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: justify;"><img border="0" src="http://2.bp.blogspot.com/-1FVBklUukYo/VI8I-s6_BzI/AAAAAAAAJqw/eVURaUM_xVo/s1600/resharper-8x6.png" height="229" width="320" /></a></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 24.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">R</span></i><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><b>esharper</b>: <o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<b><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">A Productivity
Tool for Visual Studio.<o:p></o:p></span></i></b></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Hi Everyone, Today I read news that resharper 9
has been released, so thought knowing more details about it. same I am sharing
here which can help you to manage your code in very effective and efficient
manner.<o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<b><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">So what
is resharper?<o:p></o:p></span></i></b></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">as per http://www.jetbrains.com/<o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;">
<i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">It is the one thing for .NET developers that
removes fear of change. Refactoring is just so darn easy that change isn't
scary.<o:p></o:p></span></i></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;">
<b><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Why should we use it?<o:p></o:p></span></i></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;">
<i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">So...Resharper having so many advantages
which I m listing below will help in every dimesion of programming.<o:p></o:p></span></i></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<b><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">ReSharper
Features:</span></i></b></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
<div style="text-align: justify;">
<!--[if !supportLists]--><i><span style="color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: Georgia; mso-fareast-font-family: Georgia;">1.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; font-style: normal;">
</span></span></i><!--[endif]--><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Code quality analysis<o:p></o:p></span></i></div>
</div>
<div style="background: white; line-height: 16.8pt; margin-bottom: 15.0pt; margin-left: .5in; margin-right: 0in; margin-top: 0in; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #797c80; font-family: Georgia, serif; font-size: 11pt;">ReSharper provides continuous code quality
analysis in C#, VB.NET, XAML, XML, ASP.NET, ASP.NET MVC, JavaScript, HTML, and
CSS, detecting errors and problems before you even compile.</span><o:p></o:p></div>
</div>
<div style="background: white; line-height: 16.8pt; margin-bottom: 15.0pt; margin-left: .5in; margin-right: 0in; margin-top: 0in; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #797c80; font-family: Georgia, serif; font-size: 11pt;">ReSharper applies over 1700 code
inspections to your code at design time so you can instantly see whether
your current file or even your whole solution contains any errors or problems.</span><o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
<div style="text-align: justify;">
<!--[if !supportLists]--><i><span style="color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: Georgia; mso-fareast-font-family: Georgia;">1.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; font-style: normal;">
</span></span></i><!--[endif]--><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Eliminate errors and code
smells</span><span style="background: white; color: #797c80; font-size: 15px; line-height: 22.3999996185303px;"><span style="font-family: Georgia, serif;">:</span></span></i></div>
</div>
<div style="background: white; line-height: 16.8pt; margin-bottom: 15.0pt; margin-left: .5in; margin-right: 0in; margin-top: 0in; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #797c80; font-family: Georgia, serif; font-size: 11pt;">ReSharper instantly detects and highlights
errors as you code, right in the editor.</span><span style="color: #797c80; font-family: Georgia, serif; font-size: 15px; line-height: 22.3999996185303px;"> </span><span style="color: #797c80; font-family: Georgia, serif; font-size: 11pt; line-height: 16.8pt;">Errors are highlighted with either red font
or curly underline. If you roll the mouse pointer over an error, its
description is displayed in a tooltip.</span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
<div style="text-align: justify;">
<!--[if !supportLists]--><i><span style="color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: Georgia; mso-fareast-font-family: Georgia;">2.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; font-style: normal;">
</span></span></i><!--[endif]--><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Instantly traverse your
entire solution:<o:p></o:p></span></i></div>
</div>
<div style="background: white; line-height: 16.8pt; margin-bottom: 15.0pt; margin-left: .5in; margin-right: 0in; margin-top: 0in; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #797c80; font-family: Georgia, serif; font-size: 11pt;">Not only is ReSharper capable of analyzing a
specific code file for errors, but it can extend its analysis skills to cover
your whole solution.</span><span style="color: #797c80; font-family: Georgia, serif; font-size: 15px; line-height: 22.3999996185303px;"> </span><span style="color: #797c80; font-family: Georgia, serif; font-size: 11pt; line-height: 16.8pt;">Suppose that you changed the visibility of a
member from public to internal, assuming that it was only used inside the
current assembly. At this stage, ReSharper finds no errors in the current file.
Then, you switch on Solution-Wide Analysis and ReSharper discovers that
something went wrong. You jump to the next error in solution and you find out
that someone used this member from outside of the current assembly.</span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
<div style="text-align: justify;">
<!--[if !supportLists]--><i><span style="color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: Georgia; mso-fareast-font-family: Georgia;">3.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; font-style: normal;">
</span></span></i><!--[endif]--><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Safely change your code base:<o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="background: white; color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";">ReSharper provides</span><span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"> <span style="background: white;"><span style="color: #797c80; text-decoration: none; text-underline: none;">Structural
Search and Replace</span></span> <span style="background: white;">to find custom code constructs and replace them with
other code constructs. What's even more exciting is that it's able to
continuously monitor your solution for your search patterns, highlight code
that matches them, and provide quick-fixes to replace the code according to
your replace patterns.</span><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"><span style="background: white;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
<div style="text-align: justify;">
<!--[if !supportLists]--><i><span style="color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: Georgia; mso-fareast-font-family: Georgia;">4.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; font-style: normal;">
</span></span></i><!--[endif]--><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Code editing helpers:<o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="background: white; color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";">Multiple</span><span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"> <span style="background: white;"><span style="color: #797c80; text-decoration: none; text-underline: none;">code editing
helpers</span></span> <span style="background: white;">including
extended IntelliSense, hundreds of instant code transformations, auto-importing
namespaces, rearranging code and displaying documentation.</span><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"><span style="background: white;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
<div style="text-align: justify;">
<!--[if !supportLists]--><i><span style="color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: Georgia; mso-fareast-font-family: Georgia;">5.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; font-style: normal;">
</span></span></i><!--[endif]--><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Compliance to coding
standards:<o:p></o:p></span></i></div>
</div>
<div style="margin-left: 0.5in;">
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";">Code formatting and cleanup to get
rid of unused code and ensure <span style="color: #797c80; text-decoration: none; text-underline: none;">compliance to
coding standards</span>.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
<div style="text-align: justify;">
<!--[if !supportLists]--><i><span style="color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: Georgia; mso-fareast-font-family: Georgia;">7.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; font-style: normal;">
</span></span></i><!--[endif]--><i><span style="background: white; color: #797c80; font-family: "Georgia","serif"; font-size: 13.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Code generation:<o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";">You don't have to write properties,
overloads, implementations, and comparers by hand: use <span style="color: #797c80; text-decoration: none; text-underline: none;">code generation
actions</span> to handle boilerplate code faster.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<br /></div>
</div>
<h1 style="background: white; margin: 0in 0in 6pt; text-align: justify; vertical-align: baseline;">
<i><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #797c80; font-family: Georgia, serif; font-size: 13pt;">What's
New in ReSharper 9?<span style="font-weight: normal;"><o:p></o:p></span></span></i></h1>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";">ReSharper 9 supports Visual Studio
2015 Preview, C#6.0 and regular expressions; brings more bulk quick-fixes;
vastly improves support for JavaScript & TypeScript; presents a new file
layout editor and navigation actions. It is also based on a new platform,
reducing memory consumption when ReSharper is installed in</span> <span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";">Visual
Studioalong with dotCover, dotTrace, and/or dotMemory.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";">Refrences:<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"><a href="http://www.jetbrains.com/">Link1</a><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
</div>
<div class="MsoNormal" style="margin-left: 0.5in;">
<div style="text-align: justify;">
<span style="color: #797c80; font-family: "Georgia","serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-style: italic; mso-fareast-font-family: "Times New Roman";"><a href="http://translate.google.co.in/translate?hl=en&sl=de&u=http://de.wikipedia.org/wiki/ReSharper&prev=search">Link2</a><o:p></o:p></span></div>
</div>
<div style="text-align: justify;">
</div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-2772925559052945032014-12-15T03:31:00.002-08:002014-12-16T01:50:50.726-08:00Facebook Search and Microsoft Bing....We are not together anymore... :(<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="center" class="separator" style="margin-bottom: .0001pt; margin: 0in; text-align: center;">
<span style="color: blue; font-size: 13.5pt; mso-no-proof: yes; text-decoration: none; text-underline: none;"><!--[if gte vml 1]><v:shapetype id="_x0000_t75"
coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_1" o:spid="_x0000_i1025" type="#_x0000_t75"
alt="https://4.bp.blogspot.com/-NohTI6oD1_g/VI6_8BlkgfI/AAAAAAAAJqQ/LfEvvR7FGx4/s1600/dumped.jpg"
href="http://4.bp.blogspot.com/-NohTI6oD1_g/VI6_8BlkgfI/AAAAAAAAJqQ/LfEvvR7FGx4/s1600/dumped.jpg"
style='width:240pt;height:240pt;visibility:visible;mso-wrap-style:square'
o:button="t">
<v:imagedata src="file:///C:\Users\v-amrjai\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg"
o:title="proxy?url=http%3A%2F%2F4.bp.blogspot.com%2F-NohTI6oD1_g%2FVI6_8BlkgfI%2FAAAAAAAAJqQ%2FLfEvvR7FGx4%2Fs1600%2Fdumped"/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--></span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-NohTI6oD1_g/VI6_8BlkgfI/AAAAAAAAJqQ/LfEvvR7FGx4/s1600/dumped.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-NohTI6oD1_g/VI6_8BlkgfI/AAAAAAAAJqQ/LfEvvR7FGx4/s1600/dumped.jpg" /></a></div>
<h2 style="margin: 0in 0in 0.0001pt; text-align: justify;">
<b><u><span style="background: white; color: #333333; font-family: 'Segoe UI', sans-serif;"><span style="font-size: x-large;">F</span></span><span style="background: white; color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">acebook DUMPED </span><span style="background: white; color: #333333; font-family: 'Segoe UI', sans-serif;"><span style="font-size: x-large;">B</span></span><span style="background: white; color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">ing</span></u></b></h2>
<div style="margin: 0in 0in 0.0001pt; text-align: justify;">
<b><span style="background: white; color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;"><br /></span></b></div>
<div style="margin: 0in 0in 0.0001pt; text-align: justify;">
<b><span style="background: white; color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">Facebook Users</span></b><span style="background: white; color: #333333; font-family: 'Segoe UI', sans-serif; font-size: 13.5pt;">, Its a
Breaking news for you.....Facebook has stopped including results from Microsoft
Corp's Bing search engine on its social networking site.</span></div>
<div style="margin: 0in 0in 0.0001pt; text-align: justify;">
<br /></div>
<div style="margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="background: white; color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">The move, comes as Facebook has revamped its own search
offerings, introducing a tool on Monday that allows users to quickly find past
comments and other information posted by their friends on Facebook.<u1:p></u1:p></span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div style="margin: 0in 0in 0.0001pt; text-align: justify;">
<br /></div>
<div style="margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="background: white; color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">Facebook Chief Executive Mark Zuckerberg has flagged search
as one of the company's key growth initiatives, noting in July that there were
more than 1 billion search queries occurring on Facebook every day and hinting
that the vast amount of information that users share within Facebook could
eventually replace the need to search the Web for answers to certain questions.<u1:p></u1:p></span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div style="margin: 0in 0in 0.0001pt; text-align: justify;">
<br /></div>
<div style="background: white; line-height: 15.75pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">Microsoft's search
engine only kicked in when Facebook's own querying system failed to deliver the
relevant results.<u1:p></u1:p></span></span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div style="background: white; line-height: 19.5pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">Facebook and Microsoft
have a longstanding relationship dating back to Microsoft's $240 million
investment in Facebook, for a 1.6 percent stake in the company, in October
2007. As part of that deal, Microsoft provided banner ads on Facebook's website
in international markets.</span></span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div style="background: white; line-height: 19.5pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<br /></div>
<div style="background: white; line-height: 19.5pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">Facebook stopped using Microsoft banner ads in 2010 as it moved
to take more control of its advertising business. But Facebook, during that
same time, expanded its use of Microsoft Bing search results to international
versions of its service.</span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div style="background: white; line-height: 19.5pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<br /></div>
<div style="background: white; line-height: 15.75pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">But, for nearly two
years now, Microsoft's search function has been unable to ferret around within
Facebook's social graph where the real ad money is understood to be found.<u1:p></u1:p></span></span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div style="background: white; line-height: 15.75pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">And now, as noted by <a href="http://www.reuters.com/article/2014/12/12/us-facebook-microsoft-idUSKBN0JQ2AY20141212" style="cursor: pointer;" target="_blank"><span style="color: #333333; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Reuters</span></a>,
Facebook has altogether dumped Microsoft, following the launch of its <a href="http://www.theregister.co.uk/2014/12/09/facebook_graph_search_mobile/" style="cursor: pointer;" target="_blank"><span style="color: #333333; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">rejigged search
product</span></a> earlier this week.</span></span><span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<div style="background: white; line-height: 15.75pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;"><br />
<!--[if !supportLineBreakNewLine]--><br />
<!--[endif]--></span><span style="font-size: 13.5pt;"></span><o:p></o:p></span></div>
<div style="background: white; line-height: 15.75pt; margin: 0in 0in 0.0001pt; text-align: justify;">
<i><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="color: #333333; font-family: "Segoe UI",sans-serif; font-size: 13.5pt;">Refrences:</span></span><span style="font-size: 13.5pt;"><o:p></o:p></span></i></div>
<br />
<div class="MsoNormal">
<o:p><a href="http://www.techgig.com/tech-news/editors-pick/Facebook-Dumps-Microsoft-Web-Search-Results-27727?mailer_id=2111&utm_source=Mailer&utm_medium=TG_batch&utm_campaign=digest_news_2014-12-14&email=amrit862@gmail.com&activity_name=MjM3OTY=&template_type=3&dt=&auto_login=YW1yaXQ4NjJAZ21haWwuY29tQCMkQCMkOTI3OTI3QCMkQCMkMTM5ODE5NjgwOA==&src_type=autoLogin" target="_blank"><i>Link</i></a></o:p></div>
<div class="MsoNormal">
<i><a href="http://www.msn.com/en-ph/money/other/facebook-dumps-microsoft-web-search-results/ar-BBgIySH" target="_blank">Link</a></i></div>
<div class="MsoNormal">
<a href="http://www.theregister.co.uk/2014/12/13/facebook_ditches_microsoft_bing/" target="_blank"><i>Link</i></a></div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>
<!-- Blogger automated replacement: "https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F4.bp.blogspot.com%2F-NohTI6oD1_g%2FVI6_8BlkgfI%2FAAAAAAAAJqQ%2FLfEvvR7FGx4%2Fs1600%2Fdumped.jpg&container=blogger&gadget=a&rewriteMime=image%2F*" with "https://4.bp.blogspot.com/-NohTI6oD1_g/VI6_8BlkgfI/AAAAAAAAJqQ/LfEvvR7FGx4/s1600/dumped.jpg" -->Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-33750925777933085252014-12-11T04:38:00.000-08:002014-12-16T01:51:02.838-08:00How to repeat header on each page in SSRS.<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
1. Click anywhere on report page.<br />
2. Click On Advanced Mode.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCmaT6zaBBDPuRbuRB92kleDdDI7XtzilUjUX2sQlucU4mIv1qqkHIuJnlxKy9KZVkBdLIjnnBePF7pDTfwSQccZkRkoDftYNuCiZtD8ivpgOhEO8c9NXNdaOuPiRJp-4IeFLBXx1WwEfZ/s1600/ssrs1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCmaT6zaBBDPuRbuRB92kleDdDI7XtzilUjUX2sQlucU4mIv1qqkHIuJnlxKy9KZVkBdLIjnnBePF7pDTfwSQccZkRkoDftYNuCiZtD8ivpgOhEO8c9NXNdaOuPiRJp-4IeFLBXx1WwEfZ/s1600/ssrs1.PNG" height="58" width="400" /></a></div>
<br />
3. Click on Static and see in Property window.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYWvGUVj3UgMgBEHdrVLh_IYlW0QUrfqm47gEozxnFPKjXGs9DoBZjyZJCExn_vhgBITxJYrb-yzbcc6E-TT4Q6i4ouBxPgPYMfdCMo37sUiJmQq2EA1q6_ZazGMusp9fTY5NvnqrhqMnA/s1600/sssrs2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYWvGUVj3UgMgBEHdrVLh_IYlW0QUrfqm47gEozxnFPKjXGs9DoBZjyZJCExn_vhgBITxJYrb-yzbcc6E-TT4Q6i4ouBxPgPYMfdCMo37sUiJmQq2EA1q6_ZazGMusp9fTY5NvnqrhqMnA/s1600/sssrs2.PNG" height="65" width="320" /></a></div>
<br />
4. Make <b>RepeatOnNewPage</b> = True, and you DID IT :)<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRRQnPxWQxQ2p_YovT1dXhU65F85JrecRjv3tEY3uXfoVYgyMsNjMOHKSrf10GKe753rjvrjAl3r4gIgpNLaHam0WmIpopizTK0Z6Jtf8n7_vNJdRslUct_y4blBQZKGE-h9-E55pyrWF_/s1600/sssrs3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRRQnPxWQxQ2p_YovT1dXhU65F85JrecRjv3tEY3uXfoVYgyMsNjMOHKSrf10GKe753rjvrjAl3r4gIgpNLaHam0WmIpopizTK0Z6Jtf8n7_vNJdRslUct_y4blBQZKGE-h9-E55pyrWF_/s1600/sssrs3.PNG" height="191" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br /></div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-6811111532470213062014-12-11T02:23:00.000-08:002014-12-16T01:51:16.315-08:00Pass data to partial view in MVC<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><h3 style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(225, 226, 226); color: #222222; font-family: Consolas, monospace; font-size: 13px; line-height: 18.2112007141113px; margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; text-align: left; vertical-align: baseline; white-space: normal;">
<span style="font-size: small; font-weight: normal;">Refrence Link: </span><a href="http://forums.asp.net/t/1684991.aspx?How+do+I+pass+data+to+Partial+View+" style="font-size: medium; font-weight: normal;" target="_blank">link</a></h3>
</span></pre>
<h2 style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); color: #222222; font-family: Consolas, monospace; font-size: 13px; line-height: 18.2112007141113px; margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; text-align: left; vertical-align: baseline;">
At view:</h2>
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; line-height: 18.2112007141113px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Consolas, monospace;"><div>
<table id="tableDetails">
<tr>
<td rowspan="6">
@Html.Partial("RestaurentAddressPartial", new DiningTable.Models.Address{ Id = 1, Flat = "D-1033", Steet1 = "Devi Homes", Steet2 = "Near Hafeezpet petrol Pump", ZipCode = "500049", City = "Hyderabad" })
</td>
<td rowspan="6">
@Html.Partial("RestaurentAddressPartial", new DiningTable.Models.Address { Id = 1, Flat = "D-1034", Steet1 = "Devi Homes", Steet2 = "Near Hafeezpet petrol Pump", ZipCode = "500049", City = "Hyderabad" })
</td>
</tr>
</table>
</div></span></span></pre>
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; line-height: 18.2112007141113px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Consolas, monospace;">
</span></span></pre>
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; line-height: 18.2112007141113px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><h2 style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); color: #222222; font-family: Consolas, monospace; font-size: 13px; line-height: 18.2112007141113px; margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; text-align: left; vertical-align: baseline;">
<span class="pln" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">At Partial view:</span></h2>
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; line-height: 18.2112007141113px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Consolas, monospace;">@model DiningTable.Models.Address
<h4>Address:</h4>
<p>
@Html.DisplayFor(m => m.Flat)<br />
@Html.DisplayFor(m => m.Steet1)<br />
@Html.DisplayFor(m => m.Steet2)<br />
@Html.DisplayFor(m => m.City)<br />
@Html.DisplayFor(m => m.ZipCode)<br />
</p></span></span></pre>
</span></pre>
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; line-height: 18.2112007141113px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Consolas, monospace;">
</span></span></pre>
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; line-height: 18.2112007141113px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Consolas, monospace;">OutPut:</span></span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7HJ2JYQcy8QptXraoCpeqsxRXioFwPwhf2-nd6e19NApzKx_iwJ1TI8MrzrPiWgQv_qQvAiKwpXSv0BGoZQ6Zi7MxmpK98AojnJY-dG4vmx2v0IkOc-itTPe1HeBphEiImEOrISY74RZZ/s1600/PrtialView.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7HJ2JYQcy8QptXraoCpeqsxRXioFwPwhf2-nd6e19NApzKx_iwJ1TI8MrzrPiWgQv_qQvAiKwpXSv0BGoZQ6Zi7MxmpK98AojnJY-dG4vmx2v0IkOc-itTPe1HeBphEiImEOrISY74RZZ/s1600/PrtialView.PNG" height="140" width="400" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7HJ2JYQcy8QptXraoCpeqsxRXioFwPwhf2-nd6e19NApzKx_iwJ1TI8MrzrPiWgQv_qQvAiKwpXSv0BGoZQ6Zi7MxmpK98AojnJY-dG4vmx2v0IkOc-itTPe1HeBphEiImEOrISY74RZZ/s1600/PrtialView.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<pre class="prettyprint prettyprinted" style="background: rgb(255, 255, 255); border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><pre class="prettyprint prettyprinted" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(225, 226, 226); margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"></pre>
</pre>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-42238716401886690752014-11-28T01:29:00.002-08:002014-12-16T01:51:26.717-08:00How to identify the TFS process template programmatically?<div dir="ltr" style="text-align: left;" trbidi="on">
TfsClientCredentials crd = new TfsClientCredentials(true);<br />
Uri uri = new Uri(this.Context.ConnectionString);<br />
<br />
TfsTeamProjectCollection tfs = new TfsTeamProjectCollection(uri, crd);<br />
<br />
ICommonStructureService css = (ICommonStructureService)tfs.GetService(typeof(ICommonStructureService));<br />
<br />
ProjectInfo projectInfo = css.GetProjectFromName(this.Context.CommandParameters["ProjectName"].ToString());<br />
String projectName;<br />
String prjState;<br />
int templateId = 0;<br />
ProjectProperty[] projectProperties;<br />
<br />
<br />
css.GetProjectProperties(<br />
projectInfo.Uri, out projectName, out prjState, out templateId, out projectProperties);<br />
<br />
Console.WriteLine(<b>projectProperties[2].Value</b>); //This will give you process template name<br />
<br />
<br />
Refrence: <a href="http://stackoverflow.com/questions/1072301/how-to-identify-the-process-template-of-already-created-team-project-using-tfs-s" target="_blank">Link</a></div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-29329511704668513822014-11-25T02:13:00.003-08:002014-12-16T01:51:35.567-08:00Export anything to excel<div dir="ltr" style="text-align: left;" trbidi="on">
protected void LinkProcess_Click(object sender, EventArgs e)<br />
{<br />
try<br />
{<br />
Warning[] warnings;<br />
string[] streamids;<br />
string mimeType;<br />
string encoding;<br />
string extension;<br />
<br />
byte[] bytes = KMIReportViewer.ServerReport.Render(<br />
"Excel", null, out mimeType, out encoding, out extension,<br />
out streamids, out warnings);<br />
<br />
Response.ContentType = "application/ms-excel";<br />
Response.OutputStream.Write(bytes, 0, bytes.Length);<br />
Response.AddHeader("Content-Disposition", "attachment;filename=ReviewFinding.xls");<br />
<br />
}<br />
catch (Exception)<br />
{<br />
}<br />
}</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-75515090485543986102014-11-12T01:56:00.002-08:002014-12-16T01:51:48.753-08:00SQL datediff days except saturday sunday<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background: rgb(255, 255, 255); border: 0px; clear: both; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 1em; padding: 0px; vertical-align: baseline;">
For workdays, Monday to Friday with a single SELECT:</div>
<pre class="lang-sql prettyprint prettyprinted" style="background: rgb(238, 238, 238); border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto; word-wrap: normal;"><code style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">DECLARE</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">StartDate DATETIME
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">DECLARE</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">EndDate DATETIME
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">SET</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">StartDate </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">'2008/10/01'</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">SET</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">EndDate </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">'2008/10/31'</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">DATEDIFF</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">dd</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">StartDate</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">EndDate</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">+</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">-(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">DATEDIFF</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">wk</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">StartDate</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">EndDate</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">*</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">2</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">-(</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">CASE</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">WHEN</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> DATENAME</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">dw</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">StartDate</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">'Sunday'</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">THEN</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">ELSE</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">0</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">END</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">-(</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">CASE</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">WHEN</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> DATENAME</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">dw</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">@</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">EndDate</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">'Saturday'</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">THEN</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">ELSE</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">0</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">END</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span></code></pre>
<pre class="lang-sql prettyprint prettyprinted" style="background: rgb(238, 238, 238); border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto; word-wrap: normal;"><code style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></code></pre>
<pre class="lang-sql prettyprint prettyprinted" style="background: rgb(238, 238, 238); border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto; word-wrap: normal;"><code style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></code></pre>
<pre class="lang-sql prettyprint prettyprinted" style="background: rgb(238, 238, 238); border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto; word-wrap: normal;"><code style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Refrence: <a href="http://stackoverflow.com/questions/252519/count-work-days-between-two-dates" target="_blank">link</a></b></span></code></pre>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-38678014908443846822014-10-30T08:22:00.001-07:002014-12-16T01:59:26.319-08:00ASP.net Sequence of Events in master page, ASP page, user control, nested user-control and control.<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
Here UC: UserControl <span style="text-align: left;">SubUC: Sub UserControl</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="text-align: left;">Refrence: <a href="http://forums.asp.net/t/1191194.aspx?FAQ+Sequence+that+events+are+raised+for+Pages+UserControls+MasterPages+and+HttpModules" target="_blank">Link</a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimTY11fl454Bi0oLklwBnhT2HaSMkYLKxs6uAZ1FOuZUOqvblE-zecyVrYT5uuUmwuyroApeGLT_u44tdAZAoVnGYy-MYhMwMmzMeGUfrk7ooyzZEwFxTK3-To9afwkAVnOnUAZ1J2_EO4/s1600/Even+Sequence.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimTY11fl454Bi0oLklwBnhT2HaSMkYLKxs6uAZ1FOuZUOqvblE-zecyVrYT5uuUmwuyroApeGLT_u44tdAZAoVnGYy-MYhMwMmzMeGUfrk7ooyzZEwFxTK3-To9afwkAVnOnUAZ1J2_EO4/s1600/Even+Sequence.PNG" height="385" width="640" /></a></div>
<br /></div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-39871593288267485202014-09-23T05:44:00.001-07:002014-12-16T01:59:38.377-08:00sql data from rows to columns transpose without pivot<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background: rgb(255, 255, 255); border: 0px; clear: both; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 1em; padding: 0px; vertical-align: baseline;">
PIVOTs need an aggregate function, because you could have multiple entries in the original table. If you know you only have one value per key, then just use MIN().</div>
<div style="background: rgb(255, 255, 255); border: 0px; clear: both; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 1em; padding: 0px; vertical-align: baseline;">
Also, '$row1', '$row2', '$row3' are now columns and need to be delimited like columns</div>
<pre class="lang-sql prettyprint prettyprinted" style="background: rgb(238, 238, 238); border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 17.8048000335693px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto; word-wrap: normal;"><code style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">select</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">*</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">from</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">select</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
name</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">propertyvalue</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> displayname
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">from</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> indexrows
</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> a
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">PIVOT</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
MIN</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">propertyvalue</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">for</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">[</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">displayname</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">]</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">in</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">([$</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">row1</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">],</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">[$</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">row2</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">],</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">[$</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">row3</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">])</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">as</span><span class="pln" style="background: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background: transparent; border: 0px; color: darkblue; margin: 0px; padding: 0px; vertical-align: baseline;">pivot</span></code></pre>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-57714182-1', 'auto');
ga('send', 'pageview');
</script>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-59832803035431926182014-08-22T06:34:00.002-07:002014-12-15T02:13:02.179-08:00How to select all columns except only one column in sql server<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #0b5394;">DECLARE @columnList Varchar(1000), @SQLStatment VARCHAR(4000)</span><br />
<span style="color: #0b5394;">SET @columnList = ''</span><br />
<span style="color: #0b5394;">select @columnList = @columnList + Name + ' , ' from syscolumns where id = object_id('sample_tablename') AND Name != 'Id_columnnames'</span><br />
<span style="color: #0b5394;">SELECT @SQLStatment = 'SELECT ' + Substring(@columnList ,1,len(@columnList)-1) + ' From sample_tablename'</span><br />
<span style="color: #0b5394;">EXEC(@SQLStatment)</span></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-18281646691655686872014-06-06T05:37:00.001-07:002014-12-15T02:13:02.125-08:00Kendo PopUp Resize<div dir="ltr" style="text-align: left;" trbidi="on">
<pre _xml3a_space="preserve" style="background-color: white; padding: 0px;"><span style="color: #000066; font-family: monospace, Courier New, Courier;"><span style="font-size: 12px; line-height: 19px;">$("#kendoUploadPPR").kendoWindow({
actions: ["Maximize", "Close"],
draggable: false,
height: "600px",
modal: true,
pinned: false,
position: {
top: 100,
left: 100
},
resizable: false,
title: "PPR Details",
width: "1000px"
});</span></span></pre>
</div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-65220246184959307162014-06-06T05:32:00.003-07:002014-12-15T02:13:02.194-08:00JavaScript code for checking total document or file size at client side<div dir="ltr" style="text-align: left;" trbidi="on">
// Javascript code for checking total document size.<br />
<br />
var filesize1 = 0;<br />
var filesize2 = 0;<br />
var filesize3 = 0;<br />
var filesize4 = 0;<br />
var filesize5 = 0;<br />
<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '02' + '_fuReuploadPath').bind('change', function () {<br />
filesize1 = Math.round(this.files[0].size / 1024);<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '02' + '_lblFU').text(filesize1 + "KB");<br />
EnableDisableUpdate();<br />
});<br />
<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '03' + '_fuReuploadPath').bind('change', function () {<br />
filesize2 = Math.round(this.files[0].size / 1024);<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '03' + '_lblFU').text(filesize2 + "KB");<br />
EnableDisableUpdate();<br />
});<br />
<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '04' + '_fuReuploadPath').bind('change', function () {<br />
filesize3 = Math.round(this.files[0].size / 1024);<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '04' + '_lblFU').text(filesize3 + "KB");<br />
EnableDisableUpdate();<br />
});<br />
<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '05' + '_fuReuploadPath').bind('change', function () {<br />
filesize4 = Math.round(this.files[0].size / 1024);<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '05' + '_lblFU').text(filesize4 + "KB");<br />
EnableDisableUpdate();<br />
});<br />
<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '06' + '_fuReuploadPath').bind('change', function () {<br />
filesize5 = Math.round(this.files[0].size / 1024);<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '06' + '_lblFU').text(filesize5 + "KB");<br />
EnableDisableUpdate();<br />
});<br />
<br />
function EnableDisableUpdate() {<br />
if ((filesize1 + filesize2 + filesize3 + filesize4 + filesize5) > 10000) {<br />
changeColor('red');<br />
$('#ctl00_ContentPlaceHolder1_btnUpload').attr('disabled', 'disabled');<br />
alert("Document size more than 10 MB please reduce size.");<br />
} else {<br />
changeColor('green');<br />
$('#ctl00_ContentPlaceHolder1_btnUpload').removeAttr('disabled');<br />
}<br />
}<br />
<br />
function changeColor(color) {<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '02' + '_lblFU').css({ color: color });<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '03' + '_lblFU').css({ color: color });<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '04' + '_lblFU').css({ color: color });<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '05' + '_lblFU').css({ color: color });<br />
$('#ctl00_ContentPlaceHolder1_gvReuploadDocs_ctl' + '06' + '_lblFU').css({ color: color });<br />
}<br />
<div>
<br /></div>
</div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-70494102443574555152014-06-06T05:32:00.001-07:002014-12-15T02:13:02.212-08:00Kendo file upload to check file type at client side<div dir="ltr" style="text-align: left;" trbidi="on">
<pre _xml3a_space="preserve" style="background-color: white; color: #000066; font-family: monospace, 'Courier New', Courier; font-size: 12px; line-height: 19px; padding: 0px;"><script type=<span class="highlight-literal" style="color: #cc0000; font-family: inherit; margin: 0px; padding: 0px;">"text/javascript"</span>>
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> <span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">function</span> onUpload(e) {
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> <span class="highlight-comment" style="color: #006633; font-family: inherit; margin: 0px; padding: 0px;">// Array with information about the uploaded files</span>
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> <span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">var</span> files = e.files;
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span>
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> <span class="highlight-comment" style="color: #006633; font-family: inherit; margin: 0px; padding: 0px;">// Check the extension of each file and abort the upload if it is not .jpg</span>
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> $.<span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">each</span>(files, <span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">function</span>() {
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> <span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">if</span> (<span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">this</span>.extension != <span class="highlight-literal" style="color: #cc0000; font-family: inherit; margin: 0px; padding: 0px;">".jpg"</span>) {
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> alert(<span class="highlight-literal" style="color: #cc0000; font-family: inherit; margin: 0px; padding: 0px;">"Only .jpg files can be uploaded"</span>)
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> e.preventDefault();
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> <span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">return</span> <span class="highlight-keyword" style="color: blue; font-family: inherit; margin: 0px; padding: 0px;">false</span>;
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> }
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> });
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span> }
<span class="highlight-spacerShort" style="font-family: inherit; margin: 0px; padding: 0px 5px 0px 0px;"></span></script></pre>
<pre _xml3a_space="preserve" style="background-color: white; color: #000066; font-family: monospace, 'Courier New', Courier; font-size: 12px; line-height: 19px; padding: 0px;"></pre>
<pre _xml3a_space="preserve" style="background-color: white; color: #000066; font-family: monospace, 'Courier New', Courier; font-size: 12px; line-height: 19px; padding: 0px;"></pre>
<pre _xml3a_space="preserve" style="background-color: white; color: #000066; font-family: monospace, 'Courier New', Courier; font-size: 12px; line-height: 19px; padding: 0px;"></pre>
<pre _xml3a_space="preserve" style="background-color: white; color: #000066; font-family: monospace, 'Courier New', Courier; font-size: 12px; line-height: 19px; padding: 0px;"></pre>
<pre _xml3a_space="preserve" style="background-color: white; color: #000066; font-family: monospace, 'Courier New', Courier; font-size: 12px; line-height: 19px; padding: 0px;"></pre>
<pre _xml3a_space="preserve" style="background-color: white; padding: 0px;">
</pre>
</div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-67034470664836752422014-06-06T05:31:00.000-07:002014-12-15T02:13:02.199-08:00Microsoft Excel Application entry missing in DCOMCNFG<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.001800537109375px;">1. Click start button, in start search bar, type in "DCOMCNFG.EXE" (without quote) and then press enter.</span><br />
<span style="background-color: white; color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.001800537109375px;">2. Click Computer->DCOM Config, locate component with CLSID {00024500-0000-0000-C000-000000000046}and modify the permission.</span><br />
<span style="background-color: white; color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.001800537109375px;"><br /></span>
<span style="color: #2a2a2a; font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 14px; line-height: 18.001800537109375px;">00020812-0000-0000-C000-000000000046</span></span><br />
<span style="font-size: 14px; line-height: 18.001800537109375px;"><span style="background-color: white; color: #2a2a2a; font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"></span></span><br />
<span style="color: #2a2a2a; font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 14px; line-height: 18.001800537109375px;">00024500-0000-0000-C000-000000000046</span></span><br />
<span style="background-color: white; color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.001800537109375px;"><br /></span>
<span style="background-color: white; color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.001800537109375px;"><br /></span>
<span style="background-color: white; color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.001800537109375px;"><a href="http://social.technet.microsoft.com/Forums/windows/en-US/dde69147-a01a-4eb1-8ea9-31adbf874bed/microsoft-excel-application-entry-missing-in-dcomcnfg" target="_blank">Link</a></span></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-87750444761846537632014-02-04T04:43:00.004-08:002014-12-15T02:13:02.225-08:00URL Encoding in Reporting Services<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<span style="background-color: white;"><span style="color: #b45f06; font-family: Verdana, sans-serif;"><b>URL Encoding in Reporting Services</b></span></span></h3>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><b><span style="color: #073763;">Refer Below link: </span></b></span><br />
<a href="http://capstonebi.blogspot.com/2010/04/url-encoding-in-reporting-services.html" rel="nofollow" style="background-color: white;" target="_blank"><i>Link</i></a></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-24767749106535458892014-01-28T02:48:00.005-08:002014-12-15T02:13:02.129-08:00RadGrid Does Not Render Opening Table Tag in Visual Studio 2013<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
<span style="color: #274e13; font-family: Verdana, sans-serif;">ANSWER</span></h2>
<h4 style="text-align: left;">
<em><span style="color: #6aa84f;">Add below key in your Web.Config file</span></em></h4>
<h2 style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"> </span></h2>
<div style="text-align: left;">
<span style="color: #660000; font-family: Verdana, sans-serif;"><AppSettings></span></div>
<div style="text-align: left;">
<span style="color: #660000; font-family: Verdana, sans-serif;"> <add key="vs:EnableBrowserLink" value="false" /></span></div>
<div style="text-align: left;">
<span style="color: #660000; font-family: Verdana, sans-serif;"> </AppSettings></span></div>
</div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com1tag:blogger.com,1999:blog-5275043248153555396.post-40947212815613278442013-10-24T07:32:00.001-07:002014-12-15T02:13:02.158-08:00ASP.net Export to excel.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #0b5394; font-family: Verdana, sans-serif;">Hello everyone,</span><br />
<span style="color: #0b5394; font-family: Verdana, sans-serif;"> </span><br />
<span style="color: #0b5394; font-family: Verdana, sans-serif;">Today I am explaining about different approaches for exporting data from ASP.Net web page to Excel.</span><br />
<span style="color: #0b5394; font-family: Verdana, sans-serif;"> </span><br />
<span style="color: #0b5394; font-family: Verdana, sans-serif;">So, there are 3 approaches by which we can export data to excel.</span><br />
<ol style="text-align: left;">
<li><span style="color: #0b5394; font-family: Verdana;">Export using HTML writer.</span></li>
<li><span style="color: #0b5394; font-family: Verdana;">Export With the help of Telerik controls.</span></li>
<li><span style="color: #0b5394; font-family: Verdana;">Export <span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">using</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> Microsoft.Office.Interop.Excel.</span></span></span></li>
</ol>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<strong><span style="color: #0b5394;">1.</span> </strong><span style="color: #0b5394; font-family: Verdana;"><strong>Export using HTML writer: </strong>very simple approach but the problem is you can export, but you can not import using OLEDB connecting. If you just want to export data and you are sure that it is never going to be imported than you can use this approach.</span></div>
<span style="color: #0b5394; font-family: Verdana;"></span><br />
<span style="color: #0b5394; font-family: Verdana;"><strong>2. Export With the help of Telerik controls:</strong></span><br />
<span style="color: #0b5394; font-family: Verdana;">This approach is also very good approach, but limitation is, If you want more than one sheet in out file then <em>as per my understanding</em> it is not possible.</span><br />
<span style="font-family: Verdana, sans-serif;"> <strong> </strong></span><br />
<div style="text-align: left;">
<span style="color: #0b5394;"><span style="font-family: Verdana, sans-serif;"> <strong>3.Export using Microsoft.Office.Interop.Excel:</strong></span> </span></div>
<div style="text-align: left;">
<span style="color: #0b5394; font-family: Verdana, sans-serif;">This approach works always but need little hard work.</span></div>
<div style="text-align: left;">
<span style="color: #0b5394; font-family: Verdana;"></span> </div>
<div style="text-align: left;">
<span style="color: #0b5394; font-family: Verdana;"></span> </div>
<div style="text-align: left;">
<span style="color: #0b5394; font-family: Verdana;"></span> </div>
<div style="text-align: left;">
<span style="color: #0b5394; font-family: Verdana;"></span> </div>
<div style="text-align: left;">
<em>For more details on this you can ask questions in comment section.</em> </div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<em>Related code will post soon on this blog Keep tune :)</em></div>
</div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com1tag:blogger.com,1999:blog-5275043248153555396.post-17086837788834594462013-10-18T06:30:00.000-07:002014-12-15T02:13:02.120-08:00Read Excel Cell value using OLEDB connection.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">string</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> documentPath = </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">ConfigurationManager</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">.AppSettings[</span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"SiaTempPath"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">] + </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"SIATemp.xlsb"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">;</span></span><br />
<br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"></span> </span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">string</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> connectionString = </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> + documentPath +</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">
</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">";Extended Properties=\"Excel 12.0;IMEX=1;HDR=NO;TypeGuessRows=0;ImportMixedTypes=Text\""</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">;</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">
</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">OleDbConnection</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> connection = </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">new</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">OleDbConnection</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">(connectionString);</span></span></span> </span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: green; font-family: Consolas;"><span style="color: green; font-family: Consolas;"><span style="color: green; font-family: Consolas;">// open connection to excel file</span></span></span><br />
<span style="color: green; font-family: Consolas;"><span style="color: green; font-family: Consolas;"><span style="color: green; font-family: Consolas;">
<span style="color: #2b91af;">connection.Open();</span></span></span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"></span></span></span><br />
<span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">OleDbCommand</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> cmd = </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">new</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">OleDbCommand</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">();</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">
</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">OleDbDataAdapter</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> adapter = </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">new</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">OleDbDataAdapter</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">();</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">
</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">DataSet</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> ds = </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">new</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">DataSet</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">();</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">
</span></span><br />
<span style="font-family: Consolas;"></span><br />
<br />
<span style="font-family: Consolas;"><span style="color: #38761d;">// webconfig entry: <span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;"><</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;">add</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;">key</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;">=</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">"</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="background-color: yellow; font-family: Consolas;">SiaCellCoordinates</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">"</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;">value</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;">=</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">"</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;">D19</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">"</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="font-family: Consolas;"> /></span></span></span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">string</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> siaCoordinate = </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">ConfigurationManager</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">.AppSettings[</span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"SiaCellCoordinates"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">].ToString();</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">
</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"> cmd.CommandText = </span></span><span style="background-color: yellow;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"SELECT * FROM [SIA$"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> + siaCoordinate + </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">":"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> + siaCoordinate + </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"]"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">;</span></span></span><br />
<br />
<span style="font-family: Consolas;"><br />
<span style="font-family: Consolas;">
<br />
cmd.Connection = connection;<br />
</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><span style="color: #38761d; font-family: Consolas;">// code to assign command for OleDbDataAdapter</span></span></span><br />
<span style="color: green; font-family: Consolas;"><span style="color: green; font-family: Consolas;"><span style="color: green; font-family: Consolas;">
</span></span></span><br />
<span style="font-family: Consolas;"><br />
<span style="font-family: Consolas;"><br />
adapter.SelectCommand = cmd;<br />
</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> ds.Tables.Add(</span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"xlsImport"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">, </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"Excel"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">);</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">
</span></span><br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;"> adapter.Fill(ds, </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"xlsImport"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">);</span></span><br />
<span style="font-family: Consolas;"></span><br />
<span style="background-color: yellow; font-family: Consolas;">//Required Value</span><br />
<span style="background-color: yellow;"><span style="font-family: Consolas;"><span style="font-family: Consolas;">ds.Tables[</span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"xlsImport"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">].Rows[0][0].ToString()</span></span></span><br />
<span style="font-family: Consolas;"></span><br />
<span style="background-color: white; font-family: Consolas;"></span><br />
<span style="background-color: white; font-family: Consolas;">______________________________________________________________</span><br />
<span style="background-color: white; font-family: Consolas;">Enjoy Coding ;-)</span></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com1tag:blogger.com,1999:blog-5275043248153555396.post-9474083111199837382013-10-16T07:34:00.001-07:002014-12-15T02:13:02.230-08:00File upload control as read only<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><span style="color: #b45f06;"><em>I want my File upload control as read only, so that no one can edit file upload text box. However I could select file using browse button. Write code</em></span></strong> <br />
<br />
<div style="text-align: left;">
<span style="color: #38761d;"><span class="code-keyword"><</span><span class="code-leadattribute">asp:fileupload</span> <span class="code-attribute">id</span><span class="code-keyword">="</span><span class="code-keyword">FileUpload1"</span> <span class="code-attribute">runat</span><span class="code-keyword">="</span><span class="code-keyword">server"</span> <span style="background-color: yellow;"><span class="code-attribute">onkeydown</span><span class="code-keyword">="</span><span class="code-keyword">javascript:return false;"</span></span> <span class="code-attribute">xmlns:asp</span><span class="code-keyword">="</span><span class="code-keyword">#unknown"</span> <span class="code-keyword">/</span><span class="code-keyword">></span></span></div>
</div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-62470313301126659262013-05-08T23:20:00.002-07:002014-12-15T02:13:02.186-08:00TELERIK: Search filter water mark fix.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><u>C# CODE:</u></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">protected</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">void</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> gvProjectsList_OnItemDataBound(</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">object</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> sender, </span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">GridItemEventArgs</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> e)</span></span><br />
{<br />
<span style="font-family: Consolas; font-size: x-small;">if<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (e.Item </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">is</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">GridFilteringItem</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"><br />
{<br />
<span style="color: #2b91af;">GridFilteringItem</span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> filerItem = (</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">GridFilteringItem</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)e.Item;</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">TextBox</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> textItem = (</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">TextBox</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)filerItem[</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"ProjectNameFilter"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">].Controls[0];</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">if</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">string</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">.IsNullOrEmpty(textItem.Text))</span></span><br />
{<br />
textItem.Text = <span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">@"Search project Name..."</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">;</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">textItem.Attributes.Add(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"onBlur"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">, </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"return SetMessage("</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> + textItem.ClientID + </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">");"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">);</span></span><br />
<br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">} </span></span></span> </span>textItem.Attributes.Add(<span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"onFocus"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">, </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"return ClearMessage("</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> + textItem.ClientID + </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">");"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">);</span></span><br />
} <br />
<br />
}<br />
<br />
<span style="font-family: Consolas; font-size: x-small;"> </span></span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><u>SCRIPT CODE:</u></span><br />
<br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">script</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">language</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="javascript"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">type</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="text/javascript"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;">//code to hide/show water mark on search box.</span></span></span><br />
<span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">function</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> ClearMessage(obj) {</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">if</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (obj.value == </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"Search project Name..."</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> obj.value = </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">""</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">;</span></span><br />
}<br />
<br />
<span style="font-family: Consolas; font-size: x-small;"><span style="color: blue;">function</span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> SetMessage(obj) {</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">if</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (obj.value == </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">""</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">obj.value = </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"Search project Name..."</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">;</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><br />
}<br />
</span><span style="color: blue;"></</span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">script</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;">
<br />
<br />
</span><br /></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><br />
<span style="font-family: Consolas; font-size: x-small;"><br />
<br />
<br />
</span><br /></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-44837487330089442182013-05-08T23:15:00.002-07:002014-12-15T02:13:02.167-08:00TELERIK: Search with dropddown option.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">GRID BOUND COLUMN: </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"></span></span></span></span></span><br />
<br />
<br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">GridBoundColumn</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">UniqueName</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="emname"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">DataField</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="EM"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">HeaderText</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="EM"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">HeaderStyle-Width</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="70px"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">FilterTemplate</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">RadComboBox</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">ID</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="RadComboBoxEM"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">DataSourceID</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="sdsEmList"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">DataTextField</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="emname"</span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">DataValueField</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="emname"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">Height</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="200px"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">Width</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="90"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">AppendDataBoundItems</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="true"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">SelectedValue</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">='</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"><%</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">#</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> ((</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">GridItem</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)Container).OwnerTableView.GetColumn(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"emname"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">).CurrentFilterValue %></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">'</span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">runat</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="server"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">OnClientSelectedIndexChanged</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="TitleIndexChangedEM"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">HeaderStyle-Width</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="60px"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">Items</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">RadComboBoxItem</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">Text</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="All"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">/></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">Items</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">RadComboBox</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">RadScriptBlock</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">ID</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="RadScriptBlockEM"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">runat</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="server"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">script</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">type</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="text/javascript"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">function</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> TitleIndexChangedEM(sender, args) {</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">var</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> tableView = $find(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"><%</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">#</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> ((</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">GridItem</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)Container).OwnerTableView.ClientID %></span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">);</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> tableView.filter(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"emname"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">, args.get_item().get_value(), </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"EqualTo"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">);</span></span><br />
<br />
<span style="font-family: Consolas; font-size: x-small;"><br />
<span style="font-family: Consolas; font-size: x-small;">
<br />
}<br />
</span><br /></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">script</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">RadScriptBlock</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">FilterTemplate</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">GridBoundColumn</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;">DATA SOURCE:</span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">asp</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">SqlDataSource</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">ID</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="sdsEmList"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">runat</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="server"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">ConnectionString</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"><%</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">$ ConnectionStrings:MGSIProcessConnectionString </span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">%></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">SelectCommand</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="select distinct em.employeename as emname,em.EmployeeId from Project p</span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">join Employee em on em.EmployeeId=p.emid<br />
order by emname"></<span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">asp</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">SqlDataSource</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span></span> </span><br />
</span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span> </div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-60507464147538052392013-05-08T23:12:00.001-07:002014-12-15T02:13:02.183-08:00TELERIK: make telerik search case sensitive <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">telerik</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">:</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">RadGrid</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">ID</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="gvProjectsList"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">runat</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="server"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">MasterTableView-ShowHeadersWhenNoRecords</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="true"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">AllowMultiRowSelection</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="false"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">AutoGenerateColumns</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="false"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">EnableViewState</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="true"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">MasterTableView-</span></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">ImagesPath</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="~/Skins/Vista/Grid"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">OnItemCommand</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="GvProjectsList_ItemCommand"></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="background-color: yellow;"><strong><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">GroupingSettings</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">CaseSensitive</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="false"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">/></span></span></span></strong></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">PagerStyle</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">Mode</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">="NextPrevAndNumeric"></</span></span></span><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;"><span style="color: maroon; font-family: Consolas; font-size: x-small;">PagerStyle</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-8359840600475620612013-04-05T03:27:00.002-07:002014-12-15T02:13:02.221-08:00Master Page Error<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><span style="color: red;">Problem:</span></strong><br />
<strong><span style="color: #3d85c6;">Master Page Error</span></strong><br />
<span style="color: #3d85c6;">The Master Page file '~/MyProject.Master' cannot be loaded.</span><br />
<span style="color: #3d85c6;">Correct the problem in Code View</span><br />
<br />
<br />
<strong><span style="color: #93c47d;">Solution:</span></strong><br />
<span style="color: #3d85c6;">First closed all files in the project and closed the Visual Studio.</span><br />
<span style="color: #3d85c6;">Then run <code><span style="color: orange;">devenv.exe /resetsettings</span></code> at the command line. :)</span></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0tag:blogger.com,1999:blog-5275043248153555396.post-14774838990011982952013-04-03T03:46:00.001-07:002014-12-15T02:13:02.114-08:00SSRS datatype conversion<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://msdn.microsoft.com/en-us/library/cc281083(v=sql.100).aspx">http://msdn.microsoft.com/en-us/library/cc281083(v=sql.100).aspx</a></div>
Amrit jainhttp://www.blogger.com/profile/03467824033547253515noreply@blogger.com0