ASP.NET

Christian Graus wrote:

third world programmers

Christian Graus wrote:

one of the hordes of unskilled third world programmers ripping off western companies

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;

    }
}