软件工程课程设计报告材料

;dad.Fill(ds,"tb_photo");con.Close();returnds;}publicDataSetgetAllPicToN(){OleDbConnectioncon=Db.createNewCon();OleDbDataAdapterdad=newOleDbDataAdapter();dad.mand=mand("selecttop10*from[tb_photo]orderby[id]DESC",con);DataSetds=newDataSet();dad.Fill(ds,"tb_photo");con.Close();returnds;}publicDataSetgetAllPicType(){OleDbConnectioncon=Db.createNewCon();OleDbDataAdapterdad=newOleDbDataAdapter();dad.mand=mand("select*from[tb_type]orderby[id]asc",con);DataSetds=newDataSet();dad.Fill(ds,"tb_type");con.Close();returnds;}publicDataSetgetAllPicTypeById(intid){OleDbConnectioncon=Db.createNewCon();mandcmd=mand("select*from[tb_type]whereid=@idorderby[id]asc",con);cmd.Parameters.AddWithValue("@id",id);OleDbDataAdapterdad=newOleDbDataAdapter(cmd);DataSetds=newDataSet();dad.Fill(ds,"tb_type");con.Close();