I got it to work. I forgot to include: DataSet ds = new DataSet(); Thanks, Ryan
On 5/25/05, Ryan Olshan <[EMAIL PROTECTED]> wrote: > > Code and stored procedure below error. The error I am getting is: > *Value cannot be null. Parameter name: dataSet* *Description: *An > unhandled exception occurred during the execution of the current web > request. Please review the stack trace for more information about the error > and where it originated in the code. > > *Exception Details: *System.ArgumentNullException: Value cannot be null. > Parameter name: dataSet > > *Source Error:* > > An unhandled exception was generated during the execution of the > current web request. Information regarding the origin and location of the > exception can be identified using the exception stack trace below. > > *Stack Trace:* > > [ArgumentNullException: Value cannot be null. > Parameter name: dataSet] > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior > behavior) +103 > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 > _911PigeonAlert.AdminMenuControl.Page_Load(Object sender, EventArgs e) in > c:\inetpub\ryan\wwwroot\beta.911pigeonalert.org\admin\adminmenu.ascx.cs:41 > System.Web.UI.Control.OnLoad(EventArgs e) +67 > System.Web.UI.Control.LoadRecursive() +35 > System.Web.UI.Control.LoadRecursive() +98 > System.Web.UI.Page.ProcessRequestMain() +750 > > > ------------------------------ > *Version Information:* Microsoft .NET Framework Version:1.1.4322.2032; > ASP.NET <http://asp.net/> Version:1.1.4322.2032 > *Code:* > > public void Page_Load(object sender, System.EventArgs e) > > { > > //_UserID = Convert.ToInt32(Session["UserID"]); > > _UserID = Convert.ToInt32(Request.QueryString["UserID"]); > > _MenuID = Convert.ToInt32(Request.QueryString["MenuID"]); > > string proc; > > SqlConnection conn = > new SqlConnection((string) Application["conn"]); > > proc = "GetSubMenuAccess"; > > SqlCommand cmd = > new SqlCommand(proc, conn); > > cmd.CommandType = CommandType.StoredProcedure; > > SqlParameter p1 = > new SqlParameter("@ParentID", _MenuID); > > p1.Direction = ParameterDirection.Input; > > SqlParameter p2 = > new SqlParameter("@UserID", _UserID); > > p2.Direction = ParameterDirection.Input; > > cmd.Parameters.Add(p1); > > cmd.Parameters.Add(p2); > > SqlDataAdapter adapter = > new SqlDataAdapter(cmd); > > adapter.Fill(ds); > > AdminMenuRepeater.DataSource = ds.Tables[0].DefaultView; > > AdminMenuRepeater.DataBind(); > > } > > *Stored Procedure:* > > CREATE PROCEDURE GetSubMenuAccess > ( > @ParentID int, > @UserID int > ) > AS > SELECT uma.SubMenuID, sm.Menu, sm.URL > FROM SubMenus sm > INNER JOIN UserMenuAccess uma > ON uma.SubMenuID = sm.SubMenuID > WHERE > sm.ParentMenuID = @ParentID AND uma.UserID = @UserID > ORDER BY sm.Menu ASC > GO > > On 5/25/05, Dean Fiala <[EMAIL PROTECTED]> wrote: > > > > There a number of free/cheap menu packages available for .NET that > > will save you the work. Checkout > > http://www.asp.net/ControlGallery/default.aspx?Category=32&tabindex=2 > > for an idea. > > > > But if you want to do this yourself, start with web user control, add > > a repeater control, then add a hyperlink to the repeater's item > > template, like so... > > > > <%@ Control Language="vb" AutoEventWireup="false" > > Codebehind="hm.ascx.vb" Inherits="Playground.hm <http://playground.hm/>" > > TargetSchema=" http://schemas.microsoft.com/intellisense/ie5"; %> > > <asp:Repeater id="Repeater1" runat="server"> > > <HeaderTemplate><table><tr></HeaderTemplate> > > <ItemTemplate> > > <td><asp:HyperLink ID="mnuItem" Runat="server"></asp:HyperLink></td> > > > > </ItemTemplate> > > <FooterTemplate> > > </tr></table> > > </FooterTemplate> > > </asp:Repeater> > > > > Then you simply bind it to the menu items returned from your stored > > proc. > > > > Repeater1.DataSource = > > SomeFunctionThatCallsYourStoredProcAndReturnsAReaderOrDataTable() > > Repeater1.DataBind () > > > > Add a ItemDataBound event handler to set your menu hyperlinks. For > > example, > > > > Private Sub Repeater1_ItemDataBound(ByVal sender As Object, ByVal > > e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles > > Repeater1.ItemDataBound > > Dim hl As HyperLink > > Dim dr As DataRow > > If e.Item.ItemType = ListItemType.AlternatingItem Or > > e.Item.ItemType = ListItemType.Item Then > > hl = e.Item.FindControl ("mnuItem") > > dr = e.Item.DataItem > > hl.Text = dr("Text") > > hl.NavigateUrl = Request.Url.LocalPath & "?mID=" & dr("ID") > > End If > > End Sub > > > > You'll want to change the NavigateURL obviously and add some styling > > to the menu, but this is the basic way to create a dynamic horizontal > > menu. > > > > -- > > Dean Fiala > > Very Practical Software, Inc > > http://www.vpsw.com > > > > ------------------------------ > > *Yahoo! Groups Links* > > > > - To visit your group on the web, go to: > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > - To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > <[EMAIL PROTECTED]> > > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > > Service <http://docs.yahoo.com/info/terms/>. > > > > > > > -- > Thank you, > Ryan Olshan > TeraNet Systems > http://www.teranetsystems.com -- Thank you, Ryan Olshan TeraNet Systems http://www.teranetsystems.com [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
