0

Hello i am working now to design a new website my problem is that i cannot insert in to my DB i use access as my Data Base when i click the update tool in the grid view an error msg appears

'No value given for one or more required parameters.'

my variable can be null in the DB

please help me :sad:

Edited by eng.amira: n/a

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by eng.amira
0

Show us some of your efforts or code you have done so far...So that here experts can take a look and give you solution..

Hello i am working now to design a new website my problem is that i cannot insert in to my DB i use access as my Data Base when i click the update tool in the grid view an error msg appears

'No value given for one or more required parameters.'

my variable can be null in the DB

please help me :sad:

0

hello .....

this is my code...

<%@ Page Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="app+.aspx.vb" Inherits="app_" title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">

a:link
    {color:blue;
    text-decoration:underline;
    text-underline:single;}
    </style>
</asp:Content>
<asp:Content ID="Content2" runat="server" 
    contentplaceholderid="ContentPlaceHolder2">

                        <table class="style1">
                            <tr>
                                <td>
                                    <asp:DropDownList ID="DropDownList2" runat="server" 
                                        DataSourceID="AccessDataSource3" DataTextField="DEP" DataValueField="DEP">
                                    </asp:DropDownList>
                                    <asp:AccessDataSource ID="AccessDataSource3" runat="server" 
                                        DataFile="~/زيارات 2010.MDB" 
                                        SelectCommand="SELECT DISTINCT [DEP] FROM [data0004]">
                                    </asp:AccessDataSource>
                                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
                                        AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" 
                                        BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="ID" 
                                        DataSourceID="AccessDataSource2">
                                        <RowStyle ForeColor="#000066" />
                                        <Columns>
                                            <asp:CommandField ShowEditButton="True" />
                                            <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" 
                                                SortExpression="ID" />
                                            <asp:BoundField DataField="APP_DATE" HeaderText="APP_DATE" 
                                                SortExpression="APP_DATE" />
                                            <asp:BoundField DataField="FACULTYNAM" HeaderText="FACULTYNAM" 
                                                SortExpression="FACULTYNAM" />
                                            <asp:BoundField DataField="FTEL" HeaderText="FTEL" SortExpression="FTEL" />
                                            <asp:BoundField DataField="FMOBILE" HeaderText="FMOBILE" 
                                                SortExpression="FMOBILE" />
                                            <asp:BoundField DataField="STATUS" HeaderText="STATUS" 
                                                SortExpression="STATUS" />
                                        </Columns>
                                        <FooterStyle BackColor="White" ForeColor="#000066" />
                                        <PagerTemplate>
                                            <br />
                                            <br />
                                            <br />
                                            <br />
                                        </PagerTemplate>
                                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                                    </asp:GridView>
                                    <asp:AccessDataSource ID="AccessDataSource2" runat="server" 
                                        DataFile="~/زيارات 2010.MDB" 
                                        DeleteCommand="DELETE FROM [data0004] WHERE (([ID] = ?) OR ([ID] IS NULL AND ? IS NULL))" 
                                        InsertCommand="INSERT INTO [data0004] ([ID], [APP_DATE], [FACULTYNAM], [FTEL], [FMOBILE], [STATUS]) VALUES (?, ?, ?, ?, ?, ?)" 
                                        OldValuesParameterFormatString="original_{0}" 
                                        SelectCommand="SELECT [ID], [APP_DATE], [FACULTYNAM], [FTEL], [FMOBILE], [STATUS] FROM [data0004] WHERE ([DEP] = ?)" 
                                        UpdateCommand="UPDATE [data0004] SET [APP_DATE] = ?, [FACULTYNAM] = ?, [FTEL] = ?, [FMOBILE] = ?, [STATUS] = ? WHERE (([ID] = ?) OR ([ID] IS NULL AND ? IS NULL))">
                                        <SelectParameters>
                                            <asp:ControlParameter ControlID="DropDownList2" Name="DEP" 
                                                PropertyName="SelectedValue" Type="String" />
                                        </SelectParameters>
                                        <DeleteParameters>
                                            <asp:Parameter Name="original_ID" Type="Double" />
                                        </DeleteParameters>
                                        <UpdateParameters>
                                            <asp:Parameter Name="APP_DATE" Type="DateTime" />
                                            <asp:Parameter Name="FACULTYNAM" Type="String" />
                                            <asp:Parameter Name="FTEL" Type="Double" />
                                            <asp:Parameter Name="FMOBILE" Type="Double" />
                                            <asp:Parameter Name="STATUS" Type="String" />
                                            <asp:Parameter Name="original_ID" Type="Double" />
                                        </UpdateParameters>
                                        <InsertParameters>
                                            <asp:Parameter Name="ID" Type="Double" />
                                            <asp:Parameter Name="APP_DATE" Type="DateTime" />
                                            <asp:Parameter Name="FACULTYNAM" Type="String" />
                                            <asp:Parameter Name="FTEL" Type="Double" />
                                            <asp:Parameter Name="FMOBILE" Type="Double" />
                                            <asp:Parameter Name="STATUS" Type="String" />
                                        </InsertParameters>
                                    </asp:AccessDataSource>
                                    <br />
                                    <br />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <br />
                                    <asp:Button ID="Button1" runat="server" Text="Button" />
                                    <br />
                                </td>
                            </tr>
    </table>

</asp:Content>

Edited by mike_2000_17: Fixed formatting

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.