private void GetAllDist3141Members() { MembersBll dc = new MembersBll(); DataTable dt = new DataTable(); dt = dc.GetAllDist3141Members(); if (dt.Rows.Count > 0) { DDLMem1.DataTextField = "Name"; DDLMem1.DataValueField = "MemberId"; DDLMem1.DataSource = dt; DDLMem1.DataBind(); // DDLMem1.Items.Insert(0, "Select"); DDLMem2.DataTextField = "Name"; DDLMem2.DataValueField = "MemberId"; DDLMem2.DataSource = dt; DDLMem2.DataBind(); DDLMem3.DataTextField = "Name"; DDLMem3.DataValueField = "MemberId"; DDLMem3.DataSource = dt; DDLMem3.DataBind(); DDLMem4.DataTextField = "Name"; DDLMem4.DataValueField = "MemberId"; DDLMem4.DataSource = dt; DDLMem4.DataBind(); } }
private void GetDetails() { try { MembersBll obj = new MembersBll(); DataTable dt = new DataTable(); dt = obj.GetAllMembersTrfAmt(); if (dt.Rows.Count > 0) { decimal trfAmount = Convert.ToDecimal(dt.Rows[0]["trfAmt"].ToString()); lblTotalMembers.Text = "7,500"; // dt.Rows[0]["TotalMember"].ToString(); lblTrfAmt.Text = "10,00,000"; // string.Format("{0:n0}", trfAmount); } } catch { } }
private void BindMembers(int distID) { // int distID = int.Parse(Session["DistrictClubID"].ToString()); MembersBll obj = new MembersBll(); obj.ClubId = distID; DataTable dt = new DataTable(); dt = obj.GetMemberByClubId(); if (dt.Rows.Count > 0) { DDLMember.DataTextField = "name"; DDLMember.DataValueField = "MemberId"; DDLMember.DataSource = dt; DDLMember.DataBind(); //DDLMember.Items.Insert(0, "Select"); } else { DDLMember.ClearSelection(); } }