private void BindMembers(int distID)
{
DBconnection obj = new DBconnection();
//int distID = int.Parse(Session["DistrictClubID"].ToString());
//obj.SetCommandQry = "select sr, (fname+' ' + lname) as name from member where Status='True' order by name asc";
obj.SetCommandQry = "select MemberId, (fname+' ' + lname) as name from district3140_members_tbl where DistrictClubID='" + distID + "' and Status='True' order by name asc";
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
DDLMember.DataTextField = "name";
DDLMember.DataValueField = "MemberId";
DDLMember.DataSource = dt;
DDLMember.DataBind();
// DDLMember.Items.Insert(0, "Select");
DDLMember0.DataTextField = "name";
DDLMember0.DataValueField = "MemberId";
DDLMember0.DataSource = dt;
DDLMember0.DataBind();
//DDLMember0.Items.Insert(0, "Select");
}
private void clear()
{
trPresi.Visible = false;
trSec.Visible = false;
chkIfOtherSec.Checked = false;
chkIfOther.Checked = false;
DDLYear.ClearSelection();
DDLMember.ClearSelection();
DDLMember0.ClearSelection();
DDLClubName.ClearSelection();
}
