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