Answer Posted / ks

/// <summary>
/// This function GetDetailById has been made to show
the Qualification details in grid view on the page
/// when the Admin enter any StudentId and clicks on
Submit button.
/// </summary>
/// <param name="studentid"></param>
/// <returns></returns>
public DataSet GetDetailById(int studentid)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_VIEWINFO", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studentid",studentid);
adap = new SqlDataAdapter(cmd);
adap.Fill(ds,"TBL_STUDENTQUALIFICATION");
return ds;
}

/// <summary>
/// This function GetPersonalInfoById has been made to
show the Personal details in grid view on the page
/// when the Admin enter any StudentId and clicks on
Submit button.
/// </summary>
/// <param name="studentid"></param>
/// <returns></returns>
public DataSet GetPersonalInfoById(int studentid)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_PERSONALINFO", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studentid",studentid);
adap = new SqlDataAdapter(cmd);
adap.Fill(ds,"TBL_STUDENTDETAIL");
return ds;
}

/// <summary>
/// This function GetCourseInfoById has been made to
show the Course details on the page when the Admin enters
/// any StudentId and clicks on Submit button.
/// </summary>
/// <param name="studentid"></param>
/// <returns></returns>
public SqlDataReader GetCourseInfoById(int studentid)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_GETCOURSEINFO", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue
("@studentid",studentid);
rd = cmd.ExecuteReader();
return rd;
}

/// <summary>
/// This function InsertPaymentDetail has been made to
insert the details of Payment into the Database.
/// </summary>
/// <param name="studentid">Unique Id of the
student</param>
/// <param name="paymode">Mode of Payment</param>
/// <param name="amount">Amount that has been
paid</param>
/// <param name="ddraftno">DD or Cheque No if payment
is not in cash</param>
/// <param name="bankname">Name of the Bank</param>
/// <returns></returns>
public int InsertPaymentDetail(int studentid,string
admitdate, string paymode,string amount,string
ddraftno,string bankname,string courseapply)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_PAYDETAIL",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studentid",studentid);
cmd.Parameters.AddWithValue("@admitdate",admitdate);
cmd.Parameters.AddWithValue("@paymode",paymode) ;
cmd.Parameters.AddWithValue("@amount",amount);
cmd.Parameters.AddWithValue("@ddno",ddraftno);
cmd.Parameters.AddWithValue("@bankname",bankname);
cmd.Parameters.AddWithValue
("@courseapply",courseapply);
int temp = cmd.ExecuteNonQuery();
return temp;
}

/// <summary>
/// This function ShowPaymentDetail shows the
ReceiptNo,Course name,Amount in the FeeReceipt page
/// </summary>
/// <param name="studentid">Unique Id of the
student</param>
/// <returns></returns>
public DataSet ShowPaymentDetail(int studentid)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_SHOWRECEIPTINFO",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studentid",studentid);
adap = new SqlDataAdapter(cmd);
adap.Fill(ds,"TBL_PAYMENT");
return ds;
}

/// <summary>
/// This function ShowPersonalPaymentDetail has been
made to display First Name,Last Name in the FeeReceipt Page
/// </summary>
/// <param name="studentid">Unique Id of student</param>
/// <returns></returns>
public DataSet ShowPersonalPaymentDetail(int studentid)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_SHOWRECEIPT", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studentid",
studentid);
adap = new SqlDataAdapter(cmd);
adap.Fill(ds,"TBL_STUDENTDETAIL");
return ds;
}

How do you clear a buffer in c++?

543

---

Please explain the reference variable in c++?

618

---

Can we declare a base-class destructor as virtual?

588

---

Difference between delete and free.

619

---

What is the difference between the compiler and the preprocessor?

619

---

---

List different attributes in C++?

643

---

Comment on c++ standard exceptions?

640

---

what are Operators and explain with an example?

711

---

What is the difference between new() and malloc()?

619

---

Can a constructor be private?

584

---

Can I make ios apps with c++?

562

---

What is expression parser in c++

1889

---

Name the operators that cannot be overloaded in C++?

587

---

What is the difference between public and private data members?

666

---

Who calls main function?

588

---