public List <StudentInfoObj> GetAllStudentInfo() { List <StudentInfoObj> studentinfolist = null; //Lets get the list of all employees in a datataable using (DataTable table = SqlDBHelper.ExecuteSelectCommand("GetStudentAll", CommandType.StoredProcedure)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of employees studentinfolist = new List <StudentInfoObj>(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { StudentInfoObj stuinfo = new StudentInfoObj(); stuinfo.Name = row["Name"].ToString(); stuinfo.ID = (row["ID"]).ToString(); stuinfo.Dept = row["Dept"].ToString(); stuinfo.Gender = Convert.ToChar(row["Gender"]); stuinfo.Completedcredit = Convert.ToInt32(row["CompletedCredit"]); stuinfo.Semester = Convert.ToInt32(row["Semester"]); stuinfo.Cgpa = float.Parse(row["Cgpa"].ToString()); stuinfo.Password = Convert.ToString(row["Password"]); studentinfolist.Add(stuinfo); } } } return(studentinfolist); }
protected void Button1_Click1(object sender, EventArgs e) { StudentInfoObj stuinfo = new StudentInfoObj(); stuinfo.Name = txtname.Text; stuinfo.ID = txtid.Text; stuinfo.Dept = Convert.ToString(DropDownList1.SelectedValue); stuinfo.Gender = Convert.ToChar(DropDownList2.SelectedValue); stuinfo.Completedcredit = Convert.ToInt32(txtcredit.Text); stuinfo.Semester = Convert.ToInt32(DropDownList3.SelectedValue); stuinfo.Cgpa = float.Parse(txtcgpa.Text); stuinfo.Password = txtpassword.Text; DataHandler stuhandler = new DataHandler(); stuhandler.Insert(stuinfo); txtname.Text = null; txtid.Text = null; DropDownList1.SelectedValue = null; DropDownList2.SelectedValue = null; DropDownList3.SelectedValue = null; txtcredit.Text = null; txtcgpa.Text = null; txtpassword.Text = null; string val = "Account Created Successfully..."; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + val + "');", true); Response.Redirect("StudentLogin.aspx"); }
public bool StudentInfoInsert(StudentInfoObj StudentInformation) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Name", StudentInformation.Name), new SqlParameter("@ID", StudentInformation.ID), new SqlParameter("@Dept", StudentInformation.Dept), new SqlParameter("@Gender", StudentInformation.Gender), new SqlParameter("@CompletedCredit", StudentInformation.Completedcredit), new SqlParameter("@Semester", StudentInformation.Semester), new SqlParameter("@Cgpa", StudentInformation.Cgpa), new SqlParameter("@Password", StudentInformation.Password), }; return(SqlDBHelper.ExecuteNonQuery("StudentInfoInsert", CommandType.StoredProcedure, parameters)); }