Re: dynamic menu... - ASP.NET Discussion Boards

Christian Graus wrote:
third world programmers

Very harsh Christian , you don't have any rights to abuse any one please you read guidelines before answering any question as it put by the chris maunder and atleast this should not be from your side.

Christian Graus wrote:
one of the hordes of unskilled third world programmers ripping off western companies

world is progressing,
the gap between east and west is narrowing,
and we have here some VERY narrow minded people ...

Grow up .... man ... please grow up ...

Laugh | :laugh:

Apurv

“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)

“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)

[Message Deleted]

1 - Spoon feeding is bad.
2 - If you are spoon feeding, make sure what you are feeding is correct.

The code you have posted has got many flaws including SQL injection.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Please, don't offer code like this, it helps nobody. The guy has taken on a job for which he has no clue what he is doing, so the client is going to get ripped off - his own fault, he should ask for references first, but anyway. Once the guy has used your (dodgy) code to create a login he will ask how to do the next bit of his spec, and before you know it you have written the entire thing.

The simple fact is that people like this a) give a bad impression of developers in general and b) by bidding stupidly low take jobs away from people who can actually do them, but for a realistic price.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Hi to all,

I am working on a shopping cart project. Here the scenerio is, if the admin adds a new category, that should be shown in the menu. If the admin adds a new sub category , then it should be displayed as the child item of the main category.

Can anybody suggest me how to achieve this.

cheers

sneha

cheers,
sneha

A dynamic menu will be done using javascript. Just look at any of the menus that exist on the web and work out how to make one work using dynamic properties instead of a static file, or even just write that file as needed.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Thank you for replying. I did like this:

using System;
using System.Configuration;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page 
{
    string name;
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!Page.IsPostBack)
        {
            populate_menu();
        }
    }

    DataSet GetMenuData()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["newcon"].ConnectionString);
        SqlCommand cmd = new SqlCommand();
        ArrayList arl = new ArrayList();
        cmd.Connection = con;
        cmd.CommandText = "select * from CATEGORY ";
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        cmd.Connection.Open();
        sda.Fill(ds, "CATEGORY");
        return ds;
    }

    public void populate_menu()
    {
        DataSet ds = GetMenuData();
        foreach(DataRow drow in ds.Tables["CATEGORY"].Rows)
        {
            MenuItem masteritem = new MenuItem((string)drow["category_name"]);
            name = masteritem.Text;
            get_id();
            int par_id = Convert.ToInt32 (ViewState["p_id"]);
            if (par_id == 0)
            {
                Menu1.Items.Add(masteritem);
            }
            else
            {
                //masteritem.ChildItems.Add(masteritem);
                Menu1.Items.Add(masteritem);
            }
        }
    }

    public void get_id()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["newcon"].ConnectionString);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "select parent_id from CATEGORY where category_name='"+name+"'";
        cmd.Connection.Open();
        int pa_id = Convert.ToInt32(cmd.ExecuteScalar());
        ViewState["p_id"] = pa_id;

    }
}

From this I am getting output like this:

Catering
Plastics
Glassware

cheers,
sneha

Looks about right. You're not adding subitems, you're adding all your items to the one menu

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Hi,

public void populate_menu()
{
    DataSet ds = GetMenuData();
    foreach(DataRow drow in ds.Tables["CATEGORY"].Rows)
    {
        MenuItem masteritem = new MenuItem((string)drow["category_name"]);
        name = masteritem.Text;
        get_id();
        par_id = Convert.ToInt32 (ViewState["p_id"]);
        if (par_id == 0)
        {
            Menu1.Items.Add(masteritem);
        }
        else
        {
            //now find the category whose category_id is par_id
            get_category_name();
            ca_name = ViewState["cname"].ToString();


            //then under that category, add this sub category
            Menu1.Items[0].ChildItems.Add(masteritem);
        }
    }
}

In this I am unable to find the menu index of a particular category. In this I just tried by giving it as "0".
I want the menuindex based on the category name "ca_name".

cheers,
sneha

When i run the code below it show error in bold line of code that "Cannot implicitly convert type 'string' to 'System.Web.UI.WebControls.TextBox'" as i m new to C# programming so i can't resolve it.

 protected void gvCouponDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
    int id;
    int CouponTypeID;
    int Serial_Start;
    int serial_End;
        TextBox CouponName;
    DateTime TranDate;

    GridViewRow row = gvCouponDetails.Rows[e.RowIndex];

    id = int.Parse(((Label)row.Cells[0].FindControl("lblID")).Text);
    TranDate = DateTime.Parse(((TextBox)row.Cells[2].FindControl("tbDate")).Text);
    CouponName =((DropDownList)row.Cells[3].FindControl("ddlCoupon")).SelectedValue.ToString();
    Serial_Start= int.Parse(((TextBox)row.Cells[4].FindControl("tbSerialStart")).Text);
    serial_End = int.Parse(((TextBox)row.Cells[5].FindControl("tbSerialEnd")).Text);

    string UpdateQuery = string.Format("update Coupon_Info Set ReceivingDate = '{0}',Coupon_TypeID = {1}, Serial_Start={2},Serial_End={3} where ID= {4}",TranDate.ToString(),CouponTypeID.ToString(),Serial_Start.ToString(),serial_End.ToString(),id.ToString());
    DAL da = new DAL();
    da.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
    int i= da.ExecuteNonQuery(CommandType.Text, UpdateQuery, null);
    gvCouponDetails.EditIndex = -1;
    boundgridview();
}

ASP code is

<asp:GridView   ID="gvCouponDetails" 
                        runat="server"
                        AutoGenerateColumns="false" 
            onrowcancelingedit="gvCouponDetails_RowCancelingEdit" 
            onrowediting="gvCouponDetails_RowEditing" 
            onrowupdating="gvCouponDetails_RowUpdating"
            DataKeyNames="ID" 
        style="top: 521px; left: 276px; position: absolute; height: 143px; width: 704px">
          <Columns>
            
            <asp:CommandField   ButtonType="Button"
                                CancelText="C"
                                ShowCancelButton="true"
                                EditText="E"
                                ShowEditButton="true"
                                ControlStyle-Width="15px"
                                ControlStyle-Font-Size="10px"
                                ControlStyle-ForeColor="Blue"
                                UpdateText="U"  />

                


                
                <asp:TemplateField HeaderText="Coupon Name">
                    <ItemTemplate>
                        <asp:Label ID="tbCouponName" Text='<%# Bind("CouponName") %>' Width="100px" runat="server" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:DropDownList   ID="ddlCoupon" 
                                            DataSourceID="DSCouponType" 
                                            Width="100px" 
                                            DataTextField="CouponName" 
                                            DataValueField="Coupon_TypeID"
                                            runat="server"/>
                    </EditItemTemplate>
                </asp:TemplateField>

		
		<asp:TemplateField HeaderText="Date">
                
                    <ItemTemplate>
                        <asp:Label ID="lblDate" Text='<%# Bind("TransactionDate") %>' runat="server" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="tbDate" Text='<%# Bind("TransactionDate") %>' Width="80px" runat="server" />
                    </EditItemTemplate>
                </asp:TemplateField>



                
                <asp:TemplateField HeaderText="Price">
                    <ItemTemplate>
                        <asp:Label ID="lblprice" Text='<%# Bind("Price") %>' runat="server" Width="80px" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="tbprice" Text='<%# Bind("Price") %>' runat="server"  Width="80px" />
                    </EditItemTemplate>
                </asp:TemplateField>

                
                <asp:TemplateField HeaderText="Serial End">
                    <ItemTemplate>
                        <asp:Label ID="lblSerialEnd" Text='<%# Bind("SerialEnd") %>' runat="server" Width="70px" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="tbSerialEnd"  Text='<%# Bind("SerialEnd") %>' runat="server"  Width="70px"/>
                    </EditItemTemplate>
                </asp:TemplateField>



		<asp:TemplateField HeaderText="Serial Start">
                    <ItemTemplate>
                        <asp:Label ID="lblSerialStart" Text='<%# Bind("SerialStart") %>' runat="server" Width="70px" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="tbSerialStart"  Text='<%# Bind("SerialStart") %>' runat="server"  Width="70px"/>
                    </EditItemTemplate>
                </asp:TemplateField>


                <asp:TemplateField HeaderText="Menu">
                    <ItemTemplate>
                        <asp:Label ID="tbMenu" Text='<%# Bind("Cafe_Menu") %>' Width="100px" runat="server" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:DropDownList   ID="ddlmenu" 
                                            DataSourceID="DSMenu" 
                                            Width="100px" 
                                            DataTextField="Cafe_Menu" 
                                            DataValueField="Cafe_Menu"
                                            runat="server"/>
                    </EditItemTemplate>
                </asp:TemplateField>


		<asp:TemplateField HeaderText="Description">
                    <ItemTemplate>
                        <asp:Label ID="lblDes" Text='<%# Bind("Description") %>' runat="server" Width="70px" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="tbDes"  Text='<%# Bind("Description") %>' runat="server"  Width="70px"/>
                    </EditItemTemplate>
                </asp:TemplateField>

		<asp:TemplateField HeaderText="Transaction">
                    <ItemTemplate>
                        <asp:Label ID="lblSerialStart" Text='<%# Bind("Transaction") %>' runat="server" Width="70px" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="tbSerialStart"  Text='<%# Bind("Transaction") %>' runat="server"  Width="70px"/>
                    </EditItemTemplate>
                </asp:TemplateField>
                
                                
            </Columns>
        </asp:GridView>

haleemasher wrote:
TextBox CouponName;

Why CoupanName is TextBox Type ?

haleemasher wrote:
CouponName =((DropDownList)row.Cells[3].FindControl("ddlCoupon")).SelectedValue.ToString();

Use

String CouponName;
CouponName =((DropDownList)row.Cells[3].FindControl("ddlCoupon")).SelectedValue.ToString();

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

I change my code as u suggest but now it show this error in same line of code'System.Web.UI.Control' does not contain a definition for 'SelectedValue' and no extension method 'SelectedValue' accepting a first argument of type 'System.Web.UI.Control' could be found

CouponName =(DropDownList)row.Cells[3].FindControl("ddlCoupon").SelectedValue.ToString();

CouponName will always contains some string value.Casting it to TextBox is meaningless.If you want to have TextBox based on the value of CouponName use some control logic to get it done.

M.Sendilkumar

I think you forgot to use text property.
CouponName.text="";

thnx 4 suggestion but i want to update a gridview and CouponName is my dropdownlist in gridview which i want to update.

haleemasher wrote:
as i m new to C# programming

OK, well, given that the error message is in plain english, I'm not sure what to suggest. If you knew how to program, I'd suggest you break this up into as many lines as you can and step through in the debugger to work out what is going wrong.

As you don't know C#, I assume you're either in a class, or teaching yourself. If you're in a class, you should talk to your teacher. If you're teaching yourself, buy a basic book on C#, BEFORE you try to learn ASP.NET.

And if this is paid work, you are an utter disgrace, and should tell your client right now that you are stealing from them. If you work for a company, I'd expect them to go broke soon, hiring people like you. Your best way forward would be to buy a C# book and work through it, in the hope that when they fail and you look for another programming job, you find yourself actually capable of doing some programming and/or understanding basic error messages.

I assume you didn't write this code. Whoever did, isn't very good. It's horrible.

CouponName =((DropDownList)row.Cells[3].FindControl("ddlCoupon")).SelectedValue.ToString();

There are at least four ways that this code could blow up, it should be on at least 4 lines, with extra code to check the assumptions being made.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

haleemasher wrote:
CouponName =((DropDownList)row.Cells[3].FindControl("ddlCoupon")).SelectedValue.ToString();

insead use:

string CouponName = string.empty;
CouponName = ((DropDownList)row.Cells[3].FindControl("ddlCoupon")).Text;

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

I have no idea how a textbox is getting involved in his code, but I suspect that Cells[3] has a textbox in it, instead of a drop down. He needs to break this in to steps and use the debugger to work out what is wrong. If he's capable of it.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Try this

CouponName.Text =((DropDownList)row.Cells[3].FindControl("ddlCoupon")).SelectedValue.ToString();

While running this code it show error A page can have only one server-side Form tag.
How i resolve it?

<form id="form1" runat="server">
<fieldset style="width:569px; top: 272px; left: 406px; position: absolute; height: 429px;"> 
<legend> User Login </legend> 

  <kswc:UltimateDatePicker ID="UltimateDatePicker1" runat="server">
    </kswc:UltimateDatePicker>
    <kswc:UltimateCalendar ID="UltimateCalendar1" runat="server">
    </kswc:UltimateCalendar>
    <kswc:UltimateDatePicker ID="UltimateDatePicker3" runat="server">
    </kswc:UltimateDatePicker>
    <kswc:UltimateCalendar ID="UltimateCalendar3" runat="server">
    </kswc:UltimateCalendar>
  
</fieldset><

haleemasher wrote:
A page can have only one server-side Form tag.

Its means your web pages contain more than one Server site Form Tag.
Read This For Solution[^]

Thanks !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

This can't be the whole page, as the form is not closed. If you have only one form on this page, there must be a form tag inside one of the controls you are including.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

My guess is that the custom control what you have inside form is generating form.Debug and see the page controls collection and remove if it has more than on server side form.Only one Form runat server is allowed.

M.Sendilkumar

Hi All!!

I want to create exe file of Asp.Net C# web project so that i can deploy it on any computer. Please guide me how can i do that?and what will be the requirements to deploy it on other computer having no asp.net?

Please guide me!!