insert into datbase using stored procedure and .net code by standard form control
In this blog we are going to show that how you will store the data inside a data base from a simple form using the store procedure
Database coding
<>SQL SERVER CREATE PROCEDURE WITH OUTPUT PARAMETERUse the below code to use a particular database
<span class="pln"> </span><span class="com">// USE name_of_the_database</span><span class="pln"> USE DB02TEST01 </span>
Create a table to insert data using the precedure
<span class="pln"> CREATE TABLE </span><span class="typ">EtaxiSystem_1937935</span><span class="pun">(</span><span class="pln"> </span><span class="typ">BookingReferenceNumber</span><span class="pln"> INT PRIMARY KEY IDENTITY</span><span class="pun">(</span><span class="lit">100000</span><span class="pun">,</span><span class="lit">1</span><span class="pun">),</span><span class="pln"> </span><span class="typ">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="typ">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="typ">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="typ">DepartureTime</span><span class="pln"> DATETIME</span><span class="pun">,</span><span class="pln"> </span><span class="typ">DistanceinKm</span><span class="pln"> INT</span><span class="pun">,</span><span class="pln"> </span><span class="typ">EstimatedAmount</span><span class="pln"> INT</span><span class="pun">,</span><span class="pln"> </span><span class="typ">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="pun">)</span><span class="pln"> </span>
Use the below code to see the table data It is present
<span class="pln"> </span><span class="kwd">select</span><span class="pln"> </span><span class="pun">*</span><span class="pln"> </span><span class="kwd">from</span><span class="pln"> </span><span class="typ">EtaxiSystem_1937935</span><span class="pln"> </span>
Execute the below code to create a procedure in sql server
Below is the code for stored procedure
<span class="pln"> CREATE PROCEDURE </span><span class="typ">ETaxiProcedure</span><span class="pln"> </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 OUT </span><span class="pun">)</span><span class="pln"> AS </span><span class="kwd">BEGIN</span><span class="pln"> INSERT INTO </span><span class="typ">EtaxiSystem_1937935</span><span class="pln"> VALUES </span><span class="pun">(</span><span class="pln"> </span><span class="lit">@PassengerName</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@FromLocation</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@ToLocation</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@DepartureTime</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@DistanceinKm</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@EstimatedAmount</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@CabType</span><span class="pun">)</span><span class="pln"> SET </span><span class="lit">@BookingReferenceNumber</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="pun">@</span><span class="lit">@IDENTITY</span><span class="pln"> </span><span class="kwd">END</span><span class="pln"> </span>
Execute the code to see your procedure is working or not
You can use the below code for checking your stored procedure
<span class="pln"> DECLARE </span><span class="lit">@BookingReferenceNumber1</span><span class="pln"> INT EXEC </span><span class="typ">ETaxiProcedure</span><span class="pln"> </span><span class="str">'Rumman'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Kolkata'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Kerala'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'12.02.1996'</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="lit">10</span><span class="pun">,</span><span class="pln"> </span><span class="str">'indigo'</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@BookingReferenceNumber1</span><span class="pln"> OUT PRINT </span><span class="lit">@BookingReferenceNumber1</span><span class="pln"> </span>
Now see the table details using the below code again
<span class="pln"> SELECT </span><span class="pun">*</span><span class="pln"> FROM </span><span class="typ">EtaxiSystem_1937935</span><span class="pln"> </span>
.NET Coding
File Name: TravelDetailsInsert.aspx
<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"><div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"container"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"row"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"col-sm-3"</span><span class="tag">></span><span class="pln"> </span><span class="tag"></div></span><span class="pln"> </span><span class="tag"><div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"col-sm-6"</span><span class="pln"> </span><span class="atn">style</span><span class="pun">=</span><span class="atv">"</span><span class="pln">background</span><span class="pun">-</span><span class="pln">color</span><span class="pun">:</span><span class="pln">lavenderblush</span><span class="pun">;</span><span class="atv">"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><table</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"table table-hover"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Label</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Label1"</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">"Passenger Name"</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:TextBox</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"PassengerName"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">></asp:TextBox></span><span class="pln"> </span><span class="tag"><asp:RegularExpressionValidator</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"RegularExpressionValidator1"</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">ErrorMessage</span><span class="pun">=</span><span class="atv">"* Please Enter Characters and space only"</span><span class="pln"> </span><span class="atn">ControlToValidate</span><span class="pun">=</span><span class="atv">"PassengerName"</span><span class="pln"> </span><span class="atn">ValidationExpression</span><span class="pun">=</span><span class="atv">"[a-zA-Z ]*$"</span><span class="tag">></asp:RegularExpressionValidator></span><span class="pln"> </span><span class="tag"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"RequiredFieldValidator5"</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">ControlToValidate</span><span class="pun">=</span><span class="atv">"PassengerName"</span><span class="pln"> </span><span class="atn">ErrorMessage</span><span class="pun">=</span><span class="atv">"Enter passenger name"</span><span class="tag">></asp:RequiredFieldValidator></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Label</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Label2"</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">"From Location"</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><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="pln"> </span><span class="atn">AutoPostBack</span><span class="pun">=</span><span class="atv">"true"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Please Select</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Thiruvananthapuram</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kochi</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kozhikode</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kollam</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Thrissur</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kannur</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Alappuzha</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"></asp:DropDownList></span><span class="pln"> </span><span class="tag"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"RequiredFieldValidator1"</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">ErrorMessage</span><span class="pun">=</span><span class="atv">"Select the Base location"</span><span class="pln"> </span><span class="atn">ControlToValidate</span><span class="pun">=</span><span class="atv">"FromLocation"</span><span class="tag">></asp:RequiredFieldValidator></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Label</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Label3"</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">"To Location"</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><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="pln"> </span><span class="atn">AutoPostBack</span><span class="pun">=</span><span class="atv">"true"</span><span class="pln"> </span><span class="atn">OnSelectedIndexChanged</span><span class="pun">=</span><span class="atv">"</span><span class="typ">ToLocation_SelectedIndexChanged1</span><span class="atv">"</span><span class="tag">></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Thiruvananthapuram</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kochi</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kozhikode</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kollam</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Thrissur</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Kannur</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Alappuzha</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"></asp:DropDownList></span><span class="pln"> </span><span class="tag"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"RequiredFieldValidator2"</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">ErrorMessage</span><span class="pun">=</span><span class="atv">"Select Your Destination Location"</span><span class="pln"> </span><span class="atn">ControlToValidate</span><span class="pun">=</span><span class="atv">"ToLocation"</span><span class="tag">></asp:RequiredFieldValidator></span><span class="pln"> </span><span class="tag"><asp:CustomValidator</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"CustomValidator1"</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">ErrorMessage</span><span class="pun">=</span><span class="atv">"TO and FROM is same"</span><span class="pln"> </span><span class="atn">ControlToValidate</span><span class="pun">=</span><span class="atv">"ToLocation"</span><span class="tag">></asp:CustomValidator></span><span class="pln"> </span><span class="tag"><asp:Label</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Label6"</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">"Label"</span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span class="atv">"#FF3399"</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Label</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Label4"</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">"DepartureTime"</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><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="pln"> </span><span class="atn">Type</span><span class="pun">=</span><span class="atv">"date"</span><span class="tag">></asp:TextBox></span><span class="pln"> </span><span class="tag"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"RequiredFieldValidator3"</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">ErrorMessage</span><span class="pun">=</span><span class="atv">"Select a Date"</span><span class="pln"> </span><span class="atn">ControlToValidate</span><span class="pun">=</span><span class="atv">"DepartureTime"</span><span class="tag">></asp:RequiredFieldValidator></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Label</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Label5"</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">"Distance in Km "</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><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="pln"> </span><span class="atn">onTextChanged</span><span class="pun">=</span><span class="atv">"</span><span class="typ">DistanceinKm_TextChanged</span><span class="atv">"</span><span class="pln"> </span><span class="atn">AutoPostBack</span><span class="pun">=</span><span class="atv">"true"</span><span class="pln"> </span><span class="tag">></asp:TextBox></span><span class="pln"> </span><span class="pun"><%--</span><span class="pln"> </span><span class="pun"><</span><span class="pln">asp</span><span class="pun">:</span><span class="typ">Button</span><span class="pln"> ID</span><span class="pun">=</span><span class="str">"Button2"</span><span class="pln"> runat</span><span class="pun">=</span><span class="str">"server"</span><span class="pln"> </span><span class="typ">Text</span><span class="pun">=</span><span class="str">"See Car Rent"</span><span class="pln"> </span><span class="typ">OnClick</span><span class="pun">=</span><span class="str">"TextBox2_TextChanged"</span><span class="pln"> </span><span class="pun">/>--</span><span class="pln">%> </span><span class="tag"><asp:RequiredFieldValidator</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"RequiredFieldValidator4"</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">ErrorMessage</span><span class="pun">=</span><span class="atv">"Select the distance"</span><span class="pln"> </span><span class="atn">ControlToValidate</span><span class="pun">=</span><span class="atv">"DistanceinKm"</span><span class="tag">></asp:RequiredFieldValidator></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Label</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="pln"> </span><span class="atn">Text</span><span class="pun">=</span><span class="atv">"EstimatedAmount"</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:TextBox</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"EstimatedAmount"</span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span class="atv">"server"</span><span class="tag">></asp:TextBox></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Label</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Label7"</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">"CabType"</span><span class="tag">></asp:Label></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:RadioButtonList</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"CabType"</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:ListItem></span><span class="pln">Indigo</span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"><asp:ListItem></span><span class="pln">Innova </span><span class="tag"></asp:ListItem></span><span class="pln"> </span><span class="tag"></asp:RadioButtonList></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"><tr></span><span class="pln"> </span><span class="tag"><td</span><span class="pln"> </span><span class="atn">colspan</span><span class="pun">=</span><span class="atv">"1"</span><span class="tag">></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"><td></span><span class="pln"> </span><span class="tag"><asp:Button</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span class="atv">"Button1"</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">Button1_Click</span><span class="atv">"</span><span class="pln"> </span><span class="tag">/></span><span class="pln"> </span><span class="tag"></td></span><span class="pln"> </span><span class="tag"></tr></span><span class="pln"> </span><span class="tag"></table></span><span class="pln"> </span><span class="tag"></form></span><span class="pln"> </span><span class="tag"></div></span><span class="pln"> </span><span class="tag"><div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"col-sm-3"</span><span class="tag">></span><span class="pln"> </span><span class="tag"></div></span><span class="pln"> </span><span class="tag"></div></span><span class="pln"> </span>
TravelDetailsInsert.aspx.cs
Button event
<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">Button1_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"> </span><span class="com">// int BookingReferenceNumber = 100000;</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="typ">PassengerName</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"> </span><span class="typ">FromLocation1</span><span class="pln"> </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="pun">;</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="typ">ToLocation</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"> </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"> </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="typ">DistanceinKm</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"> </span><span class="typ">EstimatedAmount1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">EstimatedAmount</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"> </span><span class="typ">CabType1</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">CabType</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">;</span><span class="pln"> </span><span class="typ">BookCabClass</span><span class="pln"> carBookDetailsobj </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="typ">PassengerName1</span><span class="pun">,</span><span class="pln"> </span><span class="typ">FromLocation1</span><span class="pun">,</span><span class="pln"> </span><span class="typ">ToLocation1</span><span class="pun">,</span><span class="pln"> </span><span class="typ">DepartureTime1</span><span class="pun">,</span><span class="pln"> </span><span class="typ">DistanceinKm1</span><span class="pun">,</span><span class="pln"> </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="pln"> </span><span class="typ">BookCabDBOperation</span><span class="pln"> dbObj </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="kwd">int</span><span class="pln"> returnValue </span><span class="pun">=</span><span class="pln"> dbObj</span><span class="pun">.</span><span class="typ">InsertBooksCarData</span><span class="pun">(</span><span class="pln">carBookDetailsobj</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="str">"Data Saved Successfully with ID:"</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> returnValue</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="typ">Convert</span><span class="pun">.</span><span class="typ">ToInt32</span><span class="pun">(</span><span class="pln">returnValue</span><span class="pun">)</span><span class="pln"> </span><span class="pun">></span><span class="pln"> </span><span class="lit">0</span><span class="pun">)</span><span class="pln"> </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><span class="pun">}</span><span class="pln"> </span>
File name: BookCabClass.cs
<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="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>
File name: BookCabDBOperation.cs
To work with date base we created a new class
<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">BookCabDBOperation</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> conString </span><span class="pun">=</span><span class="pln"> </span><span class="typ">ConfigurationManager</span><span class="pun">.</span><span class="typ">ConnectionStrings</span><span class="pun">[</span><span class="str">"constring"</span><span class="pun">].</span><span class="typ">ConnectionString</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">InsertBooksCarData</span><span class="pun">(</span><span class="typ">BookCabClass</span><span class="pln"> carBookObj</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">"ETaxiProcedure"</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"> carBookObj</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"> carBookObj</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"> carBookObj</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"> carBookObj</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"> carBookObj</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"> carBookObj</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"> carBookObj</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">Add</span><span class="pun">(</span><span class="str">"@BookingReferenceNumber"</span><span class="pun">,</span><span class="typ">SqlDbType</span><span class="pun">.</span><span class="typ">Int</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="str">"@BookingReferenceNumber"</span><span class="pun">].</span><span class="typ">Direction</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">ParameterDirection</span><span class="pun">.</span><span class="typ">Output</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">if</span><span class="pun">(</span><span class="pln">rowsAffected </span><span class="pun">></span><span class="lit">0</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> carBookObj</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">cmd</span><span class="pun">.</span><span class="typ">Parameters</span><span class="pun">[</span><span class="str">"@BookingReferenceNumber"</span><span class="pun">].</span><span class="typ">Value</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"> carBookObj</span><span class="pun">.</span><span class="typ">BookingReferenceNumber1</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
