<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-456486875723170594</id><updated>2024-09-07T02:17:57.717+06:00</updated><category term="C#"/><category term=".NET"/><category term="CSV"/><category term="Database Suspect Solution"/><category term="LINQ"/><category term="Oracle"/><category term="Sql Injection"/><category term="Sql Server"/><category term="Sql Server 7"/><category term="XML"/><category term="autorun.inf"/><category term="pen drive"/><category term="windows search"/><title type='text'>Mi</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>10</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-3859737507850572517</id><published>2020-06-04T13:54:00.005+06:00</published><updated>2020-06-10T19:37:53.800+06:00</updated><title type='text'>Crystal Report FAQ Error and Fixes</title><content type='html'>&lt;!DOCTYPE html&gt;
&lt;html&gt;

&lt;head&gt;
  &lt;meta charset=&quot;utf-8&quot;&gt;
  &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
  &lt;title&gt;CrystalReports&lt;/title&gt;
  &lt;link rel=&quot;stylesheet&quot; href=&quot;https://stackedit.io/style.css&quot; /&gt;
&lt;/head&gt;

&lt;body class=&quot;stackedit&quot;&gt;
  &lt;div class=&quot;stackedit__html&quot;&gt;&lt;h1 id=&quot;crystal-report&quot;&gt;Crystal Report&lt;/h1&gt;
&lt;h2 id=&quot;versions&quot;&gt;Versions:&lt;/h2&gt;
&lt;p&gt;&lt;a href=&quot;https://www.crystalreports.com/&quot;&gt;CrystalReports.com&lt;/a&gt;&lt;br&gt;
&lt;a href=&quot;https://www.crystalreports.com/download/&quot;&gt;CrystalReports.com/download/&lt;/a&gt;&lt;br&gt;
&lt;a href=&quot;https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads&quot;&gt;Crystal Reports, Developer for Visual Studio Downloads&lt;/a&gt;&lt;/p&gt;
&lt;h2 id=&quot;common-errors&quot;&gt;Common Errors&lt;/h2&gt;
&lt;p&gt;for runtime version: 13.0.22.2668&lt;/p&gt;
&lt;hr&gt;
&lt;h3 id=&quot;error-failed-to-load-database-information.&quot;&gt;Error: Failed to load database information.&lt;/h3&gt;
&lt;h4 id=&quot;details&quot;&gt;Details:&lt;/h4&gt;
&lt;p&gt;Error in File rpt*** 17596_15752_{FC2EA1BF-082D-4345-947E-BE235A441BFD}.rpt: Failed to load database information.&lt;/p&gt;
&lt;h4 id=&quot;details-1&quot;&gt;Details:&lt;/h4&gt;
&lt;pre class=&quot; language-csharp&quot;&gt;&lt;code class=&quot;prism  language-csharp&quot;&gt;System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpExceptionThe file &lt;span class=&quot;token string&quot;&gt;&#39;/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx&#39;&lt;/span&gt; does not exist&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;

System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;HttpException&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;0x80004005&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt; The file &lt;span class=&quot;token string&quot;&gt;&#39;/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx&#39;&lt;/span&gt; does not exist&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Util&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;CheckVirtualFileExists&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;VirtualPath virtualPath&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Compilation&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;BuildManager&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;GetVPathBuildResultInternal&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;VirtualPath virtualPath&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean noBuild&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean allowCrossApp&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean allowBuildInPrecompile&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean throwIfNotFound&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean ensureIsUpToDate&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Compilation&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;BuildManager&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;GetVPathBuildResultWithNoAssert&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;HttpContext context&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; VirtualPath virtualPath&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean noBuild&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean allowCrossApp&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean allowBuildInPrecompile&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean throwIfNotFound&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean ensureIsUpToDate&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Compilation&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;BuildManager&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;GetVirtualPathObjectFactory&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;VirtualPath virtualPath&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; HttpContext context&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean allowCrossApp&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean throwIfNotFound&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Compilation&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;BuildManager&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;CreateInstanceFromVirtualPath&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;VirtualPath virtualPath&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Type requiredBaseType&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; HttpContext context&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean allowCrossApp&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageHandlerFactory&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;GetHandlerHelper&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;HttpContext context&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; String requestType&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; VirtualPath virtualPath&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; String physicalPath&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageHandlerFactory&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;GetHandler&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;HttpContext context&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; String requestType&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; String virtualPath&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; String path&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;MaterializeHandlerExecutionStep&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;IExecutionStep&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;Execute&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ExecuteStepImpl&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;IExecutionStep step&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ExecuteStep&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;IExecutionStep step&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean&lt;span class=&quot;token operator&quot;&gt;&amp;amp;&lt;/span&gt; completedSynchronously&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;
&lt;h4 id=&quot;solution&quot;&gt;Solution:&lt;/h4&gt;
&lt;p&gt;Open IIS Manager &amp;gt;&amp;gt; Select the Application Pool &amp;gt;&amp;gt; right click &amp;gt;&amp;gt; Advanced Settings… set Properties:&lt;/p&gt;
&lt;blockquote&gt;
&lt;p&gt;Enable 32-bit application: &lt;strong&gt;True&lt;/strong&gt;&lt;/p&gt;
&lt;/blockquote&gt;
&lt;p&gt;in some previous solutions it was also suggested to set, which is not required for this version&lt;/p&gt;
&lt;blockquote&gt;
&lt;p&gt;Managed Pipeline Mode: &lt;strong&gt;Classic&lt;/strong&gt;&lt;/p&gt;
&lt;/blockquote&gt;
&lt;hr&gt;
&lt;h3 id=&quot;error-load-report-failed.&quot;&gt;Error: Load report failed.&lt;/h3&gt;
&lt;h4 id=&quot;details-2&quot;&gt;Details:&lt;/h4&gt;
&lt;pre class=&quot; language-csharp&quot;&gt;&lt;code class=&quot;prism  language-csharp&quot;&gt;ScriptResource&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;axd&lt;span class=&quot;token operator&quot;&gt;?&lt;/span&gt;d&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;QW8KkIz&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;pfuZFObs4VS19ZaG2pINCKEPYLXe&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;h2O9wLfX2cCA8E1&lt;span class=&quot;token operator&quot;&gt;&amp;amp;&lt;/span&gt;t&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;ffffffff9a9577e8&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;5&lt;/span&gt; Uncaught Sys&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebForms&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageRequestManagerServerErrorException&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt; Sys&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebForms&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageRequestManagerServerErrorException&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt; Load report failed&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;
    at Function&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Error&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;create&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;http&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;localhost&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;gsk&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;ScriptResource&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;axd&lt;span class=&quot;token operator&quot;&gt;?&lt;/span&gt;d&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;NJmAwtEo3Ipnlaxl6CMhvpGWnaSegNDTQAncPVSJDNDLj1OLpzAX_FYDLdG1YlsayalcHRCGWNiHD5csDhGoCjn4P0YMlI9VaRONlnqj9MlMs2ik2WqOBZBkuaNk4Eegty1miXm2SZHxETxUtBxMS3WHwesaZ&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;Q0ilYGcsjVnQ41&lt;span class=&quot;token operator&quot;&gt;&amp;amp;&lt;/span&gt;t&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;ffffffff9a9577e8&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;5&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;2736&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
    at Sys&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebForms&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageRequestManager&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;_createPageRequestManagerServerError&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;http&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;localhost&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;gsk&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;ScriptResource&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;axd&lt;span class=&quot;token operator&quot;&gt;?&lt;/span&gt;d&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;QW8KkIz&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;pfuZFObs4VS19ZaG2pINCKEPYLXe&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;h2O9wLfX2cCA8E1&lt;span class=&quot;token operator&quot;&gt;&amp;amp;&lt;/span&gt;t&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;ffffffff9a9577e8&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;5&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;11490&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
    at Sys&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebForms&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageRequestManager&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;_parseDelta&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;http&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;localhost&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;gsk&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;ScriptResource&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;axd&lt;span class=&quot;token operator&quot;&gt;?&lt;/span&gt;d&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;QW8KkIz&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;pfuZFObs4VS19ZaG2pINCKEPYLXe&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;h2O9wLfX2cCA8E1&lt;span class=&quot;token operator&quot;&gt;&amp;amp;&lt;/span&gt;t&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;ffffffff9a9577e8&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;5&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;29608&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
    at Sys&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebForms&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageRequestManager&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;_onFormSubmitCompleted&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;http&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;localhost&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;gsk&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;ScriptResource&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;axd&lt;span class=&quot;token operator&quot;&gt;?&lt;/span&gt;d&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;QW8KkIz&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;pfuZFObs4VS19ZaG2pINCKEPYLXe&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;h2O9wLfX2cCA8E1&lt;span class=&quot;token operator&quot;&gt;&amp;amp;&lt;/span&gt;t&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;ffffffff9a9577e8&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;5&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;25637&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
    at Array&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;&amp;lt;&lt;/span&gt;anonymous&lt;span class=&quot;token operator&quot;&gt;&amp;gt;&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;http&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;localhost&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;gsk&lt;span class=&quot;token operator&quot;&gt;/&lt;/span&gt;ScriptResource&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;axd&lt;span class=&quot;token operator&quot;&gt;?&lt;/span&gt;d&lt;span class=&quot;token operator&quot;&gt;=&lt;/span&gt;NJmA&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;
&lt;h4 id=&quot;reason&quot;&gt;Reason:&lt;/h4&gt;
&lt;p&gt;Crystal Report files are not present in the target location, which might have left-out during build and publishing application&lt;/p&gt;
&lt;h4 id=&quot;solution-1&quot;&gt;Solution:&lt;/h4&gt;
&lt;p&gt;Open Visual Studio, select all the CrystalReport.rpt files, right click to set Properties&quot;&lt;/p&gt;
&lt;blockquote&gt;
&lt;p&gt;&lt;strong&gt;Build Action: Content&lt;/strong&gt; (can also be Embedded Resource)&lt;br&gt;
&lt;strong&gt;CopyToOutputDirectory: Always&lt;/strong&gt; (can also be Copy if Newer)&lt;/p&gt;
&lt;/blockquote&gt;
&lt;hr&gt;
&lt;h3 id=&quot;error-validation-of-0viewstate-mac-failed&quot;&gt;Error: Validation of 0viewstate MAC failed&lt;/h3&gt;
&lt;h4 id=&quot;details-3&quot;&gt;Details:&lt;/h4&gt;
&lt;pre class=&quot; language-csharp&quot;&gt;&lt;code class=&quot;prism  language-csharp&quot;&gt;Sys&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebForms&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageRequestManagerServerErrorException&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt; Sys&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebForms&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PageRequestManagerServerErrorException&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt; Validation of 0viewstate MAC failed&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt; If &lt;span class=&quot;token keyword&quot;&gt;this&lt;/span&gt; application &lt;span class=&quot;token keyword&quot;&gt;is&lt;/span&gt; hosted by a Web Farm or cluster&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; ensure that &lt;span class=&quot;token operator&quot;&gt;&amp;lt;&lt;/span&gt;machineKey&lt;span class=&quot;token operator&quot;&gt;&amp;gt;&lt;/span&gt; configuration specifies the same validationKey and validation algorithm&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt; AutoGenerate cannot be used &lt;span class=&quot;token keyword&quot;&gt;in&lt;/span&gt; a cluster&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;
&lt;h4 id=&quot;solution-2&quot;&gt;Solution:&lt;/h4&gt;
&lt;p&gt;Run following commands:&lt;/p&gt;
&lt;pre class=&quot; language-bash&quot;&gt;&lt;code class=&quot;prism  language-bash&quot;&gt;&lt;span class=&quot;token function&quot;&gt;cd&lt;/span&gt; /d %windir%\Microsoft.NET\Framework64\v4.0.30319
&lt;span class=&quot;token function&quot;&gt;cd&lt;/span&gt; /d %windir%\Microsoft.NET\Framework\v4.0.30319
aspnet_regiis -ga &lt;span class=&quot;token string&quot;&gt;&quot;IIS APPPOOL\DefaultAppPool&quot;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;Ref: &lt;a href=&quot;https://support.microsoft.com/en-us/help/2915218/resolving-view-state-message-authentication-code-mac-errors&quot;&gt;https://support.microsoft.com/en-us/help/2915218/resolving-view-state-message-authentication-code-mac-errors&lt;/a&gt;&lt;/p&gt;
&lt;hr&gt;
&lt;h3 id=&quot;error-cannot-resolve-the-collation-conflict-between-latin1_general_ci_as&quot;&gt;Error: Cannot resolve the collation conflict between “Latin1_General_CI_AS”&lt;/h3&gt;
&lt;h4 id=&quot;message&quot;&gt;Message:&lt;/h4&gt;
&lt;p&gt;System.Data.SqlClient.SqlException&lt;br&gt;
Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.&lt;/p&gt;
&lt;h4 id=&quot;details-4&quot;&gt;Details:&lt;/h4&gt;
&lt;pre class=&quot; language-csharp&quot;&gt;&lt;code class=&quot;prism  language-csharp&quot;&gt;System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;HttpUnhandledException&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;0x80004005&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt; Exception of type &lt;span class=&quot;token string&quot;&gt;&#39;System.Web.HttpUnhandledException&#39;&lt;/span&gt; was thrown&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt; &lt;span class=&quot;token operator&quot;&gt;--&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;&amp;gt;&lt;/span&gt; System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Data&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;SqlClient&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;SqlException&lt;/span&gt; &lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;0x80131904&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt; Cannot resolve the collation conflict between &lt;span class=&quot;token string&quot;&gt;&quot;Latin1_General_CI_AS&quot;&lt;/span&gt; and &lt;span class=&quot;token string&quot;&gt;&quot;SQL_Latin1_General_CP1_CI_AS&quot;&lt;/span&gt; &lt;span class=&quot;token keyword&quot;&gt;in&lt;/span&gt; the equal to operation&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;
   at HR3PLO_GSK&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;DAL&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PPP&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;ReportsDAL&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;getMontlyHeadCountData&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;String year&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;token keyword&quot;&gt;in&lt;/span&gt; E&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;\Ismail\GitLab\HR3PLO_GSK\src\HR3PLO_GSK&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;DAL\PPP\ReportsDAL&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;cs&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;line &lt;span class=&quot;token number&quot;&gt;809&lt;/span&gt;
   at HR3PLO_GSK&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Reports&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;PPP&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Viewer&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;rptMonthlyHeadCount&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ShowReport&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;String year&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;token keyword&quot;&gt;in&lt;/span&gt; E&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;\Ismail\GitLab\HR3PLO_GSK\src\HR3PLO_GSK&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebApp\Reports\PPP\Viewer\rptMonthlyHeadCount&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;aspx&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;cs&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;line &lt;span class=&quot;token number&quot;&gt;36&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebControls&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Button&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;OnClick&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;EventArgs e&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;WebControls&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Button&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;RaisePostBackEvent&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;String eventArgument&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Page&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ProcessRequestMain&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;Boolean includeStagesBeforeAsyncPoint&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean includeStagesAfterAsyncPoint&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
ClientConnectionId&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;bb052ba2&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;5fec&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;4f05&lt;span class=&quot;token number&quot;&gt;-8024&lt;/span&gt;&lt;span class=&quot;token operator&quot;&gt;-&lt;/span&gt;288e5926b29b
Error Number&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;468&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt;State&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;9&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt;Class&lt;span class=&quot;token punctuation&quot;&gt;:&lt;/span&gt;&lt;span class=&quot;token number&quot;&gt;16&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Page&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;HandleError&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;Exception e&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Page&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ProcessRequestMain&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;Boolean includeStagesBeforeAsyncPoint&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean includeStagesAfterAsyncPoint&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Page&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ProcessRequest&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;Boolean includeStagesBeforeAsyncPoint&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean includeStagesAfterAsyncPoint&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Page&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ProcessRequest&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;UI&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Page&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ProcessRequest&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;HttpContext context&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;CallHandlerExecutionStep&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;IExecutionStep&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;Execute&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ExecuteStepImpl&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;IExecutionStep step&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
   at System&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;Web&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;HttpApplication&lt;span class=&quot;token punctuation&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;token function&quot;&gt;ExecuteStep&lt;/span&gt;&lt;span class=&quot;token punctuation&quot;&gt;(&lt;/span&gt;IExecutionStep step&lt;span class=&quot;token punctuation&quot;&gt;,&lt;/span&gt; Boolean&lt;span class=&quot;token operator&quot;&gt;&amp;amp;&lt;/span&gt; completedSynchronously&lt;span class=&quot;token punctuation&quot;&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;
&lt;h4 id=&quot;cause&quot;&gt;Cause:&lt;/h4&gt;
&lt;p&gt;This issue occurs because the collations of the catalog databases for Azure SQL Database differ from the collations of the replication databases at the publisher and the subscriber.&lt;/p&gt;
&lt;h4 id=&quot;solution-3&quot;&gt;Solution:&lt;/h4&gt;
&lt;p&gt;This issue is fixed in the following updates:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;https://support.microsoft.com/en-us/help/3164674&quot;&gt;Cumulative Update 1 for SQL Server 2016&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://support.microsoft.com/en-us/help/3144517&quot;&gt;Cumulative Update 13&lt;/a&gt; for SQL Server 2014&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://support.microsoft.com/en-us/help/3167392&quot;&gt;Cumulative Update 6&lt;/a&gt; for SQL Server 2014 Service Pack 1 (SP1)&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://support.microsoft.com/en-us/help/3152635&quot;&gt;Cumulative Update 3 for SQL Server 2012 SP3&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://support.microsoft.com/en-us/help/3137745&quot;&gt;Cumulative Update 11&lt;/a&gt; for SQL Server 2012 Service Pack 2 (SP2)&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Ref: &lt;a href=&quot;https://support.microsoft.com/en-us/help/3131443/fix-cannot-resolve-the-collation-conflict-error-when-you-apply-a-snaps&quot;&gt;https://support.microsoft.com/en-us/help/3131443/fix-cannot-resolve-the-collation-conflict-error-when-you-apply-a-snaps&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Also check the “Collation” between database server and instance are same, which is mostly &lt;strong&gt;SQL_Latin1_General_CP1_CI_AS&lt;/strong&gt;&lt;/p&gt;
&lt;/div&gt;
&lt;/body&gt;

&lt;/html&gt;
</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/3859737507850572517/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/3859737507850572517' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/3859737507850572517'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/3859737507850572517'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2020/06/crystal-report-faq-error-fixes.html' title='Crystal Report FAQ Error and Fixes'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-5596225533186416467</id><published>2020-03-28T18:21:00.000+06:00</published><updated>2020-03-28T18:21:09.682+06:00</updated><title type='text'>MS Sql Server Local DB</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;b&gt;Web.Config file:&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: Courier New, Courier, monospace;&quot;&gt;&amp;lt;add connectionstring=&quot;Data Source=(LocalDb)\MSSqlLocalDB; Initial Catalog=[database-name]; Integrated Security=True&quot; name=&quot;ConnectionString&quot; providername=&quot;System.Data.SqlClient&quot; /&amp;gt;
&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Connect to Local DB:&lt;/b&gt;&lt;br /&gt;
Open Visual Studio: Menu: Tools &amp;gt; Connect to Server &amp;gt;&lt;br /&gt;
&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Left navigation bar &amp;gt; New Data Connection: Server Name: (LocalDb)\MSSqlLocalDB&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;drop database &quot;myDB&quot;;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;create database &quot;myDB&quot;;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
-- Check the logical file name (1st column) after running this query&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;RESTORE FILELISTONLY FROM DISK = &#39;E:\Ismail\Projects\VPT_TVL\vpt\database\VPT.bak&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
-- Place the Logical file name after MOVE statement, and a path where database files will be created&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;RESTORE DATABASE &quot;myDB&quot;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;FROM DISK = &#39;D:\database\myDB.bak&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;WITH MOVE &#39;myDB_Data&#39; TO &#39;E:\database\TVL_PT_Data.mdf&#39;,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;MOVE &#39;myDB_Log&#39; TO &#39;E:\database\TVL_PT_Log.ldf&#39;,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;REPLACE;&lt;/span&gt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/5596225533186416467/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/5596225533186416467' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/5596225533186416467'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/5596225533186416467'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2020/03/ms-sql-server-local-db.html' title='MS Sql Server Local DB'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-4597518314870527067</id><published>2017-01-01T13:51:00.001+06:00</published><updated>2018-09-03T18:14:27.326+06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Oracle"/><title type='text'>Oracle Cheats Sheet</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;impact&amp;quot;; font-size: 26.666666666666664px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Oracle Cheats Sheet&lt;/span&gt;&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;b id=&quot;docs-internal-guid-d8a7a394-5967-5c78-6def-6dc664232dce&quot; style=&quot;font-weight: normal;&quot;&gt;&lt;br /&gt;&lt;/b&gt;&lt;/h1&gt;
&lt;h2 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 18pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;cambria&amp;quot;; font-size: 21.333333333333332px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Managing Server&lt;/span&gt;&lt;/h2&gt;
&lt;h3 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 4pt; margin-top: 16pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.666666666666664px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Switch to oracle user&lt;/span&gt;&lt;/h3&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;b style=&quot;font-weight: normal;&quot;&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;root&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;su oracle&lt;/span&gt;&lt;/div&gt;
&lt;/b&gt;&lt;/h1&gt;
&lt;h2 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 18pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.666666666666664px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Start DB&lt;/span&gt;&lt;/h2&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;b style=&quot;font-weight: normal;&quot;&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;oracle$sqlplus /nolog&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;conn sys/password as SYSDBA&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: italic; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#to start database&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;startup&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: italic; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#to shutdown database immediately&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;shutdown immediate&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;exit&lt;/span&gt;&lt;/div&gt;
&lt;/b&gt;&lt;/h1&gt;
&lt;h2 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 18pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.666666666666664px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Start Listner&lt;/span&gt;&lt;/h2&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;b style=&quot;font-weight: normal;&quot;&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#oracle$LSNRCTL&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;start &lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;- to start&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;status &lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;- to check current status&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;stop&lt;/span&gt;&lt;/div&gt;
&lt;/b&gt;&lt;/h1&gt;
&lt;h2 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 18pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.666666666666664px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Start Enterprise Manager&lt;/span&gt;&lt;/h2&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;b style=&quot;font-weight: normal;&quot;&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Url: http://iPAdress:5500/em&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: black; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.666666666666666px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;oracle$$ORACLE_HOME/bin/./emctl start dbconsole&lt;/span&gt;&lt;/div&gt;
&lt;/b&gt;&lt;/h1&gt;
&lt;h2 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 18pt;&quot;&gt;
&lt;span style=&quot;background-color: transparent; color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.666666666666664px; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Start iSqlplus&lt;/span&gt;&lt;/h2&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Url: http://iPAdress:5560/isqlplus&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;oracle$$ORACLE_HOME/bin/./isqlplusctl start&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;http://localhost:5560/isqlplus use &quot;system&quot; as user name and password given during installation&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;How to connect to a remote Oracle server using Oracle Client:&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;C:\Documents and Settings\User.Domain&amp;gt;sqlplus&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 25 13:13:36 2008&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Copyright (c) 1982, 2005, Oracle. All rights reserved.&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Enter user-name: userName/password@iPAdress/&lt;servicename&gt;&lt;/servicename&gt;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Connected to:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;With the Partitioning, OLAP and Data Mining options&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SELECT * FROM TABS;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SELECT * FROM CAT;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;*Show users&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;show users;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: normal; vertical-align: baseline;&quot;&gt;SQL&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline;&quot;&gt;show dba_users;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;; font-size: 21.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Table space and User Creation&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Create user with default tablespace&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Create user MyUserDB identified by MyUserDB123;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;grant dba, connect, resource to MyUserDB;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Create user with defined tablespace&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;DROP USER MyUserDB CASCADE;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;CREATE SMALLFILE TABLESPACE &quot;TS_MyUserDB&quot; DATAFILE &#39;TS_MyUserDB&#39;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SIZE 1000M AUTOEXTEND ON NEXT 32M&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;CREATE USER &quot;MyUserDB&quot; PROFILE &quot;DEFAULT&quot; IDENTIFIED BY &quot;MyUserDB123&quot; DEFAULT TABLESPACE &quot;TS_MyUserDB&quot; ACCOUNT UNLOCK;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;GRANT dba, resource, connect TO MyUserDB; &lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;; font-size: 21.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Export DB Backup/Dump&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;; font-size: 21.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;====================&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;How to Export dmp using emp utility:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;***Export from Client Machine using Oracle Client&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;exp userName/password@iPAdress/serviceName&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;eg: &lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;exp MyUserDB/MyUserDB123@192.168.0.1/orcl&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;then press enter to select all default options, give a path to download dmp C:\MyUserDB.dmp, and finally enter user name and then enter to start&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;strike&gt;&lt;br /&gt;&lt;/strike&gt;&lt;/span&gt; &lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Export from Linux:&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;impact&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;1. At first login as Oracle user in Linux Server, or switch to oracle user by:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;su oracle&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;2. Enter the following command for changing directory:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;$&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;cd $ORACLE_HOME/bin&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;3. Enter the following command for backup the database:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;$&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;exp userName/passward file=/home/oracle/*.dmp log=/home/oracle/.log&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;[&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-style: italic; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;N.B: /home/oracle use for this document. You can use any valid path for this. If no path is supplied then the backup file will be found in the current directory, i.e.: $ORACLE_HOME/bin&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;]&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/span&gt; &lt;span style=&quot;background-color: yellow; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Update:&lt;/span&gt;&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; white-space: pre-wrap;&quot;&gt;(for Oracle 10g or Higher edition)&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;;&quot;&gt;&lt;span style=&quot;background-color: white; font-size: 14.6667px; white-space: pre-wrap;&quot;&gt;exp utility is ancient now, use expdp (export data pump) instead.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;expdp userName/password@[iPAdress/serviceName]&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;expdp userName/password@[TNS_Name]&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt; &lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;this will put your exported dump file in the following directory of the server:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;..\app\oracle\admin\XE\dpdump&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;Create a batch file with below content to make schedule to backup database periodically with datetime in dmp and log file name&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;#===========================================================&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style=&quot;vertical-align: baseline;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;@echo off
For /f &quot;tokens=2-4 delims=/ &quot; %%a in (&#39;date /t&#39;) do (set mydate=%%c-%%a-%%b)
#For /f &quot;tokens=1-2 delims=/:&quot; %%a in (&#39;time /t&#39;) do (set mytime=%%a%%b)
For /f &quot;tokens=1-2 delims=/:&quot; %%a in (&quot;%TIME%&quot;) do (set mytime=%%a%%b)
#echo %mydate%_%mytime%

#user=sys, password=admin, tnsname=xe, schemas=schema name to backup.
expdp &#39;sys/admin@xe as sysdba&#39; schemas=test dumpfile=test_%mydate%-%mytime%.dump logfile=test_%mydate%-%mytime%.log&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;vertical-align: baseline;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#===========================================================&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;span style=&quot;font-weight: normal;&quot;&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;; font-size: 21.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Import DB Backup/Dump&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;; font-size: 21.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;====================&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;How to Import dmp using imp utility (for Oracle 10g or Lower edition)&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;***import from Client Machine using Oracle Client&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;imp user/password@IPAddress/Servicename&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;eg: &amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;imp MyUserDB/MyUserDB123@192.168.0.1/orcl&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Import in Linux: &lt;/span&gt;&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; white-space: pre-wrap;&quot;&gt;(for Oracle 10g or Lower edition)&lt;/span&gt;&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;1. At first login as Oracle user in Linux Server.&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;#su oracle&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;2. Enter the following command for changing directory:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;$cd $ORACLE_HOME/bin&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;4. Drop user, if already exists, after login as System/Sys in sqlplus:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;drop user cascade;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;If drop user fails because of any connected user session then identify the session by:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SELECT username FROM v$session WHERE username is not null;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SELECT s.sid, s.serial#, s.osuser, s.program FROM v$session s;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;and Kill by:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;5. Enter the following command for creating user(if user is not available in Oracle):&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;create user (userName) identified by (password);&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;grant connect, resource, [dba] to (userName) [with admin option];&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;[grant select_catalog_role to UserName;]&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;[grant create any view to UserName;]&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;commit;&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;6. Enter the following command for restoring database:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;$imp userName/password file=/oracle/home/*.dmp full=y&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;[&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-style: italic; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;N.B: /home/oracle use for this document. You can use any valid path for this.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;]&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/span&gt; &lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/span&gt; &lt;span style=&quot;background-color: yellow; font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;Update: &lt;/span&gt;&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; white-space: pre-wrap;&quot;&gt;(for Oracle 10g or Higher edition)&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;;&quot;&gt;&lt;span style=&quot;background-color: white; font-size: 14.6667px; white-space: pre-wrap;&quot;&gt;imp utility is ancient now, use impdp (import data pump) instead.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;put your exported dump file in the following directory of the server:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;..\app\oracle\admin\XE\dpdump&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;;&quot;&gt;&lt;span style=&quot;background-color: white; font-size: 14.6667px; white-space: pre-wrap;&quot;&gt;say the dump file name is test.dmp&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;;&quot;&gt;&lt;span style=&quot;background-color: white; font-size: 14.6667px; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt; &lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;impdp userName/password@[iPAdress/serviceName] dumpfile=test.dmp&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline;&quot;&gt;impdp userName/password@[TNS_Name]&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: bold; white-space: pre-wrap;&quot;&gt; dumpfile=test.dmp&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;u style=&quot;font-family: cambria; font-size: 21.3333px; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/u&gt; &lt;u style=&quot;font-family: cambria; font-size: 21.3333px; white-space: pre-wrap;&quot;&gt;Adminstration:&lt;/u&gt;&lt;/div&gt;
&lt;div style=&quot;font-weight: normal;&quot;&gt;
&lt;u style=&quot;font-family: cambria; font-size: 21.3333px; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/u&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
&lt;span style=&quot;font-size: 21.3333px; font-weight: 400; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;;&quot;&gt;ALTER USER &lt;user&gt; IDENTIFIED BY &lt;password&gt; ACCOUNT UNLOCK;
&lt;/password&gt;&lt;/user&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style=&quot;font-size: 21.3333px; font-weight: 400; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt; &lt;span style=&quot;font-size: 21.3333px; font-weight: 400; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;cambria&amp;quot;;&quot;&gt;GRANT dba TO &lt;user&gt;;&lt;/user&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;To Check number of Connections/Session:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SELECT&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;*&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;FROM&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; V$SESSION &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;WHERE&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;PROGRAM &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;IS&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;NOT&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;NULL)&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;and&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;username &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&#39;MyUserDB&#39;&lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;)&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SELECT&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; count&lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;(*)&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;FROM&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; V$SESSION &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;WHERE&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;PROGRAM &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;IS&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;NOT&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;NULL)&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;and&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;username &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&#39;MyUserDB&#39;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;and&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt; Status&lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&#39;INACTIVE&#39;&lt;/span&gt;&lt;span style=&quot;color: #0000f0; font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;)&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;color: #434343; font-family: &amp;quot;calibri&amp;quot;; font-size: 18.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;To Kill Sessions&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;ALTER SYSTEM KILL SESSION &#39;sid,serial#&#39;; &amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;-- Generate scripts for bulk session killing:&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;; font-size: 13.3333px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;SELECT &#39;ALTER SYSTEM KILL SESSION &#39;&#39;&#39; || sid || &#39;,&#39; || serial# || &#39;&#39;&#39;;&#39; from gv$session where username=&#39;ELIBRARY&#39;;&lt;/span&gt;&lt;/div&gt;
&lt;/h1&gt;
&lt;h1 class=&quot;entry-title&quot; style=&quot;background-color: white; box-sizing: border-box; color: #333333; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 28px; font-weight: 300; line-height: 35px; margin: 0px 0px 0.2em; padding: 0px;&quot;&gt;
list all available schemas&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;span style=&quot;font-weight: normal;&quot;&gt;&lt;span style=&quot;font-weight: normal;&quot;&gt;&lt;div style=&quot;font-size: medium;&quot;&gt;
&lt;pre style=&quot;background: rgb(236, 240, 249); border: 1px solid rgba(0, 0, 0, 0.15); box-sizing: border-box; color: #333333; font-family: monospace, monospace; font-size: 13px; line-height: 20px; padding: 9.5px; white-space: pre-wrap; word-wrap: break-word;&quot;&gt;&lt;code style=&quot;background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; box-sizing: border-box; font-family: monospace, monospace; font-size: 1em;&quot;&gt;select USERNAME from SYS.ALL_USERS&lt;/code&gt;&lt;/pre&gt;
&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;font-weight: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;/div&gt;
&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;span style=&quot;font-weight: normal;&quot;&gt;&lt;div&gt;
&lt;span style=&quot;font-weight: normal;&quot;&gt;&lt;/span&gt;&lt;/div&gt;
&lt;u style=&quot;font-family: cambria; font-size: 21.3333px; white-space: pre-wrap;&quot;&gt;PL-SQL&lt;/u&gt;&lt;br /&gt;&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;--#Insert into one table from another table within same user&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;INSERT into t_role (select pass, userid from t_user)&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;--#Insert into one table from another table between diff user but within same database&lt;/span&gt;&lt;/div&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;INSERT into Table1 (SELECT * FROM User2.Table1 MINUS SELECT * FROM Table1)&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/span&gt; &lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot;; font-size: 14.6667px; font-weight: 700; vertical-align: baseline; white-space: pre-wrap;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/h1&gt;
&lt;h1 dir=&quot;ltr&quot; style=&quot;line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;&quot;&gt;
&lt;span style=&quot;font-weight: normal;&quot;&gt; &lt;/span&gt;&lt;/h1&gt;
&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/4597518314870527067/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/4597518314870527067' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/4597518314870527067'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/4597518314870527067'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2017/01/oracle-cheats-sheet.html' title='Oracle Cheats Sheet'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-4695571948952302052</id><published>2015-02-12T19:19:00.000+06:00</published><updated>2015-02-12T19:20:02.594+06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".NET"/><category scheme="http://www.blogger.com/atom/ns#" term="C#"/><category scheme="http://www.blogger.com/atom/ns#" term="CSV"/><category scheme="http://www.blogger.com/atom/ns#" term="XML"/><title type='text'>Export DataTable or DataSet to CSV or XML</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;pre class=&quot;prettyprint&quot;&gt;&lt;pre style=&quot;background: rgb(240, 240, 240); border-radius: 2px; border: 1px solid rgb(204, 204, 204); font-family: Consolas, &#39;DejaVu Sans Mono&#39;, &#39;Bitstream Vera Sans Mono&#39;, monospace; font-size: 13px; letter-spacing: 0.015em; line-height: 15.6000003814697px; overflow-x: auto; overflow-y: hidden; padding: 0.5em;&quot;&gt;&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Collections.Generic&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Configuration&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Data&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Data.SqlClient&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.IO&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Linq&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Text&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Web&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Web.UI&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Web.UI.WebControls&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;nn&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;System.Xml.Serialization&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;

&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;public&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;partial&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;class&lt;/span&gt; &lt;span class=&quot;nc&quot; style=&quot;color: #0e84b5; font-weight: bold;&quot;&gt;ExportReservationInfo&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;System&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Web&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;UI&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Page&lt;/span&gt;
&lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
    &lt;span class=&quot;cp&quot; style=&quot;color: #007020;&quot;&gt;#region Events&lt;/span&gt;
    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;protected&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;void&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;Page_Load&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;object&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;sender&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;EventArgs&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;e&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
        &lt;span class=&quot;n&quot;&gt;lblMsg&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Page&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;IsPostBack&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;protected&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;void&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;btnExportToCSV_Click&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;object&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;sender&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;EventArgs&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;e&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
        &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;string&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;strReservationId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;txtReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Trim&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
        &lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;try&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ReservationId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;Convert&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToInt32&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;strReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ExecuteQuery&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;

            &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//Export to CSV&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;ExportToSpreadsheet&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;ReservationInfo&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;catch&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Exception&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;lblMsg&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;Please enter a valid Reservation Id&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        
    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;protected&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;void&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;btnExportToXML_Click&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;object&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;sender&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;EventArgs&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;e&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
        &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;string&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;strReservationId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;txtReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Trim&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
        &lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;try&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ReservationId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;Convert&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToInt32&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;strReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ExecuteQuery&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;

            &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//Export to XML&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;ExportToXml&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;ReservationInfo&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;catch&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Exception&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;lblMsg&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;Please enter a valid Reservation Id&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
    &lt;span class=&quot;cp&quot; style=&quot;color: #007020;&quot;&gt;#endregion&lt;/span&gt;

    &lt;span class=&quot;cp&quot; style=&quot;color: #007020;&quot;&gt;#region Methods&lt;/span&gt;
    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;private&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;ExecuteQuery&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
        &lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;dsResult&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;ReservationInfo&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
        &lt;span class=&quot;n&quot;&gt;SqlConnection&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;con&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;SqlConnection&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;System&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Configuration&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ConfigurationManager&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ConnectionStrings&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;[&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;LocalSqlServer&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;].&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ConnectionString&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;

        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;try&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;con&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;SqlConnection&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;con&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ConnectionString&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;con&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Open&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;

            &lt;span class=&quot;n&quot;&gt;SqlCommand&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;command&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;SqlCommand&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;spGetCSIAttendeeInfo&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;con&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;command&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;CommandType&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;CommandType&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;StoredProcedure&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;command&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Parameters&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AddWithValue&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;@ReservationRoomID&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ReservationId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;

            &lt;span class=&quot;n&quot;&gt;SqlDataAdapter&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;adapter&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;SqlDataAdapter&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;command&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;adapter&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Fill&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;dsResult&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//foreach (DataTable dt in dsResult.Tables) { }&lt;/span&gt;
            &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//foreach (DataRow dr in dsResult.Tables[0].Rows) {}&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;catch&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Exception&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;throw&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;Exception&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Message&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;finally&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;con&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;!=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;null&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
                &lt;span class=&quot;n&quot;&gt;con&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Dispose&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;return&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;dsResult&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;private&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;void&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;ExportToXml&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;string&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;name&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;try&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;var&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;memoryStream&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;MemoryStream&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;())&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;TextWriter&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;streamWriter&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;StreamWriter&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;memoryStream&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;))&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                    &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;var&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;xmlSerializer&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;XmlSerializer&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;typeof&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;));&lt;/span&gt;
                    &lt;span class=&quot;n&quot;&gt;xmlSerializer&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Serialize&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;streamWriter&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;

                    &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//return Encoding.UTF8.GetString(memoryStream.ToArray());&lt;/span&gt;
                    &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;var&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;docresult&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;Encoding&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;UTF8&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;GetString&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;memoryStream&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToArray&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;());&lt;/span&gt;

                    &lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Write&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;docresult&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
                    &lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ContentType&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;text/xml; charset=utf-8&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
                    &lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AddHeader&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;Content-Disposition&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;attachment; filename=&quot;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;name&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;.xml&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
                    &lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;End&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

            &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;catch&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Exception&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;lblMsg&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;An error occured processing your request&quot;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Message&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;private&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;void&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;ExportToSpreadsheet&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataSet&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;string&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;name&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
        &lt;span class=&quot;n&quot;&gt;StringBuilder&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;StringBuilder&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
        &lt;span class=&quot;n&quot;&gt;HttpContext&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;HttpContext&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Current&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;try&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Clear&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;

            &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;foreach&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataTable&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ds&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Tables&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;foreach&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataColumn&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;column&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Columns&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                    &lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Append&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;column&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ColumnName&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;,&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

                &lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AppendLine&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;

                &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;foreach&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataRow&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;row&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Rows&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;for&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;i&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;i&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;amp;&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;lt&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Columns&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Count&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;i&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;++)&lt;/span&gt;
                    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                        &lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Append&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;row&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;[&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;i&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;].&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToString&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;().&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Replace&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;,&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;;&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;,&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
                    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

                    &lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AppendLine&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

                &lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AppendLine&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
                &lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AppendLine&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Write&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;sb&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToString&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;());&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ContentType&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;text/csv&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AppendHeader&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;Content-Disposition&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;attachment; filename=&quot;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;name&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;.csv&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;End&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;catch&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Exception&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;lblMsg&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;An error occured processing your request&quot;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Message&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;

    &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;private&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;void&lt;/span&gt; &lt;span class=&quot;nf&quot; style=&quot;color: #06287e;&quot;&gt;ExportToSpreadsheet&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataTable&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;string&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;name&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;try&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;HttpContext&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;HttpContext&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Current&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Clear&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
            &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;foreach&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataColumn&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;column&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Columns&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Write&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;column&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ColumnName&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;,&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Write&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Environment&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;NewLine&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;foreach&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DataRow&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;row&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Rows&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;for&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;i&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;i&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;amp;&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;lt&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;table&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Columns&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Count&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;i&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;++)&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
                    &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Write&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;row&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;[&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;i&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;].&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToString&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;().&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Replace&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;,&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;;&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;,&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
                &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
                &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Write&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Environment&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;NewLine&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ContentType&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;text/csv&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;AppendHeader&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;Content-Disposition&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;attachment; filename=&quot;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;name&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;.csv&quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Response&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;End&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;();&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
        &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;catch&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Exception&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
            &lt;span class=&quot;n&quot;&gt;lblMsg&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Text&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s&quot; style=&quot;color: #4070a0;&quot;&gt;&quot;An error occured processing your request&quot;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;+&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;ex&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Message&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
        &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
    &lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
    &lt;span class=&quot;cp&quot; style=&quot;color: #007020;&quot;&gt;#endregion&lt;/span&gt;
&lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;&lt;/pre&gt;
&lt;/pre&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/4695571948952302052/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/4695571948952302052' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/4695571948952302052'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/4695571948952302052'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2015/02/export-datatable-or-dataset-to-csv-or.html' title='Export DataTable or DataSet to CSV or XML'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-8152427825820512387</id><published>2015-02-12T19:17:00.000+06:00</published><updated>2015-02-12T19:17:04.475+06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="C#"/><category scheme="http://www.blogger.com/atom/ns#" term="LINQ"/><title type='text'>How to SELECT WHERE NOT EXIST using LINQ?</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;pre style=&quot;background: rgb(240, 240, 240); border-radius: 2px; border: 1px solid rgb(204, 204, 204); font-family: Consolas, &#39;DejaVu Sans Mono&#39;, &#39;Bitstream Vera Sans Mono&#39;, monospace; font-size: 13px; letter-spacing: 0.015em; line-height: 15.6000003814697px; overflow-x: auto; overflow-y: hidden; padding: 0.5em;&quot;&gt;&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;/*&lt;/span&gt;
&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;#Where EXISTS&lt;/span&gt;
&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;=====================&lt;/span&gt;
&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;*/&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;from&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;tblProjectInfo&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;where&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;tblProjectFundingCommitment&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Any&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;=&amp;gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ProjectId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;==&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Id&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&amp;amp;&amp;amp;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;FundSourceId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;==&lt;/span&gt;&lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;44&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;))&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;select&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;

&lt;span class=&quot;n&quot;&gt;tblProjectInfo&lt;/span&gt;
   &lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Where&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;
      &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; 
         &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;tblProjectFundingCommitment&lt;/span&gt;
               &lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Any&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ProjectId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Id&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;FundSourceId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;44&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)))&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
   &lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;

&lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//--With Optional Parameters&lt;/span&gt;
&lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//---------------------------&lt;/span&gt;
&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;1&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;2&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//we will skip comaping if value is 2(not a boolean)&lt;/span&gt;
&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;bool&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;isUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;Convert&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToBoolean&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;managingDPId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;[&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;any&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;integer&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;value&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;starts&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;from&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;];&lt;/span&gt; &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//we will skip comaping if 0&lt;/span&gt;

&lt;span class=&quot;n&quot;&gt;tblProjectInfo&lt;/span&gt;
 &lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Where&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;
                &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;||&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;1&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;?&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;IsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;isUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;true&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
                    &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;tblProjectFundingCommitment&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Any&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ProjectId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Id&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;managingDPId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;gt;&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;?&lt;/span&gt; 

&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;FundSourceId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;managingDPId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;true&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;))))&lt;/span&gt;
                    &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(!&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;string&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;IsNullOrEmpty&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DPProjectNo&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;))&lt;/span&gt;
 &lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;

&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;/*&lt;/span&gt;
&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;#Where NOT EXISTS&lt;/span&gt;
&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;=====================&lt;/span&gt;
&lt;span class=&quot;cm&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;*/&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;from&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;tblProjectInfo&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;where&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;!&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;tblProjectFundingCommitment&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Any&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;=&amp;gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ProjectId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;==&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Id&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&amp;amp;&amp;amp;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;FundSourceId&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;==&lt;/span&gt;&lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;44&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;))&lt;/span&gt;
&lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;select&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;

&lt;span class=&quot;n&quot;&gt;tblProjectInfo&lt;/span&gt;
   &lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Where&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;
      &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; 
         &lt;span class=&quot;p&quot;&gt;!(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;tblProjectFundingCommitment&lt;/span&gt;
               &lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Any&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ProjectId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Id&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;FundSourceId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;44&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)))&lt;/span&gt;
            &lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
   &lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;

&lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//--With Optional Parameters&lt;/span&gt;
&lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//---------------------------&lt;/span&gt;
&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;1&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;2&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//we will skip comaping if value is 2(not a boolean)&lt;/span&gt;
&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;bool&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;isUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;Convert&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ToBoolean&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;);&lt;/span&gt;
&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;int&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;managingDPId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;[&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;any&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;integer&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;value&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;starts&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;from&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;];&lt;/span&gt; &lt;span class=&quot;c1&quot; style=&quot;color: #60a0b0; font-style: italic;&quot;&gt;//we will skip comaping if 0&lt;/span&gt;

&lt;span class=&quot;n&quot;&gt;tblProjectInfo&lt;/span&gt;
 &lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Where&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;
                &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;||&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;intIsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;1&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;?&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;IsUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;isUnderADP&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;true&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
                    &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;!(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;context&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;tblProjectFundingCommitment&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Any&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;=&amp;gt;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;ProjectId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;Id&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;((&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;managingDPId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;&amp;gt;&lt;/span&gt; &lt;span class=&quot;m&quot; style=&quot;color: #40a070;&quot;&gt;0&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;?&lt;/span&gt; 

&lt;span class=&quot;n&quot;&gt;pfc&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;FundSourceId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;==&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;managingDPId&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;k&quot; style=&quot;color: #007020; font-weight: bold;&quot;&gt;true&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;))))&lt;/span&gt;
                    &lt;span class=&quot;p&quot;&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;(!&lt;/span&gt;&lt;span class=&quot;kt&quot; style=&quot;color: #902000;&quot;&gt;string&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;IsNullOrEmpty&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;p&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;DPProjectNo&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;))&lt;/span&gt;
 &lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;&lt;/pre&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/8152427825820512387/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/8152427825820512387' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/8152427825820512387'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/8152427825820512387'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2015/02/how-to-select-where-not-exist-using-linq.html' title='How to SELECT WHERE NOT EXIST using LINQ?'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-6980391317369688964</id><published>2012-09-19T19:50:00.002+06:00</published><updated>2017-01-01T13:59:11.116+06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Injection"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><title type='text'>Stored Procedure to prevent sql injection with optional parameters and server side Paging and Sorting</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
To prevent sql injection on dynamic sql queries&lt;br /&gt;
we must use parametrized sql queries.&lt;br /&gt;
&lt;br /&gt;
You can generate stored procedure from tables using this tool&lt;br /&gt;
&lt;a href=&quot;https://github.com/mijaved/CodeGenerator&quot;&gt;CodeGenerator&lt;/a&gt;&amp;nbsp;from https://github.com/mijaved/CodeGenerator&lt;br /&gt;
&lt;br /&gt;
The following example illustrates optional parametrized sql statement with user supplied sorting and paging parameters:&lt;br /&gt;
&lt;br /&gt;
&lt;pre&gt;&lt;/pre&gt;
&lt;pre&gt;DECLARE
 @Mode    INT = 2,
 @UserId    INT = 0,
 @LoginId   VARCHAR(50)=&#39;&#39;,
 @FirstName   VARCHAR(50) =&#39;&#39;,
 @LastName   VARCHAR(50)=&#39;&#39;,
 @Password   VARCHAR(32)=&#39;&#39;,
 @LastLoginDateFrom VARCHAR(32)=&#39;2012-09-19&#39;,
 @LastLoginDateTo VARCHAR(32)=&#39;2012-09-20&#39;,
 @SortBy    VARCHAR(32)=&#39;UserId&#39;,
 @SortOrder   VARCHAR(32)=&#39;DESC&#39;,
 @StartIndex   INT = 1,
 @MaxIndex   INT = 100;

IF @Mode = 1 --Without Paging
BEGIN
 SELECT UserId,FirstName,LastName,LoginId,LastLoginDate
 FROM SEC_TblUsers WHERE 1=1
 AND (UserId = @UserId OR @UserId IS NULL OR @UserId &amp;lt;= 0)
 AND (LoginId = @LoginId OR @LoginId IS NULL OR @LoginId = &#39;&#39;)
 AND (FirstName LIKE &#39;%&#39; + @FirstName + &#39;%&#39; OR @FirstName IS NULL OR @FirstName = &#39;&#39;)
 AND (LastName LIKE &#39;%&#39; + @LastName + &#39;%&#39; OR @LastName IS NULL OR @LastName = &#39;&#39;)
 AND (Password = @Password OR @Password IS NULL OR @Password = &#39;&#39;)
 AND (LastLoginDate &amp;gt;= @LastLoginDateFrom OR @LastLoginDateFrom IS NULL OR @LastLoginDateFrom = &#39;&#39;)
 AND (LastLoginDate &amp;lt;= @LastLoginDateTo OR @LastLoginDateTo IS NULL OR @LastLoginDateTo = &#39;&#39;)
 ORDER BY
 CASE WHEN @SortBy = &#39;UserId&#39; AND @SortOrder = &#39;ASC&#39; THEN UserId END ASC,
 CASE WHEN @SortBy = &#39;UserId&#39; AND @SortOrder = &#39;DESC&#39; THEN UserId END DESC;
END
IF @Mode = 2 --With Paging
BEGIN
 WITH T AS (SELECT ROW_NUMBER() OVER (ORDER BY --ID DESC 
  CASE WHEN @SortBy = &#39;UserId&#39; AND @SortOrder = &#39;ASC&#39; THEN UserId END ASC,
  CASE WHEN @SortBy = &#39;UserId&#39; AND @SortOrder = &#39;DESC&#39; THEN UserId END DESC
 ) AS ROWID, * FROM ( 
  SELECT UserId,FirstName,LastName,LoginId,LastLoginDate
  FROM SEC_TblUsers WHERE 1=1
  AND (UserId = @UserId OR @UserId IS NULL OR @UserId &amp;lt;= 0)
  AND (LoginId = @LoginId OR @LoginId IS NULL OR @LoginId = &#39;&#39;)
  AND (FirstName LIKE &#39;%&#39; + @FirstName + &#39;%&#39; OR @FirstName IS NULL OR @FirstName = &#39;&#39;)
  AND (LastName LIKE &#39;%&#39; + @LastName + &#39;%&#39; OR @LastName IS NULL OR @LastName = &#39;&#39;)
  AND (Password = @Password OR @Password IS NULL OR @Password = &#39;&#39;)
  AND (LastLoginDate &amp;gt;= @LastLoginDateFrom OR @LastLoginDateFrom IS NULL OR @LastLoginDateFrom = &#39;&#39;)
  AND (LastLoginDate &amp;lt;= @LastLoginDateTo OR @LastLoginDateTo IS NULL OR @LastLoginDateTo = &#39;&#39;)
 ) AS T) SELECT * FROM T 
 WHERE 0=0 --ROWID BETWEEN @StartIndex AND @MaxIndex
 AND (ROWID &amp;gt;= @StartIndex OR @StartIndex IS NULL OR @StartIndex &amp;lt;= 0)
 AND (ROWID &amp;lt;= @MaxIndex OR @MaxIndex IS NULL OR @MaxIndex &amp;lt;= 0)
END&amp;nbsp;&lt;/pre&gt;
&lt;pre&gt;&lt;/pre&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/6980391317369688964/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/6980391317369688964' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/6980391317369688964'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/6980391317369688964'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2012/09/optional-parameterized-sql-query-or.html' title='Stored Procedure to prevent sql injection with optional parameters and server side Paging and Sorting'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-2731779710782408220</id><published>2012-07-31T11:12:00.000+06:00</published><updated>2012-07-31T11:12:33.811+06:00</updated><title type='text'>Sql Server Script Generator</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
--&lt;b&gt;Purpose: To Drop Trigger if Exists&lt;/b&gt;&lt;br /&gt;--==========================&lt;br /&gt;
&lt;br /&gt;
&lt;pre&gt;&amp;nbsp; 
&lt;br /&gt;
SELECT &#39; IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N&#39;&#39;&#39; + name + &#39;&#39;&#39;)) &#39; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;+ &#39; DROP TRIGGER &#39; + name + &#39;;&#39; FROM dbo.sysobjects 
WHERE TYPE = &#39;TR&#39;&lt;br /&gt;
&lt;/pre&gt;
&lt;br /&gt;
--Purpose: To Drop Triggers name starts with&amp;nbsp; I_ or U_ or D_  if Exists&lt;br /&gt;-----------------------------------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
&lt;pre&gt;&amp;nbsp; 
&lt;br /&gt;
SELECT &#39; IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N&#39;&#39;&#39; + name + &#39;&#39;&#39;)) &#39; 

&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;+ &#39; DROP TRIGGER &#39; + name + &#39;;&#39; FROM dbo.sysobjects 

WHERE TYPE = &#39;TR&#39; AND ( name LIKE &#39;I_%&#39; OR name LIKE &#39;U_%&#39; OR name LIKE &#39;D_%&#39;)&lt;br /&gt;
&lt;/pre&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;--To Reseed Table&#39;s Identity Column&lt;/b&gt;&lt;br /&gt;--==========================&lt;br /&gt;
&lt;br /&gt;
&lt;pre&gt;&amp;nbsp; 
&lt;br /&gt;
DBCC CHECKIDENT (PPP_tblHeadGroup, reseed, 1)&amp;nbsp;&amp;nbsp;&amp;nbsp; 
DBCC CHECKIDENT (PPP_tblHeadGroup, reseed)&lt;br /&gt;
&lt;/pre&gt;
&amp;nbsp; &lt;br /&gt;&lt;br /&gt;
&lt;br /&gt;
--&lt;b&gt;Purpose: Data Cleansing Script Generator for Sql Server Database&amp;nbsp;&lt;/b&gt;&lt;br /&gt;
--======================================================&lt;br /&gt;
&lt;br /&gt;
&lt;pre&gt; 
&lt;br /&gt;
WITH Fkeys AS (
&amp;nbsp;&amp;nbsp;&amp;nbsp; SELECT DISTINCT OnTable.name AS OnTable,
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; AgainstTable.name AS AgainstTable
&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM&amp;nbsp;&amp;nbsp; sysforeignkeys AS fk
&amp;nbsp;&amp;nbsp;&amp;nbsp; INNER JOIN sysobjects AS onTable ON fk.fkeyid = onTable.id
&amp;nbsp;&amp;nbsp;&amp;nbsp; INNER JOIN sysobjects AS againstTable ON fk.rkeyid = againstTable.id
&amp;nbsp;&amp;nbsp;&amp;nbsp; WHERE&amp;nbsp; 1 = 1
&amp;nbsp;&amp;nbsp;&amp;nbsp; AND AgainstTable.TYPE = &#39;U&#39;
&amp;nbsp;&amp;nbsp;&amp;nbsp; AND OnTable.TYPE = &#39;U&#39;
&amp;nbsp;&amp;nbsp;&amp;nbsp; -- ignore self joins; they cause an infinite recursion
&amp;nbsp;&amp;nbsp;&amp;nbsp; AND OnTable.Name &amp;lt;&amp;gt; AgainstTable.Name),
MyData AS (
&amp;nbsp;&amp;nbsp;&amp;nbsp; SELECT o.name AS OnTable,
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; FKeys.againstTable AS AgainstTable
&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM&amp;nbsp;&amp;nbsp; sys.objects AS o
&amp;nbsp;&amp;nbsp;&amp;nbsp; LEFT OUTER JOIN FKeys ON o.name = FKeys.onTable
&amp;nbsp;&amp;nbsp;&amp;nbsp; WHERE&amp;nbsp; 1 = 1
&amp;nbsp;&amp;nbsp;&amp;nbsp; AND o.type = &#39;U&#39;
&amp;nbsp;&amp;nbsp;&amp;nbsp; AND o.name NOT LIKE &#39;sys%&#39;),
MyRecursion AS (-- base case
&amp;nbsp;&amp;nbsp;&amp;nbsp; SELECT OnTable AS TableName,
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; 1 AS Lvl
&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM&amp;nbsp;&amp;nbsp; MyData
&amp;nbsp;&amp;nbsp;&amp;nbsp; WHERE&amp;nbsp; 1 = 1
&amp;nbsp;&amp;nbsp;&amp;nbsp; AND AgainstTable IS NULL
&amp;nbsp;&amp;nbsp;&amp;nbsp; -- recursive case
&amp;nbsp;&amp;nbsp;&amp;nbsp; UNION ALL
&amp;nbsp;&amp;nbsp;&amp;nbsp; SELECT OnTable AS TableName,
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; r.Lvl + 1 AS Lvl
&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM&amp;nbsp;&amp;nbsp; MyData AS d
&amp;nbsp;&amp;nbsp;&amp;nbsp; INNER JOIN MyRecursion AS r ON d.AgainstTable = r.TableName)
SELECT MAX(Lvl) AS Lvl,
&amp;nbsp;&amp;nbsp;&amp;nbsp; TableName,
&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;DELETE FROM &#39; + tablename + &#39;; &#39; AS strSql,
&amp;nbsp;&amp;nbsp;&amp;nbsp; CASE WHEN (OBJECTPROPERTY(object_id(tablename), &#39;TableHasIdentity&#39;) = 1)
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; THEN &#39;DBCC CHECKIDENT (&#39; + tablename + &#39;, RESEED, 1); DBCC CHECKIDENT (&#39; + tablename + &#39;, RESEED);&#39; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; ELSE &#39;&#39; END AS strReseed
FROM MyRecursion
GROUP BY TableName
ORDER BY 1 DESC, 2 DESC;&lt;br /&gt;
&lt;/pre&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
--Sources/Refs: &lt;br /&gt;
--http://www.jasinskionline.com/TechnicalWiki/List-Tables-in-Dependency-Order-SQL-Server.ashx?AspxAutoDetectCookieSupport=1&lt;br /&gt;--http://www.devx.com/tips/Tip/32076 &lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/2731779710782408220/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/2731779710782408220' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/2731779710782408220'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/2731779710782408220'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2012/07/sql-server-script-generator.html' title='Sql Server Script Generator'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-6079325930126129441</id><published>2010-03-03T16:31:00.000+06:00</published><updated>2010-04-28T13:36:09.348+06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="autorun.inf"/><category scheme="http://www.blogger.com/atom/ns#" term="pen drive"/><category scheme="http://www.blogger.com/atom/ns#" term="windows search"/><title type='text'>Windows Hot Fixes</title><content type='html'>&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;b&gt;&lt;span style=&quot;font-size: small;&quot;&gt;Windows Search Doesn&#39;t Work:&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;b&gt;==============================&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;Follow these steps to try to solve this problem.&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;1. Click &lt;b&gt;Start &amp;gt; Run&lt;/b&gt; and type      &lt;b&gt;regsvr32  wshom.ocx&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;2. Click &lt;b&gt;Start &amp;gt; Run&lt;/b&gt; and type      &lt;b&gt;regsvr32 jscript.dll&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;3. Click &lt;b&gt;Start &amp;gt; Run&lt;/b&gt; and type      &lt;b&gt;regsvr32 urlmon.dll&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;Restart the computer and try to search. It should work with no problems.&lt;/span&gt;&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;color: black; font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: bold;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;color: black; font-family: inherit;&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;No Folders/Directory showing in USB Pen/Flash Drive:&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;========================================= &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;No windows user might be there who hasn&#39;t face this most irritating problem. When a user connects the flash drive, then some hidden services (virus) make all folder hidden and and creates a replica of that folder as FolderName.Exe&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;Now what to do???&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;all you have to do is a little command scripting. Follow the steps:&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;&lt;/div&gt;&lt;ul style=&quot;font-family: inherit;&quot;&gt;&lt;li&gt;&amp;nbsp;Open Command window, type &quot;cmd&quot; in Run and press Enter:&lt;/li&gt;
&lt;li&gt;Switch to the Flash drive directory, suppose the directory is F:&lt;/li&gt;
&lt;/ul&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;           &lt;/span&gt;C:\Documents and Settings\Administrator&amp;gt;F:&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;ul style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;
&lt;li&gt;&amp;nbsp;List all files and Directories including hidden using following command:&lt;/li&gt;
&lt;/span&gt;&lt;/ul&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;            &lt;/span&gt;F:\dir /a /w&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;Here here can see all your Directories, but which were not showing in Windows Explorer.&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;What happened is the little irritating virus made your directories hidden.&lt;/span&gt;&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;&lt;/div&gt;&lt;ul style=&quot;font-family: inherit;&quot;&gt;&lt;li&gt;&amp;nbsp;Now change the attribute of the Directories which were not showing using following command:&lt;/li&gt;
&lt;/ul&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; F:\attrib -s -h -r &lt;directoryname&gt;&lt;/directoryname&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;/div&gt;&lt;ul style=&quot;font-family: inherit;&quot;&gt;&lt;li&gt;And delete the fake directory.Exe file&lt;/li&gt;
&lt;/ul&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;          &lt;/span&gt;F:\del -s -q &lt;direcryname.exe&gt; &lt;/direcryname.exe&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&amp;nbsp;&amp;nbsp; OR F:\rmdir -s -q &lt;direcryname.exe&gt;&lt;/direcryname.exe&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;you can also delete some more files/directories from your flash drive which are responsible for this problem like:&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;        &lt;/span&gt;F:\del -s -q Recycler.exe&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;        &lt;/span&gt;F:\del -s -q Explorer.exe&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;        &lt;/span&gt;F:\rmdir -s -q Recycler&lt;/div&gt;&lt;div face=&quot;georgia&quot; style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;        &lt;/span&gt;F:\rmdir -s -q Recycle&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;etc... and all other unknown files / folders exists in your flash drive.&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;Now your Directories are visible in Windows Explorer. &lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;Happy Computing!!!&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/6079325930126129441/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/6079325930126129441' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/6079325930126129441'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/6079325930126129441'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2009/02/general-windows-xp-problems.html' title='Windows Hot Fixes'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-2273947587782834806</id><published>2010-03-03T15:00:00.000+06:00</published><updated>2010-03-03T15:14:00.395+06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Database Suspect Solution"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 7"/><title type='text'>Sql Server 7 Administration Tips</title><content type='html'>&lt;span style=&quot;font-weight:bold;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:x-large;&quot;&gt;Resolving Sql Server Database Suspect Problem:&lt;/span&gt;&lt;/span&gt;&lt;div&gt;&lt;span&gt;&lt;/span&gt;&lt;div&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;&lt;/div&gt;&lt;hr /&gt;&lt;div&gt;All of us who work with SQL server (specially sql server 7 version) database frequently, might have faced the peculiar problem &quot;Database Suspect&quot; and black icon overlays the database icon in Enterprise Manager. Hence we can&#39;t access the Database. Here is the solution to resolve the problem. The concept is simply delete  and rebuild the database log file.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Follow the following steps: &lt;/div&gt;&lt;div&gt;--------------------------&lt;/div&gt;&lt;div&gt;First of all delete the Database log (*.ldf) file of the suspected database. then&lt;/div&gt;&lt;div&gt;--1.) Reset the status from &quot;Suspect&#39;:&lt;/div&gt;&lt;div&gt;EXEC sp_resetstatus &#39;&lt;databasename&gt;&#39;&lt;/div&gt;&lt;div&gt;--2.) Set the database property &quot;allow updates&#39;:&lt;/div&gt;&lt;div&gt;exec sp_configure &#39;allow updates&#39;, 1 RECONFIGURE WITH OVERRIDE&lt;/div&gt;&lt;div&gt;--3.) Set the database to &quot;Emergency Mode&quot;:&lt;/div&gt;&lt;div&gt;UPDATE master..sysdatabases SET status=-32768 WHERE name=&#39;&lt;databasename&gt;&#39;&lt;/div&gt;&lt;div&gt;--4.) Rebuild the database log file:&lt;/div&gt;&lt;div&gt;dbcc rebuild_log (&#39;&lt;databasename&gt;&#39;,&#39;F:\MSSQL7\Data\&lt;databasename&gt;_log&#39;)&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;For example: Suppose we have a Database Named &quot;ContractorDatabase&quot;, which is suspected.&lt;/div&gt;&lt;div&gt;Now execute the following script, after deleting the existing database log file (ContractorDatabase_log.log) from Data file location (*:/MSSQL/Data).&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;EXEC sp_resetstatus &#39;ContractorDatabase&#39;&lt;/div&gt;&lt;div&gt;EXEC sp_configure &#39;allow updates&#39;, 1 RECONFIGURE WITH OVERRIDE&lt;/div&gt;&lt;div&gt;UPDATE master..sysdatabases SET status=-32768 WHERE name=&#39;ContractorDatabase&#39;&lt;/div&gt;&lt;div&gt;DBCC rebuild_log (&#39;ContractorDatabase&#39;,&#39;F:\MSSQL7\Data\ContractorDatabase_log&#39;)&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/2273947587782834806/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/2273947587782834806' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/2273947587782834806'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/2273947587782834806'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2010/03/sql-server-7-administration-tips.html' title='Sql Server 7 Administration Tips'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-456486875723170594.post-5272969424216186626</id><published>2009-02-17T11:01:00.000+06:00</published><updated>2009-05-04T12:53:51.369+06:00</updated><title type='text'>Linux Command ref</title><content type='html'>&lt;meta name=&quot;verify-v1&quot; content=&quot;z9zwxSp7sAdKgNzdpSQssPiXzVxkXq+ykw4/hoFy8JQ=&quot;&gt;&lt;br /&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;span style=&quot;font-family:georgia;&quot;&gt;&lt;span style=&quot;color: rgb(0, 0, 153); font-weight: bold;font-size:130%;&quot; &gt;Basic Operational Commands:&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;font-family:georgia;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;span style=&quot;font-family:georgia;&quot;&gt;Show users logged in:&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$who&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$who am i&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family:georgia;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;&lt;/span&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family:georgia;&quot;&gt;To list the files/Directories:&lt;/span&gt; &lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$ls&lt;/span&gt; &lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$ls -l&lt;/span&gt;&lt;br /&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Navigate to a location&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;&lt;span style=&quot;color: rgb(0, 0, 0);&quot;&gt;GoTo root directory:&lt;br /&gt;&lt;/span&gt;$cd /&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;&lt;span style=&quot;color: rgb(0, 0, 0);&quot;&gt;GoTo /home/oracle directory&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$cd /home/oracle&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;&lt;span style=&quot;color: rgb(0, 0, 0);&quot;&gt;GoTo 1 level up&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;&lt;br /&gt;$cd ..&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;To Concatenate files and print on the standard output&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$cat &lt;filename&gt;&lt;/filename&gt;&lt;/span&gt;  &lt;div style=&quot;text-align: center;&quot;&gt;&lt;span style=&quot;color: rgb(0, 0, 153);font-family:georgia;font-size:130%;&quot;  &gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;System Admin Commands&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: rgb(0, 0, 153);font-size:130%;&quot; &gt;:&lt;/span&gt; &lt;/div&gt;&lt;span style=&quot;font-family:georgia;&quot;&gt;Show System info:&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$uname&lt;br /&gt;$uname -r&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;color: rgb(0, 0, 0);&quot;&gt;Show kernel info&lt;/span&gt;&lt;br /&gt;$cat /etc/issue&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family:georgia;&quot;&gt;To determine available RAM and Swap space:&lt;/span&gt;  &lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$free&lt;/span&gt;   &lt;span style=&quot;font-family:georgia;&quot;&gt;To determine the Physical RAM size:&lt;/span&gt; &lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;$grep MemTotal /proc/meminfo&lt;/span&gt;  &lt;span style=&quot;font-family:georgia;&quot;&gt;To determine the size of configured Swap space:&lt;/span&gt; &lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt; $grep SwapTotal /proc/meminfo&lt;/span&gt;  To determine available disk space:  &lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt; $df -k&lt;br /&gt;$df -k /tmp&lt;br /&gt;$df -k /u01&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;color: rgb(0, 0, 0);&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;To mount a PenDrive&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;Insert pen drive into USB device,&lt;br /&gt;To mount pen drive use mout command. Find out device name using&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);&quot;&gt;$fdisk –l&lt;/span&gt;&lt;br /&gt;You may see /dev/sda as pen drive and /dev/sda1 as partition. Now create directory in /mnt&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);&quot;&gt;$mkdir -p /mnt/usbpen&lt;br /&gt;&lt;/span&gt;Mount pen&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);&quot;&gt;$mount /dev/sda1 /mnt/usbpen&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;color: rgb(255, 0, 0);font-family:georgia;&quot; &gt;&lt;span style=&quot;color: rgb(0, 0, 0);&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://mijaved.blogspot.com/feeds/5272969424216186626/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/456486875723170594/5272969424216186626' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/5272969424216186626'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/456486875723170594/posts/default/5272969424216186626'/><link rel='alternate' type='text/html' href='http://mijaved.blogspot.com/2009/02/linux-command-ref.html' title='Linux Command ref'/><author><name>Mi</name><uri>http://www.blogger.com/profile/02716582665904347144</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7oHeB4WhquNSf_cK2R6FgI7L87QYCiEUHCT87WdrbfiGBvFe8hvfSvWGN1uslcT3Yh6lGh1tvDrTNoY3guTHVQxPDSgRXb5qPjve4r4a7Bvn9Dn7h-ToN5PAULYanrA/s220/5019196.jpg'/></author><thr:total>0</thr:total></entry></feed>