Fetch Data from Database using .net and view on a Grid
In this blog we will see how I can fetch the data from the database and view on a data grid
File Name: ViewCabDetails.aspx
This is a .aspx page. where we are using out grid
Note: User Interface Layer
<span class="pln"> </span><span class="pun"><%@</span><span class="pln"> </span><span class="typ">Page</span><span class="pln"> </span><span class="typ">Title</span><span class="pun">=</span><span class="str">""</span><span class="pln"> </span><span class="typ">Language</span><span class="pun">=</span><span class="str">"C#"</span><span class="pln"> </span><span class="typ">MasterPageFile</span><span class="pun">=</span><span class="str">"~/MasterPage.Master"</span><span class="pln"> </span><span class="typ">AutoEventWireup</span><span class="pun">=</span><span class="str">"true"</span><span class="pln"> </span><span class="typ">CodeBehind</span><span class="pun">=</span><span class="str">"ViewCabDetails.aspx.cs"</span><span class="pln"> </span><span class="typ">Inherits</span><span class="pun">=</span><span class="str">"TaxiManagementSystem.ViewCabDetails"</span><span class="pln"> %> </span><span class="tag"><asp:Content</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Content1"</span><span class="pln"> </span><span class="atn">ContentPlaceHolderID</span><span class="pun">=</span><span class="atv">"head"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">></span><span class="pln"> </span><span class="tag"></asp:Content></span><span class="pln"> </span><span class="tag"><asp:Content</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Content2"</span><span class="pln"> </span><span class="atn">ContentPlaceHolderID</span><span class="pun">=</span><span class="atv">"mainContent"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><form</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">></span><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="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"></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><span class="tag"></form></span><span class="pln"> </span><span class="tag"></asp:Content></span><span class="pln"> </span><span class="tag"><asp:Content</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Content3"</span><span class="pln"> </span><span class="atn">ContentPlaceHolderID</span><span class="pun">=</span><span class="atv">"ContentPlaceHolder2"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">></span><span class="pln"> </span><span class="tag"></asp:Content></span><span class="pln"> </span>
File Name: ViewCabDetails.aspx.cs
This is a .aspx page. where we are using out grid
Note: User Interface Layer (Code Behind file)
<span class="pln"> </span><span class="kwd">using</span><span class="pln"> blTaxiManagementSystem</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Collections</span><span class="pun">.</span><span class="typ">Generic</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Linq</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Web</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ">WebControls</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> ulTaxiManagementSystem</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">TaxiManagementSystem</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">partial</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> </span><span class="typ">ViewCabDetails</span><span class="pln"> </span><span class="pun">:</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Web</span><span class="pun">.</span><span class="pln">UI</span><span class="pun">.</span><span class="typ">Page</span><span class="pln"> </span><span class="pun">{</span><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">Page_Load</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"> bindData</span><span class="pun">();</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">void</span><span class="pln"> bindData</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">List</span><span class="pun"><</span><span class="typ">BookCabClass</span><span class="pun">></span><span class="pln"> cabbookList</span><span class="pun">;</span><span class="pln"> cabbookList </span><span class="pun">=</span><span class="pln"> cabBookDB</span><span class="pun">.</span><span class="typ">GetCabDetails</span><span class="pun">();</span><span class="pln"> </span><span class="typ">GridView1Awesome</span><span class="pun">.</span><span class="typ">DataSource</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cabbookList</span><span class="pun">;</span><span class="pln"> </span><span class="typ">GridView1Awesome</span><span class="pun">.</span><span class="typ">DataBind</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>
File Name: BookCabDBOperation.cs
You can save this function or method inside the Data access layer in, thus is the data base operation file
class name BookCabDBOperation
Note: Data Access Layer
cab.BookingReferenceNumber1 = Convert.ToInt32(reader["BookingReferenceNumber"]);
In the above code BookingReferenceNumber1 this is a properties of the Class and
BookingReferenceNumber this is a database feild name
<span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">BookCabClass</span><span class="pun">></span><span class="pln"> </span><span class="typ">GetCabDetails</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">"select_cab_details_1637935"</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"> </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">List</span><span class="pun"><</span><span class="typ">BookCabClass</span><span class="pun">></span><span class="pln"> cabDetails </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</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">BookCabClass</span><span class="pln"> cab </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"> cab</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"> cab</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"> cab</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"> cab</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"> cab</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"> cab</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"> cab</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"> cab</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"> cabDetails</span><span class="pun">.</span><span class="typ">Add</span><span class="pun">(</span><span class="pln">cab</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="kwd">return</span><span class="pln"> cabDetails</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
This is out Properties class
Note: This is my code for the class and properties details
<span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Collections</span><span class="pun">.</span><span class="typ">Generic</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Linq</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Threading</span><span class="pun">.</span><span class="typ">Tasks</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> blTaxiManagementSystem </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> </span><span class="typ">BookCabClass</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">BookingReferenceNumber</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">PassengerName</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">FromLocation</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">ToLocation</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">DepartureTime</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">DistanceinKm</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">EstimatedAmount</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">CabType</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="typ">BookCabClass</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="kwd">public</span><span class="pln"> </span><span class="typ">BookCabClass</span><span class="pun">(</span><span class="kwd">string</span><span class="pln"> passengerName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> fromLocation</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> toLocation</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> departureTime</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> distanceinKm</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> estimatedAmount</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> cabType</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="com">// BookingReferenceNumber1 = BookingReferenceNumber;</span><span class="pln"> </span><span class="typ">PassengerName</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> 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"> 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"> 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"> 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"> 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"> 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"> cabType</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> </span><span class="typ">BookingReferenceNumber1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">BookingReferenceNumber</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">BookingReferenceNumber</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">value</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><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">PassengerName1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">PassengerName</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">PassengerName</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">value</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><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">FromLocation1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">FromLocation</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </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="kwd">value</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><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">ToLocation1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">ToLocation</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </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="kwd">value</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><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">DepartureTime1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">DepartureTime</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </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="kwd">value</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><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">DistanceinKm1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">DistanceinKm</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </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="kwd">value</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><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">EstimatedAmount1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">EstimatedAmount</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </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="kwd">value</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><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">CabType1</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="typ">CabType</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </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="kwd">value</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>
SQL Procedure
<span class="pln"> CREATE PROCEDURE select_cab_details_1637935 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"> </span><span class="kwd">END</span><span class="pln"> </span>
