protected void BtnSearch_Click(object sender, EventArgs e)
        {
            string CS    = ConfigurationManager.ConnectionStrings["communityDB"].ConnectionString;
            string query = "Select A.ArticleType, A.ArticleDesc, A.CDate AS \"Posted Date\", L.Name AS \"Posted By\" From Article A Inner Join Login L On A.LoginId = L.LoginId Where A.ArticleType = @searchKey";

            using (SqlConnection conn = new SqlConnection(CS))
            {
                SqlCommand cmd = new SqlCommand(query, conn);
                cmd.Parameters.AddWithValue("searchKey", TxtSearch.Text);
                conn.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                if (!rdr.HasRows)
                {
                    GvArticle.DataSource = null;
                    GvArticle.DataBind();
                    LblErrorMsg.Text      = $"No '{TxtSearch.Text}' keyword is found. Please try again!";
                    LblErrorMsg.ForeColor = Color.Red;
                }
                else
                {
                    LblErrorMsg.Text     = "";
                    GvArticle.DataSource = rdr;
                    GvArticle.DataBind();
                }
            }
        }
Exemplo n.º 2
0
        protected void BtnViewAllProjects_Click(object sender, EventArgs e)
        {
            LblErrorMsg.Text = "";
            string CS    = ConfigurationManager.ConnectionStrings["communityDB"].ConnectionString;
            string query = "Select P.ProjectType, P.FileName, P.FileType, L.Name AS \"Posted By\" From Project P Inner Join Login L On P.LoginId = L.LoginId";

            using (SqlConnection conn = new SqlConnection(CS))
            {
                SqlCommand cmd = new SqlCommand(query, conn);
                conn.Open();
                GvArticle.DataSource = cmd.ExecuteReader();
                GvArticle.DataBind();
            }
        }