Need Help
-
I have an ASP.Net Page using C# and I am getting this error: No value given for one or more required parameters. Here is my code. Any help would be appreciated. <asp:HiddenField ID="hidfld1" runat="server" /> <br /> <asp:HiddenField ID="hidfld2" runat="server" /> <br /> <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/mail.mdb" DeleteCommand="DELETE FROM Email WHERE ((Email = ?) OR (Email IS NULL AND ? IS NULL))" InsertCommand="INSERT INTO Email (Email) VALUES (?)" SelectCommand="SELECT Email FROM Email WHERE (Email = ?)"> <SelectParameters> <asp:Parameter Name="Email" Type="String" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="Email" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Email" Type="String" /> </InsertParameters> </asp:AccessDataSource> Code: protected void Page_Load(object sender, EventArgs e) { hidfld1.Value = Request.QueryString["Email"].ToString(); hidfld2.Value = Request.QueryString["ACT"].ToString(); if (hidfld2.Value == "S") AddRec(); else DelRec(); } protected void AddRec() { try { AccessDataSource1.InsertParameters["Email"].DefaultValue = hidfld1.Value; AccessDataSource1.Insert(); } catch (Exception ex) { lblError.Text = ex.Message; } } protected void DelRec() { try { AccessDataSource1.DeleteParameters["Email"].DefaultValue = hidfld1.Value.ToString(); AccessDataSource1.Delete(); } catch (Exception ex) { lblError.Text = ex.Message; } } }
-
I have an ASP.Net Page using C# and I am getting this error: No value given for one or more required parameters. Here is my code. Any help would be appreciated. <asp:HiddenField ID="hidfld1" runat="server" /> <br /> <asp:HiddenField ID="hidfld2" runat="server" /> <br /> <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/mail.mdb" DeleteCommand="DELETE FROM Email WHERE ((Email = ?) OR (Email IS NULL AND ? IS NULL))" InsertCommand="INSERT INTO Email (Email) VALUES (?)" SelectCommand="SELECT Email FROM Email WHERE (Email = ?)"> <SelectParameters> <asp:Parameter Name="Email" Type="String" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="Email" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Email" Type="String" /> </InsertParameters> </asp:AccessDataSource> Code: protected void Page_Load(object sender, EventArgs e) { hidfld1.Value = Request.QueryString["Email"].ToString(); hidfld2.Value = Request.QueryString["ACT"].ToString(); if (hidfld2.Value == "S") AddRec(); else DelRec(); } protected void AddRec() { try { AccessDataSource1.InsertParameters["Email"].DefaultValue = hidfld1.Value; AccessDataSource1.Insert(); } catch (Exception ex) { lblError.Text = ex.Message; } } protected void DelRec() { try { AccessDataSource1.DeleteParameters["Email"].DefaultValue = hidfld1.Value.ToString(); AccessDataSource1.Delete(); } catch (Exception ex) { lblError.Text = ex.Message; } } }
Read this, How to get an answer to your question[^]
I know the language. I've read a book. - _Madmatt