عدم نمایش داده در GridView

[MasoudAdmin]

با سلام
من کد زیر رو واسه کلید جستجو گداشتم ولی نتیجه جستجو رو در GridView نمایش نمیده


protected void btnSearch_Click(object sender, EventArgs e)
{
string IsAdmin, IsActive, Organ = string.Empty, Position = string.Empty;
GridViewUsers.DataSource = null;
if (this.DropDownManager.Text == "")
{
IsAdmin = "0,1";
}
else
{
IsAdmin = this.DropDownManager.Text.ToString().Trim();
}
if (this.DropDownUserStatus.Text == "")
{
IsActive = "0,1";
}
else
{
IsActive = this.DropDownUserStatus.Text.ToString().Trim();
}
foreach (ListItem item in DropDownCheckBoxOrgan.Items)
{
if (item.Selected)
{
Organ += "'"+item.Text + "',";
}
}
if (Organ.Length == 0)
{
Organ = "";
}
else
{
Organ = Organ.Substring(0, Organ.Length - 1);
}
foreach (ListItem item2 in DropDownCheckBoxPosition.Items)
{
if (item2.Selected)
{
Position += "'"+item2.Text + "',";
}
}
if (Position.Length == 0)
{
Position = "";
}
else
{
Position = Position.Substring(0, Position.Length - 1);
}
//this.lbMessage.Text = IsAdmin + "-" + IsActive + "-" + Organ + "-" + Position;
string Query = string.Empty;
if (Organ.Length == 0 && Position.Length == 0)
{
Query = "Select UserName,Name,ServiceLocation,OrganizationalPositi on,CustomLevel,TitleIsAdmin,TitleIsActive,UserImag e From vw_Users Where UserName Like'%" + txtUserName.Text.Trim() + "%' And ServiceLocation Like '%%' And OrganizationalPosition Like '%%' And IsAdmin IN(" + IsAdmin + ") And IsActive IN(" + IsActive + ")";
}
if (Organ.Length != 0 && Position.Length == 0)
{
Query = "Select UserName,Name,ServiceLocation,OrganizationalPositi on,CustomLevel,TitleIsAdmin,TitleIsActive,UserImag e From vw_Users Where UserName Like '%" + txtUserName.Text.Trim() + "%' And ServiceLocation IN(" + Organ + ") And OrganizationalPosition Like '%%' And IsAdmin IN(" + IsAdmin + ") And IsActive IN(" + IsActive + ")";
}
if (Organ.Length == 0 && Position.Length != 0)
{
Query = "Select UserName,Name,ServiceLocation,OrganizationalPositi on,CustomLevel,TitleIsAdmin,TitleIsActive,UserImag e From vw_Users Where UserName Like '%" + txtUserName.Text.Trim() + "%' And ServiceLocation Like '%%' And OrganizationalPosition IN(" + Position + ") And IsAdmin IN(" + IsAdmin + ") And IsActive IN(" + IsActive + ")";
}
if (Organ.Length != 0 && Position.Length != 0)
{
Query = "Select UserName,Name,ServiceLocation,OrganizationalPositi on,CustomLevel,TitleIsAdmin,TitleIsActive,UserImag e From vw_Users Where UserName Like '%" + txtUserName.Text.Trim() + "%' ServiceLocation IN(" + Organ + ") And OrganizationalPosition IN(" + Position + ") And IsAdmin IN(" + IsAdmin + ") And IsActive IN(" + IsActive + ")";
}
ConMainSystemPlanning.ConnectionString = ConnectionSystemPlanning;
ConMainSystemPlanning.Open();
CmdMainSystemPlanning.Connection = ConMainSystemPlanning;
CmdMainSystemPlanning.CommandText = Query;
SqlDataReader DrDataUsers = CmdMainSystemPlanning.ExecuteReader();
GridViewUsers.DataSource = DrDataUsers;
GridViewUsers.DataBind();
ConMainSystemPlanning.Close();
}

عکسش رو میفرستم
138276
ممنون میشم کمک کنید

[mohsen.nsb44]

دوست عزیز میشه بگی دقیقا میخوای چیکار بکنی
توضیحی در مورد کاری که میخوای انجام بدی بگی