/// <summary>
        /// Update the student details
        /// </summary>
        /// <param name="intStudentId"></param>
        /// <param name="strStudentName"></param>
        /// <param name="strGender"></param>
        /// <param name="intAge"></param>
        /// <returns></returns>
        public int UpdateStudent(int intStudentId, string strStudentName, string strGender, int intAge)
        {
            using (MySqlConnection con = MyConnection.GetConnection())
            {
                con.Open();
                string query = "UPDATE Students SET StudentName = @studname, StudentAge = @studage, " +
                               "StudentGender = @gender WHERE StudentId = @studid";
                MySqlCommand cmd = new MySqlCommand(query, con);
                cmd.Parameters.AddWithValue("@studname", strStudentName);
                cmd.Parameters.AddWithValue("@studage", intAge);
                cmd.Parameters.AddWithValue("@gender", strGender);
                cmd.Parameters.AddWithValue("@studid", intStudentId);

                return(cmd.ExecuteNonQuery());
            }
        }
示例#2
0
        public int InsertTrackingStates(string ipaddress, long duration, string controller, string action, long createdAt)
        {
            using (MySqlConnection conn = MyConnection.GetConnection())
            {
                conn.Open();
                string       query = "INSERT INTO TrackingList (IpAddress, Duration, Controller, Action, CreatedAt) VALUES(@item1, @item2, @item3, @item4, @item5)";
                MySqlCommand cmd   = new MySqlCommand(query, conn);
                cmd.Parameters.AddWithValue("@item1", ipaddress);
                cmd.Parameters.AddWithValue("@item2", duration);
                cmd.Parameters.AddWithValue("@item3", controller);
                cmd.Parameters.AddWithValue("@item4", action);
                cmd.Parameters.AddWithValue("@item5", createdAt);

                return(cmd.ExecuteNonQuery());
            }
        }