public List <ViewStudentDetails> GetAllStudentDetails(int studentId)
{
SqlConnection connection = new SqlConnection(connectionString);
List <ViewStudentDetails> viewStudentDetailses = new List <ViewStudentDetails>();
string Query = "SELECT * FROM ViewStudentDetail where ID='" + studentId + "'";
SqlCommand cmd = new SqlCommand(Query, connection);
connection.Open();
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
ViewStudentDetails aViewStudentDetails = new ViewStudentDetails();
aViewStudentDetails.Id = Convert.ToInt32(Reader["ID"]);
aViewStudentDetails.StudentName = Reader["StudentName"].ToString();
aViewStudentDetails.Email = Reader["Email"].ToString();
aViewStudentDetails.DepartmentName = Reader["Name"].ToString();
//aViewStudentDetails.RegNo = Reader["StudentReqId"].ToString();
viewStudentDetailses.Add(aViewStudentDetails);
}
Reader.Close();
connection.Close();
return(viewStudentDetailses);
}
public ViewStudentDetails GetAllStudentsByStudentRegId(string StudentRegId)
{
SqlConnection connection = new SqlConnection(connectinDB);
string Query = "SELECT * FROM ViewStudentDetail where StudentRegId='" + StudentRegId + "'";
SqlCommand Command = new SqlCommand(Query, connection);
ViewStudentDetails aStudent = new ViewStudentDetails();
connection.Open();
SqlDataReader Reader = Command.ExecuteReader();
while (Reader.Read())
{
aStudent.StudentName = Reader["StudentName"].ToString();
aStudent.Email = Reader["Email"].ToString();
aStudent.DepartmentName = Reader["Name"].ToString();
}
Reader.Close();
connection.Close();
return(aStudent);
}
public List <ViewStudentDetails> GetAllStudentDetails(int studentId)
{
List <ViewStudentDetails> viewStudentDetailses = new List <ViewStudentDetails>();
Query = "SELECT * FROM ViewStudentDetails where StudentId='" + studentId + "'";
Command.CommandText = Query;
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
ViewStudentDetails aViewStudentDetails = new ViewStudentDetails();
aViewStudentDetails.Id = Convert.ToInt32(Reader["StudentId"]);
aViewStudentDetails.Name = Reader["StudentName"].ToString();
aViewStudentDetails.Email = Reader["StudentEmail"].ToString();
aViewStudentDetails.RegNo = Reader["StudentRegNo"].ToString();
aViewStudentDetails.DepartmentName = Reader["DepartmentName"].ToString();
viewStudentDetailses.Add(aViewStudentDetails);
}
Reader.Close();
Connection.Close();
return(viewStudentDetailses);
}