Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 21, 2013 04:50 AM by demoninside9
Participant
1490 Points
635 Posts
Feb 21, 2013 12:41 AM|LINK
demoninside9 but still doing something wrong
??????
1258 Points
1720 Posts
Feb 21, 2013 01:47 AM|LINK
ToughMan ??????
I don't know what is that wrong thing
Feb 21, 2013 04:39 AM|LINK
What exception have u got????
Feb 21, 2013 04:43 AM|LINK
parameter "xxxxx" was not supplied
Feb 21, 2013 04:45 AM|LINK
demoninside9 parameter "xxxxx" was not supplied
Ur current sql statement and full codes, plz.
Feb 21, 2013 04:50 AM|LINK
DAL enum Operation_Type { Insert, Update, Delete, Select } public class DAL { #region Connecting to database SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString); #endregion public string[] Proc_Name = new string[] {"Insert_Logbook"}; Operation_Type Type; public void Do_Insert_Update_Delete() { con.Open(); for (int j = 0; j <= Proc_Name.Length; j++) { if (Operation_Type.Insert == Type) { SqlCommand com = new SqlCommand(Proc_Name[j], con); com.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(com); foreach( SqlParameter p in com.Parameters ) { com.Parameters.AddWithValue(com.Parameters.ToString(), (object)com.Parameters); } com.ExecuteNonQuery(); con.Close(); con.Dispose(); } } } BAL public class BAL { DAL dl = new DAL(); public void Do(params object[] args) { dl.Do_Insert_Update_Delete(); } } UI code protected void btnSubmit_Click(object sender, EventArgs e) { BAL bl = new BAL(); // object[] arr = new object[] { "Vehicle_Number", DateTime.Now.Date, DateTime.Now, DateTime.Now }; bl.Do(); Response.Write("Done"); } aspx code <asp:Content ID="Content2" runat="server" contentplaceholderid="ContentPlaceHolder1"> <script type = "text/javascript" language = "javascript"> function numeralsOnly(evt) { evt = (evt) ? evt : event; var charCode = (evt.charCode) ? evt.charCode : ((evt.keyCode) ? evt.keyCode : ((evt.which) ? evt.which : 0)); if (charCode > 31 && (charCode < 48 || charCode > 57) && (charCode != 46)) { alert("Enter numerals only in this field!"); return false; } return true; } </script> <asp:Panel ID="Panel1" runat="server" Height="520px"> <table cellpadding="0" cellspacing="0" border="0" width="100%"> <tr> <td class="head" colspan="7"> Log Book</td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Date</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:TextBox ID="txtDate" runat="server"></asp:TextBox> <asp:CalendarExtender ID="txtDate_CalendarExtender" runat="server" Enabled="True" TargetControlID="txtDate" Format="dd/MM/yyyy"> </asp:CalendarExtender> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtDate" ErrorMessage="Date Required !">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="tsTimeFrom" ErrorMessage="Time From Required !">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="tsTimeTo" ErrorMessage="Time To Required !">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Time From</td> <td class="ver11bold"> :</td> <td class="style6"> <MKB:TimeSelector ID="tsTimeFrom" runat="server" DisplaySeconds="False" EnableTheming="True"> </MKB:TimeSelector> </td> <td class="ver11bold"> Time To</td> <td class="ver11bold"> :</td> <td class="ver11bold"> <MKB:TimeSelector ID="tsTimeTo" runat="server" DisplaySeconds="False" EnableTheming="True"> </MKB:TimeSelector> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtKMStart" ErrorMessage="KM Start Required !">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtKMTo" ErrorMessage="KM To Required !">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> KM Start</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:TextBox ID="txtKMStart" runat="server"></asp:TextBox> </td> <td class="ver11bold"> KM End</td> <td class="ver11bold"> :</td> <td class="ver11bold"> <asp:TextBox ID="txtKMTo" runat="server"></asp:TextBox> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Used By</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:DropDownList ID="ddlEmployee" runat="server" AppendDataBoundItems="True"> <asp:ListItem Value="0">-Select-</asp:ListItem> </asp:DropDownList> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="ddlEmployee" ErrorMessage="Used By Required !" InitialValue="0">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Others</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:TextBox ID="txtOthers" runat="server"></asp:TextBox> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Cost Code</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:DropDownList ID="ddlCostCode" runat="server" AppendDataBoundItems="True"> <asp:ListItem Value="0">-Select-</asp:ListItem> </asp:DropDownList> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="ddlCostCode" ErrorMessage="Cost Code Required !" InitialValue="0">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Budget Line</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:DropDownList ID="ddlBudgetLine" runat="server" AppendDataBoundItems="True"> <asp:ListItem Value="0">-Select-</asp:ListItem> </asp:DropDownList> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="ddlBudgetLine" ErrorMessage="Budget Line Required !" InitialValue="0">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> <asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" CausesValidation="False" /> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td colspan="6"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal" Width="770px"> <Columns> <asp:BoundField DataField="Vehicle_Booking_Date" HeaderText="Date" /> <asp:BoundField DataField="Time_From" HeaderText="Time From" /> <asp:BoundField DataField="Time_To" HeaderText="Time To" /> <asp:BoundField DataField="KM_Start" HeaderText="KM Start" /> <asp:BoundField DataField="KM_End" HeaderText="KM End" /> <asp:BoundField DataField="Vehicle_Used_By" HeaderText="Used By" /> <asp:BoundField DataField="Cost_Code" HeaderText="Cost Code" /> </Columns> <FooterStyle BackColor="White" ForeColor="#333333" /> <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" HorizontalAlign="Left" /> <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="White" ForeColor="#333333" /> <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" /> </asp:GridView> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="7"> <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </asp:ToolkitScriptManager> <asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="True" ShowSummary="False" /> </td> </tr> </table> </asp:Panel> </asp:Content> SQL CREATE TABLE [dbo].[mtblLog_Book]( [Logbook_Number] [int] IDENTITY(1,1) NOT NULL, [Vehicle_Number] [nvarchar](100) NULL, [Vehicle_Booking_Date] [datetime] NULL, [Time_From] [time](7) NULL, [Time_To] [time](7) NULL, [KM_Start] [int] NULL, [KM_End] [int] NULL, [Vehicle_Used_By] [varchar](100) NULL, [Cost_Code] [nvarchar](50) NULL, [Budget_Line] [nvarchar](50) NULL, [Entry_Date] [datetime] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[mtblLog_Book] WITH CHECK ADD FOREIGN KEY([Vehicle_Number]) REFERENCES [dbo].[mtblVehicle] ([Vehicle_Number]) GO SP ALTER proc [dbo].[Insert_LogBook] ( @Vehicle_Number nvarchar(100), @Vehicle_Booking_Date datetime, @Time_From time, @Time_To time, @KM_Start int, @KM_End int, @Vehicle_Used_By varchar(100), @Cost_Code nvarchar(50), @Budget_Line nvarchar(50), @Entry_Date datetime ) as insert INTO mtblLog_Book VALUES(@Vehicle_Number, @Vehicle_Booking_Date, @Time_From, @Time_To, @KM_Start, @KM_End,@Vehicle_Used_By,@Cost_Code, @Budget_Line,@Entry_Date )
ToughMan
Participant
1490 Points
635 Posts
Re: want to use enum and param
Feb 21, 2013 12:41 AM|LINK
??????
demoninside9
Participant
1258 Points
1720 Posts
Re: want to use enum and param
Feb 21, 2013 01:47 AM|LINK
I don't know what is that wrong thing
ToughMan
Participant
1490 Points
635 Posts
Re: want to use enum and param
Feb 21, 2013 04:39 AM|LINK
What exception have u got????
demoninside9
Participant
1258 Points
1720 Posts
Re: want to use enum and param
Feb 21, 2013 04:43 AM|LINK
parameter "xxxxx" was not supplied
ToughMan
Participant
1490 Points
635 Posts
Re: want to use enum and param
Feb 21, 2013 04:45 AM|LINK
Ur current sql statement and full codes, plz.
demoninside9
Participant
1258 Points
1720 Posts
Re: want to use enum and param
Feb 21, 2013 04:50 AM|LINK
DAL enum Operation_Type { Insert, Update, Delete, Select } public class DAL { #region Connecting to database SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString); #endregion public string[] Proc_Name = new string[] {"Insert_Logbook"}; Operation_Type Type; public void Do_Insert_Update_Delete() { con.Open(); for (int j = 0; j <= Proc_Name.Length; j++) { if (Operation_Type.Insert == Type) { SqlCommand com = new SqlCommand(Proc_Name[j], con); com.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(com); foreach( SqlParameter p in com.Parameters ) { com.Parameters.AddWithValue(com.Parameters.ToString(), (object)com.Parameters); } com.ExecuteNonQuery(); con.Close(); con.Dispose(); } } } BAL public class BAL { DAL dl = new DAL(); public void Do(params object[] args) { dl.Do_Insert_Update_Delete(); } } UI code protected void btnSubmit_Click(object sender, EventArgs e) { BAL bl = new BAL(); // object[] arr = new object[] { "Vehicle_Number", DateTime.Now.Date, DateTime.Now, DateTime.Now }; bl.Do(); Response.Write("Done"); } aspx code <asp:Content ID="Content2" runat="server" contentplaceholderid="ContentPlaceHolder1"> <script type = "text/javascript" language = "javascript"> function numeralsOnly(evt) { evt = (evt) ? evt : event; var charCode = (evt.charCode) ? evt.charCode : ((evt.keyCode) ? evt.keyCode : ((evt.which) ? evt.which : 0)); if (charCode > 31 && (charCode < 48 || charCode > 57) && (charCode != 46)) { alert("Enter numerals only in this field!"); return false; } return true; } </script> <asp:Panel ID="Panel1" runat="server" Height="520px"> <table cellpadding="0" cellspacing="0" border="0" width="100%"> <tr> <td class="head" colspan="7"> Log Book</td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Date</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:TextBox ID="txtDate" runat="server"></asp:TextBox> <asp:CalendarExtender ID="txtDate_CalendarExtender" runat="server" Enabled="True" TargetControlID="txtDate" Format="dd/MM/yyyy"> </asp:CalendarExtender> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtDate" ErrorMessage="Date Required !">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="tsTimeFrom" ErrorMessage="Time From Required !">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="tsTimeTo" ErrorMessage="Time To Required !">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Time From</td> <td class="ver11bold"> :</td> <td class="style6"> <MKB:TimeSelector ID="tsTimeFrom" runat="server" DisplaySeconds="False" EnableTheming="True"> </MKB:TimeSelector> </td> <td class="ver11bold"> Time To</td> <td class="ver11bold"> :</td> <td class="ver11bold"> <MKB:TimeSelector ID="tsTimeTo" runat="server" DisplaySeconds="False" EnableTheming="True"> </MKB:TimeSelector> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtKMStart" ErrorMessage="KM Start Required !">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtKMTo" ErrorMessage="KM To Required !">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> KM Start</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:TextBox ID="txtKMStart" runat="server"></asp:TextBox> </td> <td class="ver11bold"> KM End</td> <td class="ver11bold"> :</td> <td class="ver11bold"> <asp:TextBox ID="txtKMTo" runat="server"></asp:TextBox> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Used By</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:DropDownList ID="ddlEmployee" runat="server" AppendDataBoundItems="True"> <asp:ListItem Value="0">-Select-</asp:ListItem> </asp:DropDownList> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="ddlEmployee" ErrorMessage="Used By Required !" InitialValue="0">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Others</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:TextBox ID="txtOthers" runat="server"></asp:TextBox> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Cost Code</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:DropDownList ID="ddlCostCode" runat="server" AppendDataBoundItems="True"> <asp:ListItem Value="0">-Select-</asp:ListItem> </asp:DropDownList> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="ddlCostCode" ErrorMessage="Cost Code Required !" InitialValue="0">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="style6"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td class="ver11bold"> Budget Line</td> <td class="ver11bold"> :</td> <td class="style6"> <asp:DropDownList ID="ddlBudgetLine" runat="server" AppendDataBoundItems="True"> <asp:ListItem Value="0">-Select-</asp:ListItem> </asp:DropDownList> </td> <td class="ver11bold"> <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="ddlBudgetLine" ErrorMessage="Budget Line Required !" InitialValue="0">*</asp:RequiredFieldValidator> </td> <td class="ver11bold"> </td> <td class="ver11bold"> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> <asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" CausesValidation="False" /> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td class="style7"> </td> <td colspan="6"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal" Width="770px"> <Columns> <asp:BoundField DataField="Vehicle_Booking_Date" HeaderText="Date" /> <asp:BoundField DataField="Time_From" HeaderText="Time From" /> <asp:BoundField DataField="Time_To" HeaderText="Time To" /> <asp:BoundField DataField="KM_Start" HeaderText="KM Start" /> <asp:BoundField DataField="KM_End" HeaderText="KM End" /> <asp:BoundField DataField="Vehicle_Used_By" HeaderText="Used By" /> <asp:BoundField DataField="Cost_Code" HeaderText="Cost Code" /> </Columns> <FooterStyle BackColor="White" ForeColor="#333333" /> <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" HorizontalAlign="Left" /> <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="White" ForeColor="#333333" /> <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" /> </asp:GridView> </td> </tr> <tr> <td class="style7"> </td> <td> </td> <td> </td> <td class="style6"> </td> <td class="style8"> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="7"> <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </asp:ToolkitScriptManager> <asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="True" ShowSummary="False" /> </td> </tr> </table> </asp:Panel> </asp:Content> SQL CREATE TABLE [dbo].[mtblLog_Book]( [Logbook_Number] [int] IDENTITY(1,1) NOT NULL, [Vehicle_Number] [nvarchar](100) NULL, [Vehicle_Booking_Date] [datetime] NULL, [Time_From] [time](7) NULL, [Time_To] [time](7) NULL, [KM_Start] [int] NULL, [KM_End] [int] NULL, [Vehicle_Used_By] [varchar](100) NULL, [Cost_Code] [nvarchar](50) NULL, [Budget_Line] [nvarchar](50) NULL, [Entry_Date] [datetime] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[mtblLog_Book] WITH CHECK ADD FOREIGN KEY([Vehicle_Number]) REFERENCES [dbo].[mtblVehicle] ([Vehicle_Number]) GO SP ALTER proc [dbo].[Insert_LogBook] ( @Vehicle_Number nvarchar(100), @Vehicle_Booking_Date datetime, @Time_From time, @Time_To time, @KM_Start int, @KM_End int, @Vehicle_Used_By varchar(100), @Cost_Code nvarchar(50), @Budget_Line nvarchar(50), @Entry_Date datetime ) as insert INTO mtblLog_Book VALUES(@Vehicle_Number, @Vehicle_Booking_Date, @Time_From, @Time_To, @KM_Start, @KM_End,@Vehicle_Used_By,@Cost_Code, @Budget_Line,@Entry_Date )