tag:blogger.com,1999:blog-43775414790414353912024-03-13T22:10:15.632-07:00Sudipta K Paik on .NETAnonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.comBlogger46125tag:blogger.com,1999:blog-4377541479041435391.post-56512127396811704012017-07-04T04:21:00.002-07:002017-07-04T04:26:48.510-07:00Ubuntu commands<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-size: x-large;">Remove file or Directory</span></b><br />
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">sudo rm -rf index.html </span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">Copy all file to another Dir</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">sudo cp -a /var/www/html/meshdeveloperwebsite/. /var/www/html/</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">Lo</span></b><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">****************</span></b><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">g</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker logs name</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">Start</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker start name</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">Enter file Root</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker exec -t -i name /bin/bash</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">List ****************All</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker ps -a</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">List All</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker ps -a</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">List All</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker ps -a</span></pre>
</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-46953157705241810532017-06-09T02:46:00.002-07:002017-06-09T02:46:48.272-07:00docker commands<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-size: x-large;">Remove</span></b><br />
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker rm -f name</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">List All</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker ps -a</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">Log</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker logs name</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">Start</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker start name</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">Enter file Root</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker exec -t -i name /bin/bash</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">List ****************All</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker ps -a</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">List All</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker ps -a</span></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><b style="font-family: "times new roman"; white-space: normal;"><span style="font-size: large;">List All</span></b></pre>
<pre class="lang-js prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: #393318; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif;">docker ps -a</span></pre>
</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-39929967462564329012017-01-31T22:20:00.000-08:002017-01-31T22:20:07.516-08:00Set Folder R/W Permission Ubuntu<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-size: large;">sudo chmod -R 777 w3yelp</span></b></div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-85593290123916542732016-11-15T21:58:00.001-08:002016-11-15T21:58:31.525-08:00PostgreSQL Run on Docker with Create User and Database<div dir="ltr" style="text-align: left;" trbidi="on">
1.<br />
<blockquote class="tr_bq">
docker pull postgres</blockquote>
2<br />
<br />
<blockquote class="tr_bq">
docker run --name postgresdb -v /home/sudipto/Development/PostgresDb:/var/lib/postgresql/data -p 5432:5432 -e POSTGRES_PASSWORD=root -d postgres</blockquote>
3.<br />
<blockquote class="tr_bq">
<br /></blockquote>
<blockquote class="tr_bq">
docker inspect postgresdb</blockquote>
<br />
4.<br />
<blockquote class="tr_bq">
docker exec -it postgresdb bash</blockquote>
<br />
5.<br />
<blockquote class="tr_bq">
psql -U postgres -W</blockquote>
<br />
6.<br />
<br />
<blockquote class="tr_bq">
CREATE USER user11 SUPERUSER PASSWORD '69use420';</blockquote>
7.<br />
<blockquote class="tr_bq">
CREATE DATABASE pguser11db1;</blockquote>
8.<br />
<blockquote class="tr_bq">
GRANT ALL PRIVILEGES ON DATABASE pguser11db1 TO user11; </blockquote>
<blockquote class="tr_bq">
</blockquote>
<br />
<br />
<blockquote class="tr_bq">
</blockquote>
<br />
<br />
<blockquote class="tr_bq">
</blockquote>
<blockquote class="tr_bq">
</blockquote>
</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-67459032936915798212016-06-17T01:45:00.000-07:002016-11-02T02:21:48.355-07:00Copy a whole website via Linux command<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: #2c2d30; font-family: , "applelogo" , sans-serif; font-size: 15px; line-height: 22px;">wget --recursive --no-clobber --page-requisites --html-extension --convert-links --restrict-file-names=windows --domains </span><span style="color: #2a80b9;"><span style="background-color: white; box-sizing: border-box; font-size: 15px; line-height: 22px;">devitems.com</span></span><span style="background-color: white; color: #2c2d30; font-family: , "applelogo" , sans-serif; font-size: 15px; line-height: 22px;"> --no-parent </span><span style="color: #2a80b9;"><span style="background-color: white; box-sizing: border-box; font-size: 15px; line-height: 22px;">devitems.com/html/intensy-preview/</span></span><br />
<br />
<br />
------------------------Or------------------------------------<br />
<br />
<br />
wget --limit-rate=200k --no-clobber --convert-links --random-wait -r -p -E -e robots=off -U mozilla http://themesground.com/Superb/<br />
<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-24841492485580441752016-03-17T10:02:00.000-07:002016-03-17T10:02:21.187-07:00SingleTon Design Pattern Java<div dir="ltr" style="text-align: left;" trbidi="on">
Create a Java Application Project.<br />
<br />
Post this 2 class file in root.<br />
<br />
-------------File MainClass.java-----------------------------------------------------------------------------<br />
package singleton;<br />
<br />
public class MainClass {<br />
<br />
public static void main(String[] args) {<br />
<br />
MathHelper tmp = MathHelper.getInstance(12);<br />
MathHelper tmp2 = MathHelper.getInstance(14);<br />
MathHelper tmp3 = MathHelper.getInstance(16);<br />
<br />
tmp.demoMethod();<br />
tmp2.demoMethod();<br />
tmp3.demoMethod();<br />
}<br />
}<br />
------------------------------------------------------------------------------------------<br />
<br />
<br />
-------------File MathHelper.java-----------------------------------------------------------------------------<br />
package singleton;<br />
<br />
public class MathHelper {<br />
<br />
private static int sNumber;<br />
private static MathHelper singleton;<br />
/* A private Constructor prevents any other * class from instantiating. */<br />
<br />
private MathHelper() {<br />
}<br />
<br />
/* Static 'instance' method */<br />
public static MathHelper getInstance(int number) {<br />
if (singleton == null) {<br />
sNumber = number;<br />
singleton = new MathHelper();<br />
}<br />
return singleton;<br />
}<br />
/* Other methods protected by singleton-ness */<br />
<br />
public static void demoMethod() {<br />
System.out.println("DemoMethod for singleton: Number= " + sNumber);<br />
}<br />
}<br />
------------------------------------------------------------------------------------------<br />
<div>
<br /></div>
<br />
Run <b>MainClass.java</b> file.<br />
<br />
<b>You got result</b><br />
DemoMethod for singleton: Number= 12<br />
DemoMethod for singleton: Number= 12<br />
DemoMethod for singleton: Number= 12<br />
<br />
<b>Same result for every time.</b><br />
<br />
<br />
It's can update private static variable 'sNumber' only first time by method ‘getInstance()’. Because then no object create yet. Only first time object is null. Then it’s creating a new object by considering current object is null and return it. At that time 'sNumber' able to update its value to 12.<br />
<br />
After creating first time object, it will never able to create new object and can't update the 'sNumber'. It's return the same old object every time. And we got 12 , even we push new value when we get new object.<br />
<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-40423346550276858812015-12-28T23:37:00.005-08:002015-12-28T23:38:10.652-08:00Ubuntu Create Launcher<div dir="ltr" style="text-align: left;" trbidi="on">
create a file name with [<span style="background-color: #eeeeee; color: #111111; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; white-space: pre-wrap;">a</span>ndroid-studio<span style="background-color: #eeeeee; color: #111111; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; white-space: pre-wrap;">.desktop</span>]<br />
<br />
[-----------------------------------------------------------------------------------------------------------------------]<br />
[Desktop Entry]<br />
Version=1.0<br />
Type=Application<br />
Name=Android Studio<br />
Exec=/home/w3e/Programs/android-studio/bin/studio.sh<br />
Icon=/home/w3e/Programs/android-studio/bin/studio.png<br />
Categories=Development;IDE;<br />
Terminal=false<br />
StartupNotify=true<br />
StartupWMClass=jetbrains-android-studio<br />
Name[en_GB]=android-studio.desktop<br />
<br />
[-----------------------------------------------------------------------------------------------------------------------]<br />
<br />
<span style="background-color: white; color: #111111; font-family: Ubuntu, Arial, 'libra sans', sans-serif; font-size: 15px; line-height: 19.5px;">Dont forget to make the file executable (</span><code style="background-color: #eeeeee; border: 0px; color: #111111; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">chmod +x a<span style="color: black; font-family: 'Times New Roman'; font-size: small; white-space: normal;">ndroid-studio</span>.desktop</code><span style="background-color: white; color: #111111; font-family: Ubuntu, Arial, 'libra sans', sans-serif; font-size: 15px; line-height: 19.5px;">).</span></div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-57131745689012263182015-07-27T21:28:00.002-07:002015-07-27T21:33:19.712-07:00Complexity Reducing of Java Code<div dir="ltr" style="text-align: left;" trbidi="on">
<pre style="background-color: white; color: black; font-family: 'Courier New'; font-size: 15.0pt;"><span style="color: navy; font-weight: bold;">public boolean </span>isAllowedFileExtension(String extension) {
<span style="color: navy; font-weight: bold;">boolean </span>isSupported = <span style="color: navy; font-weight: bold;">false</span>;
<span style="color: navy; font-weight: bold;">try </span>{
<span style="color: grey; font-style: italic;">///Instead of this code block, use following block </span><span style="color: grey; font-style: italic;"> </span><span style="color: navy; font-weight: bold;"> </span></pre>
<pre style="background-color: white; color: black; font-family: 'Courier New'; font-size: 15.0pt;"><span style="color: navy; font-weight: bold;"> if </span>(extension.contains(<span style="color: green; font-weight: bold;">"pdf"</span>)
|| extension.contains(<span style="color: green; font-weight: bold;">"doc"</span>)
|| extension.contains(<span style="color: green; font-weight: bold;">"docx"</span>)
|| extension.contains(<span style="color: green; font-weight: bold;">"ppt"</span>)
|| extension.contains(<span style="color: green; font-weight: bold;">"pptx"</span>)
|| extension.contains(<span style="color: green; font-weight: bold;">"apk"</span>)
|| extension.contains(<span style="color: green; font-weight: bold;">"zip"</span>)
|| extension.contains(<span style="color: green; font-weight: bold;">"rar"</span>)) </pre>
<pre style="background-color: white; color: black; font-family: 'Courier New'; font-size: 15.0pt;"> {
isSupported = <span style="color: navy; font-weight: bold;">true</span>;
}
<span style="color: grey; font-style: italic;">///Use this code block, instead of above code block </span><span style="color: grey; font-style: italic;"> </span></pre>
<pre style="background-color: white; color: black; font-family: 'Courier New'; font-size: 15.0pt;"><span style="color: grey; font-style: italic;"> </span>String[] fieldsToInclude = {<span style="color: green; font-weight: bold;">"pdf"</span>, <span style="color: green; font-weight: bold;">"doc"</span>, <span style="color: green; font-weight: bold;">"docx"</span>,<span style="color: green; font-weight: bold;">"ppt"</span>};
<span style="color: navy; font-weight: bold;"> </span></pre>
<pre style="background-color: white; color: black; font-family: 'Courier New'; font-size: 15.0pt;"><span style="color: navy; font-weight: bold;"> for </span>(<span style="color: navy; font-weight: bold;">int </span>i = <span style="color: blue;">0</span>; i < fieldsToInclude.<span style="color: #660e7a; font-weight: bold;">length</span>; i++) {
<span style="color: navy; font-weight: bold;">if </span>(extension.contains(fieldsToInclude[i]))
isSupported = <span style="color: navy; font-weight: bold;">true</span>;
<span style="color: navy; font-weight: bold;">break</span>;
}
} <span style="color: navy; font-weight: bold;">catch </span>(Exception e) {
Log.<span style="font-style: italic;">e</span>(<span style="color: green; font-weight: bold;">"isAllowedFile"</span>, e.toString());
}
<span style="color: navy; font-weight: bold;">return </span>isSupported;
}</pre>
</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-18953921781843651212014-11-16T01:38:00.003-08:002014-11-16T01:38:36.509-08:00Optional Parameters Sequence Interchange<div dir="ltr" style="text-align: left;" trbidi="on">
///Calling Class<br />
public class Student<br />
{<br />
public void PrintList()<br />
{<br />
var wg = new WebGrid();<br />
wg.Print(new List<Student>(), 1, 100, "Name", "ASC");<br />
}<br />
}<br />
///Called Class<br />
public class WebGrid<br />
{<br />
//Main Method<br />
internal void Print(List<Student> list, int page, int size, string sortBy, string sortDirection)<br />
{<br />
//No Error<br />
throw new NotImplementedException();<br />
}<br />
<br />
//You Want<br />
internal void Print(List<Student> list, int page, int size, string sortBy = "Name", string sortDirection)<br />
{<br />
//Error , Optional parameters must appear after all required parameters<br />
throw new NotImplementedException();<br />
}<br />
//Your Solution<br />
internal void Print(List<Student> list, int page, int size, string sortBy = "Name", string sortDirection = "")<br />
{<br />
//Just make the sortDirection as optional Parameter<br />
throw new NotImplementedException();<br />
}<br />
// Another Solution<br />
internal void Print(List<Student> list, int page, int size, [Optional, DefaultParameterValue("Name")] string sortBy, string sortDirection)<br />
{<br />
// No Error, Its uses Reflection<br />
throw new NotImplementedException();<br />
}<br />
}</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-45716346515192331622014-11-04T02:35:00.000-08:002014-11-04T02:35:45.931-08:00Color Your Web Page<div dir="ltr" style="text-align: left;" trbidi="on">
Right click on Page> Inspect Element> Console> Paste code> Press Enter<br />
<br />
Your widow will be colored<br />
<br />
----------------------------------------------------------------------------------------------------<br />
<blockquote class="tr_bq">
<blockquote class="tr_bq">
[].forEach.call($$("*"),function(a){</blockquote>
<blockquote class="tr_bq">
a.style.outline="1px solid #"+(~~(Math.random()*(1<<24))).toString(16)</blockquote>
<blockquote class="tr_bq">
})</blockquote>
</blockquote>
----------------------------------------------------------------------------------------------------</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-21452225287433861602014-09-23T23:45:00.002-07:002014-09-23T23:45:20.488-07:00RDLC Report Footer Problem in DOC and PDF<div dir="ltr" style="text-align: left;" trbidi="on">
Write following code<br />
="Page " & Globals!PageNumber & " of " & Globals!TotalPages<br />
<br />
instead of<br />
="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString()<br />
<br />
<br />
i. e. : replace + sign with &<br />
and remove ToString() casting</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-52259114675641265032014-08-22T03:50:00.003-07:002014-08-22T03:50:37.707-07:00Language List for Dropdown List(HTML)<div dir="ltr" style="text-align: left;" trbidi="on">
<select name="nationality"><br />
<option value="">-- select one --</option><br />
<option value="afghan">Afghan</option><br />
<option value="albanian">Albanian</option><br />
<option value="algerian">Algerian</option><br />
<option value="american">American</option><br />
<option value="andorran">Andorran</option><br />
<option value="angolan">Angolan</option><br />
<option value="antiguans">Antiguans</option><br />
<option value="argentinean">Argentinean</option><br />
<option value="armenian">Armenian</option><br />
<option value="australian">Australian</option><br />
<option value="austrian">Austrian</option><br />
<option value="azerbaijani">Azerbaijani</option><br />
<option value="bahamian">Bahamian</option><br />
<option value="bahraini">Bahraini</option><br />
<option value="bangladeshi">Bangladeshi</option><br />
<option value="barbadian">Barbadian</option><br />
<option value="barbudans">Barbudans</option><br />
<option value="batswana">Batswana</option><br />
<option value="belarusian">Belarusian</option><br />
<option value="belgian">Belgian</option><br />
<option value="belizean">Belizean</option><br />
<option value="beninese">Beninese</option><br />
<option value="bhutanese">Bhutanese</option><br />
<option value="bolivian">Bolivian</option><br />
<option value="bosnian">Bosnian</option><br />
<option value="brazilian">Brazilian</option><br />
<option value="british">British</option><br />
<option value="bruneian">Bruneian</option><br />
<option value="bulgarian">Bulgarian</option><br />
<option value="burkinabe">Burkinabe</option><br />
<option value="burmese">Burmese</option><br />
<option value="burundian">Burundian</option><br />
<option value="cambodian">Cambodian</option><br />
<option value="cameroonian">Cameroonian</option><br />
<option value="canadian">Canadian</option><br />
<option value="cape verdean">Cape Verdean</option><br />
<option value="central african">Central African</option><br />
<option value="chadian">Chadian</option><br />
<option value="chilean">Chilean</option><br />
<option value="chinese">Chinese</option><br />
<option value="colombian">Colombian</option><br />
<option value="comoran">Comoran</option><br />
<option value="congolese">Congolese</option><br />
<option value="costa rican">Costa Rican</option><br />
<option value="croatian">Croatian</option><br />
<option value="cuban">Cuban</option><br />
<option value="cypriot">Cypriot</option><br />
<option value="czech">Czech</option><br />
<option value="danish">Danish</option><br />
<option value="djibouti">Djibouti</option><br />
<option value="dominican">Dominican</option><br />
<option value="dutch">Dutch</option><br />
<option value="east timorese">East Timorese</option><br />
<option value="ecuadorean">Ecuadorean</option><br />
<option value="egyptian">Egyptian</option><br />
<option value="emirian">Emirian</option><br />
<option value="equatorial guinean">Equatorial Guinean</option><br />
<option value="eritrean">Eritrean</option><br />
<option value="estonian">Estonian</option><br />
<option value="ethiopian">Ethiopian</option><br />
<option value="fijian">Fijian</option><br />
<option value="filipino">Filipino</option><br />
<option value="finnish">Finnish</option><br />
<option value="french">French</option><br />
<option value="gabonese">Gabonese</option><br />
<option value="gambian">Gambian</option><br />
<option value="georgian">Georgian</option><br />
<option value="german">German</option><br />
<option value="ghanaian">Ghanaian</option><br />
<option value="greek">Greek</option><br />
<option value="grenadian">Grenadian</option><br />
<option value="guatemalan">Guatemalan</option><br />
<option value="guinea-bissauan">Guinea-Bissauan</option><br />
<option value="guinean">Guinean</option><br />
<option value="guyanese">Guyanese</option><br />
<option value="haitian">Haitian</option><br />
<option value="herzegovinian">Herzegovinian</option><br />
<option value="honduran">Honduran</option><br />
<option value="hungarian">Hungarian</option><br />
<option value="icelander">Icelander</option><br />
<option value="indian">Indian</option><br />
<option value="indonesian">Indonesian</option><br />
<option value="iranian">Iranian</option><br />
<option value="iraqi">Iraqi</option><br />
<option value="irish">Irish</option><br />
<option value="israeli">Israeli</option><br />
<option value="italian">Italian</option><br />
<option value="ivorian">Ivorian</option><br />
<option value="jamaican">Jamaican</option><br />
<option value="japanese">Japanese</option><br />
<option value="jordanian">Jordanian</option><br />
<option value="kazakhstani">Kazakhstani</option><br />
<option value="kenyan">Kenyan</option><br />
<option value="kittian and nevisian">Kittian and Nevisian</option><br />
<option value="kuwaiti">Kuwaiti</option><br />
<option value="kyrgyz">Kyrgyz</option><br />
<option value="laotian">Laotian</option><br />
<option value="latvian">Latvian</option><br />
<option value="lebanese">Lebanese</option><br />
<option value="liberian">Liberian</option><br />
<option value="libyan">Libyan</option><br />
<option value="liechtensteiner">Liechtensteiner</option><br />
<option value="lithuanian">Lithuanian</option><br />
<option value="luxembourger">Luxembourger</option><br />
<option value="macedonian">Macedonian</option><br />
<option value="malagasy">Malagasy</option><br />
<option value="malawian">Malawian</option><br />
<option value="malaysian">Malaysian</option><br />
<option value="maldivan">Maldivan</option><br />
<option value="malian">Malian</option><br />
<option value="maltese">Maltese</option><br />
<option value="marshallese">Marshallese</option><br />
<option value="mauritanian">Mauritanian</option><br />
<option value="mauritian">Mauritian</option><br />
<option value="mexican">Mexican</option><br />
<option value="micronesian">Micronesian</option><br />
<option value="moldovan">Moldovan</option><br />
<option value="monacan">Monacan</option><br />
<option value="mongolian">Mongolian</option><br />
<option value="moroccan">Moroccan</option><br />
<option value="mosotho">Mosotho</option><br />
<option value="motswana">Motswana</option><br />
<option value="mozambican">Mozambican</option><br />
<option value="namibian">Namibian</option><br />
<option value="nauruan">Nauruan</option><br />
<option value="nepalese">Nepalese</option><br />
<option value="new zealander">New Zealander</option><br />
<option value="ni-vanuatu">Ni-Vanuatu</option><br />
<option value="nicaraguan">Nicaraguan</option><br />
<option value="nigerien">Nigerien</option><br />
<option value="north korean">North Korean</option><br />
<option value="northern irish">Northern Irish</option><br />
<option value="norwegian">Norwegian</option><br />
<option value="omani">Omani</option><br />
<option value="pakistani">Pakistani</option><br />
<option value="palauan">Palauan</option><br />
<option value="panamanian">Panamanian</option><br />
<option value="papua new guinean">Papua New Guinean</option><br />
<option value="paraguayan">Paraguayan</option><br />
<option value="peruvian">Peruvian</option><br />
<option value="polish">Polish</option><br />
<option value="portuguese">Portuguese</option><br />
<option value="qatari">Qatari</option><br />
<option value="romanian">Romanian</option><br />
<option value="russian">Russian</option><br />
<option value="rwandan">Rwandan</option><br />
<option value="saint lucian">Saint Lucian</option><br />
<option value="salvadoran">Salvadoran</option><br />
<option value="samoan">Samoan</option><br />
<option value="san marinese">San Marinese</option><br />
<option value="sao tomean">Sao Tomean</option><br />
<option value="saudi">Saudi</option><br />
<option value="scottish">Scottish</option><br />
<option value="senegalese">Senegalese</option><br />
<option value="serbian">Serbian</option><br />
<option value="seychellois">Seychellois</option><br />
<option value="sierra leonean">Sierra Leonean</option><br />
<option value="singaporean">Singaporean</option><br />
<option value="slovakian">Slovakian</option><br />
<option value="slovenian">Slovenian</option><br />
<option value="solomon islander">Solomon Islander</option><br />
<option value="somali">Somali</option><br />
<option value="south african">South African</option><br />
<option value="south korean">South Korean</option><br />
<option value="spanish">Spanish</option><br />
<option value="sri lankan">Sri Lankan</option><br />
<option value="sudanese">Sudanese</option><br />
<option value="surinamer">Surinamer</option><br />
<option value="swazi">Swazi</option><br />
<option value="swedish">Swedish</option><br />
<option value="swiss">Swiss</option><br />
<option value="syrian">Syrian</option><br />
<option value="taiwanese">Taiwanese</option><br />
<option value="tajik">Tajik</option><br />
<option value="tanzanian">Tanzanian</option><br />
<option value="thai">Thai</option><br />
<option value="togolese">Togolese</option><br />
<option value="tongan">Tongan</option><br />
<option value="trinidadian or tobagonian">Trinidadian or Tobagonian</option><br />
<option value="tunisian">Tunisian</option><br />
<option value="turkish">Turkish</option><br />
<option value="tuvaluan">Tuvaluan</option><br />
<option value="ugandan">Ugandan</option><br />
<option value="ukrainian">Ukrainian</option><br />
<option value="uruguayan">Uruguayan</option><br />
<option value="uzbekistani">Uzbekistani</option><br />
<option value="venezuelan">Venezuelan</option><br />
<option value="vietnamese">Vietnamese</option><br />
<option value="welsh">Welsh</option><br />
<option value="yemenite">Yemenite</option><br />
<option value="zambian">Zambian</option><br />
<option value="zimbabwean">Zimbabwean</option><br />
</select></div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-90287351865262873012014-07-15T04:01:00.003-07:002014-10-26T22:44:21.113-07:00Debug or Run SP in Oracle<div dir="ltr" style="text-align: left;" trbidi="on">
Oracle SP<br />
--------------------------------------------------------------------------------------------------------------------<br />
CREATE OR REPLACE PROCEDURE <b>RPT_MFS_Revised_Journal </b>(<br />
P_JOURNAL_DATE IN DATE := NULL,<br />
cur_OUT IN OUT SYS_REFCURSOR)<br />
AS<br />
BEGIN<br />
OPEN cur_out FOR<br />
SELECT TO_CHAR (TransactionDate, 'DD/MM/YYYY') AS TransactionDate,<br />
TXCODE, <br />
FROM T_Activity, <br />
WHERE ( (T_Activity.IsRollBack = 0)<br />
OR (T_Activity.IsRollBack = 1 <br />
ORDER BY T_Activity.TxID;<br />
END;<br />
/<br />
----------------------------------------------------------------------------------------------------------------------<br />
<br />
Suppose<br />
<b>SP Name:</b> RPT_MFS_Revised_Journal<br />
Parameters:<br />
<b>P_JOURNAL_DATE </b> : '10/25/2014'<br />
<br />
<br />
To Debug SP Write Following Code<br />
---------------------------------------------------------------------<br />
BEGIN<br />
<b>RPT_MFS_Revised_Journal </b>(<br />
:P_JOURNAL_DATE,<br />
:cur_OUT);<br />
END;<br />
---------------------------------------------------------------------<br />
<br />
Select code and click [<b>Execute statement</b>] from left side {blue play button}<br />
A Variables window popup. Select date type for [<b>P_JOURNAL_DATE</b>] and input date('<b>10/25/2014</b>') and null for [<b>cur_OUT</b>]<br />
Then click <b>OK</b>.<br />
<br />
If Everything ok, then you got actual result.</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-49221119095913169582014-07-09T22:06:00.000-07:002014-07-09T22:06:27.196-07:00Oracle Column type in SP Parameter<div dir="ltr" style="text-align: left;" trbidi="on">
p_FILEEXTENSION IN USACCTFLINFO.FILEEXTENSION%type := NULL<br />
<br />
<br />
SP Parameter Name: p_FILEEXTENSION<br />
Table Name: USACCTFLINFO<br />
Table Column Name: FILEEXTENSION<br />
<br />
<br />
If you want parameter type as column type then just write above code in SP</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-62337060203197692202014-07-08T20:27:00.003-07:002014-07-09T21:34:10.584-07:00Text area Max Length by Jquery in asp.net<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>HTML</u></b><br />
<asp:TextBox ID="txtmailingaddress1" runat="server" CssClass="textboxNormalLeftAligned inputField textarea200" TextMode="MultiLine" MaxLength="15" onkeyDown="checkTextAreaMaxLength2(this,event,'20');" /><br />
<b><u><br /></u></b>
<b><u><br /></u></b>
<b><u><br /></u></b>
<b><u>From Last character will be deleted.</u></b><br />
<b><u><br /></u></b>
$('.textarea200').keyup(function () {<br />
var limit = 200; // parseInt($(this).attr('maxlength'));<br />
var text = $(this).val();<br />
var chars = text.length;<br />
if (chars > limit) {<br />
var new_text = text.substr(0, limit);<br />
$(this).val(new_text);<br />
}<br />
});<br />
-----------------------------------------------------------------------------------------<br />
<br />
<b><u>Character will not deleted but you can input Enter between word.</u></b><br />
<b><u><br /></u></b>
$("textarea.textarea2002").keydown(function (event) {<br />
var limit = 200;<br />
var text = $(this).val();<br />
var chars = text.length;<br />
alert(chars);<br />
if ((event.keyCode == null) || (event.keyCode == 0) || (event.keyCode == 8) || (event.keyCode == 9) || (event.keyCode == 13) || (event.keyCode == 27) || (event.keyCode == 33) || (event.keyCode == 34) || (event.keyCode == 35) || (event.keyCode == 36) || (event.keyCode == 37) || (event.keyCode == 38) || (event.keyCode == 39) || (event.keyCode == 40) || (event.keyCode == 46)) {} else {<br />
if (chars <= limit) {} else {<br />
event.preventDefault();<br />
}<br />
}<br />
});<br />
<br />
-----------------------------------------------------------------------------------------<br />
<br />
<b><u>You cant enter any value between string after 200 character length</u></b><br />
<br />
function checkTextAreaMaxLength(textBox, e, mLen) {<br />
<br />
var mLen = textBox["MaxLength"];<br />
if (null == mLen)<br />
mLen = length;<br />
<br />
var maxLength = parseInt(mLen);<br />
if (!checkSpecialKeys(e)) {<br />
if (textBox.value.length > maxLength - 1) {<br />
if (window.event) //IE<br />
e.returnValue = false;<br />
else //Firefox<br />
e.preventDefault();<br />
}<br />
}<br />
}<br />
<br />
function checkSpecialKeys(e) {<br />
if (e.keyCode != 8 && e.keyCode != 46 && e.keyCode != 37 && e.keyCode != 38 && e.keyCode != 39 && e.keyCode != 40) {<br />
return false;<br />
} else {<br />
return true;<br />
}<br />
}<br />
-----------------------------------------------------------------------------------------<br />
Run in JsFiddle:<br />
<a href="http://jsfiddle.net/skpaik/L9brP">http://jsfiddle.net/skpaik/L9brP</a></div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-82874610836045430662014-05-17T21:51:00.002-07:002014-08-12T22:15:14.986-07:00Run Stored Procedure in Oracle Toad Client <div dir="ltr" style="text-align: left;" trbidi="on">
--- Procedure Name 'GetCashAccountByUserNumber'<br />
--------------------------------------------------------------<br />
<br />
CREATE OR REPLACE PROCEDURE GetCashAccountByUserNumber<br />
<br />
(p_CREATEDBY IN NUMBER := NULL,<br />
p_CREATEDDATE IN DATE := NULL,<br />
p_UPDATEDBY IN NUMBER := NULL,<br />
p_UPDATEDDATE IN DATE := NULL,<br />
p_IPADDRESS VARCHAR2 := NULL,<br />
p_FORMID IN NUMBER := NULL,<br />
p_UserNumber IN NUMBER DEFAULT NULL,<br />
p_BankKey IN NUMBER DEFAULT NULL,<br />
cur_OUT IN OUT SYS_REFCURSOR)<br />
AS<br />
BEGIN<br />
OPEN cur_OUT FOR<br />
SELECT UserAccounts.UserKey,<br />
UserAccounts.AccountTypeKey,<br />
UserAccounts.UserNumber,<br />
SysAcct.SystemAccountID,<br />
SysAcctRefUsAcct.SystemAccountRefID,<br />
SysAcctRefUsAcct.UserCurrentBalance,<br />
SysAcctRefUsAcct.BlockedAmount,<br />
SysAcctRefUsAcct.IsVAT,<br />
SysAcctRefUsAcct.IsCOM,<br />
SysAcctRefUsAcct.IsActive,<br />
SysAcctRefUsAcct.ParentCode,<br />
SysAcct.AccountNumber,<br />
SysAcct.AccountDescription,<br />
UserAccounts.UserNumber ParentUserNumber<br />
FROM SysAcct<br />
JOIN SysAcctRefUsAcct<br />
ON SysAcct.SystemAccountID = SysAcctRefUsAcct.SystemAccountID<br />
JOIN UserAccounts<br />
ON SysAcctRefUsAcct.UserKey = UserAccounts.UserKey<br />
JOIN Bank<br />
ON SysAcctRefUsAcct.BankKey = Bank.BankKey<br />
AND UserAccounts.BankKey = Bank.BankKey<br />
WHERE UserAccounts.UserNumber = p_UserNumber<br />
AND SysAcct.AccountNumber = '5008'<br />
AND UserAccounts.BankKey = p_BankKey<br />
ORDER BY UserAccounts.UserKey;<br />
END;<br />
/<br />
<br />
--------------------------------------------------------------<br />
To Run Open Editor<br />
Write following code<br />
<br />
<br />
BEGIN<br />
E_GetCashAccountByUserNumber<br />
(<br />
:p_CREATEDBY,<br />
:p_CREATEDDATE,<br />
:p_UPDATEDBY,<br />
:p_UPDATEDDATE,<br />
:p_IPADDRESS,<br />
:p_FORMID,<br />
:p_UserNumber,<br />
:p_BankKey,<br />
:cur_OUT<br />
);<br />
END;<br />
--------------------------------------------------------------<br />
<br />
Then Ctrl+A for select all code<br />
<br />
Click on 'Excecute statement' Button<br />
<br />
Give all Value type and Value<br />
<br />
<br />
Press OK</div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-40516126429446801312014-05-05T05:03:00.003-07:002014-05-05T05:08:39.847-07:00SQL SERVER – Introduction to Rollup Clause<div dir="ltr" style="text-align: left;" trbidi="on">
Create a Database<br />
Then new Script<br />
Then Fire this.<br />
------------------------------------------------------------------------------<br />
<br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">CREATE TABLE </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">Country </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VARCHAR</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">100</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">),</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">[State] </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VARCHAR</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">100</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">),</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">City </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VARCHAR</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">100</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">),</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">[Population (in Millions)] </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INT</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="background-color: white; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; text-align: justify;">GO</span><br />
<span style="background-color: white; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; text-align: justify;"><br /></span>
<span style="background-color: white; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; text-align: justify;"><br /></span>
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'East Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">9 </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'South Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">8 </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'North Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">5.5</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'West Delhi'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">7.5</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Karnataka'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Bangalore'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">9.5</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Karnataka'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Belur'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">2.5</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Karnataka'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Manipal'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">1.5</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Maharastra'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Mumbai'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">30</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Maharastra'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Pune'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">20</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Maharastra'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Nagpur'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">11 </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">INSERT INTO </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">VALUES</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'India'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">, </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Maharastra'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: red; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">'Nashik'</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">6.5</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">)</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">GO</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;"><br /></span>
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;"><br /></span>
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;"><br /></span>
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">---To Display </span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;"><br /></span>
<br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">SELECT </span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">ISNULL(Country,'All Country') AS Country</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">ISNULL([State],'All State') AS State</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">ISNULL(City,'All City') AS City</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: magenta; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">SUM </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">(</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">[Population (in Millions)]</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">) </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">AS </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">[Population (in Millions)]</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">FROM </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">tblPopulation</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">GROUP BY </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">Country</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">[State]</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: grey; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">,</span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">City </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; color: blue; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">WITH </span><span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;">ROLLUP</span><br />
<span style="-webkit-transition: 0ms; background-color: white; border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 16px; font-weight: bold; margin: 0px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: 0ms; vertical-align: baseline;"><br /></span>
<br />
<br />
<br />
<br />
<br />
<br />
Details: <a href="http://blog.sqlauthority.com/2010/02/24/sql-server-introduction-to-rollup-clause" target="_blank">http://blog.sqlauthority.com/2010/02/24/sql-server-introduction-to-rollup-clause</a></div>
Anonymoushttp://www.blogger.com/profile/13507613436159430327noreply@blogger.com1tag:blogger.com,1999:blog-4377541479041435391.post-37970213303875148312012-04-19T07:25:00.001-07:002012-04-19T07:25:19.164-07:00Upload Excel to SQL Server using OleDbConnection<div><span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:15px;line-height:20px;background-color:rgb(255,255,255)">importExcel.aspx Page</span></div><span style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:15px;line-height:20px;background-color:rgb(255,255,255)">=====================================================================</span> <div><span style="background-color:rgb(255,255,255)"><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="importExcel.aspx.cs" Inherits="Eisk.Web.admin.importExcel" %></span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<a href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd</a>"></span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><html xmlns="<a href="http://www.w3.org/1999/xhtml">http://www.w3.org/1999/xhtml</a>"></span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><head runat="server"></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> <title>Upload Excel File to Database </title></span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"></head></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><body></span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> <form id="form1" runat="server"></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> <asp:FileUpload ID="fluInput" runat="server" /></span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> <asp:Button ID="btnImport" Text="Import" runat="server" OnClick="btnUploadFile_Click"</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> CssClass="button medium green" /></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> </form></span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"></body></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"></html></span></font></div> <div style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:15px;line-height:20px">===================================================================== </div><div style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:15px;line-height:20px">Code Behind importExcel.aspx.cs</div><div style="color:rgb(51,51,51);font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:15px;line-height:20px"> ===================================================================== </div><div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">using System;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">using System.Collections.Generic;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">using System.Data;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">using System.Data.OleDb;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">using System.IO;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">using Eisk.BusinessEntities;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">using Eisk.BusinessLogicLayer;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">namespace Eisk.Web.admin</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">{</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> public partial class importExcel : System.Web.UI.Page</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> protected void Page_Load(object sender, EventArgs e)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> protected void btnUploadFile_Click(object sender, EventArgs e)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> ConvertFile();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> protected void ConvertFile()</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (fluInput.HasFile)</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string strFileName = Server.HtmlEncode(fluInput.FileName);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string strExtension = Path.GetExtension(strFileName);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (strExtension != ".xls" && strExtension != ".xlsx")</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> Response.Write("<script>alert('Please select a Excel spreadsheet to import!');</script>");</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> return;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string strUploadFileName = "~/admin/Excell/" + DateTime.Now.ToString("yyyyMMddHHmmss") + strExtension;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> strUploadFileName = Server.MapPath(strUploadFileName);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> fluInput.SaveAs(strUploadFileName);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string connectionString = "";</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (strExtension == ".xls")</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strUploadFileName + ";Extended Properties='Excel 8.0;HDR=YES;'";</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> else</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strUploadFileName + ";Extended Properties='Excel 12.0 Xml;HDR=YES;'";</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> try</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> OleDbConnection connection = new OleDbConnection(connectionString);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> connection.Open();</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string sheetName = "Sheet1";</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string query = "SELECT * FROM [" + sheetName + "$]";</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> OleDbDataAdapter adapter = new OleDbDataAdapter(query, connection);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> DataSet ds = new DataSet();</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> DataTable dt = new DataTable();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> adapter.Fill(ds);</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> dt = ds.Tables[0];</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> adapter.Fill(dt);</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> connection.Close();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> int number_of_columns = dt.Columns.Count;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> int number_of_rows = ds.Tables[0].Rows.Count / 2;</span></font></div><div> <font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string[,] sheetEntries = new string[number_of_rows, number_of_columns];</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string[] columnNames = new string[number_of_columns];</span></font></div><div> <font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> int startingColumn = 1;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> for (int i = startingColumn; i < number_of_rows; i++)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> for (int j = 0; j < number_of_columns; j++)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> sheetEntries[i, j] = dt.Rows[i].ItemArray.GetValue(j).ToString();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> List<ActivationCode> activationCodeList = CovertToList(sheetEntries, number_of_columns, number_of_rows);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> ExportToSQLServerActivationCode(activationCodeList);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (File.Exists(strUploadFileName))</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> File.Delete(strUploadFileName);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> catch (Exception ex)</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> private List<ActivationCode> CovertToList(string[,] sheetEntries, int number_of_columns, int number_of_rows)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> List<ActivationCode> aclist = new List<ActivationCode>();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> ActivationCode aCode = null;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> DateTime toDay = DateTime.Now;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> for (int i = 0; i < number_of_rows; i++)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode = new ActivationCode();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string activationCodeName = StringNullOrEmptyChecking(sheetEntries[i, 2]);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string servicePlanSKU = StringNullOrEmptyChecking(sheetEntries[i, 5]);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (!string.IsNullOrEmpty(activationCodeName) && !string.IsNullOrEmpty(servicePlanSKU))</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode.ActivationCodeName = activationCodeName;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode.ServicePlanSKU = servicePlanSKU;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode.MinProductsNo = 1;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string maxProductsNo = StringNullOrEmptyChecking(sheetEntries[i, 11]);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (!string.IsNullOrEmpty(maxProductsNo))</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode.MaxProductsNo = Convert.ToInt16(maxProductsNo);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> else</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode.MaxProductsNo = 1;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode.IsUsed = false;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aCode.UploadDate = toDay;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> aclist.Add(aCode);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> return aclist;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> private string StringNullOrEmptyChecking(object value)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (value == null)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> return null;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> string returnValue = null;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (value != null)</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> returnValue = value.ToString();</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (value == "")</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> returnValue = null;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> return returnValue;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> private void ExportToSQLServerActivationCode(List<ActivationCode> activationCodeList)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> ActivationCodeBLL activationCodeBLL = new ActivationCodeBLL();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> ActivationCodeRejectedBLL activationCodeRejectedBLL = new ActivationCodeRejectedBLL();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> List<ActivationCode> allActivationCodeList = activationCodeBLL.GetAllActivationCodes();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> List<ActivationCode> allActivationCodeListSelected = new List<ActivationCode>();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> List<ActivationCodeRejected> activationCodeRejectedList = new List<ActivationCodeRejected>();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> foreach (ActivationCode item in activationCodeList)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> ActivationCode isExists = allActivationCodeList.Find(x => x.ActivationCodeName == item.ActivationCodeName);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> if (isExists == null)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> allActivationCodeListSelected.Add(item);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> else</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> ActivationCodeRejected activationCodeRejected = new ActivationCodeRejected();</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejected.ActivationCodeName = item.ActivationCodeName;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejected.ServicePlanSKU = item.ServicePlanSKU;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejected.MinProductsNo = item.MinProductsNo;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejected.MaxProductsNo = item.MaxProductsNo;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejected.IsUsed = item.IsUsed;</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejected.UploadDate = item.UploadDate;</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejectedList.Add(activationCodeRejected);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br></span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> foreach (var item in allActivationCodeListSelected)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeBLL.CreateNewActivationCode(item);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"><br> </span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> foreach (var item in activationCodeRejectedList)</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> {</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> activationCodeRejectedBLL.CreateNewActivationCodeRejected(item);</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div> <div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px"> }</span></font></div><div><font color="#333333" face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="font-size:15px;line-height:20px">}</span></font></div> </div></span></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-61371491350685409562012-04-10T02:42:00.001-07:002012-04-19T07:27:50.715-07:00asp:GridView UI Databind<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
<div>
Backend CS File</div>
<div>
------------------------------------------------------------------------------------------------------------------------------------------------------------</div>
<div>
<br /></div>
<div>
List<ActivationCodeRejected> activationCodeRejectedList = new ActivationCodeRejectedBLL().GetAllActivationCodeRejecteds();</div>
<div>
<br /></div>
<div>
GridViewActivationCodeRejected.DataSource = activationCodeRejectedList;</div>
<div>
GridViewActivationCodeRejected.DataBind();</div>
</div>
<div>
<br /></div>
<div>
==========================================================================================</div>
<div>
Front end .aspx Page</div>
<div>
------------------------------------------------------------------------------------------------------------------------------------------------------------</div>
<div>
<asp:GridView ID="GridViewActivationCodeRejected" runat="server" AutoGenerateColumns="false"</div>
<div>
AllowPaging="false" GridLines="Both" SkinID="GridView" Visible="true"></div>
<div>
<Columns></div>
<div>
<asp:TemplateField HeaderText="Activation Code Name"></div>
<div>
<ItemTemplate></div>
<div>
<asp:Literal ID="ActivationCodeName" runat="server" Text='<%# Bind("ActivationCodeName") %>'></asp:Literal></div>
<div>
</ItemTemplate></div>
<div>
</asp:TemplateField></div>
<div>
<asp:TemplateField HeaderText="Service Plan SKU"></div>
<div>
<ItemTemplate></div>
<div>
<asp:Literal ID="ServicePlanSKU" runat="server" Text='<%# Bind("ServicePlanSKU") %>'></asp:Literal></div>
<div>
</ItemTemplate></div>
<div>
</asp:TemplateField></div>
<div>
<asp:TemplateField HeaderText="Min Products No"></div>
<div>
<ItemTemplate></div>
<div>
<asp:Literal ID="MinProductsNo" runat="server" Text='<%# Bind("MinProductsNo") %>'></asp:Literal></div>
<div>
</ItemTemplate></div>
<div>
</asp:TemplateField></div>
<div>
<asp:TemplateField HeaderText="Max Products No"></div>
<div>
<ItemTemplate></div>
<div>
<asp:Literal ID="MaxProductsNo" runat="server" Text='<%# Bind("MaxProductsNo") %>'></asp:Literal></div>
<div>
</ItemTemplate></div>
<div>
</asp:TemplateField></div>
<div>
<asp:TemplateField HeaderText="Upload Date"></div>
<div>
<ItemTemplate></div>
<div>
<asp:Literal ID="UploadDate" runat="server" Text='<%# Bind("UploadDate") %>'></asp:Literal></div>
<div>
</ItemTemplate></div>
<div>
</asp:TemplateField></div>
<div>
</Columns></div>
<div>
</asp:GridView></div>
</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-53262144464969125262012-04-10T02:38:00.001-07:002012-04-10T02:38:59.510-07:00Return URL in ASP.NET<div>Login Status Check Page</div><div>----------------------------------------------------------------------------------------------------------------------------------------------</div><div> if (!HttpContext.Current.User.Identity.IsAuthenticated)</div> <div> Response.Redirect(SiteSettings.BaseUrl + "admin/login.aspx?ReturnUrl="+Page.AppRelativeVirtualPath.ToString());</div><div><br></div><div><br></div><div>=========================================================================</div> <div>login.asp.cs Page</div><div>----------------------------------------------------------------------------------------------------------------------------------------------</div><div><div> Admin_User admin = new Admin_UserBLL().GetAdminUserByUserNamePassword(txtUserName.Text.Trim(), txtPassword.Text.Trim());</div> <div><br></div><div> if (admin != null)</div><div> {</div><div> System.Web.Security.FormsAuthentication.RedirectFromLoginPage(admin.User_Name, true);</div><div><br></div><div> string ReturnUrl = Request.QueryString["ReturnUrl"];</div><div><br></div><div> if (!string.IsNullOrEmpty(ReturnUrl))</div><div> {</div><div> Response.Redirect(ReturnUrl);</div> <div> }</div><div> else</div><div> {</div><div> Response.Redirect(SiteSettings.BaseUrl + "admin/Default.aspx");</div><div> }</div> <div> }</div><div> else</div><div> {</div><div> divMessage.Visible = true;</div><div> divMessage.Attributes.Add("class", "error");</div> <div> divMessage.InnerHtml = "Please provide user name and password correctly and try again.";</div><div> }</div></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-47965100502078777652012-04-05T02:24:00.001-07:002012-04-05T02:24:30.030-07:00Image Upload in Database(FileBytes and Location Store)<div>.aspx PAGE</div><div>===================================================================================</div><div><br></div><div>Upload Photos<br /></div><div> <asp:FileUpload ID="FileUploadImages" runat="server" class="multi " /></div> <div> <br /></div><div> <asp:Button ID="ButtonAddAlbum" runat="server" Text=" Upload"</div><div> OnClick="ButtonAddAlbum_Click" /></div><div><br></div><div>=================================================================================== </div><div><br></div><div>C# Code(Back End)</div><div><div>-------------------------------------------</div><div> if (FileUploadImages.HasFile)</div><div> {</div><div> UploadedImage upImage = new UploadedImage();</div> <div><br></div><div> upImage.FullImages = FileUploadImages.FileBytes;</div><div><br></div><div> </div><div> UploadedImageBLL uIBll = new UploadedImageBLL();</div><div><br></div><div> uIBll.CreateNewUploadedImage(upImage);</div><div><br></div><div><br></div><div> string location = Server.MapPath("UploadFile") + "\\" + FileUploadImages.FileName;</div><div> <br></div><div> FileUploadImages.SaveAs(location);</div><div> }</div></div><div><br></div><div>--------------------</div><div>N.B.:</div><div>-------------------------</div><div>Database Filed name will be 'images' for 'FileBytes'</div> <div>and 'varchar' for 'location'</div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-82812048618496661842012-04-05T02:07:00.001-07:002012-04-05T02:07:30.526-07:00Grid View (With Back end DataBound)<div><br></div><div>.aspx PAGE</div><div>==============================================================================</div><div><br></div><div><asp:GridView ID="GridViewActiveCampaigns" runat="server" AutoGenerateColumns="False" DataKeyNames="CampaignId"</div> <div>OnRowDataBound="GridViewActiveCampaigns_OnDataBound" GridLines="Both"></div><div> <Columns></div><div> <asp:BoundField DataField="CampaignName" HeaderText="Campaign Name" /></div> <div> <asp:TemplateField HeaderText="Raised"></div><div> <ItemTemplate></div><div> <asp:Literal ID="LiteralGoalAmount" runat="server"></asp:Literal></div> <div> </ItemTemplate></div><div> </asp:TemplateField></div><div> <asp:TemplateField HeaderText="Days left"></div> <div> <ItemTemplate></div><div> <asp:Literal ID="LiteralDaysLeft" runat="server"></asp:Literal></div><div> </ItemTemplate></div> <div> </asp:TemplateField></div><div> <asp:TemplateField HeaderText="Donars"></div><div> <ItemTemplate></div> <div> <asp:Literal ID="LiteraltotalDonars" runat="server"></asp:Literal></div><div> </ItemTemplate></div><div> </asp:TemplateField></div><div> </Columns></div><div> </asp:GridView></div><div><br></div><div>========================================================</div> <div>C# Code(Back end)</div><div><br></div><div>List<Campaign> CampaignList = new CampaignBLL().GetAllCampaigns();</div><div><br></div><div> GridViewActiveCampaigns.DataSource = CampaignListSelected;</div><div><br></div> <div><div> protected void GridViewActiveCampaigns_OnDataBound(object sender, GridViewRowEventArgs e)</div><div> {</div><div> if (e.Row.RowType == DataControlRowType.DataRow)</div><div> {</div> <div><br></div><div> Campaign campaign = e.Row.DataItem as Campaign;</div><div><br></div><div> Literal LiteralGoalAmount = e.Row.FindControl("LiteralGoalAmount") as Literal;</div><div> <br></div><div> LiteralGoalAmount.Text = campaign.GoalAmount.Value.ToString("C");</div><div><br></div><div><br></div><div> Literal LiteralDaysLeft = e.Row.FindControl("LiteralDaysLeft") as Literal;</div> <div><br></div><div> //LiteralDaysLeft.Text = campaign.GoalAmount.Value.ToString("C");</div><div><br></div><div> int differenceInDays = GetDifferenceOfDate(campaign);</div><div><br> </div><div> LiteralDaysLeft.Text = differenceInDays.ToString() + " Days";</div><div><br></div><div><br></div><div> int totalDonars = 0;</div><div> decimal calculateRaised = CalculateRaised(campaign.CampaignId, out totalDonars);</div> <div><br></div><div> Literal LiteraltotalDonars = e.Row.FindControl("LiteraltotalDonars") as Literal;</div><div><br></div><div> LiteraltotalDonars.Text = totalDonars.ToString();</div> <div><br></div><div> }</div><div> }</div></div><div>======================================================== </div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-8898525816125475222012-03-30T04:44:00.003-07:002012-03-30T04:44:59.773-07:00State Dropdownlist<div>internal static void GetStateDropdownlist(DropDownList ddlState)</div><div> {</div><div> ddlState.Items.Clear();</div><div> ddlState.Items.Add(new ListItem("Alabama", "AL"));</div> <div> ddlState.Items.Add(new ListItem("Alaska", "AK"));</div><div> ddlState.Items.Add(new ListItem("Arizona", "AZ"));</div><div> ddlState.Items.Add(new ListItem("Arkansas", "AR"));</div> <div> ddlState.Items.Add(new ListItem("California", "CA"));</div><div> ddlState.Items.Add(new ListItem("Colorado", "CO"));</div><div> ddlState.Items.Add(new ListItem("Connecticut", "CT"));</div> <div> ddlState.Items.Add(new ListItem("Delaware", "DE"));</div><div> ddlState.Items.Add(new ListItem("District of Columbia", "DC"));</div><div> ddlState.Items.Add(new ListItem("Florida", "FL"));</div> <div> ddlState.Items.Add(new ListItem("Georgia", "GA"));</div><div> ddlState.Items.Add(new ListItem("Hawaii", "HI"));</div><div> ddlState.Items.Add(new ListItem("Idaho", "ID"));</div> <div> ddlState.Items.Add(new ListItem("Illinois", "IL"));</div><div> ddlState.Items.Add(new ListItem("Indiana", "IN"));</div><div> ddlState.Items.Add(new ListItem("Iowa", "IA"));</div> <div> ddlState.Items.Add(new ListItem("Kansas", "KS"));</div><div> ddlState.Items.Add(new ListItem("Kentucky", "KY"));</div><div> ddlState.Items.Add(new ListItem("Louisiana", "LA"));</div> <div> ddlState.Items.Add(new ListItem("Maine", "ME"));</div><div> ddlState.Items.Add(new ListItem("Maryland", "MD"));</div><div> ddlState.Items.Add(new ListItem("Massachusetts", "MA"));</div> <div> ddlState.Items.Add(new ListItem("Michigan", "MI"));</div><div> ddlState.Items.Add(new ListItem("Minnesota", "MN"));</div><div> ddlState.Items.Add(new ListItem("Mississippi", "MS"));</div> <div> ddlState.Items.Add(new ListItem("Missouri", "MO"));</div><div> ddlState.Items.Add(new ListItem("Montana", "MT"));</div><div> ddlState.Items.Add(new ListItem("Nebraska", "NE"));</div> <div> ddlState.Items.Add(new ListItem("Nevada", "NV"));</div><div> ddlState.Items.Add(new ListItem("New Hampshire", "NH"));</div><div> ddlState.Items.Add(new ListItem("New Jersey", "NJ"));</div> <div> ddlState.Items.Add(new ListItem("New Mexico", "NM"));</div><div> ddlState.Items.Add(new ListItem("New York", "NY"));</div><div> ddlState.Items.Add(new ListItem("North Carolina", "NC"));</div> <div> ddlState.Items.Add(new ListItem("North Dakota", "ND"));</div><div> ddlState.Items.Add(new ListItem("Ohio", "OH"));</div><div> ddlState.Items.Add(new ListItem("Oklahoma", "OK"));</div> <div> ddlState.Items.Add(new ListItem("Oregon", "OR"));</div><div> ddlState.Items.Add(new ListItem("Pennsylvania", "PA"));</div><div> ddlState.Items.Add(new ListItem("Rhode Island", "RI"));</div> <div> ddlState.Items.Add(new ListItem("South Carolina", "SC"));</div><div> ddlState.Items.Add(new ListItem("South Dakota", "SD"));</div><div> ddlState.Items.Add(new ListItem("Tennessee", "TN"));</div> <div> ddlState.Items.Add(new ListItem("Texas", "TX"));</div><div> ddlState.Items.Add(new ListItem("Utah", "UT"));</div><div> ddlState.Items.Add(new ListItem("Vermont", "VT"));</div> <div> ddlState.Items.Add(new ListItem("Virginia", "VA"));</div><div> ddlState.Items.Add(new ListItem("Washington", "WA"));</div><div> ddlState.Items.Add(new ListItem("West Virginia", "WV"));</div> <div> ddlState.Items.Add(new ListItem("Wisconsin", "WI"));</div><div> ddlState.Items.Add(new ListItem("Wyoming", "WY"));</div><div> }</div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-23691078193628476882012-03-30T04:44:00.001-07:002012-03-30T04:44:16.683-07:00Country Dropdownlist<div>internal static void GetCountryDropdownlist(DropDownList ddList)</div><div> {</div><div> List<ListItem> ddlCountryList = new List<ListItem>();</div><div><br></div><div> ListItem aListItem = null;</div> <div><br></div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NA";</div><div> aListItem.Text = "Select Country";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AF";</div><div> aListItem.Text = "Afghanistan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AL";</div><div> aListItem.Text = "Albania";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "DZ";</div><div> aListItem.Text = "Algeria";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AS";</div><div> aListItem.Text = "American Samoa";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AD";</div><div> aListItem.Text = "Andorra";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AO";</div><div> aListItem.Text = "Angola";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AI";</div><div> aListItem.Text = "Anguilla";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AQ";</div><div> aListItem.Text = "Antarctica";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AG";</div><div> aListItem.Text = "Antigua And Barbuda";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AR";</div><div> aListItem.Text = "Argentina";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AM";</div><div> aListItem.Text = "Armenia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AW";</div><div> aListItem.Text = "Aruba";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AU";</div><div> aListItem.Text = "Australia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AT";</div><div> aListItem.Text = "Austria";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AZ";</div><div> aListItem.Text = "Azerbaijan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BS";</div><div> aListItem.Text = "Bahamas";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BH";</div><div> aListItem.Text = "Bahrain";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BD";</div><div> aListItem.Text = "Bangladesh";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BB";</div><div> aListItem.Text = "Barbados";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BY";</div><div> aListItem.Text = "Belarus";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BE";</div><div> aListItem.Text = "Belgium";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BZ";</div><div> aListItem.Text = "Belize";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BJ";</div><div> aListItem.Text = "Benin";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BM";</div><div> aListItem.Text = "Bermuda";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BT";</div><div> aListItem.Text = "Bhutan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BO";</div><div> aListItem.Text = "Bolivia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BA";</div><div> aListItem.Text = "Bosnia And Herzegowina";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BW";</div><div> aListItem.Text = "Botswana";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BV";</div><div> aListItem.Text = "Bouvet Island";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BR";</div><div> aListItem.Text = "Brazil";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IO";</div><div> aListItem.Text = "British Indian Ocean Territory";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BN";</div><div> aListItem.Text = "Brunei Darussalam";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BG";</div><div> aListItem.Text = "Bulgaria";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BF";</div><div> aListItem.Text = "Burkina Faso";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "BI";</div><div> aListItem.Text = "Burundi";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KH";</div><div> aListItem.Text = "Cambodia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CM";</div><div> aListItem.Text = "Cameroon";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CA";</div><div> aListItem.Text = "Canada";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CV";</div><div> aListItem.Text = "Cape Verde";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KY";</div><div> aListItem.Text = "Cayman Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CF";</div><div> aListItem.Text = "Central African Republic";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TD";</div><div> aListItem.Text = "Chad";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CL";</div><div> aListItem.Text = "Chile";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CN";</div><div> aListItem.Text = "China";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CX";</div><div> aListItem.Text = "Christmas Island";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CC";</div><div> aListItem.Text = "Cocos (Keeling) Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CO";</div><div> aListItem.Text = "Colombia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KM";</div><div> aListItem.Text = "Comoros";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CG";</div><div> aListItem.Text = "Congo";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CK";</div><div> aListItem.Text = "Cook Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CR";</div><div> aListItem.Text = "Costa Rica";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CI";</div><div> aListItem.Text = "Cote D'Ivoire";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "HR";</div><div> aListItem.Text = "Croatia (Local Name: Hrvatska)";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CU";</div><div> aListItem.Text = "Cuba";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CY";</div><div> aListItem.Text = "Cyprus";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CZ";</div><div> aListItem.Text = "Czech Republic";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "DK";</div><div> aListItem.Text = "Denmark";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "DJ";</div><div> aListItem.Text = "Djibouti";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "DM";</div><div> aListItem.Text = "Dominica";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "DO";</div><div> aListItem.Text = "Dominican Republic";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TP";</div><div> aListItem.Text = "East Timor";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "EC";</div><div> aListItem.Text = "Ecuador";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "EG";</div><div> aListItem.Text = "Egypt";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SV";</div><div> aListItem.Text = "El Salvador";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GQ";</div><div> aListItem.Text = "Equatorial Guinea";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ER";</div><div> aListItem.Text = "Eritrea";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "EE";</div><div> aListItem.Text = "Estonia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ET";</div><div> aListItem.Text = "Ethiopia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "FK";</div><div> aListItem.Text = "Falkland Islands (Malvinas)";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "FO";</div><div> aListItem.Text = "Faroe Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "FJ";</div><div> aListItem.Text = "Fiji";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "FI";</div><div> aListItem.Text = "Finland";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "FR";</div><div> aListItem.Text = "France";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GF";</div><div> aListItem.Text = "French Guiana";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PF";</div><div> aListItem.Text = "French Polynesia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TF";</div><div> aListItem.Text = "French Southern Territories";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GA";</div><div> aListItem.Text = "Gabon";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GM";</div><div> aListItem.Text = "Gambia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GE";</div><div> aListItem.Text = "Georgia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "DE";</div><div> aListItem.Text = "Germany";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GH";</div><div> aListItem.Text = "Ghana";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GI";</div><div> aListItem.Text = "Gibraltar";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GR";</div><div> aListItem.Text = "Greece";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GL";</div><div> aListItem.Text = "Greenland";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GD";</div><div> aListItem.Text = "Grenada";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GP";</div><div> aListItem.Text = "Guadeloupe";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GU";</div><div> aListItem.Text = "Guam";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GT";</div><div> aListItem.Text = "Guatemala";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GN";</div><div> aListItem.Text = "Guinea";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GW";</div><div> aListItem.Text = "Guinea-Bissau";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GY";</div><div> aListItem.Text = "Guyana";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "HT";</div><div> aListItem.Text = "Haiti";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "HM";</div><div> aListItem.Text = "Heard And Mc Donald Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "VA";</div><div> aListItem.Text = "Holy See (Vatican City State)";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "HN";</div><div> aListItem.Text = "Honduras";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "HK";</div><div> aListItem.Text = "Hong Kong";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "HU";</div><div> aListItem.Text = "Hungary";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IS";</div><div> aListItem.Text = "Ice Land";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IN";</div><div> aListItem.Text = "India";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ID";</div><div> aListItem.Text = "Indonesia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IR";</div><div> aListItem.Text = "Iran (Islamic Republic Of)";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IQ";</div><div> aListItem.Text = "Iraq";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IE";</div><div> aListItem.Text = "Ireland";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IL";</div><div> aListItem.Text = "Israel";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "IT";</div><div> aListItem.Text = "Italy";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "JM";</div><div> aListItem.Text = "Jamaica";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "JP";</div><div> aListItem.Text = "Japan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "JO";</div><div> aListItem.Text = "Jordan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KZ";</div><div> aListItem.Text = "Kazakhstan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KE";</div><div> aListItem.Text = "Kenya";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KI";</div><div> aListItem.Text = "Kiribati";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KP";</div><div> aListItem.Text = "Korea, Dem People'S Republic";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KR";</div><div> aListItem.Text = "Korea, Republic Of";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KW";</div><div> aListItem.Text = "Kuwait";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KG";</div><div> aListItem.Text = "Kyrgyzstan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LA";</div><div> aListItem.Text = "Lao People'S Dem Republic";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LV";</div><div> aListItem.Text = "Latvia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LB";</div><div> aListItem.Text = "Lebanon";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LS";</div><div> aListItem.Text = "Lesotho";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LR";</div><div> aListItem.Text = "Liberia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LY";</div><div> aListItem.Text = "Libyan Arab Jamahiriya";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LI";</div><div> aListItem.Text = "Liechtenstein";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LT";</div><div> aListItem.Text = "Lithuania";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LU";</div><div> aListItem.Text = "Luxembourg";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MO";</div><div> aListItem.Text = "Macau";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MK";</div><div> aListItem.Text = "Macedonia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MG";</div><div> aListItem.Text = "Madagascar";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MW";</div><div> aListItem.Text = "Malawi";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MY";</div><div> aListItem.Text = "Malaysia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MV";</div><div> aListItem.Text = "Maldives";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ML";</div><div> aListItem.Text = "Mali";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MT";</div><div> aListItem.Text = "Malta";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MH";</div><div> aListItem.Text = "Marshall Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MQ";</div><div> aListItem.Text = "Martinique";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MR";</div><div> aListItem.Text = "Mauritania";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MU";</div><div> aListItem.Text = "Mauritius";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "YT";</div><div> aListItem.Text = "Mayotte";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MX";</div><div> aListItem.Text = "Mexico";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "FM";</div><div> aListItem.Text = "Micronesia, Federated States";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MD";</div><div> aListItem.Text = "Moldova, Republic Of";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MC";</div><div> aListItem.Text = "Monaco";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MN";</div><div> aListItem.Text = "Mongolia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MS";</div><div> aListItem.Text = "Montserrat";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MA";</div><div> aListItem.Text = "Morocco";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MZ";</div><div> aListItem.Text = "Mozambique";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MM";</div><div> aListItem.Text = "Myanmar";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NA";</div><div> aListItem.Text = "Namibia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NR";</div><div> aListItem.Text = "Nauru";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NP";</div><div> aListItem.Text = "Nepal";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NL";</div><div> aListItem.Text = "Netherlands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AN";</div><div> aListItem.Text = "Netherlands Ant Illes";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NC";</div><div> aListItem.Text = "New Caledonia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NZ";</div><div> aListItem.Text = "New Zealand";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NI";</div><div> aListItem.Text = "Nicaragua";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NE";</div><div> aListItem.Text = "Niger";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NG";</div><div> aListItem.Text = "Nigeria";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NU";</div><div> aListItem.Text = "Niue";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NF";</div><div> aListItem.Text = "Norfolk Island";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "MP";</div><div> aListItem.Text = "Northern Mariana Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "NO";</div><div> aListItem.Text = "Norway";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "OM";</div><div> aListItem.Text = "Oman";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PK";</div><div> aListItem.Text = "Pakistan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PW";</div><div> aListItem.Text = "Palau";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PA";</div><div> aListItem.Text = "Panama";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PG";</div><div> aListItem.Text = "Papua New Guinea";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PY";</div><div> aListItem.Text = "Paraguay";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PE";</div><div> aListItem.Text = "Peru";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PH";</div><div> aListItem.Text = "Philippines";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PN";</div><div> aListItem.Text = "Pitcairn";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PL";</div><div> aListItem.Text = "Poland";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PT";</div><div> aListItem.Text = "Portugal";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PR";</div><div> aListItem.Text = "Puerto Rico";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "QA";</div><div> aListItem.Text = "Qatar";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "RE";</div><div> aListItem.Text = "Reunion";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "RO";</div><div> aListItem.Text = "Romania";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "RU";</div><div> aListItem.Text = "Russian Federation";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "RW";</div><div> aListItem.Text = "Rwanda";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "KN";</div><div> aListItem.Text = "Saint K Itts And Nevis";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LC";</div><div> aListItem.Text = "Saint Lucia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "VC";</div><div> aListItem.Text = "Saint Vincent, The Grenadines";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "WS";</div><div> aListItem.Text = "Samoa";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SM";</div><div> aListItem.Text = "San Marino";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ST";</div><div> aListItem.Text = "Sao Tome And Principe";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SA";</div><div> aListItem.Text = "Saudi Arabia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SN";</div><div> aListItem.Text = "Senegal";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SC";</div><div> aListItem.Text = "Seychelles";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SL";</div><div> aListItem.Text = "Sierra Leone";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SG";</div><div> aListItem.Text = "Singapore";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SK";</div><div> aListItem.Text = "Slovakia (Slovak Republic)";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SI";</div><div> aListItem.Text = "Slovenia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SB";</div><div> aListItem.Text = "Solomon Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SO";</div><div> aListItem.Text = "Somalia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ZA";</div><div> aListItem.Text = "South Africa";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GS";</div><div> aListItem.Text = "South Georgia , S Sandwich Is.";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ES";</div><div> aListItem.Text = "Spain";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "LK";</div><div> aListItem.Text = "Sri Lanka";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SH";</div><div> aListItem.Text = "St. Helena";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "PM";</div><div> aListItem.Text = "St. Pierre And Miquelon";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SD";</div><div> aListItem.Text = "Sudan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SR";</div><div> aListItem.Text = "Suriname";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SJ";</div><div> aListItem.Text = "Svalbard, Jan Mayen Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SZ";</div><div> aListItem.Text = "Sw Aziland";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SE";</div><div> aListItem.Text = "Sweden";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "CH";</div><div> aListItem.Text = "Switzerland";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "SY";</div><div> aListItem.Text = "Syrian Arab Republic";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TW";</div><div> aListItem.Text = "Taiwan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TJ";</div><div> aListItem.Text = "Tajikistan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TZ";</div><div> aListItem.Text = "Tanzania, United Republic Of";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TH";</div><div> aListItem.Text = "Thailand";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TG";</div><div> aListItem.Text = "Togo";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TK";</div><div> aListItem.Text = "Tokelau";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TO";</div><div> aListItem.Text = "Tonga";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TT";</div><div> aListItem.Text = "Trinidad And Tobago";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TN";</div><div> aListItem.Text = "Tunisia";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TR";</div><div> aListItem.Text = "Turkey";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TM";</div><div> aListItem.Text = "Turkmenistan";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TC";</div><div> aListItem.Text = "Turks And Caicos Islands";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "TV";</div><div> aListItem.Text = "Tuvalu";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "UG";</div><div> aListItem.Text = "Uganda";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "UA";</div><div> aListItem.Text = "Ukraine";</div><div> ddlCountryList.Add(aListItem);</div> <div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "AE";</div><div> aListItem.Text = "United Arab Emirates";</div><div> ddlCountryList.Add(aListItem);</div> <div> // <asp:ListItem Value="">/asp:ListItem></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "GB";</div><div> aListItem.Text = "United Kingdom";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "US";</div><div> aListItem.Text = "United States";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "UM";</div><div> aListItem.Text = "United States Minor Is.";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "UY";</div><div> aListItem.Text = "Uruguay";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "UZ";</div><div> aListItem.Text = "Uzbekistan";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "VU";</div><div> aListItem.Text = "Vanuatu";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "VE";</div><div> aListItem.Text = "Venezuela";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "VN";</div><div> aListItem.Text = "Viet Nam";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "VG";</div><div> aListItem.Text = "Virgin Islands (British)";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "VI";</div><div> aListItem.Text = "Virgin Islands (U.S.)";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "WF";</div><div> aListItem.Text = "Wallis And Futuna Islands";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "EH";</div><div> aListItem.Text = "Western Sahara";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "YE";</div><div> aListItem.Text = "Yemen";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "YU";</div><div> aListItem.Text = "Yugoslavia";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ZR";</div><div> aListItem.Text = "Zaire";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ZM";</div><div> aListItem.Text = "Zambia";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div> aListItem = new ListItem();</div><div> aListItem.Value = "ZW";</div><div> aListItem.Text = "Zimbabwe";</div> <div> ddlCountryList.Add(aListItem);</div><div><br></div><div><br></div><div> ddList.DataSource = ddlCountryList;</div><div> ddList.DataTextField = "Text";</div><div> ddList.DataValueField = "Value";</div> <div> ddList.DataBind();</div><div> }</div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4377541479041435391.post-72961090942200106322012-03-30T04:43:00.001-07:002012-03-30T04:43:17.623-07:00JQuery onclick Clear or Reset text for TextBox<div>function clearTextHere(field, initialText) {</div><div> if (field != null) {</div><div> if (field.value == initialText) {</div><div> field.value = "";</div><div> field.style.color = "#000000";</div> <div> if (initialText == 'Phone') {</div><div> $("#<%= tbxPhone1.ClientID %>").mask("999-999-9999");</div><div> }</div><div> }</div> <div> }</div><div> }</div><div><br></div><div> function resetText(field, initialText) {</div><div> if (field.value == "") {</div><div> field.value = initialText;</div> <div> field.style.color = "#BBBBBB";</div><div> if (initialText == 'Phone') {</div><div> field.value = initialText;</div><div> $("#<%= tbxPhone1.ClientID %>").unmask("999-999-9999");</div> <div> }</div><div> }</div><div> }</div> Unknownnoreply@blogger.com0