以下是获取所有信息的代码函数:
public static DataSet GetAllInfos()
{
string sql = "select InfoID,InfoTitle,InfoTime,InfoContent,i.AccountID,a.AccountName from Info as i inner join Account as a on i.AccountID = a.AccountID";
using (SqlConnection conn = new SqlConnection(con))
{
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();adapter.Fill(ds, "Info");
return ds;
}
}
应该怎么获取查询到的数据再放入DataSet中呢?