Update database table data using .NET using the form and database stored procedure

Rumman Ansari   2019-03-04   Student   MS dot NET > update-from-database-using-dot-net   1097 Share

File Name: ViewCabDetails.aspx

This code is important CommandName="EditEmployee" 

<span class="pln">

</span><span class="tag">&lt;asp:TemplateField</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"Edit Detalis"</span><span class="tag">&gt;</span><span class="pln">
                </span><span class="tag">&lt;ItemTemplate</span><span class="pln"> </span><span class="tag">&gt;</span><span class="pln">
                    &lt;asp:LinkButton ID="LinkButton1" CommandArgument='</span><span class="pun">&lt;%</span><span class="com"># Eval("BookingReferenceNumber1") </span><span class="pln">%&gt;' runat="server" CommandName="EditEmployee"&gt;Edit</span><span class="tag">&lt;/asp:LinkButton&gt;</span><span class="pln">
                </span><span class="tag">&lt;/ItemTemplate&gt;</span><span class="pln">
            </span><span class="tag">&lt;/asp:TemplateField&gt;</span><span class="pln">

</span>

File Name: ViewCabDetails.aspx 

<span class="pln">


</span><span class="tag">&lt;div</span><span class="pln"> </span><span class="atn">id</span><span class="pun">=</span><span class="atv">"divEdit"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;</span><span class="pln">
</span><span class="tag">&lt;h1&gt;</span><span class="pln">Edit Information</span><span class="tag">&lt;/h1&gt;</span><span class="pln">
    </span><span class="tag">&lt;table</span><span class="pln">  </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"table table-hover table-bordered"</span><span class="tag">&gt;</span><span class="pln">
        </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln">Booking Id </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> </span><span class="tag">&lt;asp:TextBox</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"bookRefNo"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;&lt;/asp:TextBox&gt;</span><span class="pln"> </span><span class="tag">&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">
    </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln">Passenger Name </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> </span><span class="tag">&lt;asp:TextBox</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"PassengerName11"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;&lt;/asp:TextBox&gt;</span><span class="pln">         
        </span><span class="tag">&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">
     </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> From Location </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln">  </span><span class="tag">&lt;asp:DropDownList</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"FromLocation"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;</span><span class="pln">
                   </span><span class="tag">&lt;asp:ListItem</span><span class="pln"> </span><span class="atn">Selected</span><span class="pun">=</span><span class="atv">"True"</span><span class="pln"> </span><span class="atn">Value</span><span class="pun">=</span><span class="atv">""</span><span class="tag">&gt;</span><span class="pln">Please Select</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Thiruvananthapuram</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kochi</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kozhikode</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kollam</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Thrissur</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kannur</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Alappuzha</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
            </span><span class="tag">&lt;/asp:DropDownList&gt;&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">
     </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> To Location </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> </span><span class="tag">&lt;asp:DropDownList</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"ToLocation"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;</span><span class="pln">
               </span><span class="tag">&lt;asp:ListItem</span><span class="pln"> </span><span class="atn">Selected</span><span class="pun">=</span><span class="atv">"True"</span><span class="pln"> </span><span class="atn">Value</span><span class="pun">=</span><span class="atv">""</span><span class="tag">&gt;</span><span class="pln">Please Select</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Thiruvananthapuram</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kochi</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kozhikode</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kollam</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Thrissur</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Kannur</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                    </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Alappuzha</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
            </span><span class="tag">&lt;/asp:DropDownList&gt;</span><span class="pln"> </span><span class="tag">&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">
    </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> Departure Time </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> </span><span class="tag">&lt;asp:TextBox</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"DepartureTime"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;&lt;/asp:TextBox&gt;&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">
        </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> Distance in Km </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln">
            </span><span class="tag">&lt;asp:TextBox</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"DistanceinKm"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;&lt;/asp:TextBox&gt;</span><span class="pln"> </span><span class="tag">&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">
    </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> Estimated Amount </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> </span><span class="tag">&lt;asp:TextBox</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"EstimatedAmountText"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">&gt;&lt;/asp:TextBox&gt;</span><span class="pln"> </span><span class="tag">&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">
      </span><span class="tag">&lt;tr&gt;</span><span class="pln"> 
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> Cab Type </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;td&gt;</span><span class="pln"> </span><span class="tag">&lt;asp:RadioButtonList</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"CabType1"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="pln"> </span><span class="tag">&gt;</span><span class="pln">
                </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Indigo</span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
                </span><span class="tag">&lt;asp:ListItem&gt;</span><span class="pln">Innova </span><span class="tag">&lt;/asp:ListItem&gt;</span><span class="pln">
            </span><span class="tag">&lt;/asp:RadioButtonList&gt;&lt;/td&gt;</span><span class="pln">
    </span><span class="tag">&lt;/tr&gt;</span><span class="pln">

        </span><span class="tag">&lt;tr&gt;</span><span class="pln">
         </span><span class="tag">&lt;td</span><span class="pln"> </span><span class="atn">colspan</span><span class="pun">=</span><span class="atv">"2"</span><span class="tag">&gt;</span><span class="pln">  
                </span><span class="tag">&lt;asp:Button</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Button1Edit"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="pln"> </span><span class="atn">Text</span><span class="pun">=</span><span class="atv">"Button"</span><span class="pln"> </span><span class="atn">CssClass</span><span class="pun">=</span><span class="atv">"button button-info"</span><span class="pln"> </span><span class="atn">OnClick</span><span class="pun">=</span><span class="atv">"</span><span class="typ">Button1Edit_Click</span><span class="atv">"</span><span class="tag">/&gt;</span><span class="pln"> </span><span class="tag">&lt;/td&gt;</span><span class="pln">
        </span><span class="tag">&lt;/tr&gt;</span><span class="pln">

    </span><span class="tag">&lt;/table&gt;</span><span class="pln">
     </span><span class="tag">&lt;/div&gt;</span><span class="pln">

</span>

File Name: ViewCabDetails.aspx.cs

RowCommand event from ViewCabDetails.aspx page

<span class="pln">
  </span><span class="kwd">protected</span><span class="pln"> </span><span class="kwd">void</span><span class="pln"> </span><span class="typ">GridView1Awesome_RowCommand</span><span class="pun">(</span><span class="kwd">object</span><span class="pln"> sender</span><span class="pun">,</span><span class="pln"> </span><span class="typ">GridViewCommandEventArgs</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">int</span><span class="pln"> </span><span class="typ">BookingReferenceNumberTemp</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Convert</span><span class="pun">.</span><span class="typ">ToInt32</span><span class="pun">(</span><span class="pln">e</span><span class="pun">.</span><span class="typ">CommandArgument</span><span class="pun">);</span><span class="pln">

            </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">e</span><span class="pun">.</span><span class="typ">CommandName</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> </span><span class="str">"DeleteEmployee"</span><span class="pun">)</span><span class="pln">
            </span><span class="pun">{</span><span class="pln">                      
                bindControlsDelete</span><span class="pun">(</span><span class="typ">BookingReferenceNumberTemp</span><span class="pun">);</span><span class="pln">  </span><span class="com">// this code is for delete</span><span class="pln">
            </span><span class="pun">}</span><span class="pln">
            </span><span class="kwd">else</span><span class="pln"> </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">e</span><span class="pun">.</span><span class="typ">CommandName</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> </span><span class="str">"EditEmployee"</span><span class="pun">)</span><span class="pln">
            </span><span class="pun">{</span><span class="pln">
                bindControls</span><span class="pun">(</span><span class="typ">BookingReferenceNumberTemp</span><span class="pun">);</span><span class="pln"> </span><span class="com">// this code for update</span><span class="pln">
            </span><span class="pun">}</span><span class="pln">
        </span><span class="pun">}</span><span class="pln">
</span>

File Name: ViewCabDetails.aspx.cs 

<span class="pln">

 </span><span class="kwd">private</span><span class="pln"> </span><span class="kwd">void</span><span class="pln"> bindControls</span><span class="pun">(</span><span class="kwd">int</span><span class="pln"> </span><span class="typ">BookingReferenceNumberTemp</span><span class="pun">)</span><span class="pln">
        </span><span class="pun">{</span><span class="pln">
            </span><span class="typ">BookCabDBOperation</span><span class="pln"> cabBookDB </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">BookCabDBOperation</span><span class="pun">();</span><span class="pln">
            cabDetails </span><span class="pun">=</span><span class="pln"> cabBookDB</span><span class="pun">.</span><span class="typ">GetCabDetailsByBookingID</span><span class="pun">(</span><span class="typ">BookingReferenceNumberTemp</span><span class="pun">);</span><span class="pln"> 

             </span><span class="com">// the above line is a function calling, which is much more important</span><span class="pln">


            bookRefNo</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Convert</span><span class="pun">.</span><span class="typ">ToString</span><span class="pun">(</span><span class="pln">cabDetails</span><span class="pun">.</span><span class="typ">BookingReferenceNumber1</span><span class="pun">);</span><span class="pln">
            </span><span class="typ">PassengerName11</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabDetails</span><span class="pun">.</span><span class="typ">PassengerName1</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">FromLocation</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabDetails</span><span class="pun">.</span><span class="typ">FromLocation1</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">ToLocation</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabDetails</span><span class="pun">.</span><span class="typ">ToLocation1</span><span class="pln"> </span><span class="pun">;</span><span class="pln">
            </span><span class="typ">DepartureTime</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabDetails</span><span class="pun">.</span><span class="typ">DepartureTime1</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">DistanceinKm</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabDetails</span><span class="pun">.</span><span class="typ">DistanceinKm1</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">EstimatedAmountText</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabDetails</span><span class="pun">.</span><span class="typ">EstimatedAmount1</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">CabType1</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabDetails</span><span class="pun">.</span><span class="typ">CabType1</span><span class="pun">;</span><span class="pln">
            divEdit</span><span class="pun">.</span><span class="typ">Visible</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">true</span><span class="pun">;</span><span class="pln">


        </span><span class="pun">}</span><span class="pln">

</span>

File Name: BookCabDBOperation.cs

Database Operation 

<span class="pln">


  </span><span class="kwd">public</span><span class="pln"> </span><span class="typ">BookCabClass</span><span class="pln"> </span><span class="typ">GetCabDetailsByBookingID</span><span class="pun">(</span><span class="kwd">int</span><span class="pln"> bookID</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln">

            </span><span class="typ">SqlConnection</span><span class="pln"> con </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SqlConnection</span><span class="pun">(</span><span class="pln">conString</span><span class="pun">);</span><span class="pln">
            con</span><span class="pun">.</span><span class="typ">Open</span><span class="pun">();</span><span class="pln">
            </span><span class="typ">SqlCommand</span><span class="pln"> cmd </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SqlCommand</span><span class="pun">(</span><span class="str">"sp_select_byId"</span><span class="pun">,</span><span class="pln"> con</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">CommandType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">CommandType</span><span class="pun">.</span><span class="typ">StoredProcedure</span><span class="pun">;</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@BookingReferenceNumber1"</span><span class="pun">,</span><span class="pln"> bookID</span><span class="pun">);</span><span class="pln">
            </span><span class="typ">SqlDataReader</span><span class="pln"> reader </span><span class="pun">=</span><span class="pln"> cmd</span><span class="pun">.</span><span class="typ">ExecuteReader</span><span class="pun">();</span><span class="pln">
            </span><span class="typ">BookCabClass</span><span class="pln"> </span><span class="typ">BookCabClasObj</span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">BookCabClass</span><span class="pun">();</span><span class="pln">
            </span><span class="kwd">while</span><span class="pln"> </span><span class="pun">(</span><span class="pln">reader</span><span class="pun">.</span><span class="typ">Read</span><span class="pun">())</span><span class="pln">
            </span><span class="pun">{</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">BookingReferenceNumber1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Convert</span><span class="pun">.</span><span class="typ">ToInt32</span><span class="pun">(</span><span class="pln">reader</span><span class="pun">[</span><span class="str">"BookingReferenceNumber"</span><span class="pun">]);</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">PassengerName1</span><span class="pln"> </span><span class="pun">=</span><span class="pln">  reader</span><span class="pun">[</span><span class="str">"PassengerName"</span><span class="pun">].</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">FromLocation1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> reader</span><span class="pun">[</span><span class="str">"FromLocation"</span><span class="pun">].</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">ToLocation1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> reader</span><span class="pun">[</span><span class="str">"ToLocation"</span><span class="pun">].</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">DepartureTime1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> reader</span><span class="pun">[</span><span class="str">"DepartureTime"</span><span class="pun">].</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">DistanceinKm1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> reader</span><span class="pun">[</span><span class="str">"DistanceinKm"</span><span class="pun">].</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">EstimatedAmount1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> reader</span><span class="pun">[</span><span class="str">"EstimatedAmount"</span><span class="pun">].</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln">
                </span><span class="typ">BookCabClasObj</span><span class="pun">.</span><span class="typ">CabType1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> reader</span><span class="pun">[</span><span class="str">"CabType"</span><span class="pun">].</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln">

            </span><span class="pun">}</span><span class="pln">
            con</span><span class="pun">.</span><span class="typ">Close</span><span class="pun">();</span><span class="pln">
            </span><span class="kwd">return</span><span class="pln"> </span><span class="typ">BookCabClasObj</span><span class="pun">;</span><span class="pln">
        </span><span class="pun">}</span><span class="pln">

</span>

File Name: ViewCabDetails.aspx.cs

OnClick="Button1Edit_Click"

After Getting the values in the textbox from the database we will update that value inside database again

<span class="pln">
  </span><span class="kwd">protected</span><span class="pln"> </span><span class="kwd">void</span><span class="pln"> </span><span class="typ">Button1Edit_Click</span><span class="pun">(</span><span class="kwd">object</span><span class="pln"> sender</span><span class="pun">,</span><span class="pln"> </span><span class="typ">EventArgs</span><span class="pln"> e</span><span class="pun">)</span><span class="pln">
        </span><span class="pun">{</span><span class="pln">
            cabDetails</span><span class="pun">.</span><span class="typ">PassengerName1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">PassengerName11</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln">
            cabDetails</span><span class="pun">.</span><span class="typ">ToLocation1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">ToLocation</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln">
            cabDetails</span><span class="pun">.</span><span class="typ">DepartureTime1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">DepartureTime</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln">
            cabDetails</span><span class="pun">.</span><span class="typ">DistanceinKm1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">DistanceinKm</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln">
            cabDetails</span><span class="pun">.</span><span class="typ">EstimatedAmount1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">EstimatedAmountText</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln">
            cabDetails</span><span class="pun">.</span><span class="typ">CabType1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">CabType1</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln">
            cabDetails</span><span class="pun">.</span><span class="typ">BookingReferenceNumber1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Convert</span><span class="pun">.</span><span class="typ">ToInt32</span><span class="pun">(</span><span class="pln">bookRefNo</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">);</span><span class="pln">

            </span><span class="kwd">string</span><span class="pln"> message </span><span class="pun">=</span><span class="pln"> cabBookDB</span><span class="pun">.</span><span class="pln">updateCabDetails</span><span class="pun">(</span><span class="pln">cabDetails</span><span class="pun">);</span><span class="pln">

          </span><span class="com">// THE ABOVE FUNCTION CALL UPDATES THE VALUE</span><span class="pln">

            bindData</span><span class="pun">();</span><span class="pln">
            </span><span class="typ">Response</span><span class="pun">.</span><span class="typ">Write</span><span class="pun">(</span><span class="typ">String</span><span class="pun">.</span><span class="typ">Format</span><span class="pun">(</span><span class="str">"&lt;script&gt;alert('{0}')&lt;/script&gt;"</span><span class="pun">,</span><span class="pln"> message</span><span class="pun">));</span><span class="pln">
            bookRefNo</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">""</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">PassengerName11</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">""</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">FromLocation</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">""</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">ToLocation</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">""</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">DepartureTime</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">""</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">DistanceinKm</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">""</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">EstimatedAmountText</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">""</span><span class="pun">;</span><span class="pln">
            </span><span class="typ">CabType1</span><span class="pun">.</span><span class="typ">SelectedValue</span><span class="pln"> </span><span class="pun">=</span><span class="str">""</span><span class="pln"> </span><span class="pun">;</span><span class="pln">
        </span><span class="pun">}</span><span class="pln">
</span>

File Name: BookCabDBOperation.cs 

<span class="pln">
 </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> updateCabDetails</span><span class="pun">(</span><span class="typ">BookCabClass</span><span class="pln"> bookCabClassObj</span><span class="pun">)</span><span class="pln">
        </span><span class="pun">{</span><span class="pln">
            </span><span class="typ">SqlConnection</span><span class="pln"> con </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SqlConnection</span><span class="pun">(</span><span class="pln">conString</span><span class="pun">);</span><span class="pln">
            con</span><span class="pun">.</span><span class="typ">Open</span><span class="pun">();</span><span class="pln">
            </span><span class="typ">SqlCommand</span><span class="pln"> cmd </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SqlCommand</span><span class="pun">(</span><span class="str">"sp_edit_ByBookId"</span><span class="pun">,</span><span class="pln"> con</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">CommandType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">CommandType</span><span class="pun">.</span><span class="typ">StoredProcedure</span><span class="pun">;</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@PassengerName"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">PassengerName1</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@FromLocation"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">FromLocation1</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@ToLocation"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">ToLocation1</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@DepartureTime"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">DepartureTime1</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@DistanceinKm"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">DistanceinKm1</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@EstimatedAmount"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">EstimatedAmount1</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@CabType"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">CabType1</span><span class="pun">);</span><span class="pln">
            cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">.</span><span class="typ">AddWithValue</span><span class="pun">(</span><span class="str">"@BookingReferenceNumber"</span><span class="pun">,</span><span class="pln"> bookCabClassObj</span><span class="pun">.</span><span class="typ">BookingReferenceNumber1</span><span class="pun">);</span><span class="pln">
            </span><span class="kwd">int</span><span class="pln"> rowsAffected </span><span class="pun">=</span><span class="pln"> cmd</span><span class="pun">.</span><span class="typ">ExecuteNonQuery</span><span class="pun">();</span><span class="pln">
            </span><span class="kwd">string</span><span class="pln"> message</span><span class="pun">;</span><span class="pln">
            </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">rowsAffected </span><span class="pun">&gt;</span><span class="pln"> </span><span class="lit">0</span><span class="pun">)</span><span class="pln">
                message </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Updated Successfully"</span><span class="pun">;</span><span class="pln">
            </span><span class="kwd">else</span><span class="pln">
                message </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Some Error occured."</span><span class="pun">;</span><span class="pln">

            </span><span class="kwd">return</span><span class="pln"> message</span><span class="pun">;</span><span class="pln">

        </span><span class="pun">}</span><span class="pln">
</span>

DATABASE SQL PROCEDURE

Store Procedure Name: sp_select_byId 

<span class="pln">

CREATE PROCEDURE sp_select_byId  
</span><span class="lit">@BookingReferenceNumber1</span><span class="pln"> INT  
AS  
</span><span class="kwd">BEGIN</span><span class="pln">  
SELECT </span><span class="pun">*</span><span class="pln"> FROM </span><span class="typ">EtaxiSystem_1937935</span><span class="pln"> WHERE </span><span class="typ">BookingReferenceNumber</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@BookingReferenceNumber1</span><span class="pln">  
</span><span class="kwd">END</span><span class="pln">

</span>

Store Procedure Name: sp_edit_ByBookId 


<span class="pln">
CREATE PROCEDURE sp_edit_ByBookId</span><span class="pun">(</span><span class="pln">  
 </span><span class="lit">@PassengerName</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">  
 </span><span class="lit">@FromLocation</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">  
 </span><span class="lit">@ToLocation</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">  
 </span><span class="lit">@DepartureTime</span><span class="pln"> DATETIME</span><span class="pun">,</span><span class="pln">  
 </span><span class="lit">@DistanceinKm</span><span class="pln"> INT</span><span class="pun">,</span><span class="pln">  
 </span><span class="lit">@EstimatedAmount</span><span class="pln"> INT</span><span class="pun">,</span><span class="pln">  
 </span><span class="lit">@CabType</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">  
 </span><span class="lit">@BookingReferenceNumber</span><span class="pln"> INT  
 </span><span class="pun">)</span><span class="pln">  
 AS  
 </span><span class="kwd">BEGIN</span><span class="pln">  
   
 UPDATE </span><span class="typ">EtaxiSystem_1937935</span><span class="pln"> SET    
 </span><span class="typ">PassengerName</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@PassengerName</span><span class="pun">,</span><span class="pln"> </span><span class="typ">FromLocation</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@FromLocation</span><span class="pun">,</span><span class="pln"> </span><span class="typ">ToLocation</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@ToLocation</span><span class="pun">,</span><span class="pln">  
  </span><span class="typ">DepartureTime</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@DepartureTime</span><span class="pun">,</span><span class="pln">  </span><span class="typ">DistanceinKm</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@DistanceinKm</span><span class="pun">,</span><span class="pln"> </span><span class="typ">EstimatedAmount</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@EstimatedAmount</span><span class="pun">,</span><span class="pln">  
 </span><span class="typ">CabType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@CabType</span><span class="pln">   WHERE </span><span class="typ">BookingReferenceNumber</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@BookingReferenceNumber</span><span class="pln">  
 </span><span class="kwd">END</span><span class="pln">  

</span>
Share this Post: