protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection cn = new SqlConnection(constr))
{
SqlCommand cmd = new SqlCommand("tiranes", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
Detail.DataSource = ds;
Detail.DataBind();
}
}
protected void NavigationMenu_MenuItemClick(object sender, MenuEventArgs e)
{
MenuItem selectedItem = NavigationMenu.SelectedItem;
string a = NavigationMenu.SelectedItem.Text;
using (SqlConnection con = new SqlConnection(constr))
{
SqlCommand cmd1 = new SqlCommand("fakultet_tiranes", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@emfakultet", a);
con.Open();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
Detail.DataSource = ds1;
Detail.DataBind();
}
}