INSERT DROPDDOWN LIST value in db

objReg.Faculty = drpdFaculty.SelectedValue;

select DROPDDOWN LIST value from db

if (Convert.ToString(dt.Rows[0]["Faculty"]) == "")
{
drpdFaculty.SelectedValue = "--Select--";
}
else
{
drpdFaculty.SelectedValue = dt.Rows[0]["Faculty"].ToString();
}

HOW TO USE VARIABLE ON ASPX PAGE AT DATA BINDING

< href="javascript:ForgotPwd('<%=userid %>')">
Visible="true">


userid = Convert.ToInt16(Request.QueryString["UserID"].ToString());//this is for sending user id to change password window. // in .cs file

HOW TO CREATE HTML TABLE USING STRING BUILDER ?

StringBuilder strBldr = new StringBuilder();
StringBuilder strFAQ = new StringBuilder();


strFAQ.Append("");


//for(int iTemp = 0 ;i< dsListOfFAQ.Tables[0].Rows.Count;i++)
int Counter = dsListOfFAQ.Tables[0].Rows.Count;

if (Counter > 0)
{
int count = 1;

foreach (DataRow dr in dsListOfFAQ.Tables[0].Rows)
{

//DataRow dr = dsListOfFAQ.Tables[0].NewRow();

strFAQ.Append("");

strFAQ.Append("");
strFAQ.Append("");
count += 1;

}
strFAQ.Append("

"); //strFAQ.Append( Convert.ToInt32(dr["FAQID"].ToString()) +"."); strFAQ.Append(Convert.ToInt32(dr["serial"].ToString()) + "."); //divFAQList.InnerHtml += " ='"+ Convert.ToInt32(dr["FAQID"].ToString()) +"'> "; strFAQ.Append("" + dr["Question"].ToString() + ""); //divFAQList.InnerHtml += " "; strFAQ.Append("

"); strFAQ.Append(dr["Answer"].ToString()); if (count == dsListOfFAQ.Tables[0].Rows.Count) { strFAQ.Append(" "); strFAQ.Append(" "); } strFAQ.Append("Click here to Edit    "); //strFAQ.Append(" " + "Approve    " + " "); strFAQ.Append("Delete"); strFAQ.Append(" "); strFAQ.Append("

");
lblFAQ.Text = strFAQ.ToString();
}
else
{
lblFAQ.Text = "No record found.";
lblFAQ.ForeColor = System.Drawing.Color.Red;
lblFAQ.Font.Bold = true;
}
}

WHAT IS GLOBAL.ASPX PAGE EVENTS AND HOW TO COUNT TOTAL APPLICATION HIT COUNTERS AND SESSION COUNT

<%@ Application Language="C#" %>

HOW TO CHANGE THEME AND MASTER PAGE ON PRE INIT

protected override void OnPreInit(EventArgs e)
{
if (Session["UserID"] != null)
{
string thm;
thm = (string)Session["Theme"];
if (thm != null)
{
Page.Theme = thm;
}
else
{
Page.Theme = "Theme1";
}
if (Convert.ToString(Session["RoleName"].ToString().Trim()) == "SuperAdmin")
{
string masterfile = "../SuperAdmin/SuperAdmin.master";
if (!masterfile.Equals(string.Empty))
{
base.MasterPageFile = masterfile;
}
}
else if (Convert.ToString(Session["RoleName"].ToString().Trim()) == "Administrator")
{
string masterfile = "../Admin/CollegeAdmin.master";
if (!masterfile.Equals(string.Empty))
{
base.MasterPageFile = masterfile;
}
}
else if (Convert.ToString(Session["RoleName"].ToString().Trim()) == "Student")
{
string masterfile = "../Users/UserMasterPage.master";
if (!masterfile.Equals(string.Empty))
{
base.MasterPageFile = masterfile;
}
}
base.OnPreInit(e);
}
else
{
Response.Redirect(LCE.Configuration.GetRootPath().ToString() + "/Login.aspx", false);
}
}

HOW TO GIVE ROOT PATH TO LINKS

< href="<%= rootPath%>/Courses/MyCourses/Default.aspx">Assign Modules



< href="<%= rootPath%>/Assessment/MyAssesments/UserAssessments.aspx">Assign Assessments


public string rootPath = LMSBeta.BLL.Configuration.GetRootPath();
public string role;
protected void Page_Load(object sender, EventArgs e)
{
role = Convert.ToString(Session["RoleName"]);
}

HOW TO OPEN WINDOW IN JS ONCLICK

Sample Certificate