private void BindWordTranslate() { string where = string.Format(@" ""LANGUAGE_ID"" = '{0}' AND ""PAGE_NAME"" = '{1}' ", ddlLanguages.SelectedValue, ddlPage.SelectedValue); //if (!string.IsNullOrEmpty(txtCode.Text)) // where += string.Format(@" AND UPPER(""CODE"") LIKE '%{0}%' ", txtCode.Text.ToUpper().Replace("'", @"''")); where += string.Format(@" ORDER BY ""CODE"" "); List <WordTranslate> wtList = WordTranslate.GetWordTranslateList(where); gvWordTranslate.DataSource = wtList; gvWordTranslate.DataBind(); }