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();
}
}
}
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();
}
}