public DataSet getStudents()
{
dsinput = new DataTable();
dsoutput = new DataSet();
dsinput.Columns.Add("data");
dsinput.Columns.Add("value");
dsoutput = cf.callProcedure("usp_getStudents", dsinput, 1);
return(dsoutput);
}
public DataSet login(string user, string pass)
{
dsinput = new DataTable();
dsoutput = new DataSet();
dsinput.Columns.Add("data");
dsinput.Columns.Add("value");
dsinput.Rows.Add("@user", user);
dsinput.Rows.Add("@pass", pass);
dsoutput = cf.callProcedure("usp_Login", dsinput, 1);
return(dsoutput);
}
public DataSet setStudent(string sname, string email, string gender, long contactno, string createddt)
{
dsinput = new DataTable();
dsoutput = new DataSet();
dsinput.Columns.Add("data");
dsinput.Columns.Add("value");
dsinput.Rows.Add("@sname", sname);
dsinput.Rows.Add("@email", email);
dsinput.Rows.Add("@gender", gender);
dsinput.Rows.Add("@contactno", contactno);
dsinput.Rows.Add("@createddt", createddt);
dsoutput = cf.callProcedure("usp_setStudent", dsinput, 1);
return(dsoutput);
}