private int GetTotalPassCredit(int StudentId, string ProgramId) { int Credits = 0; DBCommon db = new DBCommon(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_GetTotalPassCredits"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@studentid", StudentId.ToString()); cmd.Parameters.AddWithValue("@ProgramId", ProgramId); Credits = Convert.ToInt32(db.GetValue(cmd)); return(Credits); }
protected void Search_Click1(object sender, EventArgs e) { DBCommon db = new DBCommon(); SqlCommand cmd = new SqlCommand("select StudentId from tsstudent where SID=@SID "); cmd.Parameters.AddWithValue("@SID", TextBox1.Text); string StudentId = db.GetValue(cmd); Session.RemoveAll(); if (StudentId != "") { Session["StudentId"] = Convert.ToInt32(StudentId); Response.Redirect("StudentPlans.aspx"); } else { Label1.Text = "Your SID is incorrect"; Label1.ForeColor = System.Drawing.Color.Red; } }