public int AddNewItem()
{
string sql = string.Format("insert into tblStudents (Name,Gender,TotalMarks) values ('{0}',{1},{2})",
emp.Name,
emp.Gender,
emp.Marks);
return(ProjectDB.ExcuteNonQuery(sql));
}
public int UpdateItemByID(int id)
{
string sql = string.Format("update tblStudents set Name='{0}', Gender='{1}', TotalMarks={2} where ID={3}",
emp.Name,
emp.Gender,
emp.Marks,
id);
return(ProjectDB.ExcuteNonQuery(sql));
}
public employee GetItemsByID()
{
string sql = "select * from tblStudents where ID=" + emp.empId;
DataTable tb = ProjectDB.ExcuteDataTable(sql);
emp.Name = tb.Rows[0][1].ToString();
emp.Gender = tb.Rows[0][2].ToString();
emp.Marks = (int)tb.Rows[0][3];
return(emp);
}
protected void Page_Load(object sender, EventArgs e)
{
//only run once(when load the first time
if (!Page.IsPostBack)
{
List <Projects> projectList = new List <Projects>();
projectList = ProjectDB.SearchAllProject();
foreach (Projects project in projectList)
{
DropDownListProjets.Items.Add(project.ProjectCode);
}
List <Students> studentList = new List <Students>();
studentList = StudentDB.GetStudentList();
foreach (Students student in studentList)
{
DropDownListStudents.Items.Add(student.StudentNumber.ToString());
}
}
}
public object CountItems()
{
string sql = string.Format("select count(*) from tblStudents");
return(ProjectDB.ExcuteScalar(sql));
}
public DataSet GetAllItems()
{
string sql = "select * from tblStudents";
return(ProjectDB.ExcuteDataSet(sql));
}