private bool UpdateScoreToDB() { string strPtsWinA = _dgvWinLose[1, 0].Value == null ? "" : _dgvWinLose[1, 0].Value.ToString(); string strPtsWinB = _dgvWinLose[1, 1].Value == null ? "" : _dgvWinLose[1, 1].Value.ToString(); string strPtsLoseA = _dgvWinLose[2, 0].Value == null ? "" : _dgvWinLose[2, 0].Value.ToString(); string strPtsLoseB = _dgvWinLose[2, 1].Value == null ? "" : _dgvWinLose[2, 1].Value.ToString(); string strSetsWinA = _dgvWinLose[3, 0].Value == null ? "" : _dgvWinLose[3, 0].Value.ToString(); string strSetsWinB = _dgvWinLose[3, 1].Value == null ? "" : _dgvWinLose[3, 1].Value.ToString(); string strSetsLoseA = _dgvWinLose[4, 0].Value == null ? "" : _dgvWinLose[4, 0].Value.ToString(); string strSetsLoseB = _dgvWinLose[4, 1].Value == null ? "" : _dgvWinLose[4, 1].Value.ToString(); string strGrpPtsA = _dgvWinLose[5, 0].Value == null ? "" : _dgvWinLose[5, 0].Value.ToString(); string strGrpPtsB = _dgvWinLose[5, 1].Value == null ? "" : _dgvWinLose[5, 1].Value.ToString(); SqlCommand dbCmd = new SqlCommand("proc_VB_PRG_MatchSetScoreWinLose"); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.AddWithValue("@MatchID", Common.g_nMatchID); dbCmd.Parameters.AddWithValue("@PtsWinA", strPtsWinA == "" ? (object)DBNull.Value : Common.Str2Int(strPtsWinA)); dbCmd.Parameters.AddWithValue("@PtsWinB", strPtsWinB == "" ? (object)DBNull.Value : Common.Str2Int(strPtsWinB)); dbCmd.Parameters.AddWithValue("@PtsLoseA", strPtsLoseA == "" ? (object)DBNull.Value : Common.Str2Int(strPtsLoseA)); dbCmd.Parameters.AddWithValue("@PtsLoseB", strPtsLoseB == "" ? (object)DBNull.Value : Common.Str2Int(strPtsLoseB)); dbCmd.Parameters.AddWithValue("@SetsWinA", strSetsWinA == "" ? (object)DBNull.Value : Common.Str2Int(strSetsWinA)); dbCmd.Parameters.AddWithValue("@SetsWinB", strSetsWinB == "" ? (object)DBNull.Value : Common.Str2Int(strSetsWinB)); dbCmd.Parameters.AddWithValue("@SetsLoseA", strSetsLoseA == "" ? (object)DBNull.Value : Common.Str2Int(strSetsLoseA)); dbCmd.Parameters.AddWithValue("@SetsLoseB", strSetsLoseB == "" ? (object)DBNull.Value : Common.Str2Int(strSetsLoseB)); dbCmd.Parameters.AddWithValue("@GroupPointsA", strGrpPtsA == "" ? (object)DBNull.Value : Common.Str2Int(strGrpPtsA)); dbCmd.Parameters.AddWithValue("@GroupPointsB", strGrpPtsB == "" ? (object)DBNull.Value : Common.Str2Int(strGrpPtsB)); dbCmd.Parameters.AddWithValue("@Result", DBNull.Value); dbCmd.Parameters["@Result"].Size = 4; dbCmd.Parameters["@Result"].SqlDbType = SqlDbType.Int; dbCmd.Parameters["@Result"].Direction = ParameterDirection.Output; return(Common.dbExecuteNonQuery(ref dbCmd)); }