tag:blogger.com,1999:blog-75988420115165400132024-02-20T17:46:42.281-08:00ASP.NET WondersAnonymoushttp://www.blogger.com/profile/06866409674252038064noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7598842011516540013.post-32446947962405843242014-04-11T22:14:00.001-07:002014-04-11T22:14:37.596-07:003-Tier Architecture in ASP.NET with C#<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="paragraphTitle" style="color: #1452e0; font-family: Verdana; font-size: 13px; font-weight: 700;">Introduction </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">3-Tier architecture generally contains UI or Presentation Layer, Business Access Layer (BAL) or Business Logic Layer and Data Access Layer (DAL). </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;">Presentation Layer (UI)</strong><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Presentation layer cotains pages like .aspx or windows form where data is presented to the user or input is taken from the user. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;">Business Access Layer (BAL) or Business Logic Layer </strong><span style="font-family: Verdana; font-size: 13px;"></span><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">BAL contains business logic, validations or calculations related with the data, if needed. I will call it Business Access Layer in my demo.</span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;">Data Access Layer (DAL)</strong><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">DAL contains methods that helps business layer to connect the data and perform required action, might be returning data or manipulating data (insert, update, delete etc). For this demo application, I have taken a very simple example. I am assuming that I have to play with record of persons (FirstName, LastName, Age) and I will refer only these data through out this article. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span class="paragraphTitle" style="color: #1452e0; font-family: Verdana; font-size: 13px; font-weight: 700;">Designing 3-Tier Architecture </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;"><u>For the ease of understanding, I have created BAL, DAL into the App_Code folder. In real scenario, you should create separate projects for BAL, DAL (as Class Library) and UI (as Web project) and reference your BAL into UI.</u></strong><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><img class="ArticleImage" src="http://www.dotnetfunda.com/UserFiles/ArticlesFiles/633454803717051312_SheoNarayan_solution.GIF" style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;">Data Access Layer</strong><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Lets proceed with desiging 3-Tier architecture. To do that lets proceed with DAL, BAL and then UI. Add a class named by right clicking App_Code folder. (In my case I have a 3-Tier folder inside App_Code folder, you can directly add inside App_Code or you can create a separate project for DAL and add reference of this project into your BAL.) and copy-paste folowing code (Your can overwrite your default written code for the class file by pasting this code).</span><strong style="font-family: Verdana; font-size: 13px;">Here, I have assumed that you will create the respective stored procedure yourself into the database or you may download attachment from <u>http://www.dotnetfunda.com/articles/article18.aspx</u> article and look for App_Data folder for complete database structure and stored procedure for this article.</strong><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span class="paragraphTitle" style="color: #1452e0; font-family: Verdana; font-size: 13px; font-weight: 700;">Data Access Layer (DAL)</span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><i style="font-family: Verdana; font-size: 13px;">Code for Data Access Layer</i><span style="font-family: Verdana; font-size: 13px;"> </span><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Data</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Configuration</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Security</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">WebControls</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">WebControls</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">WebParts</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">HtmlControls</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Data</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">SqlClient</span><span class="pun">;</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Summary description for PersonDAL3</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">class</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">string</span><span class="pln"> connStr </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">ConfigurationManager</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ConnectionStrings</span><span class="pun">[</span><span class="str" style="color: #a31515;">"TutTestConn"</span><span class="pun">].</span><span class="typ" style="color: #2b91af;">ToString</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pun">()</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Used to insert records into database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="firstName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="lastName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="age"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Insert</span><span class="pun">(</span><span class="kwd" style="color: blue;">string</span><span class="pln"> firstName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">string</span><span class="pln"> lastName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> age</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pln"> conn </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pun">(</span><span class="pln">connStr</span><span class="pun">);</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Open</span><span class="pun">();</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlCommand</span><span class="pln"> dCmd </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlCommand</span><span class="pun">(</span><span class="str" style="color: #a31515;">"InsertData"</span><span class="pun">,</span><span class="pln"> conn</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">StoredProcedure</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@firstName"</span><span class="pun">,</span><span class="pln"> firstName</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@lastName"</span><span class="pun">,</span><span class="pln"> lastName</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@age"</span><span class="pun">,</span><span class="pln"> age</span><span class="pun">);</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ExecuteNonQuery</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Close</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Update record into database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="personID"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="firstName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="lastName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="age"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Update</span><span class="pun">(</span><span class="kwd" style="color: blue;">int</span><span class="pln"> personID</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">string</span><span class="pln"> firstName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">string</span><span class="pln"> lastName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> age</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pln"> conn </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pun">(</span><span class="pln">connStr</span><span class="pun">);</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Open</span><span class="pun">();</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlCommand</span><span class="pln"> dCmd </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlCommand</span><span class="pun">(</span><span class="str" style="color: #a31515;">"UpdateData"</span><span class="pun">,</span><span class="pln"> conn</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">StoredProcedure</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@firstName"</span><span class="pun">,</span><span class="pln"> firstName</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@lastName"</span><span class="pun">,</span><span class="pln"> lastName</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@age"</span><span class="pun">,</span><span class="pln"> age</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@personID"</span><span class="pun">,</span><span class="pln"> personID</span><span class="pun">);</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ExecuteNonQuery</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Close</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Load all records from database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">DataTable</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Load</span><span class="pun">()</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pln"> conn </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pun">(</span><span class="pln">connStr</span><span class="pun">);</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlDataAdapter</span><span class="pln"> dAd </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlDataAdapter</span><span class="pun">(</span><span class="str" style="color: #a31515;">"LoadAll"</span><span class="pun">,</span><span class="pln"> conn</span><span class="pun">);</span><span class="pln">
dAd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">SelectCommand</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">StoredProcedure</span><span class="pun">;</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">DataSet</span><span class="pln"> dSet </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">DataSet</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dAd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Fill</span><span class="pun">(</span><span class="pln">dSet</span><span class="pun">,</span><span class="pln"> </span><span class="str" style="color: #a31515;">"PersonTable"</span><span class="pun">);</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> dSet</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Tables</span><span class="pun">[</span><span class="str" style="color: #a31515;">"PersonTable"</span><span class="pun">];</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dSet</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
dAd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Close</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Delete record from database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="personID"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Delete</span><span class="pun">(</span><span class="kwd" style="color: blue;">int</span><span class="pln"> personID</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pln"> conn </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlConnection</span><span class="pun">(</span><span class="pln">connStr</span><span class="pun">);</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Open</span><span class="pun">();</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">SqlCommand</span><span class="pln"> dCmd </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">SqlCommand</span><span class="pun">(</span><span class="str" style="color: #a31515;">"DeleteData"</span><span class="pun">,</span><span class="pln"> conn</span><span class="pun">);</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">CommandType</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">StoredProcedure</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parameters</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">AddWithValue</span><span class="pun">(</span><span class="str" style="color: #a31515;">"@personID"</span><span class="pun">,</span><span class="pln"> personID</span><span class="pun">);</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ExecuteNonQuery</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
dCmd</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Close</span><span class="pun">();</span><span class="pln">
conn</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Dispose</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">In the above code, I have a member variable called connStr that is getting database connection string from my web.config file that is being used through out the class. I have separate method for inserting, deleting, updating records into database and loading records from database. I am not goint into details of how I am connecting database and manipulating the data just to make this tutorials short. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span class="paragraphTitle" style="color: #1452e0; font-family: Verdana; font-size: 13px; font-weight: 700;">Business Access Layer (BAL)</span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Now, create a class named PersonBAL3 into App_Code folder by right clicking it and write respective methods for calling Insert, Delete, Update and Load methods of Data Access Layer class file (PersonDAL3) (In my case I have a 3-Tier folder inside App_Code folder, you can directly add inside App_Code or you can create a separate project for BAL and add reference of this project into your Presentation Layer). As we don't have any business logic here so simply instantiate the PersonDAL3 class of DAL and call methods. Below is the code for BAL (Your can overwrite your default written code for the class file by pasting this code). </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><i style="font-family: Verdana; font-size: 13px;">Code for Business Access Layer </i><span style="font-family: Verdana; font-size: 13px;"></span><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Data</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Configuration</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Security</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">WebControls</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">WebControls</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">WebParts</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">using</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">System</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">HtmlControls</span><span class="pun">;</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Summary description for PersonBAL3</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">class</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pun">()</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// insert records into database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="firstName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="lastName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="age"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Insert</span><span class="pun">(</span><span class="kwd" style="color: blue;">string</span><span class="pln"> firstName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">string</span><span class="pln"> lastName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> age</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pln"> pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> pDAL</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Insert</span><span class="pun">(</span><span class="pln">firstName</span><span class="pun">,</span><span class="pln"> lastName</span><span class="pun">,</span><span class="pln"> age</span><span class="pun">);</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Update records into database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="personID"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="firstName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="lastName"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="age"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Update</span><span class="pun">(</span><span class="kwd" style="color: blue;">int</span><span class="pln"> personID</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">string</span><span class="pln"> firstName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">string</span><span class="pln"> lastName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> age</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pln"> pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> pDAL</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Update</span><span class="pun">(</span><span class="pln">personID</span><span class="pun">,</span><span class="pln"> firstName</span><span class="pun">,</span><span class="pln"> lastName</span><span class="pun">,</span><span class="pln"> age</span><span class="pun">);</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Load records from database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">DataTable</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Load</span><span class="pun">()</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pln"> pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> pDAL</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Load</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="com" style="color: green;">/// <summary></span><span class="pln">
</span><span class="com" style="color: green;">/// Delete record from database</span><span class="pln">
</span><span class="com" style="color: green;">/// </summary></span><span class="pln">
</span><span class="com" style="color: green;">/// <param name="personID"></param></span><span class="pln">
</span><span class="com" style="color: green;">/// <returns></returns></span><span class="pln">
</span><span class="kwd" style="color: blue;">public</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Delete</span><span class="pun">(</span><span class="kwd" style="color: blue;">int</span><span class="pln"> personID</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pln"> pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonDAL3</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> pDAL</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Delete</span><span class="pun">(</span><span class="pln">personID</span><span class="pun">);</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">throw</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pDAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Till now we haev our Business Access Layer and Database Access Layer ready. Now we have to write our Presentation Layer that will use our Business Access Layer methods. Lets create a form that will have three textboxes for FirstName, LastName and Age. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span class="paragraphTitle" style="color: #1452e0; font-family: Verdana; font-size: 13px; font-weight: 700;">Presentation Layer</span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><img class="ArticleImage" src="http://www.dotnetfunda.com/UserFiles/ArticlesFiles/633454803536888144_SheoNarayan_insertdata.GIF" style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Create an Insert.aspx page (make is as Startup page) and copy paste following code to bring the insert form something like displaying in the picture. </span><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;">Code for Insert Record form </strong><span style="font-family: Verdana; font-size: 13px;"></span><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:Label</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"lblMessage"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="pln"> </span><span class="atn" style="color: red;">ForeColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"red"</span><span class="pln"> </span><span class="atn" style="color: red;">EnableViewState</span><span class="pun">=</span><span class="atv" style="color: blue;">"False"</span><span class="tag" style="color: #a31515;">></asp:Label></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><table</span><span class="pln"> </span><span class="atn" style="color: red;">style</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="pln">border</span><span class="pun">:</span><span class="lit" style="color: red;">2px</span><span class="pln"> solid </span><span class="com" style="color: green;">#cccccc;</span><span class="atv" style="color: blue;">"</span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><tr</span><span class="pln"> </span><span class="atn" style="color: red;">style</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="pln">background</span><span class="pun">-</span><span class="pln">color</span><span class="pun">:</span><span class="com" style="color: green;">#507CD1;color:White;</span><span class="atv" style="color: blue;">"</span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><th</span><span class="pln"> </span><span class="atn" style="color: red;">colspan</span><span class="pun">=</span><span class="atv" style="color: blue;">"3"</span><span class="tag" style="color: #a31515;">></span><span class="pln">Add Records</span><span class="tag" style="color: #a31515;"></th></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
First Name:
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:TextBox</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"txtFirstName"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="tag" style="color: #a31515;">></asp:TextBox></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"req1"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="pln"> </span><span class="atn" style="color: red;">Text</span><span class="pun">=</span><span class="atv" style="color: blue;">"*"</span><span class="pln"> </span><span class="atn" style="color: red;">ControlToValidate</span><span class="pun">=</span><span class="atv" style="color: blue;">"txtFirstName"</span><span class="pln">
</span><span class="atn" style="color: red;">Display</span><span class="pun">=</span><span class="atv" style="color: blue;">"dynamic"</span><span class="tag" style="color: #a31515;">></asp:RequiredFieldValidator></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
Last Name:
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:TextBox</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"txtLastName"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="tag" style="color: #a31515;">></asp:TextBox></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"req2"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="pln"> </span><span class="atn" style="color: red;">Text</span><span class="pun">=</span><span class="atv" style="color: blue;">"*"</span><span class="pln"> </span><span class="atn" style="color: red;">ControlToValidate</span><span class="pun">=</span><span class="atv" style="color: blue;">"txtLastName"</span><span class="pln">
</span><span class="atn" style="color: red;">Display</span><span class="pun">=</span><span class="atv" style="color: blue;">"dynamic"</span><span class="tag" style="color: #a31515;">></asp:RequiredFieldValidator></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
Age:
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:TextBox</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"txtAge"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="pln"> </span><span class="atn" style="color: red;">Columns</span><span class="pun">=</span><span class="atv" style="color: blue;">"4"</span><span class="tag" style="color: #a31515;">></asp:TextBox></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"req3"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="pln"> </span><span class="atn" style="color: red;">Text</span><span class="pun">=</span><span class="atv" style="color: blue;">"*"</span><span class="pln"> </span><span class="atn" style="color: red;">ControlToValidate</span><span class="pun">=</span><span class="atv" style="color: blue;">"txtAge"</span><span class="pln">
</span><span class="atn" style="color: red;">Display</span><span class="pun">=</span><span class="atv" style="color: blue;">"dynamic"</span><span class="tag" style="color: #a31515;">></asp:RequiredFieldValidator></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:CompareValidator</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"Comp1"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"Server"</span><span class="pln"> </span><span class="atn" style="color: red;">Text</span><span class="pun">=</span><span class="atv" style="color: blue;">"Only integer"</span><span class="pln"> </span><span class="atn" style="color: red;">ControlToValidate</span><span class="pun">=</span><span class="atv" style="color: blue;">"txtAge"</span><span class="pln">
</span><span class="atn" style="color: red;">Operator</span><span class="pun">=</span><span class="atv" style="color: blue;">"DataTypeCheck"</span><span class="pln"> </span><span class="atn" style="color: red;">Type</span><span class="pun">=</span><span class="atv" style="color: blue;">"Integer"</span><span class="tag" style="color: #a31515;">></asp:CompareValidator></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">&nbsp;</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:Button</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"btnSubmit"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"server"</span><span class="pln"> </span><span class="atn" style="color: red;">Text</span><span class="pun">=</span><span class="atv" style="color: blue;">"Submit"</span><span class="pln"> </span><span class="atn" style="color: red;">OnClick</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="typ" style="color: #2b91af;">AddRecords</span><span class="atv" style="color: blue;">"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></td></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></tr></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></table></span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Now, lets write method that will fire when Submit button will be clicked on the from. </span><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;">Code for AddRecords method</strong><span style="font-family: Verdana; font-size: 13px;"> </span><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="kwd" style="color: blue;">protected</span><span class="pln"> </span><span class="kwd" style="color: blue;">void</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">AddRecords</span><span class="pun">(</span><span class="kwd" style="color: blue;">object</span><span class="pln"> sender</span><span class="pun">,</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">EventArgs</span><span class="pln"> e</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="com" style="color: green;">//Lets validate the page first</span><span class="pln">
</span><span class="kwd" style="color: blue;">if</span><span class="pln"> </span><span class="pun">(!</span><span class="typ" style="color: #2b91af;">Page</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">IsValid</span><span class="pun">)</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">int</span><span class="pln"> intResult </span><span class="pun">=</span><span class="pln"> </span><span class="lit" style="color: red;">0</span><span class="pun">;</span><span class="pln">
</span><span class="com" style="color: green;">// Page is valid, lets go ahead and insert records</span><span class="pln">
</span><span class="com" style="color: green;">// Instantiate BAL object</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pln"> pBAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pun">();</span><span class="pln">
</span><span class="com" style="color: green;">// Instantiate the object we have to deal with</span><span class="pln">
</span><span class="kwd" style="color: blue;">string</span><span class="pln"> firstName </span><span class="pun">=</span><span class="pln"> txtFirstName</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">string</span><span class="pln"> lastName </span><span class="pun">=</span><span class="pln"> txtLastName</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">int</span><span class="pln"> age </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Int32</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parse</span><span class="pun">(</span><span class="pln">txtAge</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pun">);</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
intResult </span><span class="pun">=</span><span class="pln"> pBAL</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Insert</span><span class="pun">(</span><span class="pln">firstName</span><span class="pun">,</span><span class="pln"> lastName</span><span class="pun">,</span><span class="pln"> age</span><span class="pun">);</span><span class="pln">
</span><span class="kwd" style="color: blue;">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">intResult </span><span class="pun">></span><span class="pln"> </span><span class="lit" style="color: red;">0</span><span class="pun">)</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str" style="color: #a31515;">"New record inserted successfully."</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">else</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str" style="color: #a31515;">"FirstName [<b>"</span><span class="pun">+</span><span class="pln"> txtFirstName</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">+</span><span class="str" style="color: #a31515;">"</b>] alredy exists, try another name"</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln"> </span><span class="pun">(</span><span class="typ" style="color: #2b91af;">Exception</span><span class="pln"> ee</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> ee</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Message</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ToString</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pBAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">In the above code, first I am validating the page by using Page.IsValid method just to check if correct data has been entered. Then I have instantiated PersonBAL3 and calling Insert method of it (pBAL.Insert) by passing firstName, lastName, age as parameter. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><strong style="font-family: Verdana; font-size: 13px;">Dispalying Records into GridView</strong><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><img class="ArticleImage" src="http://www.dotnetfunda.com/UserFiles/ArticlesFiles/633454803604859504_SheoNarayan_listdata.GIF" style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;"> </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Create a .aspx file called List.aspx and create a GridView something like displayed into the picture. To list the record into GridView that will also enable us to Edit, Delete record, copy paste following code. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><i style="font-family: Verdana; font-size: 13px;">Code for GridView</i><span style="font-family: Verdana; font-size: 13px;"> </span><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:GridView</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"GridView1"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"server"</span><span class="pln"> </span><span class="atn" style="color: red;">CellPadding</span><span class="pun">=</span><span class="atv" style="color: blue;">"4"</span><span class="pln"> </span><span class="atn" style="color: red;">ForeColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#333333"</span><span class="pln"> </span><span class="atn" style="color: red;">GridLines</span><span class="pun">=</span><span class="atv" style="color: blue;">"None"</span><span class="pln">
</span><span class="atn" style="color: red;">DataKeyNames</span><span class="pun">=</span><span class="atv" style="color: blue;">"PersonID"</span><span class="pln"> </span><span class="atn" style="color: red;">AutoGenerateEditButton</span><span class="pun">=</span><span class="atv" style="color: blue;">"True"</span><span class="pln"> </span><span class="atn" style="color: red;">AutoGenerateColumns</span><span class="pun">=</span><span class="atv" style="color: blue;">"False"</span><span class="pln">
</span><span class="atn" style="color: red;">OnRowEditing</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="typ" style="color: #2b91af;">EditRecord</span><span class="atv" style="color: blue;">"</span><span class="pln"> </span><span class="atn" style="color: red;">OnRowUpdating</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="typ" style="color: #2b91af;">UpdateRecord</span><span class="atv" style="color: blue;">"</span><span class="pln"> </span><span class="atn" style="color: red;">OnRowCancelingEdit</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="typ" style="color: #2b91af;">CancelRecord</span><span class="atv" style="color: blue;">"</span><span class="pln">
</span><span class="atn" style="color: red;">OnRowDeleting</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="typ" style="color: #2b91af;">DeleteRecord</span><span class="atv" style="color: blue;">"</span><span class="pln"> </span><span class="atn" style="color: red;">PageSize</span><span class="pun">=</span><span class="atv" style="color: blue;">"5"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><FooterStyle</span><span class="pln"> </span><span class="atn" style="color: red;">BackColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#507CD1"</span><span class="pln"> </span><span class="atn" style="color: red;">Font-Bold</span><span class="pun">=</span><span class="atv" style="color: blue;">"True"</span><span class="pln"> </span><span class="atn" style="color: red;">ForeColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"White"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><RowStyle</span><span class="pln"> </span><span class="atn" style="color: red;">BackColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#EFF3FB"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><EditRowStyle</span><span class="pln"> </span><span class="atn" style="color: red;">BackColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#2ff1BF"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><SelectedRowStyle</span><span class="pln"> </span><span class="atn" style="color: red;">BackColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#D1DDF1"</span><span class="pln"> </span><span class="atn" style="color: red;">Font-Bold</span><span class="pun">=</span><span class="atv" style="color: blue;">"True"</span><span class="pln"> </span><span class="atn" style="color: red;">ForeColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#333333"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><PagerStyle</span><span class="pln"> </span><span class="atn" style="color: red;">BackColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#2461BF"</span><span class="pln"> </span><span class="atn" style="color: red;">ForeColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"White"</span><span class="pln"> </span><span class="atn" style="color: red;">HorizontalAlign</span><span class="pun">=</span><span class="atv" style="color: blue;">"Center"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><HeaderStyle</span><span class="pln"> </span><span class="atn" style="color: red;">BackColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"#507CD1"</span><span class="pln"> </span><span class="atn" style="color: red;">Font-Bold</span><span class="pun">=</span><span class="atv" style="color: blue;">"True"</span><span class="pln"> </span><span class="atn" style="color: red;">ForeColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"White"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><AlternatingRowStyle</span><span class="pln"> </span><span class="atn" style="color: red;">BackColor</span><span class="pun">=</span><span class="atv" style="color: blue;">"White"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><Columns></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:BoundField</span><span class="pln"> </span><span class="atn" style="color: red;">DataField</span><span class="pun">=</span><span class="atv" style="color: blue;">"PersonID"</span><span class="pln"> </span><span class="atn" style="color: red;">HeaderText</span><span class="pun">=</span><span class="atv" style="color: blue;">"Person ID"</span><span class="pln"> </span><span class="atn" style="color: red;">ReadOnly</span><span class="pun">=</span><span class="atv" style="color: blue;">"True"</span><span class="pln"> </span><span class="atn" style="color: red;">SortExpression</span><span class="pun">=</span><span class="atv" style="color: blue;">"PersonID"</span><span class="pln"> </span><span class="tag" style="color: #a31515;">/></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:TemplateField</span><span class="pln"> </span><span class="atn" style="color: red;">HeaderText</span><span class="pun">=</span><span class="atv" style="color: blue;">"First Name"</span><span class="pln"> </span><span class="atn" style="color: red;">SortExpression</span><span class="pun">=</span><span class="atv" style="color: blue;">"FirstName"</span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><ItemTemplate></span><span class="pln">
</span><span class="pun"><%</span><span class="com" style="color: green;"># Eval("FirstName") </span><span class="pln">%>
</span><span class="tag" style="color: #a31515;"></ItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><EditItemTemplate></span><span class="pln">
<asp:TextBox ID="txtFName" runat="Server" Text='</span><span class="pun"><%</span><span class="com" style="color: green;"># Eval("FirstName") </span><span class="pln">%>'></span><span class="tag" style="color: #a31515;"></asp:TextBox></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></EditItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></asp:TemplateField></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:TemplateField</span><span class="pln"> </span><span class="atn" style="color: red;">HeaderText</span><span class="pun">=</span><span class="atv" style="color: blue;">"Last Name"</span><span class="pln"> </span><span class="atn" style="color: red;">SortExpression</span><span class="pun">=</span><span class="atv" style="color: blue;">"LastName"</span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><ItemTemplate></span><span class="pln">
</span><span class="pun"><%</span><span class="com" style="color: green;"># Eval("LastName") </span><span class="pln">%>
</span><span class="tag" style="color: #a31515;"></ItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><EditItemTemplate></span><span class="pln">
<asp:TextBox ID="txtLName" runat="Server" Text='</span><span class="pun"><%</span><span class="com" style="color: green;"># Eval("LastName") </span><span class="pln">%>'></span><span class="tag" style="color: #a31515;"></asp:TextBox></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></EditItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></asp:TemplateField></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:TemplateField</span><span class="pln"> </span><span class="atn" style="color: red;">HeaderText</span><span class="pun">=</span><span class="atv" style="color: blue;">"Age"</span><span class="pln"> </span><span class="atn" style="color: red;">SortExpression</span><span class="pun">=</span><span class="atv" style="color: blue;">"Age"</span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><ItemTemplate></span><span class="pln">
</span><span class="pun"><%</span><span class="com" style="color: green;"># Eval("Age") </span><span class="pln">%>
</span><span class="tag" style="color: #a31515;"></ItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><EditItemTemplate></span><span class="pln">
<asp:TextBox ID="txtAge" runat="Server" Text='</span><span class="pun"><%</span><span class="com" style="color: green;"># Eval("Age") </span><span class="pln">%>'></span><span class="tag" style="color: #a31515;"></asp:TextBox></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></EditItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></asp:TemplateField></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:TemplateField</span><span class="pln"> </span><span class="atn" style="color: red;">HeaderText</span><span class="pun">=</span><span class="atv" style="color: blue;">"Delete?"</span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><ItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><span</span><span class="pln"> </span><span class="atn" style="color: red;">onclick</span><span class="pun">=</span><span class="atv" style="color: blue;">"</span><span class="kwd" style="color: blue;">return</span><span class="pln"> confirm</span><span class="pun">(</span><span class="str" style="color: #a31515;">'Are you sure to Delete?'</span><span class="pun">)</span><span class="atv" style="color: blue;">"</span><span class="tag" style="color: #a31515;">></span><span class="pln">
</span><span class="tag" style="color: #a31515;"><asp:LinkButton</span><span class="pln"> </span><span class="atn" style="color: red;">ID</span><span class="pun">=</span><span class="atv" style="color: blue;">"lnBD"</span><span class="pln"> </span><span class="atn" style="color: red;">runat</span><span class="pun">=</span><span class="atv" style="color: blue;">"server"</span><span class="pln"> </span><span class="atn" style="color: red;">Text</span><span class="pun">=</span><span class="atv" style="color: blue;">"Delete"</span><span class="pln"> </span><span class="atn" style="color: red;">CommandName</span><span class="pun">=</span><span class="atv" style="color: blue;">"Delete"</span><span class="tag" style="color: #a31515;">></asp:LinkButton></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></span></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></ItemTemplate></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></asp:TemplateField></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></Columns></span><span class="pln">
</span><span class="tag" style="color: #a31515;"></asp:GridView></span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><i style="font-family: Verdana; font-size: 13px;">Code to Load records and Displaying Records into GridView</i><span style="font-family: Verdana; font-size: 13px;"> </span><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="kwd" style="color: blue;">private</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">DataTable</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">BindGrid</span><span class="pun">()</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pln"> p </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">DataTable</span><span class="pln"> dTable </span><span class="pun">=</span><span class="pln"> p</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Load</span><span class="pun">();</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">GridView1</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">DataSource</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> dTable</span><span class="pun">;</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">GridView1</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">DataBind</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln"> </span><span class="pun">(</span><span class="typ" style="color: #2b91af;">Exception</span><span class="pln"> ee</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> ee</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Message</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ToString</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
p </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">return</span><span class="pln"> dTable</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">In the above method I am instantiating PersonBAL3 class and calling Load method to get the record into DataTable and binding it into GridView. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><i style="font-family: Verdana; font-size: 13px;">Code to Delete Records </i><span style="font-family: Verdana; font-size: 13px;"></span><br style="font-family: Verdana; font-size: 13px;" /><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="kwd" style="color: blue;">protected</span><span class="pln"> </span><span class="kwd" style="color: blue;">void</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">DeleteRecord</span><span class="pun">(</span><span class="kwd" style="color: blue;">object</span><span class="pln"> sender</span><span class="pun">,</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">GridViewDeleteEventArgs</span><span class="pln"> e</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">int</span><span class="pln"> personID </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Int32</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parse</span><span class="pun">(</span><span class="typ" style="color: #2b91af;">GridView1</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">DataKeys</span><span class="pun">[</span><span class="pln">e</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">RowIndex</span><span class="pun">].</span><span class="typ" style="color: #2b91af;">Value</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ToString</span><span class="pun">());</span><span class="pln">
</span><span class="com" style="color: green;">// instantiate BAL</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pln"> pBAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pBAL</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Delete</span><span class="pun">(</span><span class="pln">personID</span><span class="pun">);</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str" style="color: #a31515;">"Record Deleted Successfully."</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln"> </span><span class="pun">(</span><span class="typ" style="color: #2b91af;">Exception</span><span class="pln"> ee</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> ee</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Message</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ToString</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pBAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">GridView1</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">EditIndex</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="pun">-</span><span class="lit" style="color: red;">1</span><span class="pun">;</span><span class="pln">
</span><span class="com" style="color: green;">// Refresh the list</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">BindGrid</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Above method will fire when Delete link will be clicked on the GridView. In the above code, I am instantiating PersonBAL3 and calling Delete method by passing personID as parameter so that select reocrds will be deleted from datbase. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><i style="font-family: Verdana; font-size: 13px;">Code to Update records </i><span style="font-family: Verdana; font-size: 13px;"></span><br style="font-family: Verdana; font-size: 13px;" /><br />
<pre class="prettyprint" style="background-color: white; background-image: url(http://www.dotnetfunda.com/images/codeBlockBack.gif); background-repeat: no-repeat repeat; border: 1px dashed rgb(204, 204, 204); font-family: Consolas, monospace; font-size: 13px; margin-bottom: 30px; margin-top: 18px; overflow: auto; padding: 5px; width: 650px; word-wrap: break-word;"><span class="pln">
</span><span class="kwd" style="color: blue;">protected</span><span class="pln"> </span><span class="kwd" style="color: blue;">void</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">UpdateRecord</span><span class="pun">(</span><span class="kwd" style="color: blue;">object</span><span class="pln"> sender</span><span class="pun">,</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">GridViewUpdateEventArgs</span><span class="pln"> e</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
</span><span class="kwd" style="color: blue;">int</span><span class="pln"> personID </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">Int32</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parse</span><span class="pun">(</span><span class="typ" style="color: #2b91af;">GridView1</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">DataKeys</span><span class="pun">[</span><span class="pln">e</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">RowIndex</span><span class="pun">].</span><span class="typ" style="color: #2b91af;">Value</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ToString</span><span class="pun">());</span><span class="pln">
</span><span class="kwd" style="color: blue;">int</span><span class="pln"> intResult </span><span class="pun">=</span><span class="pln"> </span><span class="lit" style="color: red;">0</span><span class="pun">;</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">GridViewRow</span><span class="pln"> row </span><span class="pun">=</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">GridView1</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Rows</span><span class="pun">[</span><span class="pln">e</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">RowIndex</span><span class="pun">];</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">TextBox</span><span class="pln"> tFN </span><span class="pun">=</span><span class="pln"> </span><span class="pun">(</span><span class="typ" style="color: #2b91af;">TextBox</span><span class="pun">)</span><span class="pln"> row</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">FindControl</span><span class="pun">(</span><span class="str" style="color: #a31515;">"txtFName"</span><span class="pun">);</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">TextBox</span><span class="pln"> tLN </span><span class="pun">=</span><span class="pln"> </span><span class="pun">(</span><span class="typ" style="color: #2b91af;">TextBox</span><span class="pun">)</span><span class="pln">row</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">FindControl</span><span class="pun">(</span><span class="str" style="color: #a31515;">"txtLName"</span><span class="pun">);</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">TextBox</span><span class="pln"> tAge </span><span class="pun">=</span><span class="pln"> </span><span class="pun">(</span><span class="typ" style="color: #2b91af;">TextBox</span><span class="pun">)</span><span class="pln">row</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">FindControl</span><span class="pun">(</span><span class="str" style="color: #a31515;">"txtAge"</span><span class="pun">);</span><span class="pln">
</span><span class="com" style="color: green;">// instantiate BAL</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pln"> pBAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">new</span><span class="pln"> </span><span class="typ" style="color: #2b91af;">PersonBAL3</span><span class="pun">();</span><span class="pln">
</span><span class="kwd" style="color: blue;">try</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
intResult </span><span class="pun">=</span><span class="pln"> pBAL</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Update</span><span class="pun">(</span><span class="pln">personID</span><span class="pun">,</span><span class="pln"> tFN</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pun">,</span><span class="pln"> tLN</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pun">,</span><span class="pln"> </span><span class="kwd" style="color: blue;">int</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Parse</span><span class="pun">(</span><span class="pln">tAge</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pun">));</span><span class="pln">
</span><span class="kwd" style="color: blue;">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">intResult </span><span class="pun">></span><span class="pln"> </span><span class="lit" style="color: red;">0</span><span class="pun">)</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str" style="color: #a31515;">"Record Updated Successfully."</span><span class="pun">;</span><span class="pln">
</span><span class="kwd" style="color: blue;">else</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str" style="color: #a31515;">"Record couldn't updated"</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="kwd" style="color: blue;">catch</span><span class="pln"> </span><span class="pun">(</span><span class="typ" style="color: #2b91af;">Exception</span><span class="pln"> ee</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
lblMessage</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> ee</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">Message</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">ToString</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln"> </span><span class="kwd" style="color: blue;">finally</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
pBAL </span><span class="pun">=</span><span class="pln"> </span><span class="kwd" style="color: blue;">null</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">GridView1</span><span class="pun">.</span><span class="typ" style="color: #2b91af;">EditIndex</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="pun">-</span><span class="lit" style="color: red;">1</span><span class="pun">;</span><span class="pln">
</span><span class="com" style="color: green;">// Refresh the list</span><span class="pln">
</span><span class="typ" style="color: #2b91af;">BindGrid</span><span class="pun">();</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span></pre>
<br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Above method will fire when Update link will be clicked for a particular row of the GridView in edit mode. In the above method, I am instantiating PersonBAL3 and calling the Update method by p[assing required parameters. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Now we have all set to go, now just run your project and try inserting records. You can also navigate to another page your created (list.aspx) and try updating, deleting records. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span class="paragraphTitle" style="color: #1452e0; font-family: Verdana; font-size: 13px; font-weight: 700;">Conclusion </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">By using 3-Tier architecture in your project you can achive </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">1. Seperation - the functionality is seperated from the data access and presentation so that it is more maintainable </span><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">2. Independence - layers are established so that if one is modified (to some extent) it will not affect other layers. </span><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">3. Reusability - As the layers are seperated, it can exist as a module that can be reused by other application by referencing it. </span><br style="font-family: Verdana; font-size: 13px;" /><br style="font-family: Verdana; font-size: 13px;" /><span style="font-family: Verdana; font-size: 13px;">Hope this article helped you understanding 3-Tier architecture and desiging it. </span><br />
<span style="font-family: Verdana; font-size: 13px;"><br /></span>
<span style="font-family: Verdana; font-size: 13px;"><br /></span>
<span style="font-family: Verdana; font-size: 13px;"><br /></span>
<span style="font-family: Verdana; font-size: 13px;">Source : </span><span style="font-family: Verdana; font-size: x-small;">http://www.dotnetfunda.com/articles/show/71/3-tier-architecture-in-aspnet-with-csharp</span></div>
Anonymoushttp://www.blogger.com/profile/06866409674252038064noreply@blogger.com0tag:blogger.com,1999:blog-7598842011516540013.post-48407143666661932212014-04-11T22:12:00.000-07:002014-04-11T22:12:43.246-07:00Asp.net watermark text for textbox in javascript<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">html</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">xmlns</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="http://www.w3.org/1999/xhtml"></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">head</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">runat</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="server"></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">title</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Watermark Textbox Using JavaScript<span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">title</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">script</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">language</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="javascript"</span> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">type</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="text/javascript"></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">function</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> WaterMark(txtName, event) {</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">var</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> defaultText = <span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">"Enter Username Here"</span>;</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: green; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">// Condition to check textbox length and event type</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">if</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> (txtName.value.length == 0 & event.type == <span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">"blur"</span>) {</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: green; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">//if condition true then setting text color and default text in textbox</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">txtName.style.color = <span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">"Gray"</span>;</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">txtName.value = defaultText;</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">}</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: green; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">// Condition to check textbox value and event type</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">if</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> (txtName.value == defaultText & event.type == <span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">"focus"</span>) {</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">txtName.style.color = <span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">"black"</span>;</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">txtName.value = <span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">""</span>;</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">}</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">}</span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">script</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">head</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">body</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">form</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">id</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="form1"</span> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">runat</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="server"></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">div</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">b</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">UserName:<span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">b</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">asp</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">TextBox</span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="txtUserName"</span> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">runat</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="server"</span> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Text</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="Enter Username Here"</span> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">ForeColor</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">="Gray"</span> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">onblur</span> <span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">"WaterMark(this, event);"</span> <span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">onfocus</span> <span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">=</span> <span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">"WaterMark(this, event);"</span> <span style="border: 0px; color: blue; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">div</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">form</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">body</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></</span><span style="border: 0px; color: #a31515; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">html</span><span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-size: xx-small;"><br /></span></span></div>
<div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; color: blue; font-family: Verdana, sans-serif; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-size: xx-small;">Source : http://www.aspdotnet-suresh.com/2011/10/how-to-create-watermark-textbox-using.html</span></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/06866409674252038064noreply@blogger.com0tag:blogger.com,1999:blog-7598842011516540013.post-24946475863146605792014-04-11T21:27:00.002-07:002014-04-11T21:29:56.618-07:00Using grid view in tab container of ajax in Asp.net<div dir="ltr" style="text-align: left;" trbidi="on">
<pre class="prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(225, 226, 226); color: #222222; font-family: Consolas, monospace; font-size: 13px; line-height: 18.211200714111328px; margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><asp:TabContainer</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"TabPanel"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"server"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Width</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"400px"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Height</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"200px"</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><asp:TabPanel</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"pane1"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"server"</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><HeaderTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
Tab 1
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></HeaderTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><ContentTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><asp:GridView</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"GridView1"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"server"</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></asp:GridView></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></ContentTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></asp:TabPanel></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><asp:TabPanel</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"pane2"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"server"</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><HeaderTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
Tab 2
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></HeaderTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><ContentTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><asp:GridView</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"GridView2"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"server"</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></asp:GridView></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></ContentTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></asp:TabPanel></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><asp:TabPanel</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"pane3"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"server"</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><HeaderTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
Tab 3
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></HeaderTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><ContentTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><asp:GridView</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"GridView3"</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"server"</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></asp:GridView></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></ContentTemplate></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></asp:TabPanel></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></asp:TabContainer></span></pre>
<pre class="prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(225, 226, 226); color: #222222; font-family: Consolas, monospace; font-size: 13px; line-height: 18.211200714111328px; margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">public</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">partial</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">class</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">_Default</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Web</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">UI</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Page</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlConnection</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> sqlcon </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlConnection</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ConfigurationManager</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ConnectionStrings</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">[</span><span class="str" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"Test"</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">].</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ConnectionString</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlCommand</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> sqlcom</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlDataAdapter</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> sqladp</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataTable</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">protected</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">void</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Page_Load</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">object</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> sender</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">EventArgs</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> e</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">if</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(!</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">IsPostBack</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BindGrid1</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BindGrid2</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BindGrid3</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">void</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BindGrid1</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">()</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">using</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sqlcom </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlCommand</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"SELECT * FROM [DBO].[NAME]"</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sqlcon</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">))</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
sqladp </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlDataAdapter</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sqlcom</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
dt </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataTable</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
sqladp</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Fill</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">if</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Rows</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Count</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">0</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">GridView1</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataSource</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">GridView1</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataBind</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">else</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Response</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Write</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"Data Not Found"</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">void</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BindGrid2</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">()</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">using</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sqlcom </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlCommand</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"SELECT * FROM [DBO].[NAME2]"</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> sqlcon</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">))</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
sqladp </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlDataAdapter</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sqlcom</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
dt </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataTable</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
sqladp</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Fill</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">if</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Rows</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Count</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">0</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">GridView2</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataSource</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">GridView2</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataBind</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">else</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Response</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Write</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"Data Not Found"</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">void</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">BindGrid3</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">()</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">using</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sqlcom </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlCommand</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"SELECT * FROM [DBO].[NAME3]"</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> sqlcon</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">))</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
sqladp </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SqlDataAdapter</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sqlcom</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
dt </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">new</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataTable</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
sqladp</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Fill</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">if</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Rows</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Count</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="background-color: transparent; border: 0px; color: red; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">0</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">GridView3</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataSource</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> dt</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">GridView3</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">DataBind</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="background-color: transparent; border: 0px; color: blue; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">else</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Response</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="background-color: transparent; border: 0px; color: #2b91af; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Write</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="background-color: transparent; border: 0px; color: #a31515; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">"Data Not Found"</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</span></pre>
<pre class="prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(225, 226, 226); color: #222222; font-family: Consolas, monospace; font-size: 13px; line-height: 18.211200714111328px; margin-bottom: 30px; margin-top: 18px; outline: 0px; overflow: auto; padding: 5px; vertical-align: baseline;"><span class="pun" style="background-color: transparent; border: 0px; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Source : http://forums.asp.net/t/1779331.aspx?Using+grid+view+in+tab+container+of+ajax+in+Asp+net</span></pre>
</div>
Anonymoushttp://www.blogger.com/profile/06866409674252038064noreply@blogger.com0