using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Collections;
public partial class mymenu2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet mainDS = CreateDataSet();
Menu1.DataSource = mainDS;
EO.Web.DataBinding binding = new EO.Web.DataBinding();
binding.DataField = "ApplicationName";
binding.Property = "Text-Html";
Menu1.Bindings.Add(binding);
// Populate from the data source (mainTable);
Menu1.DataBind();
// Bind the mainTable to DataGrid for demostration purpose.
DataGrid DataGrid1 = new DataGrid();
DataGrid1.DataSource = mainDS.Tables["Application"];
DataGrid1.DataBind();
}
public string MoahannedConnectionString
{
get
{
return ConfigurationManager.ConnectionStrings["MohannadConnectionString1"].ConnectionString;
}
}
private DataTable CreateDataTable()
{
DataTable dtApplication = new DataTable();
dtApplication.TableName = "Applications";
DataColumn myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "ApplicationID";
dtApplication.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "ApplicationName";
dtApplication.Columns.Add(myDataColumn);
return dtApplication;
}
private void AddDataToTable(string ApplicationID, string ApplicationName, DataTable myTable)
{
DataRow row;
row = myTable.NewRow();
row["ApplicationID"] = ApplicationID;
row["ApplicationName"] = ApplicationName;
myTable.Rows.Add(row);
}
private DataSet CreateDataSet()
{
DataSet ds = new DataSet();
DataTable dtApplication = CreateDataTable();
SqlConnection con = new SqlConnection(MoahannedConnectionString);
SqlCommand cmd1 = new SqlCommand("select AppID,AppName from Application", con);
SqlDataAdapter da = new SqlDataAdapter();
SqlDataReader sdr = null;
con.Open();
sdr = cmd1.ExecuteReader();
while (sdr.Read())
{
AddDataToTable(sdr["AppID"].ToString(), sdr["AppName"].ToString(), dtApplication);
}
ds.Tables.Add(dtApplication);
return ds;
}
}