difference between c and c++?
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;
}
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you master coding?
What is a multimap c++?
Describe the process of creation and destruction of a derived class object?
What are the manipulators in c++?
declare an array of structure where the members of the structure are integer variable float variable integer array char variable access all elements of the structure using dot operator and this pointer operator
What are the important differences between c++ and java?
What is the use of "new" operator?
What is oop in c++?
How do you define a class in c++?
Why is null pointer used?
write asingle linked list which read from two list & the do the following 1 sort the prime & nonprime num (prime should be less tn nonprime) 2 each node has a prime num followd by nonprime 3 add a new node into its sutable plce 4 erase the most three duplicated non prime num 5 find the least duplicated prime num
What is endl c++?
How many different levels of pointers are there?
Write a program using shift_half( ) function to shift the elements of first half array to second half and vice versa.
What is an iterator class in c++?