public DataSet getdata(string actext, string feestext, string attandancetext, string examinationtext)
{
SqlConnection con = new SqlConnection(Commonfunction.getConnectionstring());
SqlCommand cmd = new SqlCommand("Sp_StudentReportCard", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Academic", actext);
cmd.Parameters.AddWithValue("@Fees", feestext);
cmd.Parameters.AddWithValue("@Attandance", attandancetext);
cmd.Parameters.AddWithValue("@Examination", examinationtext);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataTable dt=new DataTable();
DataSet ds=new DataSet();
adap.Fill(ds);
foreach (DataTable table in ds.Tables)
{
for (int i = 0; i < ds.Tables.Count; i++)
{
dt = ds.Tables[i];
}
}
return ds;