public void FillGrid()
{
try
{
LvwDetails.Items.Clear();
string strCondi = "";
//strSql = " SELECT TOP 1000 MemberCode,ProfileId,MobileNo,MobileNo_Rel,MobileNo1,MobileNo1_Rel,LandlineNo,MobileNo2_Rel,LandlineNo1,LandlineNo1_Rel FROM tbl_membermaster WHERE isnull(MobileNo_Rel,'')='' ";
strCondi += " AND MM.Gender =" + (rdbtnMale.Checked == true ? "0" : "1");
if (Convert.ToString(ddlPAgeFrom.SelectedValue) != Convert.ToString(ddlPAgeTo.SelectedValue))
{
strCondi += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.Text + " AND " + ddlPAgeTo.Text + "";
}
if (Convert.ToInt32(ddlCaste.SelectedValue) > 0)
{
strCondi += " AND MM.Caste = " + ddlCaste.SelectedValue;
}
if (ddlUpdateStatus.Text.ToUpper() == "NOT SEND LIST")
{
strCondi += " and Married= -1 ";
}
else if (ddlUpdateStatus.Text.ToUpper() == "SEND LIST")
{
strCondi += " and Married= 0 ";
}
else if (ddlUpdateStatus.Text.ToUpper() == "YES LIST")
{
strCondi += " and Married= 1 ";
}
else if (ddlUpdateStatus.Text.ToUpper() == "NO LIST")
{
strCondi += " and Married= 2 ";
}
if (txtProfileId.Text.Trim() != "")
{
strCondi += " AND profileid='" + txtProfileId.Text.Trim() + "'";
}
tbl_MemberMasterBAL objMembermaster = new tbl_MemberMasterBAL();
DataSet dtDetails = objMembermaster.GetMarriedConfirmationList(strCondi);
if (dtDetails.Tables[0].Rows.Count > 0)
{
lblTotalCnt.Text = "Total : " + Convert.ToString(dtDetails.Tables[0].Rows.Count);
FieldLength = new int[] { 150, 200, 100, 120, 170, 80, 50, 50, 0 };
objGlobal.FillListView(LvwDetails, dtDetails.Tables[0], FieldLength);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void FillGrid(string strCond)
{
try
{
tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL();
DataSet dsdata = objtbl_MemberMasterBAL.GetMarriedConfirmationList(strCond);
if (dsdata.Tables[0].Rows.Count > 0)
{
FieldLength = new int[] { 120, 150, 0, 150, 0, 80, 80, 0, 0 };
objGlobal.FillListView(LvwDetails, dsdata.Tables[0], FieldLength);
lblTotalCnt_A.Text = "Total : " + dsdata.Tables[0].Rows.Count;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}