Delete database record from tha database using .NET via stored procedure
File Name: ViewCabDetails.aspx
This this section we will cover how you can delete a database record from the database using .NET. Here we will use Stored Procedure for performing the database operation.
<span class="pln"> </span><span class="tag"><asp:GridView</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"GridView1Awesome"</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">AutoGenerateColumns</span><span class="pun">=</span><span class="atv">"False"</span><span class="pln"> </span><span class="atn">CellPadding</span><span class="pun">=</span><span class="atv">"4"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"#333333"</span><span class="pln"> </span><span class="atn">GridLines</span><span class="pun">=</span><span class="atv">"None"</span><span class="pln"> </span><span class="atn">CssClass</span><span class="pun">=</span><span class="atv">"table table-hover"</span><span class="pln"> </span><span class="atn">OnRowCommand</span><span class="pun">=</span><span class="atv">"</span><span class="typ">GridView1Awesome_RowCommand</span><span class="atv">"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><AlternatingRowStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"White"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"#284775"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><Columns></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"BookingReferenceNumber1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"Booking ReferenceNumber "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"PassengerName1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"Passenger Name "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"FromLocation1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"From Location "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"ToLocation1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"To Location "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"DepartureTime1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"Departure Date Time "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"DistanceinKm1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"Distance in Km "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"EstimatedAmount1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"Estimated Amount "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><asp:BoundField</span><span class="pln"> </span><span class="atn">DataField</span><span class="pun">=</span><span class="atv">"CabType1"</span><span class="pln"> </span><span class="atn">HeaderText</span><span class="pun">=</span><span class="atv">"Cab Type "</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><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">></span><span class="pln"> </span><span class="tag"><ItemTemplate</span><span class="pln"> </span><span class="tag">></span><span class="pln"> <asp:LinkButton ID="LinkButton1" CommandArgument='</span><span class="pun"><%</span><span class="com"># Eval("BookingReferenceNumber1") </span><span class="pln">%>' runat="server" CommandName="EditEmployee">Edit</span><span class="tag"></asp:LinkButton></span><span class="pln"> </span><span class="tag"></ItemTemplate></span><span class="pln"> </span><span class="tag"></asp:TemplateField></span><span class="pln"> </span><span class="tag"><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">></span><span class="pln"> </span><span class="tag"><ItemTemplate</span><span class="pln"> </span><span class="tag">></span><span class="pln"> <asp:LinkButton ID="LinkButton2" CommandArgument='</span><span class="pun"><%</span><span class="com"># Eval("BookingReferenceNumber1") </span><span class="pln">%>' runat="server" CommandName="DeleteEmployee">Delete</span><span class="tag"></asp:LinkButton></span><span class="pln"> </span><span class="tag"></ItemTemplate></span><span class="pln"> </span><span class="tag"></asp:TemplateField></span><span class="pln"> </span><span class="tag"></Columns></span><span class="pln"> </span><span class="tag"><EditRowStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#999999"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><FooterStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#5D7B9D"</span><span class="pln"> </span><span class="atn">Font-Bold</span><span class="pun">=</span><span class="atv">"True"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"White"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><HeaderStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#5D7B9D"</span><span class="pln"> </span><span class="atn">Font-Bold</span><span class="pun">=</span><span class="atv">"True"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"White"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><PagerStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#284775"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"White"</span><span class="pln"> </span><span class="atn">HorizontalAlign</span><span class="pun">=</span><span class="atv">"Center"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><RowStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#F7F6F3"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"#333333"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><SelectedRowStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#E2DED6"</span><span class="pln"> </span><span class="atn">Font-Bold</span><span class="pun">=</span><span class="atv">"True"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"#333333"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><SortedAscendingCellStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#E9E7E2"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><SortedAscendingHeaderStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#506C8C"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><SortedDescendingCellStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#FFFDF8"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"><SortedDescendingHeaderStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span class="atv">"#6F8DAE"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"></asp:GridView></span><span class="pln"> </span>
File Name: ViewCabDetails.aspx.cs
CommandName="DeleteEmployee"
<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 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="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"> bindControlsDelete</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"> </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">"<script>alert('{0}')</script>"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Do you want to delete?"</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="typ">DeleteCabDetails</span><span class="pun">(</span><span class="typ">BookingReferenceNumberTemp</span><span class="pun">);</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">"<script>alert('{0}')</script>"</span><span class="pun">,</span><span class="pln"> message</span><span class="pun">));</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
File Name: BookCabDBOperation.cs
This is Data base Operation file
<span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">DeleteCabDetails</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_delect_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="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">></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">"Delete Successfully with Booking Id: "</span><span class="pun">+</span><span class="pln"> bookId</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>
SQL Procedure Name: sp_delect_ByID
<span class="pln"> CREATE PROCEDURE sp_delect_ByID </span><span class="lit">@BookingReferenceNumber1</span><span class="pln"> INT AS </span><span class="kwd">BEGIN</span><span class="pln"> DELETE 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>
