protected void Page_Load(object sender, EventArgs e)
{
string category = Request.QueryString["cat"];
if (category != null)
{
restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus();
ArrayList a = new ArrayList(r1.res_category(category));
ArrayList b = new ArrayList();
b = (ArrayList)a;
string[,] data = new string[100, 10];
int iterator = 0;
foreach (string c in b)
{
string[] row = c.Split('^');
data[iterator, 0] = row[0];
data[iterator, 1] = row[1];
data[iterator, 2] = row[2];
data[iterator, 3] = row[3];
data[iterator, 4] = row[4];
data[iterator, 5] = row[5];
data[iterator, 6] = row[6];
data[iterator, 7] = row[7];
data[iterator, 8] = row[8];
data[iterator, 9] = row[9];
iterator++;
}
DataTable newsDataTable = new DataTable();
// add some columns to our datatable
newsDataTable.Columns.Add("restaurant_name");
newsDataTable.Columns.Add("contact_no");
newsDataTable.Columns.Add("street");
newsDataTable.Columns.Add("city");
newsDataTable.Columns.Add("zipcode");
newsDataTable.Columns.Add("logopath");
newsDataTable.Columns.Add("restaurant_category");
newsDataTable.Columns.Add("minamount");
newsDataTable.Columns.Add("deliverytimings");
newsDataTable.Columns.Add("email");
// adding new rows
for (int i = 0; i < iterator; i++)
{
DataRow newsDataRow = newsDataTable.NewRow();
newsDataRow["restaurant_name"] = data[i, 0];
newsDataRow["contact_no"] = data[i, 1];
newsDataRow["street"] = data[i, 2];
newsDataRow["city"] = data[i, 3];
newsDataRow["zipcode"] = data[i, 4];
newsDataRow["logopath"] = data[i, 5];
newsDataRow["restaurant_category"] = data[i, 6];
newsDataRow["minamount"] = data[i, 7];
newsDataRow["deliverytimings"] = data[i, 8];
newsDataRow["email"] = data[i, 9];
newsDataTable.Rows.Add(newsDataRow);
}
// bind our datatable to our repeater
rescat.DataSource = newsDataTable;
rescat.DataBind();
if (iterator != 0)
{
}
else
{
dis.Text = "No Restaurants";
}
}
else
{
dis.Visible = true;
dis.Text = "No Restaurants";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string category = Request.QueryString["cat"];
if (category != null)
{
restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus();
ArrayList a = new ArrayList(r1.res_category(category));
ArrayList b = new ArrayList();
b = (ArrayList)a;
string[,] data = new string[100, 10];
int iterator = 0;
foreach (string c in b)
{
string[] row = c.Split('^');
data[iterator, 0] = row[0];
data[iterator, 1] = row[1];
data[iterator, 2] = row[2];
data[iterator, 3] = row[3];
data[iterator, 4] = row[4];
data[iterator, 5] = row[5];
data[iterator, 6] = row[6];
data[iterator, 7] = row[7];
data[iterator, 8] = row[8];
data[iterator, 9] = row[9];
iterator++;
}
DataTable newsDataTable = new DataTable();
// add some columns to our datatable
newsDataTable.Columns.Add("restaurant_name");
newsDataTable.Columns.Add("contact_no");
newsDataTable.Columns.Add("street");
newsDataTable.Columns.Add("city");
newsDataTable.Columns.Add("zipcode");
newsDataTable.Columns.Add("logopath");
newsDataTable.Columns.Add("restaurant_category");
newsDataTable.Columns.Add("minamount");
newsDataTable.Columns.Add("deliverytimings");
newsDataTable.Columns.Add("email");
// adding new rows
for (int i = 0; i < iterator; i++)
{
DataRow newsDataRow = newsDataTable.NewRow();
newsDataRow["restaurant_name"] = data[i, 0];
newsDataRow["contact_no"] = data[i, 1];
newsDataRow["street"] = data[i, 2];
newsDataRow["city"] = data[i, 3];
newsDataRow["zipcode"] = data[i, 4];
newsDataRow["logopath"] = data[i, 5];
newsDataRow["restaurant_category"] = data[i, 6];
newsDataRow["minamount"] = data[i, 7];
newsDataRow["deliverytimings"] = data[i, 8];
newsDataRow["email"] = data[i, 9];
newsDataTable.Rows.Add(newsDataRow);
}
// bind our datatable to our repeater
rescat.DataSource = newsDataTable;
rescat.DataBind();
if (iterator != 0)
{
}
else
{
dis.Text = "No Restaurants";
}
}
else
{
dis.Visible = true;
dis.Text = "No Restaurants";
}
}
