如果我需要查询数据库中的多张表来填充dataset中的多张表,我现在的代码是这么写的 dataCommand.CommandText = "SElECT * FROM STORAGE_TYPE ORDER BY CONTAINER_TYPE_NAME";
dataAdapter.Fill(dataSet, "storageType");
dataCommand.CommandText = "SELECT CONTAINER_ID, CONTAINER_NAME FROM STORAGE_CONTAINER ORDER BY CONTAINER_NAME";
dataAdapter.Fill(dataSet, "storageContainer");即多次执行dataAdapter.Fill();这样做好么?
有没有别的方法?
dataAdapter.Fill(dataSet, "storageType");
dataCommand.CommandText = "SELECT CONTAINER_ID, CONTAINER_NAME FROM STORAGE_CONTAINER ORDER BY CONTAINER_NAME";
dataAdapter.Fill(dataSet, "storageContainer");即多次执行dataAdapter.Fill();这样做好么?
有没有别的方法?
dataAdapter.Fill(dataSet);可以多条语句一起去查