ASP.NET
want to use enum and param RSS

15 replies

Last post Feb 21, 2013 04:50 AM by demoninside9
‹ Previous Thread|Next Thread ›
- Reply
ToughMan

Participant

1490 Points

635 Posts

Re: want to use enum and param

Feb 21, 2013 12:41 AM|LINK

demoninside9
but still doing something wrong

??????
- Reply
demoninside9

Participant

1258 Points

1720 Posts

Re: want to use enum and param

Feb 21, 2013 01:47 AM|LINK

ToughMan
??????

I don't know what is that wrong thing

It is our choices that show what we truly are, far more than our abilities...
- Edited by demoninside9 on Feb 21, 2013 01:49 AM
- Reply
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????
- Reply
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

It is our choices that show what we truly are, far more than our abilities...
- Reply
ToughMan

Participant

1490 Points

635 Posts

Re: want to use enum and param

Feb 21, 2013 04:45 AM|LINK

demoninside9

parameter "xxxxx" was not supplied

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">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="style8">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="style8">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="ver11bold">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
                        ControlToValidate="tsTimeFrom" ErrorMessage="Time From Required !">*</asp:RequiredFieldValidator>
                </td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
                        ControlToValidate="tsTimeTo" ErrorMessage="Time To Required !">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="style6">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
                        ControlToValidate="txtKMStart" ErrorMessage="KM Start Required !">*</asp:RequiredFieldValidator>
                </td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
                        ControlToValidate="txtKMTo" ErrorMessage="KM To Required !">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td class="ver11bold">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="style8">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td class="style6">
                    <asp:Button ID="btnSubmit" runat="server" Text="Submit"
                        onclick="btnSubmit_Click" CausesValidation="False" />
                </td>
                <td class="style8">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="style8">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style7">
                    &nbsp;</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">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td class="style6">
                    &nbsp;</td>
                <td class="style8">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</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
  )
It is our choices that show what we truly are, far more than our abilities...
Prev Next
First 1 2
‹ Previous Thread|Next Thread ›
want to use enum and param RSS

15 replies

ToughMan

Re: want to use enum and param

demoninside9

demoninside9

Re: want to use enum and param

ToughMan

ToughMan

Re: want to use enum and param

demoninside9

Re: want to use enum and param

ToughMan

Re: want to use enum and param

demoninside9

demoninside9

Re: want to use enum and param

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft
