string sqlQuery = "select * from Message order by mID DESC";
message = SQLServerDAL.DbHelperSQL.Query(sqlQuery).Tables[0];
sqlQuery = "select * from Reply order by rID DESC";
reply = SQLServerDAL.DbHelperSQL.Query(sqlQuery).Tables[0];
//你没发现这里有什么问题吗?同一个表!!
message = SQLServerDAL.DbHelperSQL.Query(sqlQuery).Tables[0];
sqlQuery = "select * from Reply order by rID DESC";
reply = SQLServerDAL.DbHelperSQL.Query(sqlQuery).Tables[0];
//你没发现这里有什么问题吗?同一个表!!
呃...数据库操作类,操作方法是写在"Using(){}"块中的,不应该吧
DataTable message = new DataTable();
DataTable reply = new DataTable();
string sqlQuery = "select * from Message order by mID DESC";
message = SQLServerDAL.DbHelperSQL.Query(sqlQuery).Tables[0];
sqlQuery = "select * from Reply order by rID DESC";
reply = SQLServerDAL.DbHelperSQL.Query(sqlQuery).Tables[0];
message.TableName = "message";
message.TableName = "reply";
ds.Tables.Add(message.Copy());
ds.Tables.Add(reply.Copy());
ds.Tables[0].TableName = "message";
ds.Tables[1].TableName = "reply";
ds.Relations.Add("myreply", ds.Tables["message"].Columns["mID"], ds.Tables["reply"].Columns["rMID"]);
SqlDataAdapter sda=new SqlDataAdapter(sql,conn);
sda.Fill(ds,"message");
//这时你找到的数据就放到了ds的message表里,可以就这样给表命名
所以重名了
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds.Tables.Add(dt.copy(), "a");