public IEnumerable<Articles> loadArticlesBywriterID(int writerID) { SqlConnection loadConnection = new SqlConnection("server=tf-PC\\SQLEXPRESS;database=blogData;uid=admin;pwd=s1y2x3"); loadConnection.Open(); string loadString = "SELECT * FROM Articles WHERE writerID=@writerID ORDER BY readtimes DESC"; SqlCommand loadCommand = new SqlCommand(loadString, loadConnection); loadCommand.Parameters.Add(new SqlParameter("writerID", SqlDbType.Int)); loadCommand.Parameters["writerID"].Value = writerID; SqlDataAdapter loadAdapter = new SqlDataAdapter(loadCommand); DataSet loadDataSet = new DataSet(); loadAdapter.Fill(loadDataSet, "Articles"); Articles[] articles = new Articles[loadDataSet.Tables["Articles"].Rows.Count]; for (int i = 0; i < loadDataSet.Tables["Articles"].Rows.Count; i++) { articles[i] = new Articles() { categoryID = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[i]["categoryID"]), ID = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[i]["ID"]), publishtime = Convert.ToDateTime(loadDataSet.Tables["Articles"].Rows[i]["publishtime"]), readtimes = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[i]["readtimes"]), title = loadDataSet.Tables["Articles"].Rows[i]["title"].ToString(), writerID = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[i]["writerID"]), content = loadDataSet.Tables["Articles"].Rows[i]["content"].ToString(), description = loadDataSet.Tables["Articles"].Rows[i]["description"].ToString() }; } return articles; }
public Articles loadArticleByArticleID(int articleID) { SqlConnection loadConnection = new SqlConnection("server=tf-PC\\SQLEXPRESS;database=blogData;uid=admin;pwd=s1y2x3"); loadConnection.Open(); string loadArticleString = "SELECT * FROM Articles WHERE ID=@ArticleID"; SqlCommand loadCommand1 = new SqlCommand(loadArticleString, loadConnection); loadCommand1.Parameters.Add(new SqlParameter("ArticleID", SqlDbType.Int)); loadCommand1.Parameters["ArticleID"].Value = articleID; SqlDataAdapter loadAdapter = new SqlDataAdapter(loadCommand1); DataSet loadDataSet = new DataSet(); loadAdapter.Fill(loadDataSet, "Articles"); Articles article = new Articles() { categoryID = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[0]["categoryID"]), ID = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[0]["ID"]), publishtime = Convert.ToDateTime(loadDataSet.Tables["Articles"].Rows[0]["publishtime"]), readtimes = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[0]["readtimes"]), title = loadDataSet.Tables["Articles"].Rows[0]["title"].ToString(), writerID = Convert.ToInt32(loadDataSet.Tables["Articles"].Rows[0]["writerID"]), content = loadDataSet.Tables["Articles"].Rows[0]["content"].ToString(), description = loadDataSet.Tables["Articles"].Rows[0]["description"].ToString() }; return article; }