tag:blogger.com,1999:blog-50589128503499272272024-03-13T20:56:50.779+05:30Tech Tasks : Asp.Net,C#.Net,Ajax,jQuery,SQL Server,MySql,Asp.net MVCA Complete Source for Microsoft Developer, Asp.Net,C#.Net,Ajax,jQuery,SQL Server,MySql,Asp.net MVCRajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.comBlogger76125tag:blogger.com,1999:blog-5058912850349927227.post-17549608868294982592013-01-31T22:43:00.001+05:302013-02-09T20:10:07.986+05:30How to Run the MySQL Query Through the Command Prompt?<div dir="ltr" style="text-align: left;" trbidi="on">
Check out useful posts regarding MySQL optimization
<br>
<li><a href="http://www.techtasks.net/2013/01/how-to-backup-restore-mysql-database-command-prompt.html" target="_blanck">How to Backup/Restore/Crate/Drop the MYSQL Data Base through the Command Prompt?</a></li>
<li><a href="http://www.techtasks.net/2013/01/stored-procedure-optimization-tips-in.html" target="_blanck">
how to optimize the <b>Stored Procedure</b>?</a></li>
<li><a href="http://www.techtasks.net/2013/01/how-to-avoid-cursors-in-stored-procedure.html" target="_blanck">
how to avoid the <b>Cursors</b> inside the Stored procedure?</a></li>
<br>
<h5>
To run the query directly from the command Prompt:</h5>
<div class="codeview">
mysql –u[Username] –p[Password] -e "select * from tbl_emp where emp_id=2" [DataBaseName] </div>
‘<b>-e</b>’ :- execute the query<br>
Even we can store the result to file
<br>
<div class="codeview">
mysql –u[Username] –p[Password] -e "select * from tbl_emp where emp_id=2" [DataBaseName] > D:\test.log<br>
</div></div><a href="http://www.techtasks.net/2013/01/how-to-run-mysql-query-through-command.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com1tag:blogger.com,1999:blog-5058912850349927227.post-56460760467454133812013-01-29T19:51:00.000+05:302013-01-29T20:24:13.355+05:30How to Backup/Restore/Crate/Drop the MYSQL Data Base through the Command Prompt?There are no of IDEs (SQLyog) are to handle the <a href="http://www.techtasks.net/search/label/MySQL?max-results=5" target="_blanck">MySQL</a> Databases, but it’s always better to use command prompt instead of IDE. It will reduce the processing time as well as burden on the server. we discussed about <a href="http://www.techtasks.net/2013/01/stored-procedure-optimization-tips-in.html" target="_blanck"> how to optimize the <b>Stored Procedure</b>?</a> and <a href="http://www.techtasks.net/2013/01/how-to-avoid-cursors-in-stored-procedure.html" target="_blanck"> how to avoid the <b>Cursors</b> inside the Stored procedure?</a>.
<br>
<h5>
To backup the Database:</h5>
<div class="codeview">
mysqldump –u[Username] –p[Password] --database [DatabaseName] > D:\DBBackup.sql </div>
<h5>
To take backup with all the Databases : </h5>
<b>--all-databases</b> :- use to take backup all DataBases
<br>
<div class="codeview">
mysqldump –u[Username] –p[Password] --all-databases > D:\DBBackup.sql </div>
<h5>
To take backup with Stored procedures, functions, triggers, views : </h5>
<b>--routines</b> :- Use to take backup with all Stored procedures, functions, triggers, views.
<br>
<div class="codeview">
mysqldump –u[Username] –p[Password] --routines --database [DatabaseName] > D:\DBBackup.sql <br>
</div><a href="http://www.techtasks.net/2013/01/how-to-backup-restore-mysql-database-command-prompt.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com4tag:blogger.com,1999:blog-5058912850349927227.post-87153667233664443772013-01-26T14:02:00.002+05:302013-05-02T15:13:12.996+05:30How to Avoid the Cursor in Stored Procedures<div dir="ltr" style="text-align: left;" trbidi="on">
<h5>
What is Cursor? </h5>
A <b>cursor </b>is a temporary work area,it will create in memory when a SQL statement is executed. A cursor holds set of records accessed based on a select statement. This temporary work area is used to store the data retrieved from the database, and manipulate/process this data row by row. A cursor can hold more than one row, but can process only one row at a time. The set of rows the cursor holds is called the active set.
<br>
<h5>
Why we need to avoid the cursor?</h5>
Mostly we will use cursor inside <b>Stored Procedures</b>, we have seen <a href="http://www.techtasks.net/2013/01/stored-procedure-optimization-tips-in.html" target="_blank">how to optimize the stored procedure</a>,<b>Cursors </b>are one of the most costliest operations in sql,it's better to avoid the <b>Cursors</b>. We can avoid the Cursors in following ways...
<br>
</div><a href="http://www.techtasks.net/2013/01/how-to-avoid-cursors-in-stored-procedure.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com2tag:blogger.com,1999:blog-5058912850349927227.post-35013983609981947422013-01-19T12:05:00.002+05:302013-01-27T10:36:29.590+05:30Stored Procedure Optimization Tips in SQL<h5>
Avoid using temporary tables.</h5>
If required use it in OLAP but NOT in OLTP. If required in OLTP, then plan on creating a permanent table. (Temporary tables eat up a lot of resources (CPU and memory) by the database engine. Temporary tables definition should have primary key, constraits and foreign keys if required.)
<br>
<br>
<b>OLTP VS OLAP</b> <br>
<br>
We can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.
<br>
<img border="0" src="https://lh3.googleusercontent.com/-aHwoeBsWh_s/UPo99MUAxbI/AAAAAAAAJM0/apJMf_sn6w0/s581/olap_vs_oltp.jpg"><br>
<br>
<a href="http://www.techtasks.net/2013/01/stored-procedure-optimization-tips-in.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com1tag:blogger.com,1999:blog-5058912850349927227.post-37837964630606516462011-12-21T20:59:00.001+05:302012-04-15T13:06:13.339+05:30How to Bind the DropDownList With EnumWe can Bind DropDownList with no of ways, Now I am going to show how to bind dropdown
using ‘enum’.
<br>
<br>
Check This <a href="http://www.techtasks.net/2011/05/how-to-bind-dropdownlist-using-list.html" target="_blanck">How To Bind DropDownList Using List Collection and DataSet in Asp.Net</a><br>
<br>
<img border="0" height="232" src="http://4.bp.blogspot.com/-Tt7scJ6ShEM/TvNnY6j8igI/AAAAAAAAGMw/0oc_ESYkJAg/s320/BindDropDownWithEnum.JPG" width="320">
<br>
<br>
Let’s take Countries ‘enum’ as follows
<br>
<br>
<div class="codeview">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">enum</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #2b91af;">enCountries</span>:<span style="color: blue;">int</span>{<st1:country-region w:st="on">India</st1:country-region>=0,<st1:country-region w:st="on">USA</st1:country-region>,<st1:place w:st="on"><st1:country-region w:st="on">UK</st1:country-region></st1:place>,UAE};<o:p></o:p></span></div>
</div>
<br>
<br>
<a href="http://www.techtasks.net/2011/12/how-to-bind-dropdownlist-with-enum.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-25235187896502658512011-05-28T14:45:00.001+05:302012-04-15T13:09:08.432+05:30How To Bind DropDownList Using List Collection and DataSet in Asp.Net<div dir="ltr" style="text-align: left;" trbidi="on">
We can bind <b>DropDownList</b> in Different ways by using <b>List</b>, <b>Dictionary </b>and <b>DataSet</b>.<br>
<br>
To bind DropDownList we need to set some properties <br>
<b>DataSource </b><br>
<b>DataValueField</b><br>
<b>DataTextField</b><br>
Let see how to use these properties to bind DropDownList<br>
<h4>
Binding DropDownList with List</h4>
In This Case the DropDownList both 'Value' and 'Text' field are same.<br>
<br>
<div class="codeview">
<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: 10pt;">DropDownList</span><span style="font-family: "Courier New"; font-size: 10pt;"> ddl = <span style="color: blue;">new</span> <span style="color: #2b91af;">DropDownList</span>();<span style="color: #2b91af;"></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 style="color: #2b91af; font-family: "Courier New"; font-size: 10pt;">List</span><span style="font-family: "Courier New"; font-size: 10pt;"><<span style="color: blue;">string</span>> countries = <span style="color: blue;">new</span> <span style="color: #2b91af;">List</span><<span style="color: blue;">string</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 style="font-family: "Courier New"; font-size: 10pt;">countries.Add(<span style="color: #a31515;">"USA"</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 style="font-family: "Courier New"; font-size: 10pt;">countries.Add(<span style="color: #a31515;">"India"</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 style="font-family: "Courier New"; font-size: 10pt;">ddl.DataSource = countries;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Courier New"; font-size: 10pt;">ddl.DataBind();</span></div>
</div>
<br>
</div><a href="http://www.techtasks.net/2011/05/how-to-bind-dropdownlist-using-list.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-21335382711411753932011-04-28T21:09:00.004+05:302012-04-23T22:16:24.814+05:30jQuery Toggle Button Widget For Blogger<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.techtasks.net/search/label/Google?max-results=5" target="_blanck">jQuery</a> is Most Powerful and useful Library.In my blog i used <a href="http://www.techtasks.net/search/label/Google?max-results=5" target="_blanck">jQuery</a> to Develop no of widgets for making more useful and attractive.<br>
<h4>
List of jQuery Widgets for Blogger</h4>
<div dir="ltr">
<br>
<li><a href="http://www.techtasks.net/2011/03/closeable-jquery-floating-message-box.html">Closeable jQuery Floating Message Box For Bloggers</a></li>
<br>
<br>
<br>
<li><a href="http://www.techtasks.net/2011/01/simple-jquery-multi-tabbed-navigation.html">Simple jQuery Multi Tabbed Navigation Widget For Blogger</a></li>
<br>
<br>
<br>
<li><a href="http://www.techtasks.net/2011/04/smooth-scrolling-widget-for-blogger.html">Smooth Scrolling Widget For Blogger</a></li>
<br>
<br>
<br>
<li><a href="http://www.techtasks.net/2011/04/jquery-accordian-widget-for-blogger.html">jQuery Accordion Widget for Blogger</a></li>
</div>
In this article i am going to show how add a toggle widget for Blogger.<br>
<br>
<img alt="jQuery Toggle" src="https://lh3.googleusercontent.com/_-A4vw5BwqxA/TbmB0yJ2E6I/AAAAAAAAFfI/By1LbOLlMYo/jQuery_toggle_for_blogger.jpg"><br>
<br>
</div><a href="http://www.techtasks.net/2011/04/jquery-toggle-button-widget-for-blogger.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com2tag:blogger.com,1999:blog-5058912850349927227.post-55830531244009993052011-04-16T11:28:00.000+05:302012-04-23T22:17:15.202+05:30Very Interesting Windows Magical Bugs<div dir="ltr" style="text-align: left;" trbidi="on">
Today i got mail notifying about very interesting and amazing Magical bug in <b>WINDOWS </b><br>
<br>
<u>MAGIC #1 </u><br>
<br>
An Indian found that nobody can create a FOLDER anywhere on<br>
the Computer which can be named as "CON". This is<br>
something funny and inexplicable? At Microsoft the whole<br>
Team, couldn't answer why this happened!<br>
TRY IT NOW, IT WILL NOT CREATE A "CON"<br>
FOLDER<br>
<a href="https://lh3.googleusercontent.com/_-A4vw5BwqxA/TaksfmEPJCI/AAAAAAAAFdk/wGIIO9UW72I/s800/Windows_Con_floder_bud.png" target="_blanck"> <img src="https://lh3.googleusercontent.com/_-A4vw5BwqxA/TaksfmEPJCI/AAAAAAAAFdk/wGIIO9UW72I/s600/Windows_Con_floder_bud.png"> </a><br>
<br>
<br>
</div><a href="http://www.techtasks.net/2011/04/very-interesting-windows-magical-bugs.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-89283533200923532552011-04-05T20:52:00.006+05:302012-04-23T22:18:23.644+05:30jQuery Accordion Widget for Blogger<div dir="ltr" style="text-align: left;" trbidi="on">
Accordion is more use as Multi Tabbed Widget.you might have been seeing on many sites.<br>
I this article i am going to how to add Accordion as a Widget for your blog.<br>
Check out my other useful jQuery Widgets For Blogger<br>
<br>
<br>
<li><a href="http://www.techtasks.net/2011/03/closeable-jquery-floating-message-box.html">Closeable jQuery Floating Message Box For Bloggers</a><br>
</li>
<br>
<br>
<br>
<br>
<li><a href="http://www.techtasks.net/2011/01/simple-jquery-multi-tabbed-navigation.html">Simple jQuery Multi Tabbed Navigation Widget For Blogger</a><br>
</li>
<br>
<br>
<br>
<br>
<li><a href="http://www.techtasks.net/2011/04/smooth-scrolling-widget-for-blogger.html">Smooth Scrolling Widget For Blogger</a><br>
</li>
<br>
<br>
<br>
<img alt="image" src="https://lh5.googleusercontent.com/_-A4vw5BwqxA/TZszZ6S2kOI/AAAAAAAAFc8/TAjbcBjER0A/Accordion_Widget_for_blogger.jpg"><br>
<br>
</div><a href="http://www.techtasks.net/2011/04/jquery-accordian-widget-for-blogger.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com7tag:blogger.com,1999:blog-5058912850349927227.post-3873545030919677602011-04-02T08:40:00.005+05:302012-04-23T22:19:11.247+05:30Smooth Scrolling Widget For Blogger<div dir="ltr" style="text-align: left;" trbidi="on">
So many blogs contains lengthy pages,the readers fell difficult to navigate in page.In so many blogs or sites you may find this jQuery Scroll to top Widget,If u your looking for that,Then go add this jQuery Smooth Scrolling Widget to give more look and fell for your blog.Check these other jQuery Widgets <br>
<br>
<b style="color: blue;">»</b><a href="http://www.techtasks.net/2011/03/closeable-jquery-floating-message-box.html" target="_blanck">jQuery Floating Message Box Widget</a><br>
<br>
<b style="color: blue;">»</b><a href="http://www.techtasks.net/2011/01/simple-jquery-multi-tabbed-navigation.html" target="_blanck">jQuery Multi Tabber Widget</a><br>
<br>
Just see Demo of Scrolling to Top and jQuery features<br>
<br>
<iframe allowfullscreen="allowfullscreen" frameborder="0" height="349" src="http://www.youtube.com/embed/csxR77zfRFE?rel=0" title="YouTube video player" width="560"></iframe><br>
<br>
</div><a href="http://www.techtasks.net/2011/04/smooth-scrolling-widget-for-blogger.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-6723456066365039532011-03-31T23:16:00.001+05:302012-04-23T22:19:39.690+05:30A Great News To (Photo)Blogger Authors<div dir="ltr" style="text-align: left;" trbidi="on">
Absolutely this is great news blogger Authors especially photo bloggers,Blogger introduces new futures to authors to project their blog with great look and fell.<br>
<br>
Blogger currently offers five dynamic views for its public blogs. These views are only accessible if allowed for by the blog author<br>
<div class="article_content" id="article-content-div">
<br>
<br>
Flipcard: available at <a href="http://funevil.blogspot.com/view/flipcard">http://funevil.blogspot.com/view/flipcard</a></div>
<div class="article_content" id="article-content-div">
<br>
Mosaic: available at <a href="http://funevil.blogspot.com/view/mosaic">http://funevil.blogspot.com/view/mosaic</a> <br>
<br>
Sidebar: available at <a href="http://funevil.blogspot.com/view/sidebar">http://funevil.blogspot.com/view/sidebar</a> <br>
<br>
Snapshot: available at <a href="http://funevil.blogspot.com/view/snapshot">http://funevil.blogspot.com/view/snapshot</a> <br>
<br>
Timeslide: available at <a href="http://funevil.blogspot.com/view/timeslide">http://funevil.blogspot.com/view/timeslide</a><br>
<br>
These views require modern browsers such as Internet Explorer 8+, Firefox 3.5+, Chrome or Safari. Many elements of these views will not work should you have an older browser.<br>
In all views, search is available in the upper right hand corner. Clicking on the ">" arrow in the very top left of the header bar will slide the header bar across and allow you to choose different views for the current blog as well as type in a new blog URL.<br>
There is also a feedback link for each view.<br>
<h3>
Flipcard</h3>
<img src="https://lh4.googleusercontent.com/_-A4vw5BwqxA/TZS4gijhnII/AAAAAAAAFb8/vYQQ5gcFE0w/s800/Blogger_new_futures.png" width="550px"> <br>
<ul>
<li>Mouse over any of the cards to see the post title and comment count. As you scroll down, additional posts will continue to load.</li>
<li>Click on a card to see the post in full view. You can navigate through the posts using <b>J</b> (older post) and <b>K</b> (newer post) or the arrow keys. Hit <b>escape</b> or click <i>Back to all posts</i> to return to the Flipcard view.</li>
<li>In the upper left, click to sort by <i>Date</i>, <i>Author</i> and <i>Category</i>.</li>
</ul>
<br>
</div></div><a href="http://www.techtasks.net/2011/03/great-newsphotoblogger-authors.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com1tag:blogger.com,1999:blog-5058912850349927227.post-54714145155229894692011-03-27T11:56:00.006+05:302012-04-23T22:20:47.854+05:30All In One Floating Subscribe N Share Widget For Blogger (Extension)<div dir="ltr" style="text-align: left;" trbidi="on">
In last article i write article on Floating Message Box for Blogger, Now in this article i am going to configure that one as a Fully Loaded Social Widget.<br>
<h4>
List Of Futures</h4>
<b style="color: blue;">»</b>eMail Subscription<br>
<b style="color: blue;">»</b>Add This Share Widget<br>
<b style="color: blue;">»</b>All Connection To Your Blog<br>
<br>
Now see how add the widget,For this you need to add the this widget <a href="http://www.techtasks.net/2011/03/closeable-jquery-floating-message-box.html" target="_blancK">Closeable jQuery Floating Message Box For Bloggers</a><br>
<br>
</div><a href="http://www.techtasks.net/2011/03/all-in-one-floating-subscribe-n-share.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-22977027470050041672011-03-19T22:22:00.004+05:302012-04-23T22:21:36.164+05:30Closeable jQuery Floating Message Box For Bloggers<div dir="ltr" style="text-align: left;" trbidi="on">
I very eagerly waiting for to make this available for blogger, Previously i make <a href="http://www.techtasks.net/2011/01/simple-jquery-multi-tabbed-navigation.html"><b>jQuery Tabber Widget For Blogger</b></a> now in this article i will show <b>how to display the jQuery Message Box</b><br>
<br>
<b style="color: blue;">»</b>I think no need to mention(First Download the Template<b>)</b><br>
<br>
<a href="https://lh3.googleusercontent.com/_-A4vw5BwqxA/TYTZJ4mzJyI/AAAAAAAAFac/ZkulxwkaAy4/s912/jQuery_Message_box_for_blogger.png" target="_blanck"><br>
<img src="https://lh3.googleusercontent.com/_-A4vw5BwqxA/TYTZJ4mzJyI/AAAAAAAAFac/ZkulxwkaAy4/s912/jQuery_Message_box_for_blogger.png" width="550px"><br>
</a><br>
<br>
<br>
<div class="demo">
<a href="http://blogger.techtasks.net/" target="_blanck">See Demo</a></div>
<br>
</div><a href="http://www.techtasks.net/2011/03/closeable-jquery-floating-message-box.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com4tag:blogger.com,1999:blog-5058912850349927227.post-63960510214878960832011-03-12T11:47:00.004+05:302012-04-23T22:23:14.023+05:30How To Display PreFixText In Different Style Of ASP.NET AutoComplete Extender<div dir="ltr" style="text-align: left;" trbidi="on">
In this article i am going to show<b> how to display PreFixTest In Different Style</b>.Before going to forward i think you have idea about<a href="http://www.techtasks.net/2011/02/how-to-use-ajax-autocompleteextender-in.html" target="_blanck"> How to Use AutoComplete Extender</a>, If not check This <a href="http://www.techtasks.net/2011/02/how-to-use-ajax-autocompleteextender-in.html" target="_blanck">Article</a><br>
and in last article i discussed about <a href="http://www.techtasks.net/2011/02/autocompleteextender-with-progress.html">AutoCompleteExtender with Progress Image</a><br>
<br>
<img src="https://lh5.googleusercontent.com/_-A4vw5BwqxA/TVdSrqUbqwI/AAAAAAAAFWM/hxbhYUJSVbY/Auto_complete_Extender_With_Progress.png"><br>
</div><a href="http://www.techtasks.net/2011/03/how-to-display-prefixtext-in-different.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com3tag:blogger.com,1999:blog-5058912850349927227.post-73222244572281219402011-02-23T23:08:00.000+05:302011-02-23T23:08:08.280+05:30Poor Error Handling In MSDN<div dir="ltr" style="text-align: left;" trbidi="on">Today i am browsing MSDN in between i notify this error.<br />
<br />
<img src="https://lh5.googleusercontent.com/_-A4vw5BwqxA/TWVErTVGwkI/AAAAAAAAFY8/DOz_1Kg5QyI/s640/msdn_error.JPG" /></div>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-37025939250458805412011-02-13T09:56:00.001+05:302012-04-23T22:23:57.966+05:30AutoCompleteExtender with Progress Image<div dir="ltr" style="text-align: left;" trbidi="on">
In last article i discussed about how to use <a href="http://www.techtasks.net/2011/02/how-to-use-ajax-autocompleteextender-in.html" target="_blanck"> <b>AutoCompleteExtender</b></a>,Now i am going to show here how to show progress image while retrieving results from <b>DataBase</b>,It is more use full if the <b>DataBase</b> Contains large no of records.<br>
<br>
<img src="https://lh5.googleusercontent.com/_-A4vw5BwqxA/TVdSrqUbqwI/AAAAAAAAFWM/hxbhYUJSVbY/Auto_complete_Extender_With_Progress.png"><br>
<br>
</div><a href="http://www.techtasks.net/2011/02/autocompleteextender-with-progress.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-40602379905832006012011-02-12T20:49:00.001+05:302012-04-23T22:25:39.704+05:30How To Use Ajax AutoCompleteExtender in Asp.Net<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Ajax</b> a powerfull script on the web,It provides lot's more functionality to improve your application Perfomence and look and fell..<br>
<br>
In this article i am going to show how to work with <b>AutoCompleteExtender</b> (Control in AjaxControlToolKIt).<br>
<br>
<b>AutoCompleteExtender</b> is an <b>ASP.NET AJAX </b>Control that can be attached to any TextBox control, and will associate that control with a popup panel to display words that begin with the prefix typed into the textbox.<br>
<br>
Can we get the Auto Suggestion from server in two ways <br>
1.From <b>Webservice</b><br>
2.From <b>Static Method</b><br>
<br>
<img src="https://lh5.googleusercontent.com/_-A4vw5BwqxA/TVanImJg6OI/AAAAAAAAFV8/hdDAICWTLf0/Ajax_AutoCompleteExtender.png"><br>
<br>
</div><a href="http://www.techtasks.net/2011/02/how-to-use-ajax-autocompleteextender-in.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com1tag:blogger.com,1999:blog-5058912850349927227.post-33840505053117870472011-01-26T13:21:00.004+05:302012-04-23T22:26:29.103+05:30Simple jQuery Multi Tabbed Navigation Widget For Blogger<div dir="ltr" style="text-align: left;" trbidi="on">
So many people heard about<b> jQuery</b>, for me still now no chance to work on that,finally the day came and i did <b>tabbed navigation</b> in one of my project.While working on that i got idea to make<b> Blogger Widget</b>.<br>
<br>
Still i remember,How much struggle i faced to setup <b>Multi Tabbed Widget</b> on my blog. But here now i am going to show in easy 3 steps.<br>
<br>
<img border="0" float="right" src="http://lh4.ggpht.com/_-A4vw5BwqxA/TT_I1phqC3I/AAAAAAAAFVA/fhlY60okYa4/Multi-Tabbed-Widget-Blogger.jpg"><br>
<br>
<div class="demo">
<a href="http://blogger.techtasks.net/" target="_blanck">See Demo</a></div>
<br>
</div><a href="http://www.techtasks.net/2011/01/simple-jquery-multi-tabbed-navigation.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com10tag:blogger.com,1999:blog-5058912850349927227.post-16864192817840452702011-01-23T16:57:00.003+05:302012-04-23T22:28:16.085+05:30Recent Posts Widget With Thumblines For Photo Bloggers<div dir="ltr" style="text-align: left;" trbidi="on">
One of Photo Bloggers request me to post this aticle,So Many Photo Bloggers are suffered to find appropriate <b>Recent Post Widget</b> to their blog. I added this widget on my Photo Blog <a href="http://funevil.blogspot.com/" target="_blanck">Fun Evil</a><br>
<br>
I Modified the original Blogger widget Developed by <a href="http://draft.blogger.com/blogertricks.com" target="_blanck">Kranthi.</a><br>
<br>
Lets see how to install.....<br>
<br>
</div><a href="http://www.techtasks.net/2011/01/recent-posts-widget-with-thumblines-for.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-7059705687324003452011-01-15T00:08:00.002+05:302012-04-23T22:29:31.296+05:30Maintaine Scroll Position After PostBack For Partial Page in Asp.Net(Using Div)Some times our page contains scrollable division inside the page,In last article i disused about <a href="http://www.techtasks.net/2011/01/maintaine-scroll-postion-after-postback.html">Maintain Scroll Position After PostBack in Page Level</a> , But it maintains scroll position for page level only not inside.<br>
<br>
<br>
For This to achieve we need to take two hidden fields to store scroll position in between postbacks <br>
<br>
First add the following javascript code in head section of page...<br>
<br>
<a href="http://www.techtasks.net/2011/01/maintaine-scroll-position-after.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-82599027611895460342011-01-14T23:35:00.003+05:302012-04-23T22:31:09.129+05:30Maintaine Scroll Postion After Postback In ASP.NetIn this article i am going to shows how to <b>Maintain Scroll Position After PostBack</b>.<br>
<br>
The <b>MaintainScrollPositionOnPostback</b> page property attribute allows to do that in different ways as follows...<br>
<br>
It is must need property for long pages...<br>
<br>
<br>
<a href="http://www.techtasks.net/2011/01/maintaine-scroll-postion-after-postback.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-4219729078343835422010-12-23T16:51:00.000+05:302012-04-23T22:31:58.021+05:30Monetize Blog With Image Space Ads : Mouse Over Image Ads So many photo bloggers are suffered with low CTR with content Ads,A new solution for this is Image Space Ads.<br>
I tried some Image Space Ads(<a href="http://www.imagespacemedia.com/" target="_blank"> IMS </a> & <a href="http://gumgum.com/" target="_blank"> GumGum </a> & <a href="http://www.pixazza.com/" target="_blank">Pixazza</a>) on my photo blog(<a href="http://draft.blogger.com/www.funevil.com" target="_target">Fun Evil</a>) Here i am going to discus about these Image Space Ad Provides <br>
<br>
<a href="http://www.imagespacemedia.com/" target="_blank">Image Space Media:IMS </a><br>
<img align="right" src="http://lh3.ggpht.com/_-A4vw5BwqxA/TRMuhVVGo1I/AAAAAAAAFFs/XDi4lBLs_eA/ISM.jpg"><br>
Image Space Media matches relevant advertisements to images across their network of 7,000 publishers, serving over a quarter billion impressions per month. IMS provide publishers with additional revenue for their sites, maximizing web advertisement space without compromising content integrity.<br>
<br>
<ul>Easy to use:Place JavaScript </ul>
<ul>ISM is keyword matching is based on metadata, ensuring all ads are targeted and relevant.</ul>
<ul>Receive monthly payments via PayPal or check.</ul>
<ul>Displays relevant ads Compare to Other.</ul>
<br>
<a href="http://www.techtasks.net/2010/12/monetize-blog-with-image-space-ads.html#more">Read more »</a>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com8tag:blogger.com,1999:blog-5058912850349927227.post-63787505052405700382010-12-20T10:13:00.003+05:302011-02-12T23:39:10.235+05:30What If Being Programmer?<img src="http://lh6.ggpht.com/_-A4vw5BwqxA/TQ7dJJgr9ZI/AAAAAAAAE6A/wJOU84CF7lQ/beingprogrammer.jpg">Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com1tag:blogger.com,1999:blog-5058912850349927227.post-22892949574820191702010-12-17T22:45:00.002+05:302010-12-24T17:40:18.056+05:30Google Body BrowserGoogle introduce another service is <span style="font-weight: bold;">Google Body Browser</span>.<br /><br /><img style="cursor: pointer; width: 400px; height: 212px;" src="http://2.bp.blogspot.com/_-A4vw5BwqxA/TQuc0h3SNLI/AAAAAAAAE44/OQ_9AZZDnLg/Google%2BBody%2BBrowser.png" alt="" id="BLOGGER_PHOTO_ID_5551703391921648818" border="0" /><br /><br />Google said in an introduction, “Body Browser is a detailed 3D model of the human body”. It is a three-dimensional, multi-layered browser version of those Visible Man/Woman model kits. It lets you peel back anatomical layers, zoom in, and navigate to parts. You can also click to identify anatomy, or search for muscles, organs, bones, and more.<br /><br /><object height="306" width="500"><param name="movie" value="http://www.youtube.com/v/KidJ-2H0nyY?fs=1&hl=en_US&rel=0"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/KidJ-2H0nyY?fs=1&hl=en_US&rel=0" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" height="306" width="500"></embed></object><br /><br /><div class="codeview">Link <a href="http://bodybrowser.googlelabs.com/" target="_blanck">Google Body Browser</a></div>Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0tag:blogger.com,1999:blog-5058912850349927227.post-15235508997930270662010-12-17T21:00:00.006+05:302010-12-24T17:36:12.848+05:30No Of Select Statements In Stored Procedure:-.NETA Stored Procedure with how no of select statements then the SP returns the That many no of tables.<br />In this post i am going to show how to deal with Data returned by Stored procedure in ASP.NET Application<br /><br />The SP is..<br /><div class="codeview"><br />create procedure MultiSelectStm<br />As<br />Begin<br />select * from Emp<br />select * from Dept<br />End<br /></div><br /><br />If you want handle with DataAdapter ..<br /><div class="codeview"><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:usefelayout/> </w:Compatibility> <m:mathpr> <m:mathfont val="Cambria Math"> <m:brkbin val="before"> <m:brkbinsub val="--"> <m:smallfrac val="off"> <m:dispdef/> <m:lmargin val="0"> <m:rmargin val="0"> <m:defjc val="centerGroup"> <m:wrapindent val="1440"> <m:intlim val="subSup"> <m:narylim 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-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]--> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style="color:teal;"> SqlConnection</span> con = <span style="color:blue;">new</span> <span style="color:teal;">SqlConnection</span>(<span style="color:maroon;">@"server=RAJI-PC\SQLEXPRESS;Initial Catalog=raji;integrated Security=True"</span>);</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style=""> </span><span style="color:teal;">SqlCommand</span><span style=""> </span>cmd = <span style="color:blue;">new</span> <span style="color:teal;">SqlCommand</span>(<span style="color:maroon;">"MultiSelectStm"</span>, con);</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>cmd.CommandType = <span style="color:teal;">CommandType</span>.StoredProcedure;</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style=""> </span><span style="color:teal;">SqlDataAdapter</span><span style=""> </span>da = <span style="color:blue;">new</span> <span style="color:teal;">SqlDataAdapter</span>();</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>da.SelectCommand = cmd;</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style="color:teal;">DataSet</span> ds=<span style="color:blue;">new</span> <span style="color:teal;">DataSet</span>();</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>con.Open();</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>da.Fill(ds);</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>con.Close();</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>GridView1.DataSource = ds.Tables[0];</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>GridView1.DataBind();</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>GridView2.DataSource = ds.Tables[1];</span></p> <p class="MsoNormal"><span style="line-height: 115%;font-family:";font-size:10pt;" ><span style=""> </span><span style=""> </span>GridView2.DataBind();</span></p><br /><br /></div><br /><br /><br />If you want handle with DataReader ..<br /><div class="codeview"><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:usefelayout/> </w:Compatibility> <m:mathpr> <m:mathfont val="Cambria Math"> <m:brkbin val="before"> <m:brkbinsub val="--"> <m:smallfrac val="off"> <m:dispdef/> <m:lmargin val="0"> <m:rmargin val="0"> <m:defjc val="centerGroup"> <m:wrapindent val="1440"> <m:intlim val="subSup"> <m:narylim 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-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]--> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;color:teal;" ><span style=""> </span>SqlConnection</span><span style=";font-family:";font-size:10pt;" > con = <span style="color:blue;">new</span> <span style="color:teal;">SqlConnection</span>(<span style="color:maroon;">@"server=RAJI-PC\SQLEXPRESS;Initial Catalog=raji;integrated Security=True"</span>);</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>con.Open();</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style=""> </span><span style="color:teal;">SqlCommand</span> cmd = <span style="color:blue;">new</span> <span style="color:teal;">SqlCommand</span>(<span style="color:maroon;">"MultiSelectStm"</span>, con);</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>cmd.CommandType = <span style="color:teal;">CommandType</span>.StoredProcedure;</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style=""> </span><span style="color:teal;">SqlDataReader</span> dr = cmd.ExecuteReader();</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style="color:blue;">bool</span> more = <span style="color:blue;">true</span>;</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" > </span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style="color:blue;">while</span>(more)</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>{</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style="color:blue;">while</span> (dr.Read())</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>{</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span></span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span><span style="color:blue;">for</span> (<span style="color:blue;">int</span> i = 0; i <dr.FieldCount;i++)</span><!--[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:usefelayout/> </w:Compatibility> <m:mathpr> <m:mathfont val="Cambria Math"> <m:brkbin val="before"> <m:brkbinsub val="--"> <m:smallfrac val="off"> <m:dispdef/> <m:lmargin val="0"> <m:rmargin val="0"> <m:defjc val="centerGroup"> <m:wrapindent val="1440"> <m:intlim val="subSup"> <m:narylim 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-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]--> </p><p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><!--[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:usefelayout/> </w:Compatibility> <m:mathpr> <m:mathfont val="Cambria Math"> <m:brkbin val="before"> <m:brkbinsub val="--"> <m:smallfrac val="off"> <m:dispdef/> <m:lmargin val="0"> <m:rmargin val="0"> <m:defjc val="centerGroup"> <m:wrapindent val="1440"> <m:intlim val="subSup"> <m:narylim 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-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]--> </p><p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>{</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>Response.Write(dr[i].ToString() + <span style="color:maroon;">" "</span>);</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>}</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>Response.Write(<span style="color:maroon;">"<br>"</span>);</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>}</span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span></span></p> <p class="MsoNormal" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:";font-size:10pt;" ><span style=""> </span>more= dr.NextResult();<span style="color:green;">//control goes to next Set of Records<br /></span></span></p> <p class="MsoNormal"><span style="line-height: 115%;font-family:";font-size:10pt;" ><span style=""> </span>}</span></p><br /><br /></div><br /><br />Comments more encourages me to post more Articles..Rajeshhttp://www.blogger.com/profile/15738036492896230626noreply@blogger.com0