SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date,B.Attender FROM STUDDET S,Batch B
where S.BthId = B.BthId and s.StudId = '55386';
select * from STUDDET where StudId = '55386';
select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end)
from facfeedback where studid = '55386' and answerid = '5';
select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end)
from facfeedback
select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end)
from facfeedback where studid = '32468' and answerid = '5';
-- select * from STUDDET where StudId = '55386';
--32468 55639
select * from STUDDET where Studid = '32468';
SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date,B.Attender FROM STUDDET S,Batch B
where S.BthId = B.BthId and s.StudId = '32468';
select * from STUDDET where Studid = '44504';
select * from STUDDET where Studid = '55639';
select * from STUDDET where Studid = '31791';
-- 44504
-- SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date,B.Attender,S.AnswerID,C.Comment FROM STUDDET S,Batch B,Comment C
-- where S.BthId = B.BthId and S.AnswerID = C.AnswerID and s.StudId = '31791';
select * from STUDDET where Studid = '31791';
SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date, B.Attender,S.AnswerID as Ans_ID FROM STUDDET S,Batch B,Comment C
where S.BthId = B.BthId and S.AnswerID = C.AnswerID and s.StudId = '31791';
--second student
-- select * from STUDDET where Studid = '52716';
--
-- SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date, B.Attender,S.AnswerID as Ans_ID FROM STUDDET S,Batch B,Comment C
-- where S.BthId = B.BthId and S.AnswerID = C.AnswerID and s.StudId = '52716';
--Third student
select * from STUDDET where Studid = '60182';
SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date, B.Attender,S.AnswerID as Ans_ID FROM STUDDET S,Batch B
where S.BthId = B.BthId and S.AnswerID = s.Studid and s.StudId = '60182';
-----student
select * from STUDDET where Studid = '52716';
SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date, B.Attender,S.AnswerID as Ans_ID FROM STUDDET S,Batch B
where S.BthId = B.BthId and S.AnswerID = S.AnswerID and s.StudId = '52716';
--student
SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date, B.Attender,S.AnswerID as Ans_ID FROM STUDDET S,Batch B
where S.BthId = B.BthId and S.AnswerID = S.AnswerID and s.StudId ='61459';
select * from STUDDET where Studid = '61459';
--student
SELECT S.Marks, S.QPName,B.Class,B.BthNo, CONVERT(varchar(11),B.Batchdate,106) as Batch_Date, B.Attender,S.AnswerID as Ans_ID FROM STUDDET S,Batch B
where S.BthId = B.BthId and S.AnswerID = S.AnswerID and s.StudId ='32468';
select * from STUDDET where Studid = '32468';
-- 52716 60182 61459
--Rating for faculty use the below query
select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end)
from facfeedback where studid = '55386' and answerid = '5';
select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end)
from facfeedback
-- select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end)
-- from facfeedback where Faculty_Name = 'G.SEKHAR';
select * from startexec;
select * from batch where Bthid = '718';
select s.bthid, class from batch b, startexec s where s.bthid = b.bthid
select Class,Bthid from Batch;
Select Class from batch where Bthid = '718';
select * from studdet where Marks > 59;
select * from studdet where Marks > 59 and Studid = '49771';
select * from marks > 59 and Studid = '49771'
select * from studdet where Studid = '60845';
select * from studdet where Marks < 59
--select s.StudName,S.Marks,b.class from studdet s,Batch b where Marks > 59 and s.Studid = '55334' and b.Bthid = '37';
--select * from studdet where Studid = '55334';
Select Bthid from startexec
Select Bthid from startexec
Select * from currentexam
Select Class from batch where Bthid = '13'
--Select Class,Bthid from batch
Select Bthid,Class from batch
select * From course
select * from Batch;
Select Bthid from startexec
Select Class from batch where Bthid = '718';
--Login validation query
select * from batch where Bthid ='37';
select StudName from studdet where Marks > 59 and Studid = '55334' and Bthid = '37';
select * from studdet where Studid = '55334';
Chart download lnk follows;
Chart Control usage link as follows
http://aspnetnova.blogspot.in/2008/12/how-to-add-ms-chart-controls-into.html (to download the chart use the link)
http://www.asp.net/web-pages/tutorials/data/7-displaying-data-in-a-chart
http://www.chestysoft.com/aspnetgraph/manual.htm
http://www.4guysfromrolla.com/articles/072909-1.aspx
http://msdn.microsoft.com/en-IN/library/dd489231.aspx
http://www.chartingcontrol.net/
http://aspalliance.com/1828_Using_the_ASPNET_Chart_Control.all