can anyone help me.. I have coding that generate dynamic div based on database data. I'm using stringbuilder. In the div i have div= menu which has href in it. The href will generate base on database data also. i do i make the dynamic div hide when there is no href in the div=menu. below are my aspx.cs code and jquery. Please help..
aspx.cs
using (SqlConnection stud = ClassConn.GetStudPortConnection())
{
StringBuilder stringBuilder = new StringBuilder();
// stud.Open();
da.SelectCommand = new SqlCommand("SELECT moduleID,moduleDesc FROM Module WHERE systemID = '1'", stud);
SqlDataReader sc = da.SelectCommand.ExecuteReader();
if (sc.HasRows)
{
while (sc.Read())
{
var modID = sc["moduleID"].ToString();
var modDesc = sc["moduleDesc"].ToString();
stringBuilder.Append("
}
if (stringBuilder.Length > 0)
{
columnsContainer.Controls.Add(new Literal { Text = stringBuilder.ToString() });
columnsContainer.Visible = true;
}
}
}
{
StringBuilder stringBuilder = new StringBuilder();
// stud.Open();
da.SelectCommand = new SqlCommand("SELECT moduleID,moduleDesc FROM Module WHERE systemID = '1'", stud);
SqlDataReader sc = da.SelectCommand.ExecuteReader();
if (sc.HasRows)
{
while (sc.Read())
{
var modID = sc["moduleID"].ToString();
var modDesc = sc["moduleDesc"].ToString();
stringBuilder.Append("
");
stringBuilder.Append("
if (modDesc == "Timetable")
{
DataTable dt = this.BindGrid();
stringBuilder.Append("");
");
}
if (modDesc == "Profile")
{
DataTable dt = this.studentProfile();
stringBuilder.Append("");
");
}
stringBuilder.Append("");
stringBuilder.Append("
");stringBuilder.Append("
" + sc["moduleDesc"].ToString() + "
");if (modDesc == "Timetable")
{
DataTable dt = this.BindGrid();
stringBuilder.Append("
| "); stringBuilder.Append(column.ColumnName); stringBuilder.Append(" | ");
|---|
| "); stringBuilder.Append(row[column.ColumnName]); stringBuilder.Append(" | ");
}
if (modDesc == "Profile")
{
DataTable dt = this.studentProfile();
stringBuilder.Append("
| "); stringBuilder.Append(row[column.ColumnName]); stringBuilder.Append(" | ");
}
stringBuilder.Append("");
stringBuilder.Append("
}
if (stringBuilder.Length > 0)
{
columnsContainer.Controls.Add(new Literal { Text = stringBuilder.ToString() });
columnsContainer.Visible = true;
}
}
}
jquery code:
$('div.grid').filter(function () {
var lis = $(this).find('#menu');
return lis.length === lis.filter(':empty').length;
}).hide();
var lis = $(this).find('#menu');
return lis.length === lis.filter(':empty').length;
}).hide();
Hazel MahmudPosted Feb 23, 2016, 10:19 PM
Venkateshwar ReddyPosted Jan 27, 2016, 12:16 AM
{
stringBuilder.AppendFormat("
}