public DataTable SearchArticles(DAArticles article)
{
DataTable dt = new DataTable();
string articleType = article.ArticleType;
SqlDataAdapter da = new SqlDataAdapter("select a.ArticlType,a.ArticleDesc,a.CDate,a.Time,l.Username from Articles a inner join Login l on l.LoginId=a.LognId where ArticlType like'" + articleType+"%'", con);
da.Fill(dt);
return dt;
}
public int InsertPostArticle(DAArticles article)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into Articles values(@ArticleId,@ArticlType,@ArticleDesc,@CDate,@Time,@LognId)",con);
cmd.Parameters.AddWithValue("@ArticleId",article.ArticleId);
cmd.Parameters.AddWithValue("@ArticlType",article.ArticleType);
cmd.Parameters.AddWithValue("@ArticleDesc",article.Description);
cmd.Parameters.Add("@CDate",SqlDbType.Date).Value=article.date;
cmd.Parameters.Add("@Time",SqlDbType.Time).Value=article.Time;
cmd.Parameters.AddWithValue("@LognId", article.LoginId);
int i = cmd.ExecuteNonQuery();
con.Close();
return i;
}
