tag:blogger.com,1999:blog-54450701912537919992024-03-13T22:17:51.198+05:00InfOFreAksReviews, Programming, Databases, Online Projects...Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.comBlogger28125tag:blogger.com,1999:blog-5445070191253791999.post-59996108512192725242014-11-11T12:58:00.000+05:002014-11-11T12:58:12.179+05:00c# and asp.net development on Ubuntu<div dir="ltr" style="text-align: left;" trbidi="on">
<b>MonoDevelop </b> is the tool used to develop .Net language applications on ubuntu<br />
To install on Ubuntu use terminal with following command:<br />
<br />
<span style="background-color: #eeeeee; color: #222222; font-family: 'Ubuntu Mono', 'Ubuntu Beta Mono A', Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14px; line-height: 18.2000007629395px; white-space: pre-wrap;">sudo apt-get install monodevelop</span><br />
<span style="background-color: #eeeeee; color: #222222; font-family: 'Ubuntu Mono', 'Ubuntu Beta Mono A', Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14px; line-height: 18.2000007629395px; white-space: pre-wrap;"><br /></span></div>
Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-28047891886835183652014-11-11T12:46:00.004+05:002014-11-11T12:49:28.739+05:00Show Windows Virtual Keyboard c#<div dir="ltr" style="text-align: left;" trbidi="on">
The simplest way to show windows virtual keyboard using c# is as follows:<br />
<br />
1. Create new windows form project.<br />
2. Double Click on newly created form to create form load event.<br />
3. Now start a process of virtual keyboard by following code on form load event:<br />
<br />
<span style="color: red;">System.Diagnostics.Process.Start("osk.exe");</span><br />
<br />
4. Now create form closing event by right clicking the form view and clicking on events from properties windows. Now double click on formclosing event. It will create the form closing event. Add following code in it:<br />
<br />
<span style="color: red;">Process.GetProcessesByName("osk")[0].Kill(); </span><br />
<br />
For any question you may contact me.</div>
Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-64958429246369870552012-08-07T11:42:00.000+05:002012-08-07T11:45:19.384+05:00Browse images from directory and Convert Colored Images to Gray Scale c#<div dir="ltr" style="text-align: left;" trbidi="on">
Recently i have to convert colored bitmap/jpeg images to gray scale in my project. I found many solutions on Google but found one useful. This tutorial will help you browse images from directory and convert them to gray scale one by one.<br />
<br />
First of all create a solution and windows form project in visual studio.<br />
<br />
Then drag two picture boxes from toolbox on the left on to the form and two buttons also.<br />
<br />
Name picture boxes pctColoredImage and pctGrayScale. Also the two buttons btnNext and btnPrevious and show text on them Next and Previous respectively.<br />
<br />
Double click on each picture boxes and buttons to create their events.<br />
<br />
Now create<br />
<b><br /></b>
<b>List<string> FilesFromFolder = null; </b>a global variable and in constructor initialize it like this<br />
<br />
<b>FilesFromFolder = new List<string>();</b><br />
<br />
Now in form load add files from the folder to the list just initialized in the constructor.<br />
<br />
<br />
<b>string[] fileEntries = Directory.GetFiles("data/")</b><br />
<b> foreach (string fileName in fileEntries)</b><br />
<b> {</b><br />
<b> // add directory files to list</b><br />
<b> FilesFromFolder.Add(fileName);</b><br />
<b> }</b><br />
<b><br /></b>
Declare <b>int fileIndex = 0; </b>as global variable to track count of index.<br />
<br />
Now in event of onClick of btnNext write this code<br />
<br />
<br />
<b>if (FilesFromFolder.Count == fileIndex)</b><br />
<b> fileIndex = 0;</b><br />
<b><br /></b>
<b> this.Text = FilesFromFolder[fileIndex];</b><br />
<b> CalculateACCR(fileIndex);</b><br />
<b> pctBoxMain.Image = new Bitmap(FilesFromFolder[fileIndex++]);</b><br />
<b><br /></b>
<b> pctBoxGrayScale.Image = </b>
<b>ConvertToGrayscale</b> <b>(new Bitmap(pctBoxMain.Image));</b><br />
<b><br /></b>
In event of onClick of btnPrevious write this code
<br />
<br />
<br />
<b>if (fileIndex == 0)</b><br />
<b> fileIndex = FilesFromFolder.Count;</b><br />
<b><br /></b>
<b> this.Text = FilesFromFolder[(fileIndex) - 1];</b><br />
<b><br /></b>
<b> CalculateACCR(fileIndex - 1);</b><br />
<b><br /></b>
<b> pctBoxMain.Image = new Bitmap(FilesFromFolder[(fileIndex) - 1]);</b><br />
<b> fileIndex--;</b><br />
<b><br /></b>
<b> pctBoxGrayScale.Image = ConvertToGrayscale(new Bitmap(pctBoxMain.Image));</b><br />
<b><br /></b>
now to convert images to gray scale us this function<br />
<br />
<br />
<b>public static Bitmap </b>
<b>ConvertToGrayscale</b> <b>(Bitmap original)</b><br />
<b> {</b><br />
<b> //create a blank bitmap the same size as original</b><br />
<b> Bitmap newBitmap = new Bitmap(original.Width, original.Height);</b><br />
<b><br /></b>
<b> //get a graphics object from the new image</b><br />
<b> Graphics g = Graphics.FromImage(newBitmap);</b><br />
<b><br /></b>
<b> //create the grayscale ColorMatrix</b><br />
<b> ColorMatrix colorMatrix = new ColorMatrix(</b><br />
<b> new float[][] </b><br />
<b> {</b><br />
<b> new float[] {.3f, .3f, .3f, 0, 0},</b><br />
<b> new float[] {.59f, .59f, .59f, 0, 0},</b><br />
<b> new float[] {.11f, .11f, .11f, 0, 0},</b><br />
<b> new float[] {0, 0, 0, 1, 0},</b><br />
<b> new float[] {0, 0, 0, 0, 1}</b><br />
<b> });</b><br />
<b><br /></b>
<b> //create some image attributes</b><br />
<b> ImageAttributes attributes = new ImageAttributes();</b><br />
<b><br /></b>
<b> //set the color matrix attribute</b><br />
<b> attributes.SetColorMatrix(colorMatrix);</b><br />
<b><br /></b>
<b> //draw the original image on the new image</b><br />
<b> //using the grayscale color matrix</b><br />
<b> g.DrawImage(original, new Rectangle(0, 0, original.Width, original.Height),</b><br />
<b> 0, 0, original.Width, original.Height, GraphicsUnit.Pixel, attributes);</b><br />
<b><br /></b>
<b> //dispose the Graphics object</b><br />
<b> g.Dispose();</b><br />
<b> return newBitmap;</b><br />
<b> }</b><br />
<br />
<br />
<br />
<b><br /></b>
<br />
<span style="color: red;">Note: you may have to adjust slightly the index for next and previous image.</span></div>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-2032608353097766082012-06-01T10:40:00.000+05:002012-06-01T10:40:50.702+05:00HP g6 weak wireless issue resolved<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial, Helvetica, sans-serif;">I recently bought HP g6 i5 and very first day got issue of weak wireless signals. First i thought its just the router issue but it kept as it is for week or so. </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Got frustrated with it and started googling it. Read some different posts so gonna conclude them.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">One post said remove the back cover and check if wireless antennas are not connected to the wireless card. This may be one of the issue. It resolved the issue of the person who posted it.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Another said that just update the wlan broadcomm drivers. It can be done by going into the device manager and clicking expand on the network adapters. Find wireless there and right click on it and update drivers. It works on windows 7. You can also download the drivers from hp site. </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Both are the solutions. I followed the second one n got my laptops signal strength to maximum.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Also there is an option in device manager about the wireless signal. Do check it if its 100% or not.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">If none of above works then pray your laptop is in warranty :)</span></div>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-40153313568276382482012-04-10T15:20:00.002+05:002012-04-10T15:36:13.794+05:00Use Morse Code to write text in Desktop Apps<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">First of all create a windows form project in visual studio and drag three buttons on the form and a textbox(you can add further controls but these are minimum controls needed).</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Declare following global variables.\</span><br />
<br />
<span style="color: red; font-family: Arial,Helvetica,sans-serif;">private string inputString = "";<br /> private int count = 0;<br /><br /> private static readonly Dictionary<string, string> mapping = new Dictionary<string, string>() {<br /> { ".-","a" },<br /> { "-...","b" },<br /> { "-.-.", "c"},<br /> { "-..","d" },<br /> { "." ,"e"},<br /> { "..-.","f" },<br /> { "--.","g" },<br /> { "....","h" },<br /> { "..","i" },<br /> { ".---","j" },<br /> { "-.-" ,"k"},<br /> { ".-.." ,"l"},<br /> { "--" ,"m"},<br /> { "-." ,"n"},<br /> { "---" ,"o"},<br /> { ".--." ,"p"},<br /> { "--.-" ,"q"},<br /> { ".-." ,"r"},<br /> { "..." ,"s"},<br /> { "-" ,"t"},<br /> { "..-" ,"u"},<br /> { "...-" ,"v"},<br /> { ".--" ,"w"},<br /> { "-..-" ,"x"},<br /> { "-.--" ,"y"},<br /> { "--.." ,"z"},<br /> { "-----" ,"0"},<br /> { ".----" ,"1"},<br /> { "..---" ,"2"},<br /> { "...--" ,"3"},<br /> { "....-" ,"4"},<br /> { "....." ,"5"},<br /> { "-...." ,"6"},<br /> { "--..." ,"7"},<br /> { "---.." ,"8"},<br /> { "----." ,"9"}<br /> }; </span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Now name one button as "." and second as "-" as morse code depends on these two characters.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Name the third button as "space" which will be used to differentiate characters and letters.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">On click event of button named "." write following line.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;">inputString += ".";</span> </span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">On click event of button named "-" write following line.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;">inputString += "-";</span></span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;"></span></span><span style="font-family: Arial,Helvetica,sans-serif;">On click event of button named "space" write following lines.</span><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;"></span> </span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"> <span style="color: red;"> count++;</span><br style="color: red;" /><span style="color: red;"> if (count == 1 && inputString != "")</span><br style="color: red;" /><span style="color: red;"> {</span><br style="color: red;" /><span style="color: red;"> textBox1.Text += GetLetter(inputString);</span><br style="color: red;" /><span style="color: red;"> count = 0;</span><br style="color: red;" /><span style="color: red;"> }</span><br style="color: red;" /><span style="color: red;"> else </span><br style="color: red;" /><span style="color: red;"> {</span><br style="color: red;" /><span style="color: red;"> textBox1.Text += GetLetter(inputString) + " ";</span><br style="color: red;" /><span style="color: red;"> count = 0;</span><br style="color: red;" /><span style="color: red;"> }</span><br style="color: red;" /><br style="color: red;" /><span style="color: red;"> inputString = "";</span></span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;"> public string GetLetter(string morseCode)<br /> {<br /> return mapping.ContainsKey(morseCode.ToString()) ? mapping[morseCode] : "";<br /> }</span></span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;"> <span style="color: black;">Now build and run this project. </span></span></span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;"><span style="color: black;">If you want to differentiate between characters hit space once and if you want to add space hit space twice.</span></span></span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: red;"><span style="color: black;">This can b very useful in mobile development where it could be used for typing.</span></span></span><br />
<br />
<div style="color: red;">
<span style="font-family: Arial,Helvetica,sans-serif;">Any suggestions and queries are welcome. </span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></div>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-56191602882730360662011-05-05T15:27:00.000+05:002011-05-05T15:27:55.986+05:00Getting all databases from Sql Server 2005-2008 using c#<div dir="ltr" style="text-align: left;" trbidi="on">This code will help you in getting all databases of Sql Server and show them in the drop down list.<br />
<br />
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
</style> <![endif]--> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"><span style="color: #2b91af; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">SqlConnection</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> connection = <span style="color: blue;">new</span> <span style="color: #2b91af;">SqlConnection(connectionstring</span><span style="color: green;">);</span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"><span style="color: #2b91af; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">ServerConnection</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> conn = <span style="color: blue;">new</span> <span style="color: #2b91af;">ServerConnection</span>(connection);</span></div><div class="MsoNormal"><span style="color: #2b91af; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">Server</span><span style="font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"> myServer = <span style="color: blue;">new</span> <span style="color: #2b91af;">Server</span>(conn);</span></div><div class="MsoNormal"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
</style> <![endif]--> </div><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">foreach</span><span style="font-family: "Courier New"; font-size: 10pt;"> (<span style="color: #2b91af;">Database</span> db <span style="color: blue;">in</span> </span><span style="font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">myServer</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">.Databases)</span></div><div class="MsoNormal"><span style="font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>ddlDatabases.Items.Add(db.Name);</span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%;"><span style="color: red;">Note:</span> '</span><span style="font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"><span style="mso-spacerun: yes;"></span>ddlDatabases' is the name of combobox. And db.Name contains the name of the database</span></div></div>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com2tag:blogger.com,1999:blog-5445070191253791999.post-30573760439531621442011-04-19T10:54:00.000+05:002012-08-07T11:46:02.570+05:00Paging through SQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
This query will help you in doing paging through SQL Server. You will need to pass just the starting and ending index and it will return the records..<br />
<br />
<br />
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span class="Apple-style-span" style="line-height: 14px;"></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">DECLARE</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @startingindex <span style="color: blue;">int</span><span style="color: grey;">;<o:p></o:p></span></span></span></div>
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"> </span><br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">DECLARE</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @endingindex <span style="color: blue;">int<o:p></o:p></span></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @startingindex<span style="color: grey;">=</span>10<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @endingindex<span style="color: grey;">=</span>20<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">select</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: grey;">*</span> <span style="color: blue;">from</span> Table_Name <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">where</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> table_id <span style="color: grey;">in(<o:p></o:p></span></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">SELECT</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> us<span style="color: grey;">.</span>table_id<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">FROM </span><span style="color: grey; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">(</span><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">SELECT</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: magenta;">ROW_NUMBER</span><span style="color: grey;">()</span> <span style="color: blue;">OVER </span><span style="color: grey;">(</span><span style="color: blue;">ORDER</span> <span style="color: blue;">BY</span> table_id<span style="color: grey;">)</span> <span style="color: blue;">AS</span> Row<span style="color: grey;">,</span> <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">Table_id<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">FROM</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> Table_Name<span style="color: grey;">)</span> us <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">WHERE</span><span style="font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"> Row <span style="color: grey;">></span>@startingindex <span style="color: grey;">and</span> Row<span style="color: grey;"><</span>@endingindex<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span class="Apple-style-span" style="color: grey; font-family: 'Courier New'; font-size: x-small;"><span style="color: grey; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">)</span></span></div>
</div>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-29891171237186001772010-12-28T21:58:00.000+05:002010-12-28T21:58:01.534+05:00Running SQL Server Compact on WINCE--TutorialRecently i had to use SQL server in WINCE which was installed on Friendly ARM device. I had to go through some R&D to find it. Got some errors in the beginning but finally was able to do so. Just to be simple on the new image of WINCE just copy these cab files from the pc and copy them to TEMP folder in the WINCE.<br />
<br />
You can find these cab files in the Program Files/SQL Server Compact in ARM folder. You will also need a .NET cab file which you can get from Framework installed directory. If you have Visual Studio 2008 installed you can get them easily you don't need to download these.<br />
<br />
The files are<br />
1.<span class="Apple-style-span" style="background-color: white;"> <span class="Apple-style-span" style="color: #073763;">NETCFv35.wce.armv4</span></span><br />
2. <span class="Apple-style-span" style="color: #073763;">sql.wce5.armv4i</span><br />
3. <span class="Apple-style-span" style="color: #073763;">sqlce.dev.ENU.wce5.armv4i</span><br />
4. <span class="Apple-style-span" style="color: #073763;">sqlce.repl.wce5.armv4i</span><br />
5. <span class="Apple-style-span" style="color: #073763;">sqlce.wce5.armv4i</span><br />
<br />
After copying these files in TEMP folder in WINCE double click each of them to install them one by one. Install them on the default path (Recommended).<br />
<br />
Now you can run SQLCE commands in your application using C# or any language . If any one of these files are not installed properly you may not be able to run the SQL Server Compact.<br />
<br />
The database file is .sdf which will be used in WINCE. You can create this DB file in SQL Server Management 2008. On startup just select database engine type to compact and create the file. Then copy it to the WINCE and you are good to go.<br />
<br />
How to connect to it will be in next tutorial....<br />
<br />
Queries are welcomed..Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com1tag:blogger.com,1999:blog-5445070191253791999.post-43270103852457462972010-11-21T12:50:00.001+05:002012-08-13T11:10:42.594+05:00Image Store Save/Retrieve C# Web SQL Server using Handler/ Generic Handler<div dir="ltr" style="text-align: left;" trbidi="on">
This tutorial is to guide you to save/retrieve image using C# in ASP.Net Web<br />
<br />
The saving image process is same as the windows form saving image process. You can get detail on my other tutorial which i wrote earlier which guide you to save/retrieve image in Windows Forms. You can read that tutorial from <a href="http://freakzmenia.blogspot.com/2010/10/image-saveretrieve-c-windows-form-sql.html" target="_blank">Click Here</a><br />
<br />
For you ease i will copy past the code to show you how you save image in SQL server using C#.<br />
<br />
1. First of all we need a database in SQL Server which contains a table with only two columns one is 'id' of type 'int' and second is of 'image' of type 'image'.<br />
<br />
2. Open SQL Server 2005 Express Management Studio and create new database. Name it according to your choice.<br />
<br />
3. After successfully creating database create a table with two columns described in step 1.<br />
<br />
4. Now Open Visual Studio 2008/2010. <br />
<br />
5. Create a project of windows Web.<br />
<br />
6.. In this event function of button you are using to save the image, create an object of FileStream, a string and byte array. Or you can simply paste the code below.<br />
<br />
<br />
<span class="Apple-style-span" style="color: #3d85c6;">FileStream fs;</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">string path = "C:\\Sunset.jpg";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">fs = new FileStream(path, FileMode.Open, FileAccess.Read);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">//a byte array to read the image</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">byte[] picbyte = new byte[fs.Length];</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length));</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">fs.Close();</span><br />
<br />
7. Now below this create database connectivity and store this byte array(picbyte) to the image column in the database table you created in starting steps. OR you can use this code.<br />
<br />
<span class="Apple-style-span" style="color: #3d85c6;">string cString = "Initial Catalog=DB NAME;Data Source=SQL SERVER INSTANCE;User ID=DB USER;Password=DB USER PASSWORD;";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlConnection connection = new SqlConnection(cString);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">string query = "insert into TableName (ColumnName) values (@pic)";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">connection.Open();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlParameter picparameter = new SqlParameter();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">picparameter.SqlDbType = SqlDbType.Image;</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">picparameter.ParameterName = "pic";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">picparameter.Value = picbyte;</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlCommand cmd = new SqlCommand(query, connection);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">cmd.Parameters.Add(picparameter);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">if (cmd.ExecuteNonQuery() > 0)</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">MessageBox.Show("Image Saved");</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">connection.Close();</span><br />
<br />
8. Now the image is saved in the database. You can see this by using query analyzer. Confirm it by the length of image column you will see when you will query it.<br />
<br />
9. Now the image is successfully saved, its time to Retrieve it.<br />
<br />
10. Retrieving and showing image in web is slightly different from windows form.<br />
<br />
11. You need handler to show image.<br />
<br />
12. You can add handler from right clicking the web project and adding new item.<br />
<br />
13. Handler got the extension of .ashx. E.g. when you added handler from adding new item you get Handler.ashx. You can rename it to whatever you want.<br />
<br />
14. Now you need a image control in the web page to show the image. You can use asp:image and in its ImageUrl attribute write handler's URl like<br />
<br />
<span class="Apple-style-span" style="color: #3d85c6;">ImageUrl="~/Handler.ashx"</span><br />
<br />
15. '<span class="Apple-style-span" style="color: #3d85c6;">~</span>' sign is to get the project starting location. If its in any folder then write its name first after ~ sign.<br />
<br />
16. In handler.ashx you will retrieve the image and show it. You can send the image id or user id to the handler if you want to show image at runtime depending on the user. Basically used in dynamic sites. You can send id like this<br />
<br />
<span class="Apple-style-span" style="color: #3d85c6;">ImageUrl="~/Handler.ashx?id=1"</span><br />
<br />
17. Handler code looks like<br />
<br />
<span class="Apple-style-span" style="color: #3d85c6;">public void ProcessRequest (HttpContext context) </span><br />
<span class="Apple-style-span" style="color: #3d85c6;">{</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">try</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">{</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">context.Response.ContentType = "image/jpg";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">conDB = new System.Data.SqlClient.SqlConnection("Data Source=SERVER Name;Initial Catalog=DB Name;Integrated Security=True;");</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">conDB.Open();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">int id = 'id of the user or image You can get it from URL also if you send it to handler by REQUEST';</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">string str = "Select (Image) from TableName where UserID or ImageID =" + id;</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">System.Data.SqlClient.SqlCommand cmd = new SqlCommand(str, conDB);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">reader.Read();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">byte[] img = (byte[])reader["Image"];</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">reader.Close();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">memoryStream.Write(img, 0, img.Length);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">context.Response.Buffer = true;</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">context.Response.BinaryWrite(img);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">memoryStream.Dispose();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">conDB.Close();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">context.Response.OutputStream.Write(img, 0, img.Length);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">context.Response.BinaryWrite(img);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">}</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">catch (Exception ex)</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">{ </span><br />
<span class="Apple-style-span" style="color: #3d85c6;">context.Response.Redirect("Error.aspx"); </span><br />
<span class="Apple-style-span" style="color: #3d85c6;">}</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">}</span><br />
<br />
18. Now the Image will be shown in the asp:image after retrieval from Database.<br />
<br />
19. One handler is enough to show as many images you want to show in the web site.<br />
<br />
Queries are welcomed........</div>
Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com3tag:blogger.com,1999:blog-5445070191253791999.post-35145029571076146752010-10-27T16:05:00.002+05:002010-11-01T20:07:56.594+05:00Image Save/Retrieve C# Windows Form SQL ServerThis tutorial will guide you to save or retrieve image from SQL Server in C#.<br />
<br />
1. First of all we need a database in SQL Server which contains a table with only two columns one is 'id' of type 'int' and second is of 'image' of type 'image'.<br />
<br />
2. Open SQL Server 2005 Express Management Studio and create new database. Name it according to your choice.<br />
<br />
3. After successfully creating database create a table with two columns described in step 1.<br />
<br />
4. Now Open Visual Studio 2008/2010. <br />
<br />
5. Create a project of windows form.<br />
<br />
6. In Design View of Form1(you can rename it to your choice) drag a control of picture box to the form with two buttons.<br />
<br />
7. Change text of one button to Save and second to Retrieve.<br />
<br />
8. Double click Save button to create event for double click.<br />
<br />
9. In this event function, create an object of FileStream, a string and byte array. Or you can simply paste the code below.<br />
<br />
<br />
<span class="Apple-style-span" style="color: #0b5394;">FileStream fs;</span><br />
<span class="Apple-style-span" style="color: #0b5394;"><br />
</span><br />
<span class="Apple-style-span" style="color: #0b5394;">string path = "C:\\Sunset.jpg";</span><br />
<span class="Apple-style-span" style="color: #0b5394;"><br />
</span><br />
<span class="Apple-style-span" style="color: #0b5394;">fs = new FileStream(path, FileMode.Open, FileAccess.Read);</span><br />
<span class="Apple-style-span" style="color: #0b5394;"><br />
</span><br />
<span class="Apple-style-span" style="color: #0b5394;">//a byte array to read the image</span><br />
<span class="Apple-style-span" style="color: #0b5394;"><br />
</span><br />
<span class="Apple-style-span" style="color: #0b5394;">byte[] picbyte = new byte[fs.Length];</span><br />
<span class="Apple-style-span" style="color: #0b5394;"><br />
</span><br />
<span class="Apple-style-span" style="color: #0b5394;">fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length));</span><br />
<span class="Apple-style-span" style="color: #0b5394;"><br />
</span><br />
<span class="Apple-style-span" style="color: #0b5394;">fs.Close();</span><br />
<br />
10. Now below this create database connectivity and store this byte array(picbyte) to the image column in the database table you created in starting steps. OR you can use this code.<br />
<br />
<span class="Apple-style-span" style="color: #3d85c6;">string cString = "Initial Catalog=DB NAME;Data Source=SQL SERVER INSTANCE;User ID=DB USER;Password=DB USER PASSWORD;";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlConnection connection = new SqlConnection(cString);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">string query = "insert into TableName (ColumnName) values (@pic)";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">connection.Open();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlParameter picparameter = new SqlParameter();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">picparameter.SqlDbType = SqlDbType.Image;</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">picparameter.ParameterName = "pic";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">picparameter.Value = picbyte;</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlCommand cmd = new SqlCommand(query, connection);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">cmd.Parameters.Add(picparameter);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">if (cmd.ExecuteNonQuery() > 0)</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">MessageBox.Show("Image Saved");</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">connection.Close();</span><br />
<br />
11. Now the image is saved in the database. You can see this by using query analyzer. Confirm it by the length of image column you will see when you will query it.<br />
<br />
12. Now the image is successfully saved, its time to Retrieve it.<br />
<br />
13. Drag another picture box to the Designer.<br />
<br />
14. Double click the Retrieve button to create the double click event.<br />
<br />
15. You can simply use the code below to show the image you saved in the second picture box.<br />
<br />
<span class="Apple-style-span" style="color: #3d85c6;">string cString = "Initial Catalog=DatabaseName;Data Source=SQL Instance Name;User ID=DB user;Password=Db User Password;";</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlConnection connection = new SqlConnection(cString);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlCommand command = new SqlCommand("select ColumnName from tableName where ID=1", connection);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">connection.Open();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">sqlDataAdapter.SelectCommand = new SqlCommand("select userimage from UserImages where imageID=" + Convert.ToInt32(txtID.Text), connection);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">DataSet dSet = new DataSet();</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">sqlDataAdapter.Fill(dSet);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;"><br />
</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">if (dSet.Tables[0].Rows.Count > 0)</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">{</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">MemoryStream ms = new MemoryStream((byte[])dSet.Tables[0].Rows[0]["userimage"]);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">pictureBox2.Image = new Bitmap(ms);</span><br />
<span class="Apple-style-span" style="color: #3d85c6;">}</span><br />
<br />
<span class="Apple-style-span" style="color: red;">Note</span>: <span class="Apple-style-span" style="color: #e06666;">ID in the command is the id you will see in the database of the image just stored. You can get this id form UI by just giving a textbox to the user.</span><br />
<br />
Now you have successfully saved/retrieved image in the SQL Database using C#.<br />
<br />
Any queries then you may ask....Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com12tag:blogger.com,1999:blog-5445070191253791999.post-51491940668069442552010-10-18T21:00:00.000+05:002010-10-18T21:01:06.167+05:00♥♥ GENERAL KNOWLEDGE OF HOLY QURAN ♥♥<font size="2"><font face="tahoma,sans-serif"><br clear="all"></font></font><div class="gmail_quote"><b><br></b> <div lang="EN-US" link="blue" vlink="purple"> <div> <table border="0" cellspacing="0" cellpadding="0"> <tbody><tr> <td valign="top" style="padding:0in 0in 0in 0in"> <p class="MsoNormal" style="margin-bottom:12.0pt"><font size="3" face="Gulim"><span style="font-size:12.0pt"> </span></font></p> <p class="MsoNormal"><font size="3" face="Gulim"><span style="font-size:12.0pt"> </span></font></p> <p class="MsoNormal"><font size="3" face="Gulim"><span style="font-size:12.0pt"> </span></font></p> <p class="MsoNormal"><span><b><u><font size="5" color="blue" face="Gulim"><span style="font-size:18.0pt;color:blue;font-weight:bold">GENERAL KNOWLEDGE OF HOLY QURAN.</span></font></u></b></span><span><b><u><font size="6" color="blue"><span style="font-size:24.0pt;color:blue;font-weight:bold"> </span></font></u></b></span><span><u><font size="6" color="blue"><span style="font-size:24.0pt;color:blue"> </span></font></u></span><span><font size="2" color="black"><span style="font-size:10.0pt;color:black"> </span></font></span></p> <p class="MsoNormal"><font size="3" face="Gulim"><span style="font-size:12.0pt"> </span></font></p> <table border="0" cellpadding="0"> <tbody><tr> <td bgcolor="silver" style="background:silver;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="purple" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:purple;font-weight:bold">No</span></font></b></p> </td> <td bgcolor="silver" style="background:silver;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="purple" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:purple;font-weight:bold">QUESTION</span></font></b></p> </td> <td bgcolor="silver" style="background:silver;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="purple" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:purple;font-weight:bold">ANSWER</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">1</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many Sura are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">114</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">2</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many Verses are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">6666</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">3</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many dots are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">1015030</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">4</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many over bar (zaber) are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">93243</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">5</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many under bar ( Zaer ) are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">39586</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">6</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many R</span></font></b><b><font size="2" color="navy"><span style="font-size:10.0pt;color:navy;font-weight:bold"> u</span></font></b><b><font size="2" color="#004200"><span style="font-size:10.0pt;color:#004200;font-weight:bold"> que are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">1000</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">7</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many stop ( Waqf ) are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">5098</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">8</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many Thashdeed are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">19253</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">9</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many letters are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">323671</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">10</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many p</span></font></b><b><font size="2" color="navy"><span style="font-size:10.0pt;color:navy;font-weight:bold"> e</span></font></b><b><font size="2" color="#004200"><span style="font-size:10.0pt;color:#004200;font-weight:bold"> sh are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">4808</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">11</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many Madd are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">1771</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">12</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many words are in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">77701</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">13</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many parts of Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">30</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">14</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many time Besmillah Al-Rahmaan Al-Raheem is repeated ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">114</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">15</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many Sura start with Besmillah Al-Rahmaan Al-Raheem ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">113</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">16</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many time the word 'Quran' is repeated in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">70</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">17</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which is the longest Sura of Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Al-Baqarah.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">18</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which is the best drink mentioned in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Milk.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">19</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">The best eatable thing mentioned inHoly Quran is ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Honey.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">20</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which is the shortest Sura of Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Qausar.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">21</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">The longest verse of Holy Quran is in which Sura?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Al-Baqarah No.282</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">22</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">The most disliked thing by the God though Halal is ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Divorce</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">23</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which letter is used for the most time in Holy Quran.?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Alaph</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">24</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which letter is used for the lest time in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Zaa.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">25</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which is the best night mentioned in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Night of Qadar.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">26</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which is the best month mentioned in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Ramzan.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">27</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which is the biggest animal mentioned in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Elephant.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">28</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which is the smallest animal mentioned in Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Mosquito</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">29</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many words are in the longest Sura of Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">25500</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">30</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many words are in the smallest Sura of Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">42</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">31</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which Sura of Holy Quran is called the mother of Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Hamd</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">32</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many Sura start with Al-Hamdullelah ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Five: Hamd, Inaam, Kahf, Saba & Fatr.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">33</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which Sura has the same number of verses as the number of Sura of Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Taqveer, 114 verses.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">34</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many Sura's name is only one letter ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Three: Qaf, Sad & Noon.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">35</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many Sura start with word " Inna " ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Four sura - Fatha, Nuh,Qadr, Qausar.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">36</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which Sura has the number of its verses equal to the number of Masumeen ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Saf, 14 verses.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">37</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which sura are called Musabbahat ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Esra, Hadeed, Hsar, Juma, Taghabun & Aala.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">38</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many sura are Makkahi and how many are Madni ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Macci 86, Madni 28.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">39</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which sura is on the name of tribe of Holy Prophet ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Quresh</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">40</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which sura is called the heart of Holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Yaseen.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">41</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">In which sura the name of Allah is repeated five time ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura al-Haj.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">42</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which sura are named Azaiam ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sajdah, Fusselat, Najum & Alaq.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">43</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which sura is on the name of one Holy war ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Ahzaab.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">44</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which sura is on the name of one metal ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Hadeed</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">45</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which sura does not starts with Bismellah ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Tauba.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">46</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which sura is called ' Aroos-ul-Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Rehman.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">47</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which sura is considered as 1/3 of holy Quran ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Tauheed.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">48</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">The name of how many sura are with out dot ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Hamd, Raad, Toor, Room, Masad.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">49</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">In which sura Besmillah came twice ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Naml..</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">50</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">How many sura start with the Initials ( Mukette'at )?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">29 Sura.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">51</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which Sura was revealed twice ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Hamd..</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">52</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">In which Sura the back biter are condemned ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Humzah.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">53</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">In which Sura the name of Allah is repeated in every verse ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Mujadala.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">54</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">In which Sura the letter 'Fa' did not come ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Hamd.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">55</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which Sura are called Muzetain ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Falk & Nas.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">56</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which are those Sura if their name are reversed remain the same ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Lael & Tabbat.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">57</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which is that Sura if its first letter is remove becomes the name of one of the city of Saudi Arab ? </span></font></b><font color="#813f62"><span style="color:#813F62"> </span></font></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sajdah</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">58</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which Sura start with word ' Tabara Kallazi' ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Mulk & Furkan</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">59</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Macci Sura were revealed in how many years ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">13 years</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">60</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Madani Sura were revealed in how many years ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">10 years.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">61</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which sura start with word Kad ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Mujadala & Momenoon.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">62</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which Sura is related to Hazrat Ali ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Adiat.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">63</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">How many Sura are in 30th. Chapter ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">37</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">64</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which sura every verse ends with letter 'Dal ' ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Tauheed.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">65</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which Sura is revealed in respect of Ahllelbayet ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Dahr..</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">66</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which sura every verse ends with letter ' Ra '?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Qauser.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">67</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">In which sura the creation of human being is mentioned ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Hijr V-26.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">68</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">In which sura the regulations for prisoner of war is mentioned ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Nesa</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">69</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">Which sura is having the laws about marriage ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Nesa..</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">70</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">Which sura if its name is reversed becomes the name of one bird ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Room..</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">71</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">In which sura the story of the worship of cow of Bani Esra'iel is mentioned ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Taha..</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">72</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">In which sura the law of inheritance is mentioned?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Nesa..</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">73</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Gulim"><span style="font-size:10.0pt;color:#813F62;font-weight:bold">In which sura the Hegira of Holy Prophet is mentioned ?</span></font></b></p> </td> <td bgcolor="#CCFFCC" style="background:#CCFFCC;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#813f62" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#813F62;font-weight:bold">Sura Infall.</span></font></b></p> </td> </tr> <tr> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal" align="right" style="text-align:right"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">74</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Gulim"><span style="font-size:10.0pt;color:#004200;font-weight:bold">In which Sura the 27 Attributes of God are mentioned ?</span></font></b></p> </td> <td bgcolor="#CCFFFF" style="background:#CCFFFF;padding:0in 0in 0in 0in"> <p class="MsoNormal"><b><font size="2" color="#004200" face="Times New Roman"><span style="font-size:10.0pt;font-family:"Times New Roman";color:#004200;font-weight:bold">Sura Hadeed</span></font></b></p> </td> </tr> </tbody></table> <p class="MsoNormal"><font size="5" color="#000099" face="Times New Roman"><span style="font-size:18.0pt;font-family:"Times New Roman";color:#000099"><br> <span> </span></span></font></p> </td> </tr> </tbody></table> <p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <div> <p class="MsoNormal"><font class="Apple-style-span" color="#000080" face="Arial"><br></font></p> </div> <p class="MsoNormal"><font size="3" face="Gulim"><span style="font-size:12.0pt"> </span></font></p> </div> </div> </div><br> Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-10482384845857033512010-06-22T11:23:00.000+05:002010-06-22T11:23:43.016+05:00Getting Specific Row in SQL 2000 & 2005Here is the query to find the specific row in Sql 2000<br />
<br />
SELECT ( SELECT SUM(1)<br />
<br />
FROM [Table_Name]<br />
WHERE [TableID]<=reg.[TableID]<br />
) AS Row<br />
,*<br />
FROM<br />
[Table_Name] AS reg<br />
WHERE ( SELECT SUM(1)<br />
<br />
FROM [Table_Name]<br />
WHERE [TableID]<=reg.[TableID]<br />
) = 5<br />
<br />
Note: 5 is the row number you want to find in the table.<br />
<br />
Now for SQL 2005<br />
<br />
SELECT us.TableID<br />
FROM (SELECT ROW_NUMBER() OVER (ORDER BY [Table_Name].[TableID]) AS Row, <br />
[Table_Name].[TableID]<br />
FROM [Table_Name] ) us <br />
WHERE Row = 5<br />
<br />
In this built in function ROW_NUMBER is used. Again '5' is the row number you are looking for. u can change it with the row number u want to find.Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-23285524656245419112010-02-09T10:03:00.000+05:002010-02-09T10:03:39.540+05:00Multiple Selection in RadComboBox--- Getting selectedValue at server side-- Setting selected value javascriptThis article shows how to select multiple items in radcombobox and to get these selected values at server side. Also it shows how to show selected value in radcombobox using javascript.<br />
<br />
1.First of all declare radcombobox.<br />
<br />
<br />
<telerik:RadComboBox ID="ddlVehicleOwners" OnClientSelectedIndexChanging="onSelectedIndexChangingVehicleOwner" runat="server" Skin="WebBlue" OnClientDropDownClosed="HandleClose" LoadingMessage="Loading..." ><br />
<ItemTemplate><br />
<table width="100%" cellpadding="0" cellspacing="0"><br />
<tr><br />
<td width="5%"><br />
<asp:CheckBox ID="CheckBox" runat="server" Text='<%# Eval("DataFieldName") %>' /><br />
</td><br />
<td align="left"><br />
<asp:Label ID="lblVName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"DataFieldName") %>'<br />
Visible="false"></asp:Label><br />
</td><br />
</tr><br />
</table><br />
</ItemTemplate><br />
</telerik:RadComboBox><br />
<br />
<telerik:radcombobox id="ddlVehicleOwners" loadingmessage="Loading..." onclientdropdownclosed="HandleClose" onclientselectedindexchanging="onSelectedIndexChangingVehicleOwner" runat="server" skin="WebBlue">The label visible is false because it will have the text representing the id of that record.<br />
<itemtemplate><br />
</itemtemplate></telerik:radcombobox><br />
<telerik:radcombobox id="ddlVehicleOwners" loadingmessage="Loading..." onclientdropdownclosed="HandleClose" onclientselectedindexchanging="onSelectedIndexChangingVehicleOwner" runat="server" skin="WebBlue"><itemtemplate>2. Now in the head portion of the page use javascript to show selectedvalues in the radcombobox.</itemtemplate></telerik:radcombobox><br />
<telerik:radcombobox id="ddlVehicleOwners" loadingmessage="Loading..." onclientdropdownclosed="HandleClose" onclientselectedindexchanging="onSelectedIndexChangingVehicleOwner" runat="server" skin="WebBlue"><itemtemplate><br />
</itemtemplate></telerik:radcombobox><br />
<telerik:radcombobox id="ddlVehicleOwners" loadingmessage="Loading..." onclientdropdownclosed="HandleClose" onclientselectedindexchanging="onSelectedIndexChangingVehicleOwner" runat="server" skin="WebBlue"><itemtemplate></itemtemplate></telerik:radcombobox><br />
function HandleClose(comboBox)<br />
{<br />
var selectedData = "";<br />
var items = comboBox.get_items();<br />
for (var i = 0; i < items.get_count(); i++)<br />
{<br />
var itemDiv = items.getItem(i).get_element();<br />
var inputs = itemDiv.getElementsByTagName("input");<br />
var inputsData = itemDiv.getElementsByTagName("label");<br />
for (var inputIndex = 0; inputIndex < inputs.length; inputIndex++)<br />
{<br />
var input = inputs[inputIndex];<br />
if (input.type == "checkbox")<br />
{<br />
if (input.checked == true)<br />
selectedData = selectedData + inputsData[inputIndex].innerText+",";<br />
}<br />
}<br />
}<br />
comboBox.set_text(selectedData.substring(0, selectedData.length - 1));<br />
}<br />
<br />
<table cellpadding="0" cellspacing="0"><tbody>
<tr> <td width="5%"><br />
</td><td align="left"><br />
3. Now final step to get values at server side.<br />
<br />
<br />
foreach (RadComboBoxItem item in ddlVehicleOwners.Items)<br />
{<br />
CheckBox checkBox = (CheckBox)item.FindControl("CheckBox");<br />
if (checkBox.Checked)<br />
{<br />
Label label = (Label)item.FindControl("lblVName");<br />
text=label.text;<br />
}<br />
<br />
}<br />
<br />
<br />
</td></tr>
</tbody></table>The text will contain the value of that selected item.Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com4tag:blogger.com,1999:blog-5445070191253791999.post-3666047042462061712009-10-01T09:50:00.002+06:002009-10-01T12:49:08.436+06:0015 Master Minds Who Changed the Internet Forever | Tempting Magazinevery interesting and informative..<br />These faces should be remembered because they have brought revolution to the internet world.<br /><br /><a href="http://www.temptingmagazine.com/2009/10/15-master-minds-who-changed-the-internet-forever.html">15 Master Minds Who Changed the Internet Forever | Tempting Magazine</a>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-7188752218756804432009-09-30T12:05:00.001+06:002009-09-30T12:05:31.269+06:00CLR Triggers for SQL Server 2005: ASP AllianceTriggers are very important now a days. In SQL we usually need to capture insert update and delete operation performed on any table.<br />Triggers can be applied on tables. Different types of Triggers are there like AFTER, INSTEAD OF, MULTIPLE etc.<br /><br /><a href="http://aspalliance.com/1273_CLR_Triggers_for_SQL_Server_2005.all">CLR Triggers for SQL Server 2005: ASP Alliance</a><br /><br />Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-81597290607061339892009-09-30T12:00:00.001+06:002009-09-30T12:00:11.347+06:00ASP.NET AJAX Overview The UpdatePanel and UpdateProgress Controls UpdatePanel Control OverviewA very nice article about the Update Panel. It is used when we just want to update certain page contents and not the whole page. <br /><br /><a href="http://www.asp.net/Ajax/Documentation/Live/overview/UpdatePanelOverview.aspx">ASP.NET AJAX Overview The UpdatePanel and UpdateProgress Controls UpdatePanel Control Overview</a><br /><br /><br />Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-60986540329666104402009-09-29T17:09:00.001+06:002009-09-29T17:09:24.669+06:00Help and Support on RecoverAnyPassword.comMOre info coming soon........... keep visiting<br /><br /><br /><a href="http://recoveranypassword.com/recover/windows-password/#">Help and Support on RecoverAnyPassword.com</a><br /><br />Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-2840915035263114952009-09-15T12:15:00.001+06:002009-09-15T12:15:39.009+06:00ScriptCase - Framework PHP Ajax<a href="http://www.scriptcase.net/siteen/download/download.php?rand=a543cd4ba00e76b2">ScriptCase - Framework PHP Ajax</a><br /><br />Shared via <a href="http://addthis.com">AddThis</a><br />Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-55827035939969016602009-08-17T17:36:00.002+06:002009-08-22T15:53:44.631+06:00What is BlogThis! ? - Blogger Help<a href="http://www.google.com/support/blogger/bin/answer.py?hl=en&answer=41469" Target="blank">What is BlogThis! ? - Blogger Help</a>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-22315898568571433352009-08-17T17:05:00.003+06:002009-08-17T17:19:49.898+06:00Numion - YourSpeed and SiteSpeedVery interesting site. This site has some tools with the hlp of which we can find the loading time of our website or any website. Also we can find the stat of our website. Nice site for the developers to find out the loading time of their websites.<br /><br /><a href="http://www.numion.com/" Target="blank">Numion - YourSpeed and SiteSpeed</a>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-8211233944912147382009-08-11T13:10:00.003+06:002009-08-11T13:13:54.892+06:00Atom Vs RSS??I have read this article which emphasis on the difference between Atom & RSS feeds. Hope u will also get benefit from it..<br /><br />click <a href="http://www.problogger.net/archives/2006/03/30/rss-vs-atom-whats-the-big-deal/" Target="blank">ProBlogger.....</a> to read full article.Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-23365773318180405562009-08-11T12:21:00.002+06:002009-08-11T12:25:06.903+06:00SourceForge ... Open SourceThis site provides softwares of any type. Their source is also available and users can modify them according to their needs. SourceForge's media and e-commerce web sites connect millions of influential technology professionals and enthusiasts each day. Combining user-developed content, online marketplaces and e-commerce, SourceForge is the global technology community's nexus for information exchange, goods for geeks, and open source software distribution and services.<br /><br />For Further details..<br /><br /><a href="http://www.sourceforge.net" Target="blank">SourceForge</a>Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-6392125939203302582009-08-10T16:34:00.006+06:002009-08-11T10:30:42.565+06:00serVonic Software ready for Open Source PBX - Unified Messaging for AsteriskserVonic’s unified messaging solution IXI-UMS now can also be connected to Asterisk PBX’s successfully and therewith is "Ready for Open Source PBX". The connection can be realized via SIP or ISDN.<br /><br />Click<a href="http://www.prlog.org/10232544-servonic-software-ready-for-open-source-pbx-unified-messaging-for-asterisk.html" Target="blank"> Here</a> to read more about this.Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-68565817757108842642009-08-07T17:13:00.003+06:002009-08-07T17:17:52.957+06:00Function for Calculating Difference between two dates....This function will calculate the date difference from today to the date passed to this function. <br /><br />Send it the Date in the form of DateTime in asp.net C#.<br /><br /> int[] monthDay = new int[12] { 31, -1, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };<br /> DateTime fromDate=DateTime.Now ;<br /> DateTime toDate=dt;<br /> string difference;<br /> int year;<br /> int month;<br /> int day;<br /> int increment = 0;<br /><br /> if (fromDate.Day > toDate.Day)<br /> {<br /> increment = monthDay[fromDate.Month - 1];<br /><br /> }<br /> <br /> if (increment == -1)<br /> {<br /> if (DateTime.IsLeapYear(fromDate.Year))<br /> {<br /> <br /> increment = 29;<br /> }<br /> else<br /> {<br /> increment = 28;<br /> }<br /> }<br /> if (increment != 0)<br /> {<br /> day = (toDate.Day + increment) - fromDate.Day;<br /> increment = 1;<br /> }<br /> else<br /> {<br /> day = toDate.Day - fromDate.Day;<br /> }<br /><br /> <br /> if ((fromDate.Month + increment) > toDate.Month)<br /> {<br /> month = (toDate.Month + 12) - (fromDate.Month + increment);<br /> increment = 1;<br /> }<br /> else<br /> {<br /> month = (toDate.Month) - (fromDate.Month + increment);<br /> increment = 0;<br /> }<br /><br /> <br /> year = toDate.Year - (fromDate.Year + increment);<br /> if( year==0 && month==0 && day==0 )<br /> {<br /> if ((DateTime.Now.Hour - toDate.Hour)==0)<br /> {<br /> return difference = ((DateTime.Now.Minute - toDate.Minute) + " m ").ToString();<br /> }<br /> return difference=((DateTime.Now.Hour-toDate.Hour)+" h ").ToString();<br /><br />It receives data in the form of DateTime.....Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0tag:blogger.com,1999:blog-5445070191253791999.post-57418233454596724092009-08-07T10:53:00.004+06:002009-08-07T10:59:47.128+06:00Changing Header Text of GridView Dynamically.. Header Test ChangeI am working on a project and find it a bit tricky to change the header text of grid view by data binding.<br /><br />1. First of all you have to set the property of the page on which you are using grid view. <br /><br />2. Set the property from the data you brought from the database(or with any data on run time)<br /><br />3.Now on Page Load do this<br /><br />GdvMain.Columns[0].HeaderText = heading;<br /><br />where<br />GdvMain is the grid view<br />heading is the property i set(meaning string containing text u want to see at grid view header)<br /><br />4. This will set the header text of grid view to the text you want.<br /><br />If you have any queries u are welcome......Anonymoushttp://www.blogger.com/profile/13147520569378171530noreply@blogger.com0