help

[fatemeh001]

salam daram search minevisam moshkel daram kojae codam moshkel dare



MyDataList.DataSource = null;
string filter = string.Empty;
filter += "AddressedType=" + ComboAddressType.SelectedValue + " and ";
filter += "FormatType=" + ComboFormatType.SelectedValue + " or ";
filter += String.Format("{0} like '% N {1} %' or ", "Name", txt_title.Text);

filter += "Text=" + "N'"+ txt_Text.Text +"'"+ " and ";
filter += "fullname" + DropDownList4.SelectedValue +"and";
filter += "StatusType" + RadioButtonList2.SelectedValue + "and";
// filter += "Status" + RadioButtonList.SelectedValue + "and";
// DateTime date = Convert.ToDateTime(labelDate.Text);
// labelDate.Text = string.Format("{0}{1}{2}{3}", " در تاریخ", MyDate.PersianStringFromDateTime(date), "ساعت", MyDate.TimeStringFromDateTime(date));

if (filter.Length > 0)
{
filter = filter.Substring(0, filter.LastIndexOf(" and "));
}

DataSet dset = f.FishSelectAll(filter);
int count = dset.Tables[0].Rows.Count;
if (count > 0)
{
MyDataList.DataSource = dset;
MyDataList.DataBind();
lblMsg.Visible = false;
txt_title.Text = txt_Text.Text = "";
ComboFormatType.SelectedIndex = ComboAddressType.SelectedIndex = -1;
}
else
{

MyDataList.DataSource = null;
MyDataList.DataBind();
lblMsg.Visible = true;
lblMsg.Text = TSEn.Mssage.Search;
txt_title.Text = txt_Text.Text = "";
ComboFormatType.SelectedIndex = ComboAddressType.SelectedIndex = -1;
}
}

[hamedvahedi]

هر چند شيوه جالبي نيست :n13:

MyDataList.DataSource = null;
string filter = string.Empty;
filter += "AddressedType=" + ComboAddressType.SelectedValue + " and ";
filter += "FormatType=" + ComboFormatType.SelectedValue + " or ";
filter += String.Format("Name like N'%{0}%' or ", txt_title.Text);

filter += "Text=" + "N'"+ txt_Text.Text +"'"+ " and ";
filter += "fullname=" + DropDownList4.SelectedValue +" and ";
filter += "StatusType=" + RadioButtonList2.SelectedValue + " and ";

if (filter.Length > 0)
{
filter = filter.Substring(0, filter.LastIndexOf(" and "));
}

DataSet dset = f.FishSelectAll(filter);
int count = dset.Tables[0].Rows.Count;
if (count > 0)
{
MyDataList.DataSource = dset;
MyDataList.DataBind();
lblMsg.Visible = false;
txt_title.Text = txt_Text.Text = "";
ComboFormatType.SelectedIndex = ComboAddressType.SelectedIndex = -1;
}
else
{

MyDataList.DataSource = null;
MyDataList.DataBind();
lblMsg.Visible = true;
lblMsg.Text = TSEn.Mssage.Search;
txt_title.Text = txt_Text.Text = "";
ComboFormatType.SelectedIndex = ComboAddressType.SelectedIndex = -1;
}
}

[hamedvahedi]

هر چند شيوه جالبي نيست :n13:

MyDataList.DataSource = null;
string filter = string.Empty;
filter += "AddressedType=" + ComboAddressType.SelectedValue + " and ";
filter += "FormatType=" + ComboFormatType.SelectedValue + " or ";
filter += String.Format("Name like N'%{0}%' or ", txt_title.Text);

filter += "Text=" + "N'"+ txt_Text.Text +"'"+ " and ";
filter += "fullname=" + DropDownList4.SelectedValue +" and ";
filter += "StatusType=" + RadioButtonList2.SelectedValue + " and ";

if (filter.Length > 0)
{
filter = filter.Substring(0, filter.LastIndexOf(" and "));
}

DataSet dset = f.FishSelectAll(filter);
int count = dset.Tables[0].Rows.Count;
if (count > 0)
{
MyDataList.DataSource = dset;
MyDataList.DataBind();
lblMsg.Visible = false;
txt_title.Text = txt_Text.Text = "";
ComboFormatType.SelectedIndex = ComboAddressType.SelectedIndex = -1;
}
else
{

MyDataList.DataSource = null;
MyDataList.DataBind();
lblMsg.Visible = true;
lblMsg.Text = TSEn.Mssage.Search;
txt_title.Text = txt_Text.Text = "";
ComboFormatType.SelectedIndex = ComboAddressType.SelectedIndex = -1;
}
}