12,162
社区成员
发帖
与我相关
我的任务
分享
static public DataTable LoadPosts(int subjectID)
{
DataTable table = new DataTable("Table"); // 为了序列化,必须设置表名,否则客户端抛异常
string sql = string.Format("SELECT * FROM Posts AS p INNER JOIN SubjectPosts AS sp ON p.PostID = sp.PostID WHERE SubjectID = {0}", subjectID);
SqlDataAdapter adapter = new SqlDataAdapter(sql, Configuration.ConnectionString);
adapter.Fill(table);
return table;
}
[WebMethod(EnableSession = true)]
public DataTable LoadPosts(int subjectID)
{
return Database.LoadPosts(subjectID);
}
DataTable table = webService.LoadPosts(subjectID);