tag:blogger.com,1999:blog-56757059525888034972024-03-13T19:21:37.634-07:00ASP.NETvikvishhttp://www.blogger.com/profile/03830351141053224742noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5675705952588803497.post-90037760360167814122016-04-10T06:01:00.000-07:002016-04-10T06:04:07.298-07:00Databound fields in GridView using Ado.net in asp.net C#<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
Hello there, here i m explaining how to use Databound fields
using gridview .</div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
Now first of all we will create a database. Here the following script, copy it and run
it.</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">SET</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">ANSI_NULLS</span> <span style="color: blue;">ON<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">GO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">SET</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">QUOTED_IDENTIFIER</span> <span style="color: blue;">ON<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">GO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">IF</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: grey;">NOT</span> <span style="color: grey;">EXISTS</span> <span style="color: grey;">(</span><span style="color: blue;">SELECT</span> <span style="color: grey;">*</span> <span style="color: blue;">FROM</span> <span style="color: green;">sys.objects</span> <span style="color: blue;">WHERE</span> <span style="color: magenta;">object_id</span> <span style="color: grey;">=</span> <span style="color: magenta;">OBJECT_ID</span><span style="color: grey;">(</span>N<span style="color: red;">'[dbo].[tbEmp]'</span><span style="color: grey;">)</span> <span style="color: grey;">AND</span> <span style="color: blue;">type</span> <span style="color: grey;">in</span> <span style="color: grey;">(</span>N<span style="color: red;">'U'</span><span style="color: grey;">))<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">BEGIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">CREATE</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">TABLE</span> [dbo]<span style="color: grey;">.</span>[tbEmp]<span style="color: grey;">(<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [id] [int] <span style="color: blue;">IDENTITY</span><span style="color: grey;">(</span>1<span style="color: grey;">,</span>1<span style="color: grey;">)</span> <span style="color: grey;">NOT</span> <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [name] [varchar]<span style="color: grey;">(</span>50<span style="color: grey;">)</span> <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [age] [int] <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [address] [varchar]<span style="color: grey;">(</span>50<span style="color: grey;">)</span> <span style="color: grey;">NULL<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">)</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">ON</span> [PRIMARY]<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">END<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-zbflhN4U9JQ/VwpN-SaUWEI/AAAAAAAAAUY/fgAIJQg6j8IuyQIqcSaEjHL168jkhMbYQ/s1600/DB.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="111" src="https://1.bp.blogspot.com/-zbflhN4U9JQ/VwpN-SaUWEI/AAAAAAAAAUY/fgAIJQg6j8IuyQIqcSaEjHL168jkhMbYQ/s320/DB.png" width="320" /></a></div>
<div class="MsoNormal">
<br />
<!--[endif]--></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Place the
GridView control on a form and set the following property.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-indent: -18pt;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="color: red; font-family: "courier new"; font-size: 10.0pt;">AutoGenerateColumns</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">="False"</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">And set
the Gridview <b>Events</b> name is<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="color: red; font-family: "courier new"; font-size: 10.0pt;">onrowcancelingedit</span></b><b><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">="GridView1_RowCancelingEdit"</span></b><b><span style="font-family: "courier new"; font-size: 10.0pt;"> </span></b><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="color: red; font-family: "courier new"; font-size: 10.0pt;">onrowdeleting</span></b><b><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">="GridView1_RowDeleting"</span></b><span style="font-family: "courier new"; font-size: 10.0pt;"> <b><span style="color: red;">onrowediting</span><span style="color: blue;">="GridView1_RowEditing"</span> </b></span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="color: red; font-family: "courier new"; font-size: 10.0pt;">onrowupdating</span></b><b><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">="GridView1_RowUpdating"<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-xrICefROq3o/VwpN5SPjXaI/AAAAAAAAAUU/WDO-7YRPyg4YeYwCfF8FJoxPlZosmQLUQ/s1600/GridViewProperties.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://3.bp.blogspot.com/-xrICefROq3o/VwpN5SPjXaI/AAAAAAAAAUU/WDO-7YRPyg4YeYwCfF8FJoxPlZosmQLUQ/s1600/GridViewProperties.png" /></a></div>
<div class="MsoNormal">
<br />
<!--[endif]--></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Or add the default.aspx page and paste the following source
code in it.<br />
<br />
<br />
<a name='more'></a><br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: yellow; font-family: "courier new"; font-size: 10.0pt;"><%</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">@</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">Page</span> <span style="color: red;">Language</span><span style="color: blue;">="C#"</span>
<span style="color: red;">AutoEventWireup</span><span style="color: blue;">="true"</span> <span style="color: red;">CodeFile</span><span style="color: blue;">="Default.aspx.cs"</span> <span style="color: red;">Inherits</span><span style="color: blue;">="_Default"</span> <span style="background: yellow; mso-highlight: yellow;">%><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><!</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">DOCTYPE</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">html</span> <span style="color: red;">PUBLIC</span>
<span style="color: blue;">"-//W3C//DTD XHTML 1.0 Transitional//EN"</span>
<span style="color: blue;">"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">html</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">xmlns</span><span style="color: blue;">="http://www.w3.org/1999/xhtml"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">head</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">runat</span><span style="color: blue;">="server"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">title</span><span style="color: blue;">></span>Untitled
Page<span style="color: blue;"></</span><span style="color: #a31515;">title</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">style</span> <span style="color: red;">type</span><span style="color: blue;">="text/css"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style1<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">width</span>:
<span style="color: blue;">100%</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">style</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"></</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">head</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">body</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">form</span> <span style="color: red;">id</span><span style="color: blue;">="form1"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">div</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">div</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">table</span> <span style="color: red;">class</span><span style="color: blue;">="style1"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> Name<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txt_name"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span><span style="color: blue;">></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> Age<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txt_age"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span><span style="color: blue;">></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> Address<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txt_address"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span><span style="color: blue;">></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">&nbsp;</span><span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Button</span> <span style="color: red;">ID</span><span style="color: blue;">="Button1"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">onclick</span><span style="color: blue;">="Button1_Click"</span> <span style="color: red;">Text</span><span style="color: blue;">="Button"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">colspan</span><span style="color: blue;">="2"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="lbl_msg"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">ForeColor</span><span style="color: blue;">="Red"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">colspan</span><span style="color: blue;">="2"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">GridView</span> <span style="color: red;">ID</span><span style="color: blue;">="GridView1"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">AutoGenerateColumns</span><span style="color: blue;">="False"</span> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">AutoGenerateDeleteButton</span><span style="color: blue;">="True"</span> <span style="color: red;">AutoGenerateEditButton</span><span style="color: blue;">="True"</span> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">onrowdeleting</span><span style="color: blue;">="GridView1_RowDeleting"</span> <span style="color: red;">onrowediting</span><span style="color: blue;">="GridView1_RowEditing"</span>
<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">onrowcancelingedit</span><span style="color: blue;">="GridView1_RowCancelingEdit"</span> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">onrowupdating</span><span style="color: blue;">="GridView1_RowUpdating"</span> <span style="color: red;">CellPadding</span><span style="color: blue;">="4"</span>
<span style="color: red;">ForeColor</span><span style="color: blue;">="#333333"</span>
<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">GridLines</span><span style="color: blue;">="None"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">RowStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#EFF3FB"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">Columns</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">BoundField</span> <span style="color: red;">DataField</span><span style="color: blue;">="id"</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="Id"</span> <span style="color: red;">ReadOnly</span><span style="color: blue;">="True"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">BoundField</span> <span style="color: red;">DataField</span><span style="color: blue;">="Name"</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="Name"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">BoundField</span> <span style="color: red;">DataField</span><span style="color: blue;">="Age"</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="Age"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">BoundField</span> <span style="color: red;">DataField</span><span style="color: blue;">="address"</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="address"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">Columns</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">FooterStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#507CD1"</span> <span style="color: red;">Font-Bold</span><span style="color: blue;">="True"</span> <span style="color: red;">ForeColor</span><span style="color: blue;">="White"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">PagerStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#2461BF"</span> <span style="color: red;">ForeColor</span><span style="color: blue;">="White"</span> <span style="color: red;">HorizontalAlign</span><span style="color: blue;">="Center"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">SelectedRowStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#D1DDF1"</span> <span style="color: red;">Font-Bold</span><span style="color: blue;">="True"</span> <span style="color: red;">ForeColor</span><span style="color: blue;">="#333333"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">HeaderStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#507CD1"</span> <span style="color: red;">Font-Bold</span><span style="color: blue;">="True"</span> <span style="color: red;">ForeColor</span><span style="color: blue;">="White"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">EditRowStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#2461BF"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">AlternatingRowStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="White"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">GridView</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">table</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">form</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"></</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">body</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"></</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">html</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-QLrlAmifld8/VwpN4HRaLEI/AAAAAAAAAUI/hhbQiUMmQf0c4vI2E3JfsQYcvi5jGERGw/s1600/GridViewDataBoundOutPut.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="125" src="https://4.bp.blogspot.com/-QLrlAmifld8/VwpN4HRaLEI/AAAAAAAAAUI/hhbQiUMmQf0c4vI2E3JfsQYcvi5jGERGw/s320/GridViewDataBoundOutPut.png" width="320" /></a></div>
<div class="MsoNormal">
<br />
<!--[endif]--></div>
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt; line-height: 115%;"><br clear="all" style="mso-special-character: line-break; page-break-before: always;" />
</span>
<br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
In Coding</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;"> System;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Configuration;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Data;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Linq;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.Security;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI.HtmlControls;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI.WebControls;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI.WebControls.WebParts;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Xml.Linq;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Data.SqlClient;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">public</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">partial</span> <span style="color: blue;">class</span> <span style="color: #2b91af;">_Default</span> : System.Web.UI.<span style="color: #2b91af;">Page<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">{<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">SqlConnection</span>
con = <span style="color: blue;">new</span> <span style="color: #2b91af;">SqlConnection</span>();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">SqlDataAdapter</span>
adp;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">SqlCommand</span>
cmd;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">DataTable</span>
dt;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> Page_Load(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.ConnectionString = <span style="color: #2b91af;">ConfigurationManager</span>.ConnectionStrings[<span style="color: #a31515;">"cnn"</span>].ConnectionString;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Open();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(con.State == <span style="color: #2b91af;">ConnectionState</span>.Closed)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { con.Open(); }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Close();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(IsPostBack == <span style="color: blue;">false</span>)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { grdview(); }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">private</span> <span style="color: blue;">void</span> grdview()<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(con.State == <span style="color: #2b91af;">ConnectionState</span>.Closed)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { con.Open(); }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> adp = <span style="color: blue;">new</span>
<span style="color: #2b91af;">SqlDataAdapter</span>(<span style="color: #a31515;">"select
* from tbemp order by id desc"</span>, con);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> dt = <span style="color: blue;">new</span>
<span style="color: #2b91af;">DataTable</span>();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> adp.Fill(dt);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> adp.Dispose();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>(dt.Rows.Count
== 0)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> lbl_msg.Text = <span style="color: #a31515;">"No Record"</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">else<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> lbl_msg.Text = <span style="color: #2b91af;">String</span>.Empty;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> GridView1.DataSource = dt;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> GridView1.DataBind();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> dt.Dispose();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Close();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> Button1_Click(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(con.State == <span style="color: #2b91af;">ConnectionState</span>.Closed)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { con.Open(); }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd = <span style="color: blue;">new</span>
<span style="color: #2b91af;">SqlCommand</span>(<span style="color: #a31515;">"insert
into tbEmp values(@name,@age,@address)"</span>, con);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@name"</span>, txt_name.Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@age"</span>, txt_age.Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@address"</span>, txt_address.Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.ExecuteNonQuery();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Dispose();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Close();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> grdview();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> txt_name.Text = <span style="color: #2b91af;">String</span>.Empty;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> txt_age.Text = <span style="color: #2b91af;">String</span>.Empty;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> txt_address.Text = <span style="color: #2b91af;">String</span>.Empty;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">// Deleting the Record<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> GridView1_RowDeleting(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">GridViewDeleteEventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(con.State == <span style="color: #2b91af;">ConnectionState</span>.Closed)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { con.Open(); }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">Int32</span>
idd = <span style="color: #2b91af;">Convert</span>.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd = <span style="color: blue;">new</span>
<span style="color: #2b91af;">SqlCommand</span>(<span style="color: #a31515;">"delete
from tbemp where id=@id"</span>, con);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@id"</span>, idd);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.ExecuteNonQuery();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Dispose();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Close();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> grdview();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> GridView1_RowCancelingEdit(<span style="color: blue;">object</span> sender, <span style="color: #2b91af;">GridViewCancelEditEventArgs</span>
e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> GridView1.EditIndex = -1;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> grdview();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> GridView1_RowEditing(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">GridViewEditEventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> GridView1.EditIndex = e.NewEditIndex;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> grdview();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> GridView1_RowUpdating(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">GridViewUpdateEventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span> (con.State
== <span style="color: #2b91af;">ConnectionState</span>.Closed)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { con.Open(); }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">Int32</span>
idd = <span style="color: #2b91af;">Convert</span>.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd = <span style="color: blue;">new</span>
<span style="color: #2b91af;">SqlCommand</span>(<span style="color: #a31515;">"update
tbemp set name=@name,age=@age,address=@address where id=@id"</span>, con);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@name"</span>, ((<span style="color: #2b91af;">TextBox</span>)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@age"</span>, ((<span style="color: #2b91af;">TextBox</span>)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@address"</span>, ((<span style="color: #2b91af;">TextBox</span>)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@id"</span>, idd);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.ExecuteNonQuery();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Dispose();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Close();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> GridView1.EditIndex = -1;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> grdview();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">}<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="font-family: "courier new"; font-size: 10.0pt;">EDIT RECORDS<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-Uh7P81XUt0Q/VwpN4cERZ1I/AAAAAAAAAUM/-uHujt_N-kwwve_qmj-4AmyNg-LfXM1hg/s1600/GridViewDataBoundOutPut1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="131" src="https://2.bp.blogspot.com/-Uh7P81XUt0Q/VwpN4cERZ1I/AAAAAAAAAUM/-uHujt_N-kwwve_qmj-4AmyNg-LfXM1hg/s320/GridViewDataBoundOutPut1.png" width="320" /></a></div>
<div class="MsoNormal">
<br />
<!--[endif]--></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>EDITED RECORDS<o:p></o:p></b></div>
<br />
<div class="MsoNormal">
<br />
<!--[endif]--></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-ifJ1qfFlKRE/VwpN5AnIwKI/AAAAAAAAAUQ/HKUEWlpHvXIiynyVOgd3xc45XmGnClijQ/s1600/GridViewDataBoundOutPuttEdit.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="132" src="https://4.bp.blogspot.com/-ifJ1qfFlKRE/VwpN5AnIwKI/AAAAAAAAAUQ/HKUEWlpHvXIiynyVOgd3xc45XmGnClijQ/s320/GridViewDataBoundOutPuttEdit.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
</div>
vikvishhttp://www.blogger.com/profile/03830351141053224742noreply@blogger.com0tag:blogger.com,1999:blog-5675705952588803497.post-68835516474495642532016-04-10T05:48:00.000-07:002016-04-10T06:04:53.394-07:00DataList Paging using ado.net in asp.net C#<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
In this article i am explaining how to do paging in datalist
as we know datalist control does not support paging properties as Gridview
control support. In this article i m displaying two images for paging and
according to your requirement you can change it. First of all create a database following the
script which you can copy and paste it in your sql server 2005.<br />
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">SET</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">ANSI_NULLS</span> <span style="color: blue;">ON<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">GO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">SET</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">QUOTED_IDENTIFIER</span> <span style="color: blue;">ON<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">GO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">IF</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: grey;">NOT</span> <span style="color: grey;">EXISTS</span> <span style="color: grey;">(</span><span style="color: blue;">SELECT</span> <span style="color: grey;">*</span> <span style="color: blue;">FROM</span> <span style="color: green;">sys.objects</span> <span style="color: blue;">WHERE</span> <span style="color: magenta;">object_id</span> <span style="color: grey;">=</span> <span style="color: magenta;">OBJECT_ID</span><span style="color: grey;">(</span>N<span style="color: red;">'[dbo].[tbStudent]'</span><span style="color: grey;">)</span> <span style="color: grey;">AND</span> <span style="color: blue;">type</span> <span style="color: grey;">in</span> <span style="color: grey;">(</span>N<span style="color: red;">'U'</span><span style="color: grey;">))<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">BEGIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">CREATE</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">TABLE</span> [dbo]<span style="color: grey;">.</span>[tbStudent]<span style="color: grey;">(<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [id] [int] <span style="color: blue;">IDENTITY</span><span style="color: grey;">(</span>10<span style="color: grey;">,</span>1<span style="color: grey;">)</span> <span style="color: grey;">NOT</span> <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [name] [varchar]<span style="color: grey;">(</span>50<span style="color: grey;">)</span> <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [age] [int] <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [rollno] [int] <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [address] [varchar]<span style="color: grey;">(</span>50<span style="color: grey;">)</span> <span style="color: grey;">NULL,<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> [image] [varchar]<span style="color: grey;">(</span>50<span style="color: grey;">)</span> <span style="color: grey;">NULL<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">)</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">ON</span> [PRIMARY]<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">END<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><br /></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-PUv4-pYQxeE/VwpK1FZeyoI/AAAAAAAAATs/jBK1Aut30-wl0SzJC8aajG2dE9Qk72z_w/s1600/DB.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="156" src="https://1.bp.blogspot.com/-PUv4-pYQxeE/VwpK1FZeyoI/AAAAAAAAATs/jBK1Aut30-wl0SzJC8aajG2dE9Qk72z_w/s320/DB.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-xuYpRN3MKJk/VwpK2dx37qI/AAAAAAAAAT4/Vp4epue5R0IMqbPM3uI40h9l9xpvMvtaQ/s1600/DatalistPagingImageFolder.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://1.bp.blogspot.com/-xuYpRN3MKJk/VwpK2dx37qI/AAAAAAAAAT4/Vp4epue5R0IMqbPM3uI40h9l9xpvMvtaQ/s1600/DatalistPagingImageFolder.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<a name='more'></a><br /><br />
<div class="MsoNormal">
<v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">
<v:stroke joinstyle="miter">
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0">
<v:f eqn="sum @0 1 0">
<v:f eqn="sum 0 0 @1">
<v:f eqn="prod @2 1 2">
<v:f eqn="prod @3 21600 pixelWidth">
<v:f eqn="prod @3 21600 pixelHeight">
<v:f eqn="sum @0 0 1">
<v:f eqn="prod @6 1 2">
<v:f eqn="prod @7 21600 pixelWidth">
<v:f eqn="sum @8 21600 0">
<v:f eqn="prod @7 21600 pixelHeight">
<v:f eqn="sum @10 21600 0">
</v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
<v:path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f">
<o:lock aspectratio="t" v:ext="edit">
</o:lock></v:path></v:stroke></v:shapetype><v:shape id="Picture_x0020_1" o:spid="_x0000_i1028" style="height: 120.75pt; mso-wrap-style: square; visibility: visible; width: 251.25pt;" type="#_x0000_t75">
<v:imagedata o:title="database_structure" src="file:///C:\Users\Vikvish\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg">
</v:imagedata></v:shape></div>
<div class="MsoNormal">
Now create a folder name pics in your website.</div>
<div class="MsoNormal">
<b><v:shape id="Picture_x0020_5" o:spid="_x0000_i1027" style="height: 207.75pt; mso-wrap-style: square; visibility: visible; width: 181.5pt;" type="#_x0000_t75">
<v:imagedata o:title="pics_folder" src="file:///C:\Users\Vikvish\AppData\Local\Temp\msohtmlclip1\01\clip_image002.jpg">
</v:imagedata></v:shape></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
Few property must be set like </div>
<div class="MsoNormal">
<b>Repeatcolumns =2 or you can change it <o:p></o:p></b></div>
<div class="MsoNormal">
<b><v:shape id="Picture_x0020_3" o:spid="_x0000_i1026" style="height: 142.5pt; mso-wrap-style: square; visibility: visible; width: 450.75pt;" type="#_x0000_t75">
<v:imagedata o:title="repeatColumns" src="file:///C:\Users\Vikvish\AppData\Local\Temp\msohtmlclip1\01\clip_image003.jpg">
</v:imagedata></v:shape><o:p></o:p></b></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-SwKABg1KRFI/VwpK1BV_w3I/AAAAAAAAAT0/KkHw9tRMvLUx_PPkj2wkmveu_hnYaBxhQ/s1600/DataListProperties.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="100" src="https://1.bp.blogspot.com/-SwKABg1KRFI/VwpK1BV_w3I/AAAAAAAAAT0/KkHw9tRMvLUx_PPkj2wkmveu_hnYaBxhQ/s320/DataListProperties.png" width="320" /></a></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
Now add a page name it <b>dtlist.aspx</b>
and paste the souce code in it.</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: yellow; font-family: "courier new"; font-size: 10.0pt;"><%</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">@</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">Page</span> <span style="color: red;">Language</span><span style="color: blue;">="C#"</span>
<span style="color: red;">AutoEventWireup</span><span style="color: blue;">="true"</span> <span style="color: red;">CodeFile</span><span style="color: blue;">="dtlist.aspx.cs"</span> <span style="color: red;">Inherits</span><span style="color: blue;">="_Default"</span> <span style="background: yellow; mso-highlight: yellow;">%><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><!</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">DOCTYPE</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">html</span> <span style="color: red;">PUBLIC</span>
<span style="color: blue;">"-//W3C//DTD XHTML 1.0 Transitional//EN"</span>
<span style="color: blue;">"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">html</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">xmlns</span><span style="color: blue;">="http://www.w3.org/1999/xhtml"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">head</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">runat</span><span style="color: blue;">="server"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">title</span><span style="color: blue;">></span>Untitled
Page<span style="color: blue;"></</span><span style="color: #a31515;">title</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">style</span> <span style="color: red;">type</span><span style="color: blue;">="text/css"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style1<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">width</span>:
<span style="color: blue;">85%</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">height</span>:
<span style="color: blue;">67px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style2<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">width</span>:
<span style="color: blue;">770px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style3<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">width</span>:
<span style="color: blue;">76px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style4<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">width</span>:
<span style="color: blue;">67px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style5<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">width</span>:
<span style="color: blue;">67px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">height</span>:
<span style="color: blue;">21px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style6<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">height</span>:
<span style="color: blue;">21px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #a31515;">.style7<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">width</span>:
<span style="color: blue;">62px</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">style</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"></</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">head</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">body</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">form</span> <span style="color: red;">id</span><span style="color: blue;">="form1"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">div</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">table</span> <span style="color: red;">class</span><span style="color: blue;">="style1"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style2"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">table</span> <span style="color: red;">class</span><span style="color: blue;">="style1"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style7"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> Name<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txt_name"</span>
<span style="color: red;">runat</span><span style="color: blue;">="server"</span>
<span style="color: red;">style</span><span style="color: blue;">="</span><span style="color: red;">margin-bottom</span>: <span style="color: blue;">0px"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style7"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> age<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txt_age"</span>
<span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style7"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> rollno<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txt_rollno"</span>
<span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style7"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> address<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txt_address"</span>
<span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">TextBox</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style7"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> image<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">FileUpload</span> <span style="color: red;">ID</span><span style="color: blue;">="fileupload"</span>
<span style="color: red;">runat</span><span style="color: blue;">="server"</span>
<span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">RegularExpressionValidator</span>
<span style="color: red;">ID</span><span style="color: blue;">="RegularExpressionValidator1"<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">runat</span><span style="color: blue;">="server"<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">ErrorMessage</span><span style="color: blue;">="Invalid File!(only
.gif, .jpg, .jpeg, .wav Files are supported)"<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">ValidationExpression</span><span style="color: blue;">="^.+(.jpg|.JPG|.gif|.GIF|.jpeg|JPEG)$"<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">ControlToValidate</span><span style="color: blue;">="fileupload"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">RegularExpressionValidator</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style7"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">&nbsp;</span><span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Button</span> <span style="color: red;">ID</span><span style="color: blue;">="Button1"</span>
<span style="color: red;">runat</span><span style="color: blue;">="server"</span>
<span style="color: red;">onclick</span><span style="color: blue;">="Button1_Click"</span>
<span style="color: red;">Text</span><span style="color: blue;">="Insert"</span>
<span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">table</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style2"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">&nbsp;</span><span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">&nbsp;</span><span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">DataList</span> <span style="color: red;">ID</span><span style="color: blue;">="DataList1"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">RepeatColumns</span><span style="color: blue;">="2"</span> <span style="color: red;">Width</span><span style="color: blue;">="500px"</span> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">CellPadding</span><span style="color: blue;">="4"</span> <span style="color: red;">ForeColor</span><span style="color: blue;">="#333333"</span>
<span style="color: red;">Height</span><span style="color: blue;">="204px"</span>
<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">ShowFooter</span><span style="color: blue;">="False"</span> <span style="color: red;">ShowHeader</span><span style="color: blue;">="False"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">FooterStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#990000"</span>
<span style="color: red;">Font-Bold</span><span style="color: blue;">="True"</span>
<span style="color: red;">ForeColor</span><span style="color: blue;">="White"</span>
<span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">ItemTemplate</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">table</span> <span style="color: red;">class</span><span style="color: blue;">="style1"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">rowspan</span><span style="color: blue;">="4"</span> <span style="color: red;">class</span><span style="color: blue;">="style3"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">img</span> <span style="color: red;">src</span><span style="color: blue;">='pics/</span><span style="background: yellow; mso-highlight: yellow;"><%</span>#Eval("image")
<span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">style</span><span style="color: blue;">="</span><span style="color: red;">height</span>: <span style="color: blue;">95px</span>; <span style="color: red;">width</span>: <span style="color: blue;">93px"</span> <span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style4"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> name<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="Label1"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span>
<span style="color: red;">Text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span>#
Eval("name") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style4"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> age<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="Label2"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span>#
Eval("age") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">Width</span><span style="color: blue;">="200px"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style5"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> rollno<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style6"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="Label3"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span>
<span style="color: red;">Text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span>#
Eval("rollno") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span> <span style="color: red;">class</span><span style="color: blue;">="style4"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> address<span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="Label4"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span>
<span style="color: red;">Text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span>#
Eval("address") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: red;">Width</span><span style="color: blue;">="250px"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">td</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">tr</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">table</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">ItemTemplate</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">AlternatingItemStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="White"</span>
<span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">ItemStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#FFFBD6"</span>
<span style="color: red;">ForeColor</span><span style="color: blue;">="#333333"</span>
<span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">SelectedItemStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#FFCC66"</span>
<span style="color: red;">Font-Bold</span><span style="color: blue;">="True"</span>
<span style="color: red;">ForeColor</span><span style="color: blue;">="Navy"</span>
<span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">HeaderStyle</span> <span style="color: red;">BackColor</span><span style="color: blue;">="#990000"</span>
<span style="color: red;">Font-Bold</span><span style="color: blue;">="True"</span>
<span style="color: red;">ForeColor</span><span style="color: blue;">="White"</span>
<span style="color: blue;">/><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">DataList</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">table</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">div</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">p</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="btn_prev"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">onclick</span><span style="color: blue;">="btn_prev_Click"></span>Prev<span style="color: blue;"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: red; font-family: "courier new"; font-size: 10.0pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="btn_first"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">onclick</span><span style="color: blue;">="btn_first_Click"></span>First<span style="color: blue;"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: red; font-family: "courier new"; font-size: 10.0pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="btn_nxt"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">onclick</span><span style="color: blue;">="btn_nxt_Click"></span>Next<span style="color: blue;"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: red; font-family: "courier new"; font-size: 10.0pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="btn_last"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">onclick</span><span style="color: blue;">="btn_last_Click"></span>Last<span style="color: blue;"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">LinkButton</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">p</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">p</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: red; font-family: "courier new"; font-size: 10.0pt;">&nbsp;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="lbl_msg"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">Label</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">p</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;"></</span><span style="color: #a31515;">form</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"></</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">body</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"></</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">html</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><v:shape id="Picture_x0020_4" o:spid="_x0000_i1025" style="height: 4in; mso-wrap-style: square; visibility: visible; width: 450.75pt;" type="#_x0000_t75">
<v:imagedata o:title="paginImage1" src="file:///C:\Users\Vikvish\AppData\Local\Temp\msohtmlclip1\01\clip_image004.jpg">
</v:imagedata></v:shape></span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-FWqcNQHddmk/VwpK1RhSGcI/AAAAAAAAATw/RiTFpvuLdJALnxAalFMCnR5TSt25m3-2Q/s1600/DatalistOuptut.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="205" src="https://1.bp.blogspot.com/-FWqcNQHddmk/VwpK1RhSGcI/AAAAAAAAATw/RiTFpvuLdJALnxAalFMCnR5TSt25m3-2Q/s320/DatalistOuptut.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
In Coding</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;"> System;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Configuration;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Data;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Linq;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.Security;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI.HtmlControls;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI.WebControls;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Web.UI.WebControls.WebParts;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Xml.Linq;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;">
System.Data.SqlClient;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">using</span><span style="font-family: "courier new"; font-size: 10.0pt;"> System.IO;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">public</span><span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">partial</span> <span style="color: blue;">class</span> <span style="color: #2b91af;">_Default</span> : System.Web.UI.<span style="color: #2b91af;">Page</span>
<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">{<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">decimal</span>
count; <span style="color: green;">//for count the total records.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">Decimal</span>
last1; <span style="color: green;">// to access the last record<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">String</span>
fn; <span style="color: green;">// for image name<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">String</span>
pth; <span style="color: green;">// for storing the path<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">SqlConnection</span>
con = <span style="color: blue;">new</span> <span style="color: #2b91af;">SqlConnection</span>();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">SqlCommand</span>
cmd;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">PagedDataSource</span>
pageData = <span style="color: blue;">new</span> <span style="color: #2b91af;">PagedDataSource</span>();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> Page_Load(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.ConnectionString = <span style="color: #2b91af;">ConfigurationManager</span>.ConnectionStrings[<span style="color: #a31515;">"cnn"</span>].ConnectionString;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Open();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> doPaging(); <span style="color: green;">//will
call this message and fetch the data from database<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">public</span> <span style="color: #2b91af;">DataTable</span> getTheData()<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">SqlDataAdapter</span>
objSQLAdapter = <span style="color: blue;">new</span> <span style="color: #2b91af;">SqlDataAdapter</span>(<span style="color: #a31515;">"select *from [tbStudent]"</span>, con);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: #2b91af;">DataSet</span>
DS = <span style="color: blue;">new</span> <span style="color: #2b91af;">DataSet</span>();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> objSQLAdapter.Fill(DS);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(DS.Tables[0].Rows.Count == 0)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> lbl_msg.Text = <span style="color: #a31515;">""</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> DataList1.Visible = <span style="color: blue;">false</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">else<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> Session[<span style="color: #a31515;">"cnt"</span>]
= DS.Tables[0].Rows.Count;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">return</span> DS.Tables[0];<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">private</span> <span style="color: blue;">void</span> doPaging()<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: green;">//paging
function<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">try<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> pageData.DataSource =
getTheData().DefaultView; <span style="color: green;">//will call the
getTheData() method<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> pageData.AllowPaging = <span style="color: blue;">true</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> pageData.PageSize = 2;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> count = <span style="color: #2b91af;">Convert</span>.ToInt32(Session[<span style="color: #a31515;">"cnt"</span>]);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> last1 = count / pageData.PageSize;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> last1 = <span style="color: #2b91af;">Convert</span>.ToDecimal(<span style="color: #2b91af;">Math</span>.Ceiling(last1)); <span style="color: green;">//
will convert the 17/4 = 4.5 --> 5 pages<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">try<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> pageData.CurrentPageIndex = <span style="color: #2b91af;">Int32</span>.Parse(Request[<span style="color: #a31515;">"page"</span>].ToString());<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">catch<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> pageData.CurrentPageIndex = 0; <span style="color: green;">// default first 4 images<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> btn_prev.Visible =
(!pageData.IsFirstPage);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> btn_first.Visible =
(!pageData.IsFirstPage);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> btn_nxt.Visible =
(!pageData.IsLastPage);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> btn_last.Visible =
(!pageData.IsLastPage);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> DataList1.DataSource = pageData;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> DataList1.DataBind();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">catch<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> Button1_Click(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(fileupload.PostedFile.ContentLength > 0)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> fn = <span style="color: #2b91af;">Path</span>.GetFileName(fileupload.FileName);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> pth = Server.MapPath(<span style="color: #a31515;">"pics"</span>) + <span style="color: #a31515;">"/"</span>
+ fn; <span style="color: green;">// fn for file image name<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> fileupload.SaveAs(pth); <span style="color: green;">// storing the image in pics folder *Be sure pics folder
must exist there..<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">if</span>
(con.State == <span style="color: #2b91af;">ConnectionState</span>.Closed)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Open();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd = <span style="color: blue;">new</span>
<span style="color: #2b91af;">SqlCommand</span>(<span style="color: #a31515;">"insert
into [tbStudent] values(@name,@age,@rollno,@address,@image)"</span>, con);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@name"</span>, txt_name.Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@age"</span>, txt_age.Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@rollno"</span>, txt_rollno.Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@address"</span>, txt_address.Text);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Parameters.AddWithValue(<span style="color: #a31515;">"@image"</span>, fn);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.ExecuteNonQuery();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> cmd.Dispose();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> con.Close();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> doPaging();<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> btn_prev_Click(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">
Response.Redirect(Request.CurrentExecutionFilePath + <span style="color: #a31515;">"?Page="</span> + (pageData.CurrentPageIndex -
1).ToString());<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> btn_first_Click(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">
Response.Redirect(Request.CurrentExecutionFilePath + <span style="color: #a31515;">"?Page="</span> + (pageData.CurrentPageIndex ==
1).ToString());<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> btn_nxt_Click(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> Response.Redirect(<span style="color: #a31515;">"dtlist.aspx?page="</span> + <span style="color: #2b91af;">Convert</span>.ToInt32(last1 - 1)); <span style="color: green;">// dtlist.aspx to access the last record.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> btn_last_Click(<span style="color: blue;">object</span>
sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> { <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">
Response.Redirect(Request.CurrentExecutionFilePath + <span style="color: #a31515;">"?Page="</span> + (pageData.CurrentPageIndex +
1).ToString());<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 10.0pt;">}<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<br /></div>
vikvishhttp://www.blogger.com/profile/03830351141053224742noreply@blogger.com0tag:blogger.com,1999:blog-5675705952588803497.post-53976351432171580042010-10-08T22:42:00.000-07:002012-07-04T23:51:57.966-07:00How to create Temporary Table in asp.net with compute column in C#<div dir="ltr" style="text-align: left;" trbidi="on">
<m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent> </m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac><br />
<m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent> </m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac><br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Data;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Configuration;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Collections;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Web;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Web.Security;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Web.UI;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Web.UI.WebControls;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Web.UI.WebControls.WebParts;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">using</span><span style="font-family: "Courier New"; font-size: 10pt;"> System.Web.UI.HtmlControls;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">public</span><span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">partial</span> <span style="color: blue;">class</span> <span style="color: #2b91af;">Default3</span> : System.Web.UI.Page</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;">{</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: #2b91af;">Int32</span> tt; <span style="color: green;">// tt for total it will calculate the total</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> DataTable tb = <span style="color: blue;">new</span> DataTable(); <span style="color: green;">//create a instance tb of Datatable</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> Page_Load(<span style="color: blue;">object</span> sender, <span style="color: #2b91af;">EventArgs</span> e)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// here we will create a temporary table of columns under ispostback.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">if</span> (IsPostBack == <span style="color: blue;">false</span>)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">//”ord” is a datatable type which create a “Table” and “c” for datatable columns.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> DataTable ord = <span style="color: blue;">new</span> DataTable(<span style="color: #a31515;">"Table"</span>); <span style="color: green;">//the “Table” value must be same for </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> DataColumn c = <span style="color: blue;">new</span> DataColumn(); <span style="color: green;">// always</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> ord.Columns.Add(<span style="color: blue;">new</span> DataColumn(<span style="color: #a31515;">"value"</span>, <span style="color: #2b91af;">Type</span>.GetType(<span style="color: #a31515;">"System.Int32"</span>)));</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// “value” is a column name with Int32 datatype. </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> ord.Columns.Add(<span style="color: blue;">new</span> DataColumn(<span style="color: #a31515;">"length"</span>, <span style="color: #2b91af;">Type</span>.GetType(<span style="color: #a31515;">"System.Int32"</span>)));</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// “length” is a column name with Int32 datatype. </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> ord.Columns.Add(<span style="color: blue;">new</span> DataColumn(<span style="color: #a31515;">"breadth"</span>, <span style="color: #2b91af;">Type</span>.GetType(<span style="color: #a31515;">"System.Int32"</span>)));</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// “total” is a column name with Int32 datatype. </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> ord.Columns.Add(<span style="color: blue;">new</span> DataColumn(<span style="color: #a31515;">"total"</span>, <span style="color: #2b91af;">Type</span>.GetType(<span style="color: #a31515;">"System.Decimal"</span>)));</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// “total” is a Expression which calculate the following formula</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> ord.Columns[<span style="color: #a31515;">"total"</span>].Expression = <span style="color: #a31515;">"value/(length*breadth)"</span>;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">//storing the structure in “ss” name session.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> Session[<span style="color: #a31515;">"ss"</span>] = ord;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> } </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> btn_submit_Click(<span style="color: blue;">object</span> sender, <span style="color: #2b91af;">EventArgs</span> e)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> grdview();<span style="color: green;">// will call the grdview method</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// following the temporary table with structure</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">private</span> <span style="color: blue;">void</span> tempdata()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tb = (DataTable)(Session[<span style="color: #a31515;">"ss"</span>]); <span style="color: green;">//getting the structure from session and </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> GridView1.DataSource = tb; <span style="color: green;">// storing in “tb” datatable variable and bind with</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> GridView1.DataBind(); <span style="color: green;">// gridview</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: #2b91af;">Int32</span> a; <span style="color: #2b91af;">Int32</span> i; ;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> a = tb.Rows.Count; <span style="color: green;">// it will count the total records in the temporary table</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">for</span> (i = 0; i < a; i++)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tt += <span style="color: #2b91af;">Convert</span>.ToInt32(tb.Rows[i][3]);<span style="color: green;">// will sum the each value</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> Label1.Text = tt.ToString();<span style="color: green;">// display in label the total values</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br />
<a name='more'></a><br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">private</span> <span style="color: blue;">void</span> grdview()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: green;">//retreiving the structure from session and after creating the new row </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// storing the data in rows as index wise. As we know we cannot store Expression column </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="color: green; font-family: "Courier New"; font-size: 10pt;">// in database name is “total” which calculating the formula.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tb = (DataTable)(Session[<span style="color: #a31515;">"ss"</span>]);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> DataRow r1 = tb.NewRow();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> r1[0] = <span style="color: #2b91af;">Convert</span>.ToInt32(txt_value.Text);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> r1[1] = <span style="color: #2b91af;">Convert</span>.ToInt32(txt_length.Text);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> r1[2] = <span style="color: #2b91af;">Convert</span>.ToInt32(txt_breadth.Text);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tb.Rows.Add(r1);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> GridView1.DataSource = tb; <span style="color: green;">//now binding the gridview with data.</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> GridView1.DataBind();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: #2b91af;">Int32</span> a; <span style="color: #2b91af;">Int32</span> i; ;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> a = tb.Rows.Count;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tt = 0;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">for</span> (i = 0; i < a; i++)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;">]);<span style="color: green;">// will sum the each value according to index of the column.</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tt += <span style="color: #2b91af;">Convert</span>.ToInt32(tb.Rows[i][3]);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> Label1.Text = tt.ToString(); <span style="color: green;">//will store the Total amount of the Square feet..</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">protected</span> <span style="color: blue;">void</span> GridView1_RowDeleting(<span style="color: blue;">object</span> sender, GridViewDeleteEventArgs e)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">try</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tb = (DataTable)(Session[<span style="color: #a31515;">"ss"</span>]);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tb.Rows.RemoveAt(e.RowIndex); <span style="color: green;">//deleting the records and decreasing the total</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> tempdata(); <span style="color: green;">//calling the tempdata form refresh the output </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">catch</span> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> { }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<span style="font-family: "Courier New"; font-size: 10pt;">}</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;">
<br />
store the data into database table</div>
*put the below code where u need. <br />
DataTable tb_data = new DataTable();<br />
tb_data = Session(“ss”); //** here u can store ur all records from session to data table.<br />
savedataintotable();<br />
<br />
<br />
private void savedataintotable()<br />
{<br />
SqlDataAdapter adp1 = new SqlDataAdapter(“select * from table”, con); //* columnname must be same <br />
table.<br />
SqlCommandBuilder cb = new SqlCommandBuilder(adp1);<br />
DataSet ds1 = new DataSet();<br />
adp1.Fill(ds1);<br />
try {<br />
adp1.Update(tb_data);<br />
} catch (Exception ex) {<br />
}<br />
try<br />
{<br />
tb_data.AcceptChanges()<br />
}<br />
catch (Exception ex) {<br />
}<br />
}<br />
hope it will help u<br />
<br /><div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/_ubcMUFFwdEs/TLAAxbCTWoI/AAAAAAAAAGI/DXWKWHShD2s/s1600/submitting.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/_ubcMUFFwdEs/TLAAxbCTWoI/AAAAAAAAAGI/DXWKWHShD2s/s320/submitting.JPG" width="294" /></a></div>
<div class="MsoNormal">
<br /></div>
</div>vikvishhttp://www.blogger.com/profile/03830351141053224742noreply@blogger.com3