Query = "select * from tblCategory "; DataTable dtSubCat = GetDataTable(Query); foreach (DataRow drSubCat in dtSubCat.Rows) { string MText, MValue, MToolTip, MImageUrl, MNavigateUrl; MText = drSubCat["SubCatName"].ToString(); MValue = drSubCat["Value"].ToString(); MImageUrl = drSubCat["ImgUrl"].ToString(); MNavigateUrl = drSubCat["NavigateUrl"].ToString(); MToolTip = drSubCat["ToolTip"].ToString(); MenuItem Mi = new MenuItem(); Mi.Text = MText; Mi.Value = MValue; Mi.ToolTip = MToolTip; Mi.ImageUrl = MImageUrl; Mi.NavigateUrl = MNavigateUrl; Mi.SeparatorImageUrl = ""; MenuControl.Items.Add(Mi); } public DataTable GetDataTable(string Query) { SqlConnection objCon = new SqlConnection("your Connect String"); SqlCommand objCmd = new SqlCommand(Query, objCon); SqlDataAdapter objDA = new SqlDataAdapter(objCmd); objDA.SelectCommand.CommandText = objCmd.CommandText.ToString(); DataTable dt = new DataTable("Table"); objDA.Fill(dt); return dt; }
INFORMATION ABOUT COMPUTER SCIENCE(SOFTWARE ENGI)TECHNOLOGY & MEDICAL SCIENCE
Monday, April 1, 2013
how to fill menu dynamically in asp.net from database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment